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
#22300 - 06/22/03 06:10 AM 6.1.1 to 6.3 HELP!!
Anonymous
Unregistered

I optimized the database, backed it up.

Then, I uploaded the 6.3 files, changing the path in main.inc.php.

The I ran altertable-6.1.1-6.2.php, and I get this:

HELP!!!!!

I uploaded the files, called up altertable 6.1-6.2.php, and I get this:

Converting old poll votes from username to usernumber..
SQL ERROR: Unable to do_query: SELECT DISTINCT P_IP FROM w3t_PollData
No Database Selected
Warning: Supplied argument is not a valid MySQL result resource in /home/twenty4hourcampfire/ubbthreads/mysql.inc.php on line 131
Alter the Boards table to drop the Bo_Moderators field...
SQL ERROR: Unable to do_query: ALTER TABLE w3t_Boards DROP Bo_Moderators
No Database SelectedSQL ERROR: Unable to do_query: ALTER TABLE w3t_Users DROP U_Post_Format
No Database SelectedProceed to step 2

What now? I HATE upgrades!

Rick
Top
#22301 - 06/22/03 07:09 PM Re: 6.1.1 to 6.3 HELP!!
Anonymous
Unregistered

Did you overwrite your config.inc.php file? It looks like maybe the dbname value in that file doesn't exist so it can't actually select the database to work on.

-------------------
Rick Baker
UBBThreads developer
Top
#22302 - 06/23/03 01:35 PM Re: 6.1.1 to 6.3 HELP!!
Anonymous
Unregistered

Rick:

That must have been it. I went back and re-uploaded the old config.inc.php file and ran the altertable again, and it worked. The only thing I got was a fatal error when running altertable-6.2-6.3-replies that said something like:

Fatal error: System timed out at line 1849.

What should I make of this error? Everything seems to be working fine.

Thanks.
Top
#22303 - 06/23/03 06:32 PM Re: 6.1.1 to 6.3 HELP!!
Anonymous
Unregistered

As the UPGRADING.html file says - your browser may time out on the altertable script - depending on the size of your database. It's OK - MySQL and the process continues and completes. So all should be fine. <img border="0" title="" alt="[Smile]" src="images/icons/smile.gif" />

Josh
www.joshuapettit.com
ThreadsDev.com Administrator | InfoPop Community Moderator
Register to see my How To/Site Help Library Forum at ThreadsDev.com.
My threads 'tweaking' abilities are for hire for upgrades, tweaks and modifications.
Top
#22304 - 06/25/03 02:03 PM Re: 6.1.1 to 6.3 HELP!!
Anonymous
Unregistered

Hi,
I also have a problem with:
altertable-6-3-replies.php

is runs some time and then I do get an "Internal Server Error"

I repeated this action several times but it kees on failing ...

two questions:
1. how to solve ?
2. can I re-open the board in the mean time ??

[This message was edited by Matthijs on June 25, 2003 at 11:30 AM.]
Top
#22305 - 06/25/03 07:32 PM Re: 6.1.1 to 6.3 HELP!!
Anonymous
Unregistered

</font><blockquote><font size="1" face="">quote:</font><hr /><font size="" face="">Originally posted by JoshPet:
As the UPGRADING.html file says - "your browser may time out on the altertable script - depending on the size of your database. It's OK - MySQL and the process continues and completes." So all should be fine. <img border="0" title="" alt="[Smile]" src="images/icons/smile.gif" />
</font><hr /></blockquote><font size="" face="">Yes, as I said above - all should be fine. <img border="0" title="" alt="[Wink]" src="images/icons/wink.gif" />

There is a "fix" to this here:
http://community.infopop.net/6/ubb.x?a=tpc&s=729094322&f=6183028913&m=5213083527

If you want to rerun it.

Josh
www.joshuapettit.com
ThreadsDev.com Administrator | InfoPop Community Moderator
Register to see my How To/Site Help Library Forum at ThreadsDev.com.
My threads 'tweaking' abilities are for hire for upgrades, tweaks and modifications.
Top



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