Dolibarr loaded the following default data after installation. These data values can be referenced by other tables as foreign keys.
Author: Yvonne Lu
MYSQL Cheat Sheet
To dump all data in a database mysqldump –host=”hostname” –user=”username” –password=”password” databasename > backup_name.sql To reset auto-increment field in a
Dolibarr Module development
Module tutorial https://wiki.dolibarr.org/index.php/Module_development Dolibarr development https://wiki.dolibarr.org/index.php/Developer_documentation Using Module Builder In Dolibarr 8.0 to Generate a Test Module Change paths in htdocs/conf/conf.php
Dolibarr Notes
Open source ERP comparison chart in wikipedia. https://en.wikipedia.org/wiki/Comparison_of_accounting_software Dolibarr installation after downloading source code (not the installer!) Run http://localhost/dolibarr-8.0.0/htdocs/install/index.php Dolibarr wiki
PSQL tips on Windows
To resolve charset conflict error between utf8 and WIN1252, do the following before any further command are issued in PSQL:
Postgresql Related Notes
If you’ve installed postgresql using the installer, it typically sets the service to start automatically when Windows is started. To
PHP with Postgresql
If PHP is installed as part of XAMPP, it will work with MySQL/MariaDB with no additional change. However, to work
Use Psql to test database connection after install
Note: command case sensitive. Issued from shell at <install directory>/bin psql -d mydb -U myuser To change database: \c databasename
Ofbiz 16.11.04 Logs Locations
run time (including errors, access and engine reports) <install directory>\runtime\logs webtools <install directory>\framework\webtools\groovyScripts\logs <install directory>\framework\webtools\template
Running PSQL after first PostgreSQL install on Windows 10
First, make sure Postgresql is running. A way to start the server is by issuing postgres -D ..\data in the