Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
Who's Online
0 registered (), 19 Guests and 23 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 06/05/06
Posts: 340
Top Posters (30 Days)
Ruben Rocha 103
Rick 81
Mark S 72
Thelockman 56
Gizmo 50
driv 35
Sirdude 30
ntdoc 30
packlite 24
AllenAyres 22
Latest Photos
bear test
Beach Barbie-Q
Sunset
Accept the challenge!
Trees
Topic Options
Rate This Topic
#165570 - 10/10/06 05:53 AM SQL ERROR: new install
Vipernet Offline
stranger

Registered: 10/10/06
Posts: 1
Seems to install ok with no errors but once i go and click on the fourms it shows header/footer but gives the following error:

Code:
SQL ERROR: Unable to do_query: SELECT Bo_Title,Bo_Description,Bo_Keyword,Bo_Total,Bo_Last,
Bo_Number,Bo_Moderated,Bo_Read_Perm,Bo_Write_Perm,
Bo_Threads,Bo_Sorter,Bo_Poster,Bo_Moderators,
Bo_LastMain,Bo_LastNumber FROM ubb_Boards 
WHERE Bo_Cat = 1 AND (Bo_Read_Perm LIKE '%-3-%' OR 
Bo_Read_Perm LIKE '%-1-%') ORDER BY Bo_Sorter 
Table 'ubb.ubb_Boards' doesn't exist 

 



i under stand basicly its missing the table ubb_Boards so i double checked my sql tables and it is missing. I reinstalled after wiping the tables from my database to see if i could get an error on the install to see why ubb_boards is not being created and i got the following error:


You may now proceed to creating the database tables.

Code:
 

Creating the tables...
SQL ERROR: Unable to do_query: CREATE TABLE ubbBoards( Bo_Title text, 
Bo_Description text,Bo_Keyword varchar(100) NOT NULL, 
Bo_Total INT(9) UNSIGNED, Bo_Last INT(11) UNSIGNED, 
Bo_HTML varchar(3) DEFAULT 'On' NOT NULL, 
Bo_Markup varchar(3) DEFAULT 'On' NOT NULL, 
Bo_Number INT(9) UNSIGNED DEFAULT '0' AUTO_INCREMENT PRIMARY KEY, 
Bo_Created INT(11) UNSIGNED, 
Bo_Expire INT(4) UNSIGNED, 
Bo_Approve varchar(3) DEFAULT 'Off' NOT NULL, 
Bo_Moderated varchar(3) DEFAULT 'no', 
Bo_Cat INT(4) UNSIGNED DEFAULT '1' NOT NULL, 
Bo_Read_Perm varchar(250) DEFAULT '-3-4-', 
Bo_Write_Perm varchar(250) DEFAULT '-3-4-', 
Bo_Threads INT(9) UNSIGNED unsigned DEFAULT '0', 
Bo_Sorter INT(4) UNSIGNED, Bo_CatName varchar(255), 
Bo_ThreadAge INT(4) UNSIGNED, Bo_Poster varchar(64), Bo_Reply_Perm varchar(25) DEFAULT '-3-4-', 
Bo_Moderators text, Bo_SpecialHeader INT(1), 
Bo_Stylesheet varchar(50), Bo_LastNumber INT(9), 
Bo_lastMain INT(9) ,UNIQUE indx1 (Bo_Keyword), 
INDEX indx2 (Bo_Number), INDEX Cat_ndx (Bo_Cat) )
Invalid default value for 
'Bo_Number'Board table created...
Posts table created...
Adding a master poll table...
Adding the poll results table...
Last viewed table created...
Category table created...
Users table created...
Moderator table created...
Messages table created...
Banned table created...
Groups table createdBasic groups created...
Online table created...
Subscribe table created...
Creating table for the address book...
Creating the table to store favorites and reminders...
SQL ERROR: Unable to do_query: 
CREATE TABLE ubbFavorites( F_Number INT(9) 
UNSIGNED DEFAULT '0' AUTO_INCREMENT PRIMARY KEY, 
F_Thread INT(9) UNSIGNED DEFAULT '0' NOT NULL, 
F_Owner varchar(64) NOT NULL, 
F_LastPost INT(4) UNSIGNED, F_Type varchar(1) ,
INDEX FAV_indx1 (F_Owner) ) 
Invalid default value for 
'F_Number'Creating the table to store posts that a moderator has been notified on...
Inserting a placeholder user for anonymous posts...

All tables created. 

You will want to remove all altertables, createtable.php and install.php from your webserver. 



Do i have a corrupt createtable.php file? Am i able to get a new copy if so? Really at a loss on what to do, any suggests, tips or pointing me in the right dicerction would be very helpful.

Thanks
Vipernet


Edited by Vipernet (10/10/06 05:57 AM)

Top
#165577 - 10/10/06 07:51 AM Re: SQL ERROR: new install [Re: Vipernet]
Rick Administrator Offline

*****

Registered: 06/04/06
Posts: 7993
Loc: Aberdeen, WA
Can you tell me what version of MySQL you are using? It somewhat looks like you might be using version 5 which 6.5.5 doesn't support. Only the latest version 7 will run on MySQL 5.
_________________________
UBB.threads™ Developer
My Personal Website · StogieSmokers.com

Top


Shout Box

Today's Birthdays
theregit
Recent Topics
New members don't get access and are not displayed in the config panel
by Yomar
Yesterday at 03:32 AM
How to Change Link Color / Underline in styles?
by ECNet
01/07/09 10:00 PM
Chaging the "max online" number and date
by wanted
01/07/09 02:22 PM
7.4.1. In Threaded Mode - "Mark All Read" Doesn't Work
by packlite
01/07/09 10:26 AM
Custom island with sql connection
by Robje01
01/07/09 09:13 AM
Forum Stats
4296 Members
33 Forums
30687 Topics
156017 Posts

Max Online: 978 @ 06/24/07 08:19 PM