Menu
▾
▴
Update the Database
general
After updating the software , updating the database is often necessary . Since the database for reasons of data security is not automatically updated must be done manually . This is done in several steps.
If the ERP is running on Windows, first a Cygwin environment must be installed because the scripts needs Unix tools. A usable cygwin environ can be installed during the installation of the ERP.
- Create a backup of the database . This can for example pgAdmin is used , which is in the installation of Postgres with Installed. The procedure can be found in the accompanying manual.
- Start the script <installdir>/erp/db/dbupdate resp. <installdir>/erp/db/dbupdate.bat on windows. The script asks for the password for the admin user admindb ERP and compares the database structure using the new database structure. For this purpose, a database was created erpdborig in each update.
- After the script finishes , the log files should be content.log modify.log and checked for errors and these are corrected manually. Errors normaly occur only if the ERP was customized.
The update of the database can be started several times because they always compare the original state of the database with the current state of the database and, if necessary changes .
Update to 3.5
You must add one of these lines in <intallationsdir>/erp/programs/server.arg , depend on your operating system, with the content:
projectroot: /opt/mne_erp ( for Linux )
projectroot: <programmdir>/Nelson IT/Erp ( for windows )
projectroot: /Library/MneErp ( for mac )EmbedwebHttpDataroot: /opt/mne_erp/data ( for Linux )
EmbedwebHttpDataroot: C:\ErpRepository ( for windows )
EmbedwebHttpDataroot: /Library/MneErp/data ( for mac )
Update to 2.4.2.4
On Windows and Mac OS X upgrade the Postgres Release to 9.3 manual. You can find how to do it in the postgres manual in the chapter Upgrading a PostgreSQL Cluster.
Update to 2.2.4
the field x,y,z in the table mne_warehouse.storagelocation must be manual modified. the type of the field must be change from char to long with the database manager.
