|
Joined: Feb 2007
Posts: 25
newbie
|
newbie
Joined: Feb 2007
Posts: 25 |
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...
|
|
|
|
Joined: Dec 2003
Posts: 1,796
Pooh-Bah
|
Pooh-Bah
Joined: Dec 2003
Posts: 1,796 |
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.
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
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.
|
|
|
|
Joined: Feb 2007
Posts: 25
newbie
|
newbie
Joined: Feb 2007
Posts: 25 |
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
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
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'
|
|
|
|
Joined: Jun 2006
Posts: 16,299 Likes: 116
|
Joined: Jun 2006
Posts: 16,299 Likes: 116 |
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: 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'
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
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?
|
|
|
|
Joined: Jun 2006
Posts: 16,299 Likes: 116
|
Joined: Jun 2006
Posts: 16,299 Likes: 116 |
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...
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
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.
|
|
|
|
Joined: Jun 2006
Posts: 16,299 Likes: 116
|
Joined: Jun 2006
Posts: 16,299 Likes: 116 |
<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
|
|
|
|
Joined: Feb 2007
Posts: 25
newbie
|
newbie
Joined: Feb 2007
Posts: 25 |
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"
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
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.
|
|
|
|
Joined: Nov 2006
Posts: 3,095 Likes: 1
Carpal Tunnel
|
Carpal Tunnel
Joined: Nov 2006
Posts: 3,095 Likes: 1 |
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.
|
|
|
|
Joined: Jul 2006
Posts: 4,057
|
Joined: Jul 2006
Posts: 4,057 |
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
BOOM !! Version v7.6.1.1 People who inspire me Isaac ME Gizmo
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
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.
|
|
|
|
Joined: Jun 2006
Posts: 16,299 Likes: 116
|
Joined: Jun 2006
Posts: 16,299 Likes: 116 |
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...
|
|
|
Bots
by Outdoorking - 04/13/2024 5:08 PM
|
|
|
|
|
|
1 members (Nightcrawler),
445
guests, and
142
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|