Please help database screwed up

[zomgwtfbbq]

Hi,

I'm having a problem with my database, I installed vbGallery, but didn't knew I had to point my browser to some installation file, so I imported the xml file and after that I got errors all over the board.
So I manually created the gallery table, that fixed most of the errors, however I'm not able to login anymore(I do get the thank you for logging in, but then I'm not logged in).

When I look at all the error queries, I see everywhere userid is missing, I did check the table where those are stored but all users are fine...

Anyway I think all errors come from one query, just can't fix it by myself sadly.

I get this error when logging into admincp:

Database error in vBulletin 3.7.3:

Invalid SQL:
INSERT INTO lol_cpsession (userid, hash, dateline) VALUES (, '3a77e71df6f5aa260cdee1ac3bd575a4', 1225524603);

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 ' '3a77e71df6f5aa260cdee1ac3bd575a4', 1225524603)' at line 1
Error Number : 1064
Request Date : Saturday, November 1st 2008 @ 08:30:03 AM
Error Date : Saturday, November 1st 2008 @ 08:30:03 AM
Script : url/login.php?do=login
Referrer : url/admincp/
IP Address : xxxxxxxxxxxx
Username : zomgwtfbbq
Classname : vB_Database
MySQL Version : 4.1.12-standard-log

I get this error when viewing anyone's profile:

Invalid SQL:

SELECT MAX(dateline) AS lastpost, COUNT(*) AS total
FROM lol_usernote AS usernote
WHERE userid =;

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 '' at line 3
Error Number : 1064
Request Date : Saturday, November 1st 2008 @ 08:47:54 AM
Error Date : Saturday, November 1st 2008 @ 08:47:54 AM
Script : url/members/zomgwtfbbq.html
Referrer : url/
IP Address : xxxxxxxxxxxxxx
Username : Unregistered
Classname : vB_Database

Also my posts are still there, but this is how they show up(I'm admin, have avatar etc.)

Please help me

 

[NanoEntity]

I would reset XML to default vbulletin values

or you can do a search for "cpsession (userid, hash, dateline)"

and try to figure out why userid is not being processed in admincp

or you can hard edit and enter your userid into the VALUES (youruserid,

 

[bluescorpion]

To start with, you need to "uninstall" the xml you imported and get your system back to it normal state without the errors. You are looking for misery if you start hacking vBulletin queries instead of backing out the mistake. IMHO!

 

[zomgwtfbbq]

I did remove the data from table productcode but that didnt help...also I can't login to my admin table.
Anymore stuff that I can safely remove?

 

[NanoEntity]

meh

backup the whole database

install a fresh vbulletin

import important tables, users/polls/attachments/threads.....

 

[moron]

I did remove the data from table productcode but that didnt help...also I can't login to my admin table.
Anymore stuff that I can safely remove?

well that what i would suggest u as well , back up the database ... and delete the database create a new one .. and upload the backup one .

u should not get any more errors.

pe@c3