Upgrade from 2.7 to 8.3 then 2.12.2 ends with multiude of problems

[kerryww]

I'm using PHP 7.3.26 on a Dreamhost shared account. MySQL database. Site: http://www.rail2trail.org

I first attempted to upgrade from WB2.7 to 8.3 but ended up with a blank page. I then attempted to upgrade to  2.12.2 using the unzip.php method.

I can login to the Admin panel. When I do, I'm taken to the Admin panel with "The upgrade script could not start automatically. Please click on this link to start the script!"

When I click on the link to start the script, I'm taken to a page with which says:  WebsiteBaker Upgrade
It is not possible to upgrade from WebsiteBaker Versions before 2.8.3. To upgrade to version 2.12.2 you must first upgrade to v2.8.3 at least!

I've tried reinstalling both versions using the unzip.php script 2 or 3 times but keep getting taken back to the same page when I try to upgrade.

The Admin panel shows WB-Version 2.12.2 r379. But when I login to the MySQL database it shows WB 2.7.

When I go to http://www.rail2trail.org/pages/home.php or any page on the site the text and images are missing and I get the show_menu error. I've read about this problem but I'm somewhat confused on how to solve it. I've tried to install  the show_menu2 module but get the following error: [201] Update for show_menu2 [Module] show_menu2 v4.10.0 not possible.

Everything appears OK in the Admin panel but when I try to add a page I get the following error: Unknown column 'page_icon' in 'field list'

I'm not sure where to start in solving all the problems.

Thanks for your help and suggestions.

[dbs]

Hello, it seems that the upgrade to 2.8.3 was not successful. The rest are follow-up problems.
If you can go back to 2.7 and try the upgrade to 2.8.3 again.

[kerryww]

Hi, thanks for the feedback. I could probably find a copy of WB2.7 somewhere, but the problem still remains that PHP7.3 and higher is all I have access to using the Dreamhost shared acct. the site runs on. The reason I tried to upgrade to WB 2.8.3 was that Dreamhost are now charging extra to run sites on PHP versions less than 7.3.

[dbs]

The problem is, you are to late.
You have to make the website new.

Or you take the PHP5.3 option for a short time. You need it to upgrade to WB 2.8.3

Or you have a portable server with PHP5.6.
Here you could import your website and upgrade to WB 2.8.3.
Then you need PHP7.3 and upgrade to WB 2.12.2 or 2.13

[kerryww]

The problem is, you are to late.
You have to make the website new.

Or you take the PHP5.3 option for a short time. You need it to upgrade to WB 2.8.3

Or you have a portable server with PHP5.6.
Here you could import your website and upgrade to WB 2.8.3.
Then you need PHP7.3 and upgrade to WB 2.12.2 or 2.13

I uploaded a backup copy of my site to my Mint desktop with LAMP installed. I downgraded PHP to 5.6.

WSB connected to the remote database on the Dreamhost DB server and ran the site, although a little slow due to the remote DB connection.

I tried to update from WSB vs 2.7 to 2.8.3 using the unzip.php method. I got the error-
You have a outdated version of PHP (5.6.40-47+ubuntu16.04.1+deb.sury.org+1)
Please contact your Provider for update to 7.4.x or higher

So I copied the files over manually. Now when I start the upgrade-script it freezes on Install droplets as shown below.

WebsiteBaker Upgrade
This script upgrades an existing WebsiteBaker Version 2.7 installation to the Version 2.8.3 Revision [1611] .
The upgrade script alters the existing WB database to reflect the changes introduced with WB 2.8.x
Step 2 : Updating database entries
Adding default_theme to settings table
Install droplets

Although the upgrade freezes the site still loads correctly. Ive tried a few times running the upgrade script but it always freezes on Install droplets.

I also copied the site over to it's place (http://www.rail2trail.org) on the Dreamhost server but now getting the error:-
There was an unknown exception: Call to undefined function mysql_connect() in line (59) of (/framework/class.database.php)

I've checked and checked again the config.php file, but all is correct. I've never made any changes to it. The connection works fine on a remote connection, but fails to connect when the two servers are next to each other.

No matter which way I turn there's no love!

Thanks for any suggestion.



 

[dbs]

Hi, i have no experience with remote db.
But do you read the instructions? Search for 2.7
https://forum.WebsiteBaker.org/index.php/topic,23412.0.html

[hgs]

Here is a supplementary link that leads directly to the instructions.
https://forum.WebsiteBaker.org/index.php/topic,23412.msg158494.html#msg158494

[kerryww]

Thx for the link. I went in and deleted folders that the link suggested be deleted. Then I ran unzip.php. All ran well but for some reason it didn't set up a new Admin folder. So I just uploaded it manually. No luck as was when I clicked on the admin button it took me to a page with the same error: "There was an unknown exception: Call to undefined function mysql_connect() in line (59) of (/framework/class.database.php)"

You can try it at http://www.rail2trail.org/unzip.php

I've done a lot of searching on the error I'm getting. There appear to be a lot of abandoned websites out there with exactly the same error! There's talk of the problem being caused by upgrades to PHP and code mysqli / pdo replacing mysql connections.

Here's the code in my /framework/class.database.php around line 59.

Code: [Select]

// Set DB_URL
function database($url = '') {
// Connect to database
$this->connect();
// Check for database connection error
if($this->is_error()) {
die($this->get_error());
}
}

// Connect to the database
function connect() {
$status = $this->db_handle = mysql_connect(DB_HOST, DB_USERNAME, DB_PASSWORD);
if(mysql_error()) {
$this->connected = false;
$this->error = mysql_error();
} else {
if(!mysql_select_db(DB_NAME)) {
$this->connected = false;
$this->error = mysql_error();
} else {
$this->connected = true;
}
}
return $this->connected;
Here's my confi.php file:

Code: [Select]

<?php

define('DB_TYPE', 'mysql');
define('DB_HOST', 'mysql.rail2trail.org');
define('DB_USERNAME', 'Trf56secret');
define('DB_PASSWORD', 'XXXsecretbb');
define('DB_NAME', 'rail2trail');
define('TABLE_PREFIX', '');

define('WB_PATH', dirname(__FILE__));
define('WB_URL', 'http://www.rail2trail.org');
define('ADMIN_PATH', WB_PATH.'/admin');
define('ADMIN_URL', 'http://www.rail2trail.org/admin');

require_once(WB_PATH.'/framework/initialize.php');

?> 
Thx again  for any suggestions.

[dbs]

You said you do not have PHP 5.6 there, but you need it for the step from wb2.7 to wb2.8.3.
So you can only do this step with your LAMP.
I would perfer make it completely local, use also the database (not remote).
It is the "move from server A to server B" and later vice versa.

[kerryww]

You said you do not have PHP 5.6 there, but you need it for the step from wb2.7 to wb2.8.3.
So you can only do this step with your LAMP.
I would perfer make it completely local, use also the database (not remote).
It is the "move from server A to server B" and later vice versa.

Thanks for your help.

I've partly got it working on localhost running on PHP 5.6. The pages come up, but when I try to go to admin I'm taken to the upgrade-script.php page. When I click on the Start Upgrade button I'm taken to the next page which freezes at  Step 2 > Install droplets. I imported a copy of the remote database and now using it as the localhost database instead of the remote DB. Since the localhost update script freezes, the database appears to be only partly updated. In the settings, it still shows wb_version is 2.7. I go back and forth between the two installations, trying to get either one to work. But no luck with either.

Most of my hair loss is caused by the error I'm getting at http://www.rail2trail.org Googling the error brings up what appears to be numerous abandoned websites with the same error. Furthermore there appears to be no real solution. Here's the error:
"There was an unknown exception: Call to undefined function mysql_connect() in line (59) of (/framework/class.database.php)"

[dbs]

The error is a php version thing.
You have no mysql_ with PHP 7.x, only mysqli_
Forget this error.
Local with PHP5.6 this is not a problem.

We can search the forum for another user with a upgrade droplets problem. I can't remember this problem.

You are locally with PHP5.6 and the database is also locally?
The upgrade stops at step2 install Droplets?
right?

If you can give us a backup zip and the database, we can try to upgrade.

[kerryww]

You are locally with PHP5.6 and the database is also locally?
The upgrade stops at step2 install Droplets?
right?

Yes, correct, I'm working locally with PHP5.6 and the database. Yes, the upgrade stops at Install Droplets - correct.

I zipped up the files and downloaded a copy of the db and uploaded them to Google to share with you. Then I get a message from Google saying there is a virus in the files. Let me check that out and I'll get back to you.

Thx for your help!

[kerryww]

Please mark this problem down as UNSOLVED. It's too old to continue to try to recover. Instead, I've just started again and created a new site and copied over all the text and images. It took me less than 2 hrs. http://www.rail2trail.org

Thanks for your help.

[dbs]

And why you don't use WB?
Your link leads to a WP installation.

[kerryww]

And why you don't use WB?
Your link leads to a WP installation.

I first started to use WSB back in 2005 when I started setting up websites for clients. Most wanted a simple CMS that they could edit themselves. WSB was perfect for the purpose. It took me about 10 minutes to show clients how to use it.

At the time Wordpress and Joomla lead the market. Joomla was good but had a high learning curve. Wordpress sites were getting hacked, plus it had a higher learning curve than WSB. Also, WSB was very stable. It also appeared to go under the radar with the hackers. WSB filled my niche perfectly.

In about 2008 WSB went into a bit of turmoil. Some users on this forum accused it of being dangerous. At the same time some other users broke away and setup their own version of WSB. I can't remember the name now of the new CMS.

At the same time Wordpress got their act together and made WP more secure. Wordpress then became the flavour of the day. People started asking me to develop their site using WP.  So I just changed over.

Now I see that it's all changed again. The popular CMS now are Squarespace, Wix and Facebook. But developing with them you don't get the chance to charge for hosting.

Rail2trail.org was my last WSB site.

[dbs]

Thanks for your answer. Good luck with WP.
We will continue to work on WB.
Bye