SQL ERROR: new install

Print Thread

Hop To

#165570 10/10/2006 8:53 AM

Joined: Oct 2006

Posts: 2

V

Vipernet

stranger

Vipernet

stranger

V

Joined: Oct 2006

Posts: 2

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

Last edited by Vipernet; 10/10/2006 8:57 AM.

Re: SQL ERROR: new install Vipernet #165577 10/10/2006 10:51 AM
Joined: Jun 2006 Posts: 9,242 Likes: 1 Aberdeen, WA R Rick Former Developer
Rick Former Developer R Joined: Jun 2006 Posts: 9,242 Likes: 1 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.

Link Copied to Clipboard

ShoutChat

Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.

UBB.threads PHP Forum Software Community Forums UBB.threads 6 Version 6 Support SQL ERROR: new install