Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
2 registered (SteveS, Gizmo), 33 Guests and 15 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 06/07/07
Posts: 4
Top Posters (30 Days)
Ruben 51
Gizmo 24
DennyP 24
Dunny 15
SteveS 14
AllenAyres 12
dbremer 10
SD 10
drkknght00 9
doug 8
Latest Photos
OK Corral Shoot Out
Testing
Basildon Train Station
Basildon Town Centre looking from the rounderbout
Basildon Town Square
Page 1 of 2 1 2 >
Topic Options
#191708 - 07/18/07 05:24 AM How can I run the update patch again.
Trunklid Offline
newbie
Registered: 02/22/07
Posts: 27
Loc: Bonney Lake, WA
I ran the patch to 7.2 and it left me at 7.1.1 now every time I try and repair or re-run the update it tells me "This upgrade has been completed. Please remove the entire install directory" I have deleted the install directory and re-uploaded the files from the 7.2 zip and I still get the message "This upgrade has been completed. Please remove the entire install directory" Is there a file that needs to be rolled back to think it is still 7.1.1 or do I need to reload the site from the backup I did prior to the update?

Hoping I can just roll back a file; if not what is the best way to reinstall the site from the backup? I would imagine with a fresh install and then another import...
_________________________
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."
#191738 - 07/18/07 10:32 AM Re: How can I run the update patch again. [Re: Trunklid]
AllenAyres Offline

Registered: 12/29/03
Posts: 1995
Loc: Texas
You probably need to open a support ticket for that -- many things could go wrong at this point trying to hand-hold an altertable script. \:\)

If you can "reload the site from the backup I did prior to the update" that will probably save you some time.
_________________________
- Allen
- ThreadsDev | PraiseCafe
Top
#191766 - 07/18/07 01:37 PM Re: How can I run the update patch again. [Re: AllenAyres]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
It appears this is a problem for some users upgrading from 7.0.x. It runs the 7.1 altertable, but not the 7.2 altertable. A quick fix for now, you can run the following SQL command:

update ubbt_VERSION set SCRIPT_VERSION='7.1.1'

After that, go through the upgrade script again and it will run the 7.2 alters.
Top
#191783 - 07/18/07 03:03 PM Re: How can I run the update patch again. [Re: Rick]
Trunklid Offline
newbie
Registered: 02/22/07
Posts: 27
Loc: Bonney Lake, WA
 Originally Posted By: Rick
It appears this is a problem for some users upgrading from 7.0.x. It runs the 7.1 altertable, but not the 7.2 altertable. A quick fix for now, you can run the following SQL command:

update ubbt_VERSION set SCRIPT_VERSION='7.1.1'

After that, go through the upgrade script again and it will run the 7.2 alters.


From the /ubbthreads directory the command: update ubbt_VERSION set SCRIPT_VERSION='7.1.1'

returns bash: update: command not found

Any suggestions? and thank you Gizmo and Rick for the help
_________________________
Top
#191785 - 07/18/07 03:07 PM Re: How can I run the update patch again. [Re: Trunklid]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
That's an actual SQL command you'll need to run. You'll want to run that either directly from a mysql shell or from something like phpmyadmin:

update ubbt_VERSION set SCRIPT_VERSION='7.1.1'
Top
#191788 - 07/18/07 04:16 PM Re: How can I run the update patch again. [Re: Rick]
Gizmo Online   cat

Registered: 06/05/06
Posts: 14995
Loc: Portland, OR; USA
Rick, tried running that then going through the upgrade and it still says he's running 7.1.1; and further proof the altertable wasn't run is that when editing a forum he gets:
 Code:
SELECT FORUM_TITLE,FORUM_DESCRIPTION,FORUM_ALLOW_HTML,FORUM_ALLOW_MARKUP,FORUM_IS_MODERATED,CATEGORY_ID,FORUM_DEFAULT_TOPIC_AGE,FORUM_CUSTOM_HEADER,FORUM_STYLE,FORUM_IMAGE,FORUM_IS_ACTIVE,FORUM_PARENT,FORUM_ALLOW_ATTACHMENTS,FORUM_ALLOW_POLLS,FORUM_POLLS_ANYWHERE,FORUM_ISLAND_INSERT,FORUM_SHOW_INTRO,FORUM_INTRO_TITLE,FORUM_GUEST_CAPTCHA,FORUM_IS_TEASER,FORUM_IS_GALLERY FROM ubbt_FORUMS WHERE FORUM_ID = '1'

Unknown column 'FORUM_IS_TEASER' in 'field list'
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#191791 - 07/18/07 04:42 PM Re: How can I run the update patch again. [Re: Gizmo]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
Did it actually let the upgrade script run? Meaning, could you go through the steps of the upgrade including where it says it's going to upgrade the database, or did it just stop?
Top
#191792 - 07/18/07 04:47 PM Re: How can I run the update patch again. [Re: Rick]
Gizmo Online   cat

Registered: 06/05/06
Posts: 14995
Loc: Portland, OR; USA
It would run the upgrade script again yes, however all of the fields showed blank; it went to the update database step and said it ran, but obviously it lies...
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#191794 - 07/18/07 04:54 PM Re: How can I run the update patch again. [Re: Gizmo]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
Might need this one in a support ticket with ftp info, admin info, and the info for running the sql command as well, however that was run.
Top
#191795 - 07/18/07 04:55 PM Re: How can I run the update patch again. [Re: Rick]
Gizmo Online   cat

Registered: 06/05/06
Posts: 14995
Loc: Portland, OR; USA
<snicker> dont have any of that information; just happen to be adminned on his forums (I did some stylesheet work for him); just ran the sql command from the UBB CP and it said it effected 1 row.

Will email him to open up a support ticket
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
Page 1 of 2 1 2 >



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

Today's Birthdays
No Birthdays
Recent Topics
Temporary Password email not being received
by
Yesterday at 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
10489 Members
36 Forums
33841 Topics
181707 Posts

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