fabioisonfire

Yeah, realjumper. Would you be willing to go into my MySQL admin and check this out for me? redarrow, it's too late for that.

I made a dump, and I unchecked the thing that transfers the auto-increment data, and then renamed it so it'd work with my code, and it still didn't work. What am I doing wrong?

So there is NO way to fix this then? (Other than wiping the entire table.) And if it comes to wiping the table, is there a way to get my users' data back?

I can't be sure (I'm a bit of a beginner), but that sounds right.

Here's the problem... I deleted a few users from the database, and now, whenever a user registers, they are put into the 'users' table, but get a completely blank ID for the 'userstats' table, which causes all kinds of havoc to break loose. The 'users' section also makes their ID like there are, say, 60 members (the number before I deleted the users), when there is really only, say, 56. Is there any way to somehow... 're-align' the tables so they are both synced again? I'm willing to let someone into my MySQL database to help out.

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.

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

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

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.

Thanks a lot, guys.

Here is the error I'm getting: Parse error: syntax error, unexpected T_STRING in /home/fabio/public_html/vote.php on line 21 Here's the code: <?php session_start(); require "global_func.php"; if($_SESSION['loggedin']==0) { header("Location: login.php");exit; } $userid=$_SESSION['userid']; require "header.php"; $h = new headers; $h->startheaders(); include "mysql.php"; global $c; $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()); $ir=mysql_fetch_array($is); check_level(); $fm=money_formatter($ir['money']); $lv=date('F j, Y, g:i a',$ir['laston']); $h->userdata($ir,$lv,$fm); $h->menuarea(); print " <b>Vote here on each of these sites to help Ruins of Sera. Each one of your votes gives you 50 Credits.</b><br><br> <a href="http://www.toprpgames.com/vote.php?idno=1832"><img src="http://www.toprpgames.com/images/banners/toprpg_88x31-2.gif" border="0"></a> <br><br> <a href="http://best-rpg.com/games/vote/382/" title="Vote on Best Rpg 200" ><img src="http://www.ruinsofsera.x10hosting.com/index.php/bestrpg.jpg"></a> <br><br> <div style="width: 88px; height: 55;"> <a href="http://www.xtremetop100.com/in.php?site=1132239810"> <img src="http://www.xtremeTop100.com/votenew.jpg" border="0" alt="MMORPG & MPOG Free server" style="float: left;\ margin-top: -1px;"></a><br><a href="http://www.xtremetop100.com/"> <img src="http://www.xtremeTop100.com/tracker.jpg" border="0" alt="MMORPG & MPOG Free server" style="float: left;\ margin-top: -1px;"></a></td> </div><br><br><a href="http://www.gtop100.com/in.php?site=21959" title="MMORPG / MPOG" target="_blank"> <img src="http://www.gtop100.com/images/votebutton.jpg" border="0" alt="MMORPG / MPOG"></a>"; $h->endpage(); ?>