Previous Thread
Next Thread
Print Thread
Hop To
Joined: Mar 2008
Posts: 326
D
Enthusiast
Enthusiast
D Offline
Joined: Mar 2008
Posts: 326
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.)

Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
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
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
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.

Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
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
Joined: Mar 2008
Posts: 326
D
Enthusiast
Enthusiast
D Offline
Joined: Mar 2008
Posts: 326
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), 

Joined: Mar 2008
Posts: 326
D
Enthusiast
Enthusiast
D Offline
Joined: Mar 2008
Posts: 326
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/2009 10:31 PM.
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
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.

Joined: Jun 2006
Posts: 464
Likes: 1
M
Addict
Addict
M Offline
Joined: Jun 2006
Posts: 464
Likes: 1
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 !!!
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
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.

Joined: Jun 2006
Posts: 464
Likes: 1
M
Addict
Addict
M Offline
Joined: Jun 2006
Posts: 464
Likes: 1
it is fixed. something messed up the PHP installation.. must of been coincidence


Happy Customer !!!

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
2 members (Gizmo, Nightcrawler), 553 guests, and 186 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)