|
Joined: Jul 2006
Posts: 1
stranger
|
stranger
Joined: Jul 2006
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.
|
|
|
|
Joined: Dec 2003
Posts: 1,796
Pooh-Bah
|
Pooh-Bah
Joined: Dec 2003
Posts: 1,796 |
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 <img src="https://www.ubbcentral.com/boards/images/graemlins/smile.gif" alt="" />
|
|
|
|
Joined: Sep 2007
Posts: 3
stranger
|
stranger
Joined: Sep 2007
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!!
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
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.
|
|
|
|
Joined: Jun 2006
Posts: 16,299 Likes: 116
|
Joined: Jun 2006
Posts: 16,299 Likes: 116 |
Yeh, there are quite a few security issues in 6.5 which are all hammered out in 6.5.5
|
|
|
|
Joined: Sep 2007
Posts: 3
stranger
|
stranger
Joined: Sep 2007
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
|
|
|
|
Joined: Jun 2006
Posts: 16,299 Likes: 116
|
Joined: Jun 2006
Posts: 16,299 Likes: 116 |
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
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
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?
|
|
|
|
Joined: Dec 2003
Posts: 1,796
Pooh-Bah
|
Pooh-Bah
Joined: Dec 2003
Posts: 1,796 |
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::
|
|
|
|
Joined: Jun 2006
Posts: 16,299 Likes: 116
|
Joined: Jun 2006
Posts: 16,299 Likes: 116 |
I sense an eyepatch, a pegleg, and a small parrot...
|
|
|
|
Joined: Sep 2007
Posts: 3
stranger
|
stranger
Joined: Sep 2007
Posts: 3 |
I am installing the ancient 6.5.1.1 version because that is all that I have backed up and no longer have access to download nor login to the members section to receive any updates. Can anyone link me an update?
|
|
|
|
Joined: Jun 2006
Posts: 16,299 Likes: 116
|
Joined: Jun 2006
Posts: 16,299 Likes: 116 |
It would be a violation of our licenses to provide you with an upgrade; if you wish to upgrade past 6.5.1 (which is the latest version you have) you'll need to renew your license.
|
|
|
|
Joined: Dec 2003
Posts: 1,796
Pooh-Bah
|
Pooh-Bah
Joined: Dec 2003
Posts: 1,796 |
You can renew very inexpensively here and get the latest/best code: http://www.infopop.com/order/order.php?a=threads&t=service&d=maOtherwise, your version has various bugs/security exploits that will make running a forum like playing russian roulette. You may be lucky for a long time, or someone may just delete it for you - it's possible for any version prior to 6.5.4 I believe.
|
|
|
|
Joined: May 2008
Posts: 17
newbie
|
newbie
Joined: May 2008
Posts: 17 |
|
|
|
Bots
by Outdoorking - 04/13/2024 5:08 PM
|
|
|
|
|
|
0 members (),
797
guests, and
200
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|