Cronus Posted February 11, 2007 Posted February 11, 2007 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 This appears in my main menu where the events should show up. It ust happened randomly and I don't knwo what is wrong. The page stops at this error. The header file still runs and it pulls all my information(name, money, level, etc.) just like it is supposed to EXCEPT it can't find the userid. I'm not sure why this is, it can read all my other information but not the id? If anyone knows what's wrong please help. Thanks ~Cronus Quote
seanybob Posted February 11, 2007 Posted February 11, 2007 Re: Random Error - Not Sure What Is Wrong back in the day, this happened to me twice. Off the top of my head I can't remember how I fixed it, I think I cleared all the events or something like that... but ya, it happened to me too, and at the most random times Quote
Cronus Posted February 11, 2007 Author Posted February 11, 2007 Re: Random Error - Not Sure What Is Wrong This is the 2nd time it has happened to me also, I have already deleted all events. And it's not all playersm, It's just my account, other players are still going along as normal and I'm not exactly sure what's up, I was in the process of starting a new mod and then my account goes crazy lol. ~Cronus Quote
UCC Posted February 11, 2007 Posted February 11, 2007 Re: Random Error - Not Sure What Is Wrong Can you show us the entire SQL query? Quote
Cronus Posted February 11, 2007 Author Posted February 11, 2007 Re: Random Error - Not Sure What Is Wrong The query works, I know it does, it has worked for 2 months now and I have not ever touched it before, plus no one else has access to my files at all so no one could have changed it. ~Cronus Quote
Dabomstew Posted February 12, 2007 Posted February 12, 2007 Re: Random Error - Not Sure What Is Wrong Your user no longer has an entry in userstats, for whatever reason. Insert a new entry into userstats with your ID and it should be fixed. Quote
Anaconda Posted February 16, 2007 Posted February 16, 2007 Re: Random Error - Not Sure What Is Wrong nope bomb its the error code at the end of the query it started on mine after a update to the server was done easy fix ill post it here when i pull out the file Quote
Anaconda Posted February 16, 2007 Posted February 16, 2007 Re: Random Error - Not Sure What Is Wrong change this $d=mysql_query("SELECT COUNT(*) as cnt FROM events WHERE evUSER={$ir['userid']} AND evREAD=0",$c) or print(mysql_error()); $r=mysql_fetch_array($d); to this $d2=mysql_query("SELECT COUNT(*) as cnt FROM mail WHERE mail_to={$ir['userid']} AND mail_read=0",$c); $r=mysql_fetch_array($d2); and it all works again like it should its some kind of conflict with the one in header.php and the one in mainmenue.php Quote
Cronus Posted February 16, 2007 Author Posted February 16, 2007 Re: Random Error - Not Sure What Is Wrong No, it was the stats. I don't know what happened to them tho :oops: Quote
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.