SQL syntax...

[fabioisonfire]

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.

[DarkWater]

Line 1 means the first line of the SQL query causing the error, not of the PHP script. =P

[dptr1988]

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.

[fabioisonfire]

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);

[dptr1988]

Well I don't see any references to 'evREAD' either. Is 'evREAD' defined anywhere in your database?

[fabioisonfire]

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...

[fabioisonfire]

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.