Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
Who's Online
6 registered (ChevyGuy, Djuma, DougMM, Pink Jazz, Thelockman, 1 invisible), 22 Guests and 24 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 11/02/08
Posts: 2
Top Posters (30 Days)
Ruben Rocha 179
Gizmo 112
Rick 109
Thelockman 80
driv 43
AllenAyres 35
ntdoc 28
Ian 24
Sirdude 23
ScriptKeeper 20
Latest Photos
My Home System
test photo gallery
Bernese Mountain Dogs
My Daimler
Dorado and shark
Page 1 of 2 1 2 >
Topic Options
Rate This Topic
#129671 - 07/29/06 10:34 AM 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 07:27 AM Re: MySQL Error in Installation!
AllenAyres Moderator Offline

****

Registered: 12/29/03
Posts: 1639
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 06: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 08:28 AM Re: MySQL Error in Installation! [Re: gigantic]
Rick Administrator Offline

*****

Registered: 06/04/06
Posts: 7898
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.
_________________________
UBB.threads™ Developer
My Personal Website · StogieSmokers.com

Top
#196152 - 09/03/07 05:44 PM Re: MySQL Error in Installation! [Re: Rick]
Gizmo Moderator Offline

***

Registered: 06/04/06
Posts: 12006
Loc: Portland, OR; USA
Yeh, there are quite a few security issues in 6.5 which are all hammered out in 6.5.5
_________________________
UGN Security, Elite Web Gamers & VNC Web Design Owner
Longtime UBB Supporter, UBB7 Beta Tester & Resident Post-A-Holic

Top
#196301 - 09/05/07 03: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 04:01 AM Re: MySQL Error in Installation! [Re: gigantic]
Gizmo Moderator Offline

***

Registered: 06/04/06
Posts: 12006
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
_________________________
UGN Security, Elite Web Gamers & VNC Web Design Owner
Longtime UBB Supporter, UBB7 Beta Tester & Resident Post-A-Holic

Top
#196322 - 09/05/07 09:33 AM Re: MySQL Error in Installation! [Re: Gizmo]
Rick Administrator Offline

*****

Registered: 06/04/06
Posts: 7898
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?
_________________________
UBB.threads™ Developer
My Personal Website · StogieSmokers.com

Top
#196329 - 09/05/07 11:36 AM Re: MySQL Error in Installation! [Re: Rick]
AllenAyres Moderator Offline

****

Registered: 12/29/03
Posts: 1639
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 04:43 PM Re: MySQL Error in Installation! [Re: AllenAyres]
Gizmo Moderator Offline

***

Registered: 06/04/06
Posts: 12006
Loc: Portland, OR; USA
I sense an eyepatch, a pegleg, and a small parrot...
_________________________
UGN Security, Elite Web Gamers & VNC Web Design Owner
Longtime UBB Supporter, UBB7 Beta Tester & Resident Post-A-Holic

Top
Page 1 of 2 1 2 >


Shout Box

Today's Birthdays
brushie, cass, Monte G., twebman, White Gold Wielder
Recent Topics
Shrinking graemlins
by Djuma
Today at 05:48 PM
2 problems I'm seeing now.
by DougMM
Today at 04:39 PM
Which CSS Style Controls the bottom lines
by David DelMonte
Today at 01:51 PM
UBBThreads vs. vBulletin -- Defections & Why So Tough to Compare?
by WebMagic
Today at 12:28 PM
Font and column shifts occuring
by Bill B
Yesterday at 06:21 PM
Forum Stats
4261 Members
33 Forums
30532 Topics
154960 Posts

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