Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
New install with old database
04-17-2020, 06:00 AM,
#1
New install with old database
I want to install a new version of WebERP on my shared hosting account and upgrade my old database from 3.11. Can I simply run all the sql scripts I see in the Git reporitory sequentially from 3.11 to the latest 4.15 on the database and then add as a company to the new installation?
Reply
04-19-2020, 10:00 AM,
#2
RE: New install with old database
This should be possible ... yes
Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
Reply
04-19-2020, 10:26 AM,
#3
RE: New install with old database

If you create a company folder as the name of this database and appropriate entries in config.php

Code:
$CompanyList[0] = array('database'=>'yourDBname' ,'company'=>'Your Company Name' );

When you attempt to login the automatic upgrade will work - it will ask you to select the version that you are upgrading from - you can select 3.11 or 4.01-4.02 and it will automatically apply all the SQL scripts since that date

When you login it looks for the version number recorded in includes/ConnectDB.inc and compares against the VersionNumber in the config table of the DB. However, in versions before 4.0 the VersionNumber variable in includes/ConnectDB.inc did not exist so in the old code and old DB the comparison cannot be done - so the upgrade script gives you a choice to manually select the version you are upgrading from.
The manual application of the SQL scripts is a worthy fall back :-)
Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
Reply
04-20-2020, 10:29 PM,
#4
RE: New install with old database
As you are going from such a long way back I would strongly recommend applying the scripts manually, and individually, checking each for any issues along the way.

Tim
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)