[Clipart] Openclipart.org shows database error

[momo]

That's exactly what I've been told by a web programmer friend: it is quite 
possible that there are queries that aren't supported by an older MySQL 
version on the osuosl server. Was the old server running a newer database 
version?

Molumen

----- Original Message ----- 
From: "Greg Bulmash" <oneminuteinspirations at gmail.com>
To: "Jon Phillips" <jon at rejon.org>; "Open Clip Art Library list" 
<clipart at lists.freedesktop.org>
Sent: Wednesday, July 11, 2007 5:12 AM
Subject: Re: [Clipart] Openclipart.org shows database error


> What version of MySQL is the server running?  Sometimes the default
> version is old and won't support the syntax of newer queries.
>
> -Greg
>
> Jon Phillips wrote:
>> Anyone know the bad behavior plugin? Maybe it needs to be updated. I
>> just commented it out
>> in /var/www/openclipart.org/htdocs/wiki/LocalSettings.php
>>
>> Is anyone interested in looking at this?
>>
>> Jon
>>
>>
>> On Wed, 2007-07-11 at 00:06 +0200, momo wrote:
>>> A database error has occurred
>>> Query: SELECT `ip` FROM `mw_bad_behavior_log` WHERE `ip` LIKE
>>> '127.0.0.1' AND `http_response` = 403 AND `date` >
>>> DATE_SUB('2007-07-10 22:05:19', INTERVAL INF MINUTE)
>>> Function:
>>> Error: 1054 Unknown column 'INF' in 'where clause' (db1.osuosl.org)
>>>
>>> Backtrace:
>>> GlobalFunctions.php line 602 calls wfBacktrace()
>>> Database.php line 473 calls wfDebugDieBacktrace()
>>> Database.php line 419 calls Database::reportQueryError()
>>> DatabaseFunctions.php line 25 calls Database::query()
>>> bad-behavior-mediawiki.php line 85 calls wfQuery()
>>> bad-behavior-database.php line 115 calls wp_bb_db_query()
>>> bad-behavior-core.php line 135 calls wp_bb_db_search()
>>> bad-behavior-mediawiki.php line 109 calls require_once()
>>> - line - calls wp_bb_mediawiki_run()
>>> Setup.php line 327 calls call_user_func()
>>> index.php line 80 calls require_once()
>>>
>>> _______________________________________________
>>> clipart mailing list
>>> clipart at lists.freedesktop.org
>>> http://lists.freedesktop.org/mailman/listinfo/clipart
> _______________________________________________
> clipart mailing list
> clipart at lists.freedesktop.org
> http://lists.freedesktop.org/mailman/listinfo/clipart
>