Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
2 registered (Ruben, Gizmo), 34 Guests and 9 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 08/24/09
Posts: 29
Top Posters (30 Days)
Ruben 45
Bert 26
Gizmo 18
Rob Provencher 12
Rimex 9
SD 8
sw55 7
Eugene 5
TCS1 4
Matthias1976 4
Latest Photos
Uhm...
Mayan End of World
Gas Station Disco Video Shoot
Test Pictures
Audrey Kate
Page 1 of 2 1 2 >
Topic Options
#129671 - 07/29/06 12:34 PM MySQL Error in Installation!
Pier-Luc Offline
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:

 Code:
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
#129672 - 07/30/06 09:27 AM Re: MySQL Error in Installation!
AllenAyres Offline
Registered: 12/29/03
Posts: 2020
Loc: Texas
looks like the users table didn't get created, you might try dropping the tables and trying again. I would imagine the trial forum needs some updating
_________________________
- Allen
- ThreadsDev | PraiseCafe
Top
#196076 - 09/02/07 08:10 PM Re: MySQL Error in Installation! [Re: AllenAyres]
gigantic Offline
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:

 Code:
 "
	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
#196106 - 09/03/07 10:28 AM Re: MySQL Error in Installation! [Re: gigantic]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10177
Loc: Aberdeen, WA
The problem is all the "default '0' portions. If you must install a 6.5 version, then you'd want to get 6.5.5 as this is fixed in there. Otherwise, you should definitely be going with version 7.
Top
#196152 - 09/03/07 07:44 PM Re: MySQL Error in Installation! [Re: Rick]
Gizmo Online   cat

Registered: 06/05/06
Posts: 15453
Loc: Portland, OR; USA
Yeh, there are quite a few security issues in 6.5 which are all hammered out in 6.5.5
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime Supporter, Beta Tester & Resident Post-A-Holic.
Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Top
#196301 - 09/05/07 05:54 AM Re: MySQL Error in Installation! [Re: Gizmo]
gigantic Offline
stranger
Registered: 09/02/07
Posts: 3
ubbthreads-6-5-1-1 :(. i paid over $199 for this and can't even get an update nor INSTALL it...wtf. You know what I'm looking for. If you can help me out, please, thx \:D
Top
#196302 - 09/05/07 06:01 AM Re: MySQL Error in Installation! [Re: gigantic]
Gizmo Online   cat

Registered: 06/05/06
Posts: 15453
Loc: Portland, OR; USA
The current zip in the install area is 6.5.5; if you've just spent $199 then you need to go and update; 6.5 versions prior to 6.5.5 have vast security issues and you shouldn't just assume you will be safe (as it's easy enough to use Google to turn up sites running the 6.5.x releases).. honestly, i'd say that it's not WORTH installing 6.5.x unless you are using it to migrate to .t7 or will be operating 6.5.5
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime Supporter, Beta Tester & Resident Post-A-Holic.
Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Top
#196322 - 09/05/07 11:33 AM Re: MySQL Error in Installation! [Re: Gizmo]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10177
Loc: Aberdeen, WA
Like I said, if you must install that version, then the "default '0'" portions need to be removed from the createtable. As has been stated, you're opening yourself up to security issues though.

I am a bit curious however, why you're just now installing 6.5.1.1 since it was released well over 2 years ago, back in March of '05?
Top
#196329 - 09/05/07 01:36 PM Re: MySQL Error in Installation! [Re: Rick]
AllenAyres Offline
Registered: 12/29/03
Posts: 2020
Loc: Texas
 Originally Posted By: Rick
I am a bit curious however, why you're just now installing 6.5.1.1 since it was released well over 2 years ago, back in March of '05?


::crickets::
_________________________
- Allen
- ThreadsDev | PraiseCafe
Top
#196383 - 09/05/07 06:43 PM Re: MySQL Error in Installation! [Re: AllenAyres]
Gizmo Online   cat

Registered: 06/05/06
Posts: 15453
Loc: Portland, OR; USA
I sense an eyepatch, a pegleg, and a small parrot...
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime Supporter, Beta Tester & Resident Post-A-Holic.
Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Top
Page 1 of 2 1 2 >



Shout Box

Today's Birthdays
No Birthdays
Recent Topics
Express hosting.
by Ruben
05/16/13 03:54 PM
Level of detail in new user registration emails
by Mitch P.
05/15/13 10:20 PM
Approving users
by Bert
05/15/13 09:22 PM
Users randomly added to other group
by Bert
05/15/13 09:15 PM
Posting and other problems with 7.5.7
by Matthias1976
05/15/13 02:58 PM
Forum Stats
10965 Members
36 Forums
33957 Topics
183405 Posts

Max Online: 978 @ 06/24/07 10:19 PM
Random Image