Previous Thread
Next Thread
Print Thread
Hop To
#129671 07/29/2006 1:34 PM
Joined: Jul 2006
Posts: 1
P
stranger
stranger
P Offline
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:

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. 

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="" />


- Allen
- ThreadsDev | PraiseCafe
Joined: Sep 2007
Posts: 3
G
stranger
stranger
G Offline
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:

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!!

Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
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
UBB.threads Developer
UBB.threads Developer
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


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Sep 2007
Posts: 3
G
stranger
stranger
G Offline
Joined: Sep 2007
Posts: 3
ubbthreads-6-5-1-1 frown. 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 laugh

Joined: Jun 2006
Posts: 16,299
Likes: 116
UBB.threads Developer
UBB.threads Developer
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


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
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
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
Joined: Jun 2006
Posts: 16,299
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,299
Likes: 116
I sense an eyepatch, a pegleg, and a small parrot...


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Sep 2007
Posts: 3
G
stranger
stranger
G Offline
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
UBB.threads Developer
UBB.threads Developer
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.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
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=ma

Otherwise, 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.


- Allen
- ThreadsDev | PraiseCafe
Joined: May 2008
Posts: 17
newbie
newbie
Joined: May 2008
Posts: 17
me too lol


Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Bots
by Outdoorking - 04/13/2024 5:08 PM
Can you add html to language files?
by Baldeagle - 04/07/2024 2:41 PM
Do I need to rebuild my database?
by Baldeagle - 04/07/2024 2:58 AM
This is not a bug, but a suggestion
by Baldeagle - 04/05/2024 11:25 PM
Is UBB.threads still going?
by Aaron101 - 04/01/2022 8:18 AM
Who's Online Now
0 members (), 797 guests, and 200 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)