PLEASE HELP WITH DB ERRORS!!

[TechTalk]

Hey everyone...sorry to yell but this is really getting to me. I recently moved my forums to a new domain and everything was going smooth untill I tried to post a reply to a topic....it was displayed in the wrong order because it thinks I posted it 2 days ago (which would have been before the original post) does that make any sence?

Heres the thread:
http://www.glidetech.com/forums/showthread.php?postid=9391#post9391

And this brings up the next problem...I thought updating counters would work...but as most of you know, I have been getting errors on updating counters way before I ever changed servers.

Here are 2 from updating the user counters:

Database error in vBulletin: Invalid SQL: SELECT canview,cansearch,canemail,canpostnew,canreply,can adminedit,canedit,candelete,canopenclose,canmove,c ancontrolpanel FROM usergroup WHERE usergroupid=6
mysql error: Table 'glidetech.usergroup' doesn't exist
mysql error number: 1146
Date: Thursday 14th of September 2000 08:40:45 PM
Script: /forums/
Referer:



Database error in vBulletin: Invalid SQL: SELECT daysprune,lastvisit,lastactivity,cookieuser,userna me,password,usergroupid,timezoneoffset FROM user WHERE userid=2
mysql error: Table 'glidetech.user' doesn't exist
mysql error number: 1146
Date: Thursday 14th of September 2000 08:40:44 PM
Script: /forums/
Referer



And yes I do have a "usergroup" and a "user" table in my db, so I dont know where that came from

I also get an error about halfway thru updating threads, but I never get an e-mail for that one!

Any help would be much appreciated!!

Thanks
~Chris

[Menno]

I'm ptobably noy gonna make alot of sence, but it seems like its looking for a part of a join query (glidetech.user)

maybe you should look into that?

[Mike Sullivan]

Chris, are you still getting the errors? Because if I go here: http://www.glidetech.com/forums/member.php?action=getinfo&userid=308, I don't get an error. And since that's a user info page, you would think that I'd get the glidetech.user doesn't exist error. :confused:

[TechTalk]

Originally posted by Menno
I'm ptobably noy gonna make alot of sence, but it seems like its looking for a part of a join query (glidetech.user)

maybe you should look into that?

Yea I seen the glidetech.user part. I just assumed vb was taking the value of $dbname (from config.php) and using it for the joins. I havent altered anything in anway so I cant figure out whats going on.


Mike - Thats the same thing I was thinking. That user can post, you can view their profile and everything. But come time to update posts and users, the script never makes it further than half way.

Update: I fixed the problem where posts were appearing in the wrong order. The date was wrong on my server

Thanks in advance for any help.

~Chris

[TechTalk]

New update: This is gonan sound real stupid but bear with me here:

I can now update the users. Why? I personally think its because mike went and viewed the profile for that user that was causing the problem. I know it sounds dumb but I have the same situation with threads.

Example: If im updating threads and it dies while updating thread 1004, if I go to showthread.php?threadid=1005 and I go back to the control panel and I try it again.....it will get past that thread, and die at another one later on thru the update.

John, is this possibly a bug?

Thanks
~Chris

[Mike Sullivan]

That's really freakin' weird! Chris, next time you are updating threads and get to the problem one, give us all the thread info (from the thread table [at least]) and then view it, and make sure it works.

That's really all I can think of...

OT: Chris, what's up with your server? I can't get into glidetech, my domain, FTP, or Telnet. But it pings and tracert's fine. :)

[TechTalk]

Originally posted by Ed Sullivan
That's really freakin' weird! Chris, next time you are updating threads and get to the problem one, give us all the thread info (from the thread table [at least]) and then view it, and make sure it works.

That's really all I can think of...

OT: Chris, what's up with your server? I can't get into glidetech, my domain, FTP, or Telnet. But it pings and tracert's fine. :)

It ran out of memory amidst all these sql errors so I had to reboot it. Its back now.
Database error in vBulletin: Invalid SQL: SELECT * FROM replacement ORDER BY replacementid DESC
mysql error: Out of memory (Needed 65536 bytes)
mysql error number: 5
Date: Saturday 16th of September 2000 11:24:35 AM
Script: /forums/showthread.php?threadid=1006
Referer:

65538 bytes??? isnt that a bit much??

~Chris