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
#191803 - 07/18/07 05:17 PM Re: How can I run the update patch again. [Re: Gizmo]
Trunklid Offline
newbie
Registered: 02/22/07
Posts: 27
Loc: Bonney Lake, WA
Rick, I will send you that info tonight when I get home from work. It was strange how it did say "This upgrade has been completed. Please remove the entire install directory"
_________________________
Top
#191816 - 07/18/07 06:20 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
Got your information. It looks like possibly not all of the files were uploaded or something like that. I was able to upload the files and run through the upgrade ok.
Top
#191818 - 07/18/07 06:22 PM Re: How can I run the update patch again. [Re: Rick]
ntdoc Offline
Registered: 11/09/06
Posts: 3384
Not the first time this has happened to users. Maybe add an additional part to the script that checks to confirm all default files are found on the system before proceeding.
Top
#191823 - 07/18/07 06:27 PM Re: How can I run the update patch again. [Re: ntdoc]
Mark S Offline
Carpal Tunnel
Registered: 07/04/06
Posts: 4447
Loc: Liverpool : England : UK
its getting better i will say ;\)

i would like to see a txt readable version of changes
in the installer directory, as i like to peak but
its written all joined up and gobbley gook lol

you know what i mean.

A readable version of the changes ;\)
_________________________
Version v7.5.6 smile smile < Threads satisfaction status
People who inspire me Rick Gizmo Ian David jgeoff ntdoc
Oooo i hear 8 is coming? just after 7 my friend.
Top
#191825 - 07/18/07 06:30 PM Re: How can I run the update patch again. [Re: Mark S]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
Well it's supposed to make sure that all of the files are uploaded that need to be. It uses the UPGRADE_CHANGES.txt file to check to make sure everything was uploaded as it should be and normally will not let you continue if it doesn't find anything. So, I'm not entirely sure what happened there.
Top
#191899 - 07/19/07 01:05 AM Re: How can I run the update patch again. [Re: Rick]
Gizmo Online   cat

Registered: 06/05/06
Posts: 14995
Loc: Portland, OR; USA
Well, he tried the upgrade path of uploading only the install directory and the libs/ubbthreads.inc.php file; from there things just got awkward...
_________________________
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