Jump to content
MakeWebGames

Random Error - Not Sure What Is Wrong


Cronus
 Share

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...