Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online Now
1 registered members (Pilgrim), 57 guests, and 278 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
Gizmo
Gizmo
Portland, OR; USA
Posts: 16,785
Joined: June 2006
Show All Member Profiles 
Top Posters(30 Days)
Gizmo 15
FREAK 11
M4TT 10
Ruben 5
mmkk 5
isaac 4
Latest Photos
Chinese Buddhist temple.
My buddha beads.
Rendered Walls
Multi-Screen wallpaper
Stockholm Metro
Previous Thread
Next Thread
Print Thread
[FIXED for 7.5.1] [7.5] createtables.php b0rkt #222995
02/24/09 08:16 PM
02/24/09 08:16 PM
Joined: Mar 2008
Posts: 340
North Carolina
D
DLWebmaestro Offline OP
enthusiast
DLWebmaestro  Offline OP
enthusiast
D
Joined: Mar 2008
Posts: 340
North Carolina
Some things need to be fixed here, else it is impossible to do a fresh install of 7.5.

in install/createtable.php


find:
PHP Code
USER_NOTIFY_MULTI tinyint(1) unsigned not null default '0' 


and replace with:
PHP Code
USER_NOTIFY_MULTI tinyint(1) unsigned not null default '0', 


delete this next chunk (it is trying to create PROFILE_COMMENTS again):
PHP Code
// PROFILE COMMENTS TABLE
$query = "																 
create table {$config['TABLE_PREFIX']}PROFILE_COMMENTS (			   
	COMMENT_ID int(11) unsigned not null primary key auto_increment,   
	PROFILE_ID int(9) unsigned not null,							   
	USER_ID int(9) unsigned not null,								  
	COMMENT_BODY text,												 
	COMMENT_DEFAULT_BODY text,										 
	COMMENT_MD5 varchar(32),										   
	COMMENT_TIME int(11) unsigned,									 
	INDEX profile_ndx (PROFILE_ID),									
	INDEX user_ndx (USER_ID),										  
	INDEX md5_ndx (COMMENT_MD5)										
) TYPE=MyISAM														  
";																		 
$dbh->do_query($query,"{$config['TABLE_PREFIX']}PROFILE_COMMENTS table created."); 


Note that this code chunk is the second instance of the code that tries to create the table. It is slightly different than the first one so you should be able to easily identify it. (Looks like it's missing some syntax at the end.)

Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
Re: [7.5] createtables.php b0rkt [Re: DLWebmaestro] #222996
02/24/09 08:19 PM
02/24/09 08:19 PM
Joined: Dec 2003
Posts: 5,824
Lutz,FL
Ruben Offline

Ruben  Offline


Joined: Dec 2003
Posts: 5,824
Lutz,FL
Your almost dangerous hacking up a fresh version hours old.
HE HE


Blue Man Group


There is no such thing as stupid questions. Just stupid answers
Re: [7.5] createtables.php b0rkt [Re: DLWebmaestro] #222997
02/24/09 08:19 PM
02/24/09 08:19 PM
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
R
Rick Offline
Former Developer
Rick  Offline
Former Developer
R
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
Argh, I need to relegate myself to the fact I never get the initial release right. Spent all day yesterday making sure, and ended up with several old files in place of the new one, like this. Thanks for the info.

Re: [7.5] createtables.php b0rkt [Re: Rick] #222999
02/24/09 08:22 PM
02/24/09 08:22 PM
Joined: Dec 2003
Posts: 5,824
Lutz,FL
Ruben Offline

Ruben  Offline


Joined: Dec 2003
Posts: 5,824
Lutz,FL
twenty lashes with the whip.
Got one or two items to go.
And we take away your stogie.


Blue Man Group


There is no such thing as stupid questions. Just stupid answers
Re: [7.5] createtables.php b0rkt [Re: Ruben] #223006
02/24/09 09:22 PM
02/24/09 09:22 PM
Joined: Mar 2008
Posts: 340
North Carolina
D
DLWebmaestro Offline OP
enthusiast
DLWebmaestro  Offline OP
enthusiast
D
Joined: Mar 2008
Posts: 340
North Carolina
Got another one for you... same file. This one needs to be fixed so that forums can be created.

find:
PHP Code
FROUM_SORT_DIR varchar(3), 

replace with:
PHP Code
FORUM_SORT_DIR varchar(3), 

Re: [7.5] createtables.php b0rkt [Re: DLWebmaestro] #223007
02/24/09 09:28 PM
02/24/09 09:28 PM
Joined: Mar 2008
Posts: 340
North Carolina
D
DLWebmaestro Offline OP
enthusiast
DLWebmaestro  Offline OP
enthusiast
D
Joined: Mar 2008
Posts: 340
North Carolina
And just in case someone has installed a new 7.5 and have the "FROUM_SORT_DIR" in their database (you get an error when trying to create a forum), here is a quick fix:
SQL Query
ALTER TABLE `ubbt_FORUMS` CHANGE `FROUM_SORT_DIR` `FORUM_SORT_DIR` VARCHAR( 3 )
Replace ubbt_ with your table prefix, if different.

Last edited by DLWebmaestro; 02/24/09 09:31 PM.
Re: [7.5] createtables.php b0rkt [Re: DLWebmaestro] #223008
02/24/09 09:53 PM
02/24/09 09:53 PM
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
R
Rick Offline
Former Developer
Rick  Offline
Former Developer
R
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
I see what I did wrong with the createtable script, I'll blame it on my editor (vi) wink Going over this now and will get this updated in the morning when Dave gets in.

Re: [7.5] createtables.php b0rkt [Re: Rick] #223046
02/25/09 09:58 AM
02/25/09 09:58 AM
Joined: Jun 2006
Posts: 472
So. California
Mors Offline
addict
Mors  Offline
addict
Joined: Jun 2006
Posts: 472
So. California
wow I updated my site and get this now ??

Fatal error: Call to undefined function mysql_connect() in D:\UBBMSB\latest\ubbthreads-7-4-2\libs\mysql.inc.php on line 36


is this related??

none of my sites work now.. mysql is jacked hmm


Happy Customer !!!
Re: [7.5] createtables.php b0rkt [Re: Mors] #223049
02/25/09 10:13 AM
02/25/09 10:13 AM
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
R
Rick Offline
Former Developer
Rick  Offline
Former Developer
R
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
I don't think that's related to the upgrade. Basically, it's saying that PHP isn't compiled with mysql_connect() or it's not turned on in the php.ini.

Can't remember if this is your server or a hosted, but if it's a hosted I'd open up a support ticket with the host and give them that error.

Re: [7.5] createtables.php b0rkt [Re: Rick] #223173
02/26/09 12:36 AM
02/26/09 12:36 AM
Joined: Jun 2006
Posts: 472
So. California
Mors Offline
addict
Mors  Offline
addict
Joined: Jun 2006
Posts: 472
So. California
it is fixed. something messed up the PHP installation.. must of been coincidence


Happy Customer !!!

Shout Box
Today's Birthdays
No Birthdays
Recent Topics
Shout Box Sound Effect
by M4TT. 11/29/17 08:28 PM
Ad island
by TGCsanderson. 11/25/17 06:41 PM
Taking to long to connect to DB
by AstroCat. 11/24/17 12:34 PM
I want to update forum but can't find license
by dimaninc. 11/23/17 10:51 AM
Forum Statistics
Forums36
Topics35,014
Posts190,533
Members12,045
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.6.1
(Snapshot build 20171106)