php forum
php mysql forum
php mysql smarty
 
Topic Options
#318266 - 10/25/09 01:41 AM Table Error
grant Offline
Lurker

Registered: 10/25/09
Posts: 1
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

Top
#318305 - 11/11/09 05:07 PM Re: Table Error [Re: grant]
Gizmo Offline

Wizard

Registered: 01/10/00
Posts: 5352
Loc: Portland, OR, USA
Well, it's saying that the table "w3t_users" doesn't exist in the database "mysql"; are both of these named correctly?
_________________________
UBB.Dev - Where you too can render your UBB install completely useless...
UGN Security, Elite Web Gamers & VNC Web Design & Development President
UBB.Threads: My UBBSkins, UBB.Sitemaps

Top
#318306 - 11/11/09 06:08 PM Re: Table Error [Re: Gizmo]
Ruben Rocha Offline
Member

Registered: 01/19/00
Posts: 182
Loc: Lutz,FL,USA
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.

Top



Latest Posts
Shout Box

(Views)Popular Topics
Known public proxy servers 1636135
Integrated Index Page (IIP) 5.3.1 528187
Finished-[6.5.2] Games Arcade Deluxe v1.9 486016
Integrated Index Page (IIP) 5.1.1 401388
TLD Bv2.1 Released - Threads Links Directory 382774
[6.0x] Who's Online 4.0.0 [Finished] 374847
Finished-[6.5.1] Integrated Index Page (IIP) 6.5 318709
Q & A 264276
[6.3.x] [beta] Hit Hack 2.0 225221
[7.x] Gizmo's Embedding BBCode (Pre UBB.T7.3) 202973
Forum Stats
13620 Members
59 Forums
37189 Topics
295701 Posts

Max Online: 686 @ 06/28/07 07:04 AM

 

 

 
fusionbb message board php hacks