WebsiteBaker Support (2.12.x) > General Help & Support

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

<< < (2/4) > >>

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: ---// 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;
--- End code ---

Here's my confi.php file:

--- Code: ---<?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');

?> 
--- End code ---

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:

--- Quote from: dbs on March 05, 2021, 11:19:08 AM ---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.

--- End quote ---

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)"

Navigation

[0] Message Index

[#] Next page

[*] Previous page