How to migrate from 2.5.2 to 2.6.x

[kibmcz]

After running the upgrade on a working 2.5.2 install (Yes i have backups) i am unable to accesss the site or the admin area. All it shows is "Error loading language file DEFAULT_LANGUAGE, please check configuration"

I lookded in PhpMyadmin and found the upgrade script didn't create some of the proper entrys. Mainly in the "settings" table.

The test server is: Windows 2000 running xampp 1.5.0-pl1

[ruebenwurzel]

Hello,

tested on my lokal machine and the most seems to work fine. Found only one little bug in the update script.

Line 159 should i think be

Code:

$query = "ALTER TABLE ".TABLE_PREFIX."mod_news_posts CHANGE `short` `content_short` TEXT NOT NULL, CHANGE `long` `content_long` TEXT NOT NULL";

With the original upgrade script the mod_news_posts tables are not renamed.

Matthias

[Ryan]

@Matthias: I have fixed the problem you included.
I will look at the settings problem when I come home on Friday (I am going for a 3 week long vacation and am coming back every now and then).

[ruebenwurzel]

Okay

found another little issue. Captcha is included in forms and news, there are the options in admininterface, but update script only added the use_captcha field to mod_form_settings. So there have to be added the following lines after line 162

Code:

$query = "ALTER TABLE ".TABLE_PREFIX."mod_news_settings ADD `use_captcha` INT(11) NOT NULL";
$database->query($query);

I have attached the changed upgrade script. It should work.

For all who wanna test the update, have a look at the instructions from Ryan at the upgrade file:

INSTRUCTIONS:

1. Upgrade all non-custom files to the latest version
2. Place and run this upgrade script from the root of your installation
All done!

Please note: certain addons may not be compatible with 2.6.x,
so please check the forum before upgrading.
Also, language files must be upgraded during step 1, as well
as all stock modules and templates.

But Attention:
1.) You can copy all the files from WB 2.6.1 over your existing WB 2.5.2 but don't overwrite the config(dot)php in the root with the newone from WB 2.6.1. , otherwise you lost your whole configuration and your homepage doesn't work anymore.
2.) Be sure your language file supports 2.6.x.. If you are not shure, try to set the languages back to default EN before running the upgrade, otherwise you could have problems with the admin interface.
3.) This is only for testing and not for production till Ryan releases the official upgrade script.

Have fun
Great work ryan and stefan 

Matthias

[ruebenwurzel]

Hello,

and another bug appeared after upgrading a few homepages. It also has to do with captcha.

In WB 2.5.2 the code for displaying the add comment page is stored in database mod_news_settings/comments_page. In WB 2.6.1 the code is stored in the file comments_page.php. So the upgrade script should delete the entries in mod_news_settings/comments_page from 2.5.2 and add the new entries from 2.6.1.

Old code:

Code:

<h1>Comment</h1>
<h2>[POST_TITLE]</h2>
<br />
<form name="comment" action="[ACTION_URL]" method="post">
Title:
<br />
<input type="text" name="title" maxlength="255" style="width: 90%;" />
<br /><br />
Comment:
<br />
<textarea name="comment" style="width: 90%; height: 150px;"></textarea>
<br /><br />
<input type="submit" name="submit" value="Add Comment" />

New code:

Code:

<h1>Comment</h1>
<h2>[POST_TITLE]</h2>
<br />

Workaround for all who have updated to 2.6.1:
Go to Option from your news Page and change the entries from Comments Page manually.

Have fun

Matthias

[centipod]

Hi,
I hope all are well,   post Christmas.   

I have a customer who put a ton of effort into his 2.5.2 site and, sadly,  since I am migrating to a new server (apache 2) which  has the UTF  garbage character problem I was hoping to just use 2.6.1. as the remedy for that.

 But I know nothing about the subject of how to import his 2.5.2 data into 2.6.1.  I don't mind reworking the site's tweaks. But the database scares me. Are there many changes to the schema?

Is it in the works to have a script that will do this migration? Or can it be done by hand?
He seems very afraid of having to repeat  all his hard work. 

Well, watch out for  too much  New Years grog  'cause it erodes vitamins outta the little grey cells.   and happy scripting.

Centipod.
 

[Ryan]

Is it in the works to have a script that will do this migration? Or can it be done by hand?

Well, if you have read what this post is about, you will know exactly how to migrate - we have been working hard to make the soon-to-be-official upgrade script, so you can upgrade in a few easy steps (see above for more details).

@ruebenwurzel: Thank-you very much for testing! I will release the script shortly

[jacksenechal]

I'm sad that I can't just stick a template directory in there and have it work anymore...  It's not too hard, I suppose, to just stick another row in the 'addons' table, but it's not nearly so easy as it was before. Just curious, what is the reason for moving to database storage of the template info? Is this an in-between to some new template features?

[kibmcz]

I'm sad that I can't just stick a template directory in there and have it work anymore...  It's not too hard, I suppose, to just stick another row in the 'addons' table, but it's not nearly so easy as it was before. Just curious, what is the reason for moving to database storage of the template info? Is this an in-between to some new template features?

If you upload a extracted module or template all you have to do is the following:
1. Go to your WB site admin (/admin)
2. Click on settings
3. Click on the "Show Advanced Options >>" button
4. Scroll down to the botton of the page and find "Reload Add-ons" and click on it.
5. Select Modules & Templates and click the "Reload" button
6. You now have synced the Addons table with templates/modules folders.

[hks]

What is the problem if I get the following lines



WebsiteBaker 2.5.2 to 2.6.x Upgrade Script
--------------------------------------------------------------------------------
Current version: 2.5.2
New version: 2.5.2
Error: Upgrade script has nothing to do

I am sure I have 2.5.2. and wants to upgrade to 2.6.0
In the zip file there is only an upgrade.php (is this Okee??)

I searched for upgrade documentation and found nothing

Please help

[mroony]

I had the same thing, but just figured I did something wrong... ??

[pcwacht]

mroony and hks

Did you upload the files of wb261 first to your webspace?

Remember, DO NOT overwrite existing configphp!!!

Te update script updates the database, not the files

John

[mroony]

Whadya know.... that works so much better... thank you very much.

[Stefan]

Topic Split

I split the long upgrade topic into two. This one for general discussions, the other one for specific support.

[Attila]

Just to let you know:
I upgraded an installation from 2.5.1 to 2.5.2 to 2.6.1. Then I installed the FCKEditor v2.1RC1 module. Everything works perfect. Thank you all!

-- Dave

[tarzadon]

I know this is an old post, but I found the solution to my problem here.

When posting a comment, I got an error that [ACTION_URL] was not found on the server.

I just upgraded from 2.6.5 to 2.6.7 to 2.70.

I had to go to the news Page and change the entries from Comments Page manually.