05 June 2017, 7:48

I hate to ask a question that has been asked before, but we're stuck for a solution to move this site to a new server.

we've zipped up the mahara files and dataroot directory and installed them in the new server with proper ownership and permissions.  We've recreated the database (mysql) and imported the existing data into the new server.  We've changed the "wwwroot" to the new server.

When we use the browser to see the site, we get an Installation page, rather than the site itself? 

We're on ubuntu 16.04, KVM, 8 gigs Ram, 4 cpu.

We would appreciate help on this frustrating issue.

05 June 2017, 13:52

Hi Jack,

One thing you can check is this, using the database connection details in the config.php file try and connect to  the database from the terminal.

And once in the database run this command:

 SELECT field,value FROM config WHERE field = 'installed';

It should return:

 installed | 1

If that line is missing or set to 0 then it will prompt you to install again.

Cheers

Robert

06 June 2017, 0:49

The line in the table config was missing.  I added it, and now the site wants to upgrade.  "Login" won't let us log in, and clicking admin just returns the "upgrade" page. 

The upgrade, BTW, fails.

Thanks for the idea anyway.

06 June 2017, 7:45

Hi Jack

It sounds like the version number in the database config table does not match the version number in htdocs/lib/version.php and that is why Mahara is wanting you to run an upgrade.

What is the number in the config table?

SELECT value FROM config WHERE field = 'version';

Cheers

Robert

06 June 2017, 8:37

SELECT value FROM config WHERE field = 'version';  generates an empty set -- that data is not in the database!??

the only items in the config table are 

noreplyaddress
searchplugin
wwwroot

sounds like we should have more entries in that table??


Thanks!

06 June 2017, 9:34

Hi Jack,

Yeah, I'd check tables to make sure they at least had the right data count as you'd expect, eg

SELECT COUNT(*) FROM view;

SELECT COUNT(*) FROM usr;

etc, if they differ from old to new site then something has gone wrong in the migration for sure

Cheers

Robert