Jump to content
MakeWebGames

Recommended Posts

Posted

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

Posted

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

Posted

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

Posted

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

Posted

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

Posted

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

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.

×
×
  • Create New...