 |
 |
 |
 |
Registered: 02/14/08
Posts: 2
|
|
|
 |
 |
 |
 |
|
 |
 |
 |
 |
#129671 - 07/29/06 10:34 AM
MySQL Error in Installation!
|
stranger
Registered: 07/29/06
Posts: 1
|
I'm trying to install the Trial and I always get an error when the ubbthreads/install/install.php file is running and when I'm at the Creating Tables part. It says: Creating the tables...
We cannot proceed.
Script: /home/pierluc/public_html/ubbthreads/ubbt.inc.php
Line#: 1556
SQL Error: Table 'pierluc_ubb.pierluc_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 pierluc_Users WHERE U_Number = ''
Please use your back button to return to the previous page.
|
|
Top
|
|
|
|
|
 |
 |
 |
 |
 |
 |
 |
 |
#196076 - 09/02/07 06:10 PM
Re: MySQL Error in Installation!
[Re: AllenAyres]
|
stranger
Registered: 09/02/07
Posts: 3
|
I am having the exact same issue whenever I try to install UBB Threads 6.5. I have looked up the createtable.php file and found the entry where the script is supposed to create the USERS table. Below: "
CREATE TABLE {$config['tbprefix']}Users(
U_LoginName $varchar(64) NOT NULL,
U_Username $varchar(64) NOT NULL,
U_Password $varchar(32) NOT NULL,
U_Email $varchar(50),
U_Fakeemail $varchar(50),
U_Name $varchar(100),
U_Totalposts $int9 default '0',
U_Laston $int11,
U_Signature $text,
U_Homepage $varchar(150),
U_Occupation $varchar(150),
U_Hobbies $varchar(200),
U_Location $varchar(200),
U_Bio $text,
U_Status $varchar(15) DEFAULT 'User' NOT NULL,
U_Display $varchar(10) NOT NULL DEFAULT 'flat',
U_View $varchar(10) NOT NULL,
U_PostsPer $int11,
U_Number $int9 $autoincs PRIMARY KEY,
U_EReplies $varchar(3) NOT NULL,
U_Notify $varchar(3) NOT NULL,
U_TextCols $varchar(3),
U_TextRows $varchar(3),
U_Extra1 $varchar(200),
U_Extra2 $varchar(200),
U_Extra3 $varchar(200),
U_Extra4 $varchar(200),
U_Extra5 $varchar(200),
U_Registered $int11,
U_Preview $varchar(5),
U_Picture $varchar(150),
U_PictureView $varchar(3),
U_Visible $varchar(3) DEFAULT 'yes',
U_PicturePosts $varchar(3),
U_AcceptPriv $varchar(3) DEFAULT 'yes',
U_RegEmail char(50),
U_RegIP char(15),
U_Groups $varchar(250) DEFAULT '-1-',
U_Language $varchar(20),
U_Title $varchar(100),
U_FlatPosts $varchar(2),
U_TempPass $varchar(32),
U_Color $varchar(15),
U_StyleSheet $varchar(50),
U_TimeOffset $varchar(10),
U_Privates $int4 DEFAULT '0',
U_FrontPage $varchar(20),
U_StartPage $varchar(2) DEFAULT 'cp',
U_Favorites $varchar(250) DEFAULT '-',
U_ShowSigs $varchar(3),
U_OnlineFormat $varchar(3),
U_Rating $varchar(5) DEFAULT '0',
U_Rates $int4 DEFAULT '0',
U_RealRating $int1,
U_PicWidth $int4,
U_PicHeight $int4,
U_SessionId varchar(64) NOT NULL DEFAULT '0',
U_Approved VARCHAR(8) NOT NULL,
U_Palprofile $int11,
U_AdminEmails VARCHAR(3),
U_EmailFormat VARCHAR(10),
U_WhichForums VARCHAR(3) DEFAULT 'all',
U_Categories VARCHAR(255) DEFAULT '-',
U_Banned INT(1) DEFAULT '0',
U_CoppaUser INT(1) UNSIGNED DEFAULT '0',
U_Birthday VARCHAR(10) NOT NULL DEFAULT '0',
U_ShowBday INT(1) NOT NULL DEFAULT '0',
U_TimeFormat VARCHAR(6),
U_Ignored TEXT,
U_OC_Userid VARCHAR(64),
U_LastPostTime INT(11) unsigned,
U_LastPostIP VARCHAR(15),
U_LastSearch INT(11),
U_SearchSession VARCHAR(32),
U_FloodControl MEDIUMINT(8),
U_LastPost INT(11) UNSIGNED,
U_ProfileHash VARCHAR(32)
$indexes
)"Can someone please help me by rewriting the above so I can directly enter this as a SQL command to create this USERS table. I have looked all over and still suffer from not finding the correct way to execute this as a SQL command. Thanks!!
|
|
Top
|
|
|
|
|
 |
 |
 |
 |
|
|