How to change MAIN_DB_PREFIX in sql modul setup

thumb · July 2, 2020, 7:48pm

I’m about to create a module for dolibarr and setup sql for that modul. But what if the allready installe DB has a different “prefix” than “llx_” how do I find that and set it up for my module ?
Possible ? or stick to llx_

ksar · July 2, 2020, 8:34pm

Hi,

use $dolibarr_main_db_prefix

github.com

Dolibarr/dolibarr/blob/develop/htdocs/conf/conf.php.example

<?php
// Dolibarr example for conf.php file
//
// Do not edit this file without changing its name.
// This file is an example of empty config file for Dolibarr than can be used to create "conf.php".
//
// Warning: Be sure to not add line feed or spaces after closing php tag.


//###################
// Main parameters
//###################

// dolibarr_main_url_root
// This parameter defines the root URL of your Dolibarr index.php page without ending "/".
// It must link to the directory htdocs.
// In most cases, this is autodetected but it's still required
// * to show full url bookmarks for some services (ie: agenda rss export url, ...)
// * or when using Apache dir aliases (autodetect fails)
// * or when using nginx (autodetect fails)

This file has been truncated. show original

// dolibarr_main_db_prefix
// This parameter contains prefix of Dolibarr database. 'llx_' if not defined.
// Examples:
// $dolibarr_main_db_prefix='llx_';

thumb · July 3, 2020, 7:06am

Yes , I know where to finde it . But when you “activate” a module the (default) sql get read from the modul/sql/*.sql dir and that is only clean sql statements with default prefix (llx_) !? And I do not see the “module” service doing anything to that !