View Single Post
  #11  
Old 22nd January 2010, 18:17
Viperia Viperia is offline
Senior Member
 
Join Date: Jul 2008
Sweden
Posts: 46
Default
Howdy,

I recently re installed my vps with lighttpd, mysql and debian lenny. And reinstalled my FTS copy but when i go to the index i get this error.

Code:
SQL Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '>= first AND <= last' at line 1

in /var/www/*censor*/include/functions.php, line 448
I checked the functions.php and all i find there is:

Code:
    $res = mysql_query("SELECT * FROM bans WHERE $nip >= first AND $nip <= last") or
        sqlerr(__file__, __line__);
    if (mysql_num_rows($res) > 0) {
Line 448 is the "sqlerr(__file__, __line__);"

Anyone have any idea about this? My guess is that i have miseed something in the server config. :(

Regards,
Viperia
Reply With Quote
The Following User Says Thank You to Viperia For This Useful Post:
Mody (8th May 2023)