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: 5305
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: 172
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



Who's Online
0 registered (), 49 Guests and 7 Spiders online.
Key: Admin, Global Mod, Mod
Shout Box

Ubb - Buy It!
best forum software
Latest Posts
[7.2.1] - Naked shoutbox
by MithofOT
08/31/10 01:58 PM
[7.5.5] getting $_COOKIE to work
by gtho4
08/29/10 12:28 AM
Jelsoft Bought
by AllenAyres
08/20/10 04:44 PM
UBBDev Now Running Threads 7.5.6
by AllenAyres
08/18/10 07:59 PM
How do I add another field to the profile page?
by Gizmo
08/05/10 09:24 AM
UBB developer needed.
by AllenAyres
08/03/10 02:57 PM
New Mods
How do I add another field to the profile page?
by Vee
08/05/10 06:02 AM
[7.2.1] - Naked shoutbox
by sirdude
08/17/07 10:36 PM
Newest Members
stevebrummie, Neronrg, Vee, dessy, Manish
13533 Registered Users
Top Posters
AllenAyres 25565
JoshPet 11330
Rick 8373
LK 7396
Lord Dexter 6503
Greg Hard 5533
Charles Capps 5438
(Views)Popular Topics
Known public proxy servers 1224347
Finished-[6.5.2] Games Arcade Deluxe v1.9 375009
Integrated Index Page (IIP) 5.3.1 345193
Integrated Index Page (IIP) 5.1.1 322504
TLD Bv2.1 Released - Threads Links Directory 301614
[6.0x] Who's Online 4.0.0 [Finished] 267207
Finished-[6.5.1] Integrated Index Page (IIP) 6.5 244632
[6.3.x] [beta] Hit Hack 2.0 197599
[7.x] Gizmo's Embedding BBCode (Pre UBB.T7.3) 173774
FlashChat & UBB.threads 169520
Forum Stats
13533 Members
59 Forums
37128 Topics
290448 Posts

Max Online: 686 @ 06/28/07 07:04 AM
Featured Member
Registered: 07/03/01
Posts: 811

 

 

 
fusionbb message board php hacks