PDA

View Full Version : Database error in vBulletin Mod Control Panel


desi
10-26-2002, 09:09 AM
Database error in vBulletin Mod Control Panel :

Invalid SQL: SELECT template FROM template WHERE title='options'
mysql error: Table 'zeus.template' doesn't exist

mysql error number: 1146

Date: Saturday 26th of October 2002 02:59:25 AM
Script: /Forum/mod/


i have tried installing v-bulletin 5-6 times and get the similar errors everytime ....

could someone plz help me out ..

the forum is not accessible in anyway :(

thankz

desi
10-26-2002, 10:35 AM
fixed ... :)

Erwin
10-26-2002, 11:17 AM
The best problems are the one that you find out you can fix yourself. :)

Data
10-27-2002, 06:27 AM
I have a problem too. I tried to change a username and this happened:

Database error in vBulletin Control Panel 2.2.8:

Invalid SQL: SELECT userid
FROM user
WHERE username='Osiris'
AND userid <>
mysql error: You have an error in your SQL syntax near '' at line 4

mysql error number: 1064

Erwin
10-27-2002, 07:24 AM
You need to post that part of code in your user.php in your admin directory here, so that we can look at it. Have you put any hacks into your admin user.php? In future, start a new thread - this thread is about something different - your problem has nothing to do with it.

Xenon
10-27-2002, 08:53 AM
data that's a known problem which occures since php4.2.x

look https://vborg.vbsupport.ru/showthread.php?s=&threadid=44305&highlight=userid%3C%3E
there's a fix for a quite similar problem

Erwin
10-27-2002, 11:12 AM
Ahhh... that one. :) I had to fix my user.php too - a while back.