Jenny

Long, long, long story.

Right now I'm having 2 major errors on my OC Board

Here are the 2:
-------------------------
When you search for all posts by a user -

Database error in vBulletin 2.3.2:

Invalid SQL: SELECT COUNT(*) AS posts FROM post
LEFT JOIN thread ON thread.threadid=post.threadid WHERE post.visible=1 AND post.threadid= AND 1=1 AND NOT (thread.forumid='83') AND post.userid='177'
mysql error: 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 1=1 AND NOT (thread.forumid='83') AND post.userid='177'' a

mysql error number: 1064

Date: Thursday 25th of August 2005 03:26:00 PM
Script: http://www.theoc-boards.com/forum/fo...searchid=57402
Referer:
-------------------------
When we try and add new schemes/styles -

Database error in vBulletin Control Panel 2.3.2:

Invalid SQL: INSERT INTO style (styleid,title,replacementsetid,templatesetid,userselect) VALUES (NULL,'TestingJenny2','92','17','0','Test1','Test2')
mysql error: Column count doesn't match value count at row 1

mysql error number: 1136

Date: Thursday 25th of August 2005 03:27:36 PM
Script: http://www.theoc-boards.com/forum/forum/admin/style.php
Referer: http://www.theoc-boards.com/forum/ad...hp?action=add&
-------------------------

So I've been told by several people that it is probably hacks gone bad when our old host screwed **** up and we had to move hosts. That something didn't get switched over or something got edited out or something.

Well, we are also currently running vers. 2.3.2, which is OLD. We've been hesitant to switch over cause it'll be a lot of work. But at this point, I'm thinking with those errors, we're gonna have to do something.

So I picked a new place on my domain (testforum rather than forum) and installed 3.0.8. Started using ImpEx to import all the stuff I could from our current one. Everything looks good (no styles of course). The posts are all there, forums all there, PMs all there, etc. No users. All the users show up in the admincp but if I look at the Members List on the forum, I'm the only user. Wtf!

THEN, I'm getting this error:

Database error in vBulletin:ImpEx Target 3.0.8:

Invalid SQL: INSERT INTO vbfields VALUES (594,'usertitle','VARCHAR(250)','N/A','userban','usertitle VARCHAR(250) NOT NULL DEFAULT \'\'','N','NULL','return true;')
mysql error: Table 'theocbo_theocbonewvers.vbfields' doesn't exist

mysql error number: 1146

I looked in the phpMyadmin and vbfields is too there!

HELP! Please! lol

__________________
Check out my spoilers for over 20 shows @ SpoilerFix.com

Check out my TV blog, where I post weekly & daily TV
schedules, TV news, interviews with TV stars & more!
All new TV forums as well @ TV Is My Pacifier

Hiro

I probably won't be much help here, but you might want to cross post this at: http://www.vbulletin.com/forum/forumdisplay.php?f=38

Make sure your table name is actually, "theocbo_theocbonewvers" also. Since you switched hosts, this might have changed (it could just be "theocbonewvers" now). Different hosts run their MySQL Servers completely differently.

The same issue applies above, this could just be because the data you are trying to import is looking for different paths than what you have.

I really can't explain the fixes or what I would do best, I'd have to see it first hand. I'm horrible with helping others when it comes to this, sorry.

__________________
-Corsec-

Jenny

the db is new (I made for this install) and is theocbo_theocbonewvers There is a table in that db called vbfields.