UBB.Dev
Posted By: grant Table Error - 10/25/2009 8:41 AM
Greetings

I use version 6.5, but during installation of a forum I had a problem. I have filled all fields (db name, db user, db password, etc.) but when I have pressed on creating tables, I had a following error:

Creating the tables...
We cannot proceed.

Script: D:\WebServer\www\ubbthreads\ubbt.inc.php
Line#: 1565
SQL Error: Table 'mysql.w3t_users' doesn't exist
SQL Error #: 1146
Query: SELECT U_Username,U_Password,U_SessionId, U_StyleSheet, U_Status, U_Privates, U_FrontPage, U_Number, U_Banned,U_LastOn,U_OC_Userid FROM w3t_Users WHERE U_Number = ''

Please use your back button to return to the previous page.


What can cause this error, what I do not so?

I thank
Posted By: Gizmo Re: Table Error - 11/12/2009 1:07 AM
Well, it's saying that the table "w3t_users" doesn't exist in the database "mysql"; are both of these named correctly?
Posted By: Ruben Rocha Re: Table Error - 11/12/2009 2:08 AM
Well I don't know why you be doing a fresh install of a outdated version. But Giz has pointed you in the right direction.
Looking at mysql.w3t_users.
First thing is the case of the name, second is does the table actually exist.
So you need to have a peek at the db and see what the prefix is named including upper/lower case of the name. Then see if the table is there. Using something other than UBB. Such as phpmyadmin.
© UBB.Developers