PDA

View Full Version : Database error in vBulletin 3.8.4:

3eyon
08-20-2009, 11:34 AM
I have Problem with my forum http://www.3eyon.net

and when I upgrade my Vb in the step=1

Database error in vBulletin 3.8.4:

Invalid SQL:

SELECT forum.*
FROM forum AS forum

ORDER BY displayorder;

MySQL Error : Table 'threyonn_fvbfor33.forum' doesn't exist
Error Number : 1146
Request Date : Thursday, August 20th 2009 @ 04:55:11 AM
Error Date : Thursday, August 20th 2009 @ 04:55:11 AM
Script : http://www.3eyon.net/vb/install/finalupgrade.php?step=1
Referrer : http://www.3eyon.net/vb/install/finalupgrade.php?rand=1250765704
IP Address : 91.142.51.36
Username :
Classname : vB_Database
MySQL Version : 5.0.81-community-log

and in th step=4


Database error in vBulletin 3.8.4:
Invalid SQL:
DELETE FROM template WHERE styleid = -10 AND (product = 'vbulletin' OR product = '');
MySQL Error : Table 'threyonn_fvbfor33.template' doesn't exist
Error Number : 1146
Request Date : Thursday, August 20th 2009 @ 05:01:32 AM
Error Date : Thursday, August 20th 2009 @ 05:01:33 AM
Script : http://www.3eyon.net/vb/install/finalupgrade.php?step=4
Referrer : http://www.3eyon.net/vb/install/finalupgrade.php?step=3
IP Address : 91.142.51.36
Username :
Classname : vB_Database
MySQL Version : 5.0.81-community-log

??????????????????
Marco van Herwaarden
08-20-2009, 11:49 AM
If you have replced your ./includes/config.php with a new one, then check if you have set the correct table prefix.
3eyon
08-20-2009, 11:54 AM
no I dont replc ./includes/config.php
Marco van Herwaarden
08-20-2009, 12:35 PM
Did the problems start before your attempt to upgrade? If so, what where the problems?
3eyon
08-20-2009, 12:39 PM
No, this has been a problem in my site today and I am trying to upgrade to solve the problem of no use to me
Marco van Herwaarden
08-20-2009, 01:10 PM
So the answer is Yes?

Yes you already had problems before the upgrade.

Upgrading will not fix problems like database errors. I will need to see the original error message you received before the upgrade.

Did you check with a tool like phpMyAdmin if these tables really don't exist in your database?
3eyon
08-20-2009, 01:46 PM
yes in phpmyadmin tables really don't exist in your database what we do now ?
Marco van Herwaarden
08-21-2009, 08:46 AM
If the tables have been deleted from your database, then your only solution is to restore a backup from before those tables where deleted.
Ascension
08-28-2009, 09:40 AM
fixed yet? yes no?