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: 5287
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: 169
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 (), 23 Guests and 19 Spiders online.
Key: Admin, Global Mod, Mod
Shout Box

Ubb - Buy It!
best forum software
Latest Posts
I want to create a Self Search mod [Question]
by lightningrod
03/10/10 09:04 PM
If I create a new script, can I just upload it?
by lightningrod
03/10/10 05:35 PM
Notepad Creates Errors when working with PHP
by lightningrod
03/10/10 05:01 PM
Question on Adding a New Script ?
by lightningrod
03/10/10 06:39 AM
Disable Watch List option
by Mike_Tabat
03/09/10 01:27 PM
[7.x] [Pre-7.3] [Final] pJIRC Addon v0.5
by Gizmo
02/27/10 05:07 PM
How to Be a Great Host
by pinku
02/19/10 02:47 AM
New Mods
Disable Watch List option
by Mike_Tabat
02/18/10 09:14 AM
[7.x] Generic Page Outside of forum directory
by
01/14/07 10:58 PM
[7.x] [Pre-7.3] [Final] pJIRC Addon v0.5
by
07/30/06 10:42 PM
Newest Members
Vick, Bartman, Infinity Master, Cry0, Romeos Tune
13494 Registered Users
Top Posters
AllenAyres 25554
JoshPet 11330
Rick 8373
LK 7396
Lord Dexter 6503
Greg Hard 5533
Charles Capps 5438
(Views)Popular Topics
Known public proxy servers 1028046
Finished-[6.5.2] Games Arcade Deluxe v1.9 327222
Integrated Index Page (IIP) 5.3.1 279924
Integrated Index Page (IIP) 5.1.1 279403
TLD Bv2.1 Released - Threads Links Directory 270427
[6.0x] Who's Online 4.0.0 [Finished] 230365
Finished-[6.5.1] Integrated Index Page (IIP) 6.5 217518
[6.3.x] [beta] Hit Hack 2.0 179339
FlashChat & UBB.threads 161010
[7.x] Gizmo's Embedding BBCode (Pre UBB.T7.3) 154650
Forum Stats
13495 Members
59 Forums
37114 Topics
290378 Posts

Max Online: 686 @ 06/28/07 07:04 AM
Featured Member
Registered: 02/02/10
Posts: 2

 

 

 
fusionbb message board php hacks