Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
2 registered (Dunny, Ruben), 48 Guests and 14 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 06/05/06
Posts: 709
Top Posters (30 Days)
Ruben 50
DennyP 24
Gizmo 24
Dunny 15
SteveS 13
AllenAyres 12
dbremer 10
SD 10
drkknght00 9
driv 8
Latest Photos
OK Corral Shoot Out
Testing
Basildon Train Station
Basildon Town Centre looking from the rounderbout
Basildon Town Square
Topic Options
#222995 - 02/24/09 08:16 PM [FIXED for 7.5.1] [7.5] createtables.php b0rkt
DLWebmaestro Offline
enthusiast
Registered: 03/26/08
Posts: 333
Loc: 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.)
_________________________
Marching Percussion ( Drumline ) Community
Top
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."
#222996 - 02/24/09 08:19 PM Re: [7.5] createtables.php b0rkt [Re: DLWebmaestro]
Ruben Online   hyper

Registered: 12/20/03
Posts: 4424
Loc: Lutz,FL
Your almost dangerous hacking up a fresh version hours old.
HE HE
_________________________
Blue Man Group
Top
#222997 - 02/24/09 08:19 PM Re: [7.5] createtables.php b0rkt [Re: DLWebmaestro]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: 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.
Top
#222999 - 02/24/09 08:22 PM Re: [7.5] createtables.php b0rkt [Re: Rick]
Ruben Online   hyper

Registered: 12/20/03
Posts: 4424
Loc: Lutz,FL
twenty lashes with the whip.
Got one or two items to go.
And we take away your stogie.
_________________________
Blue Man Group
Top
#223006 - 02/24/09 09:22 PM Re: [7.5] createtables.php b0rkt [Re: Ruben]
DLWebmaestro Offline
enthusiast
Registered: 03/26/08
Posts: 333
Loc: 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), 
_________________________
Marching Percussion ( Drumline ) Community
Top
#223007 - 02/24/09 09:28 PM Re: [7.5] createtables.php b0rkt [Re: DLWebmaestro]
DLWebmaestro Offline
enthusiast
Registered: 03/26/08
Posts: 333
Loc: 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.


Edited by DLWebmaestro (02/24/09 09:31 PM)
_________________________
Marching Percussion ( Drumline ) Community
Top
#223008 - 02/24/09 09:53 PM Re: [7.5] createtables.php b0rkt [Re: DLWebmaestro]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: 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.
Top
#223046 - 02/25/09 09:58 AM Re: [7.5] createtables.php b0rkt [Re: Rick]
Mors Offline
addict
Registered: 06/26/06
Posts: 471
Loc: 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 !!!
Top
#223049 - 02/25/09 10:13 AM Re: [7.5] createtables.php b0rkt [Re: Mors]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: 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.
Top
#223173 - 02/26/09 12:36 AM Re: [7.5] createtables.php b0rkt [Re: Rick]
Mors Offline
addict
Registered: 06/26/06
Posts: 471
Loc: So. California
it is fixed. something messed up the PHP installation.. must of been coincidence
_________________________
Happy Customer !!!
Top



Moderator:  AllenAyres, Harold, Ian, Ron M 
Shout Box

Today's Birthdays
No Birthdays
Recent Topics
Temporary Password email not being received
by
05/24/12 10:02 PM
Ability to "like" individual posts (not Facebook "likes)
by doug
05/23/12 09:03 AM
Island Permissions
by ThreadsUser
05/22/12 03:03 PM
streaming video
by prkrgrp
05/20/12 07:02 PM
New Posts Corrupted? Can someone help?
by PianoWorld
05/19/12 09:41 AM
Forum Stats
10492 Members
36 Forums
33842 Topics
181709 Posts

Max Online: 978 @ 06/24/07 11:19 PM
Random Image