fabioisonfire Posted April 28, 2008 Share Posted April 28, 2008 Here's the error that new users are getting... 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 'AND evREAD=0' at line 1 What does this mean? I checked all my scripts and I can't find 'AND evREAD=0' at ANY line 1. Quote Link to comment Share on other sites More sharing options...
DarkWater Posted April 28, 2008 Share Posted April 28, 2008 Line 1 means the first line of the SQL query causing the error, not of the PHP script. =P Quote Link to comment Share on other sites More sharing options...
dptr1988 Posted April 28, 2008 Share Posted April 28, 2008 You need to echo your query and look at that. If you don't know how to do that, show us the code that makes the query string. Quote Link to comment Share on other sites More sharing options...
fabioisonfire Posted April 28, 2008 Author Share Posted April 28, 2008 Here are all the pieces of mySQL query code in the 'loggedin' script, which is where the error is shown and stays: $is=mysql_query("SELECT u.*,us.* FROM users u LEFT JOIN userstats us ON u.userid=us.userid WHERE u.userid=$userid",$c) or die(mysql_error()); $q=mysql_query("SELECT * FROM papercontent LIMIT 1",$c); Quote Link to comment Share on other sites More sharing options...
dptr1988 Posted April 28, 2008 Share Posted April 28, 2008 Well I don't see any references to 'evREAD' either. Is 'evREAD' defined anywhere in your database? Quote Link to comment Share on other sites More sharing options...
fabioisonfire Posted April 28, 2008 Author Share Posted April 28, 2008 I'm checking right now... What happened was I deleted a few users from the database, and now, every user who signs up gets a weird user ID. For example: 1 2 3 4 5 6 I delete 4-6. 1 2 3 *new user* 7 etc. I found evREAD. It's in my 'events' table. It's int(11)... I seriously don't see any problems... Quote Link to comment Share on other sites More sharing options...
fabioisonfire Posted April 28, 2008 Author Share Posted April 28, 2008 AH HA! This is where the error occurs. <a href='events.php'>"; $d=mysql_query("SELECT COUNT(*) as cnt FROM events WHERE evUSER={$ir['userid']} AND evREAD=0",$c) or die(mysql_error()); This had worked perfectly until I deleted those users from the database. Users started to register with blank IDs. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.