I have this issue on version 16
This website or feature is currently temporarly not available or failed after a technical error.
This may be due to a maintenance operation. Current status of operation (2022-09-28T02:45:03Z) are on next line…
Dolibarr has detected a technical error. You can read log file or set option $dolibarr_main_prod to ‘0’ in your config file to get more information.
Hello,
Change the $dolibarr_main_prod to ‘1’ in conf/conf.php to have the full message
Requested URL: /public_html/dolibarr/index.php?mainmenu=home&leftmenu=home&mainmenu=home&mm=home0
Referer: High Point Technology @ 16.0.0
Menu manager: revolutionpro_menu.php
Modules/Applications: user, revolutionpro, partnership, knowledgemanagement, fournisseur, supplier_proposal, adherent, reception, incoterm, facture, tax, holiday, salaries, expensereport, banque, recruitment, paymentbybanktransfer, prelevement, margin, product, societe, propal, commande, service, contrat, stock, expedition, productbatch, variants, ficheinter, bom, ticket, mrp, agenda, projet, resource, eventorganization, categorie, accounting, ecm, workflow, import, export, mailing, emailcollector, cron, notification, ldap, externalsite, debugbar, mailmanspip, gravatar
Database type manager: mysqli
Latest database access request error: SELECT count(p.rowid) as nb FROM llxnb_ticket as p LEFT JOIN llxnb_societe as s ON p.fk_soc = s.rowid WHERE p.entity IN (1)
Return code for latest database access request error: DB_ERROR_NOSUCHTABLE
Information for latest database access request error: Table ‘hpt_doli822.llxnb_ticket’ doesn’t exist
Hello,
You have an issue with your database, ticket table doesn’t exist.
noted , But how can fix this
Hello,
It is not supposed to happened, so, most probably, something has been done or happened in your database.
We can’t investigate for you, you have to do it.
The first questions are : Is it a fresh installation or an old one ? What have you done recently on your infrastructructure ? etc…
hello, this is the fresh install and I didn’t make any changes on infrastructure
Ok,
Could you have a look on your database to see if ‘llxnb_ticket’ does exist or not ?
Something went wrong during the installation process, no warning messages during installation ?
infomation
php7.4-fpm; mysql8.1, nginx, apache
software version tested: 17.01, 17.02
the issue only when turn these modules on: TICKETS, DONATIONS
I also have this issue for many fresh installations tries. i thought that would be my server problem. I test in many environments problem still exist. it related to MySQL problem then I change in different character set for database. utf8_general_ci, utf8mb4, etc. change php versions. the problem come from the package when it initiate the installation. if anyone need me to regenerate the issue let me know. xdebug is on
sorry for the Un-organized nginx server log
[Sat Jul 15 16:49:33.290898 2023] [proxy_fcgi:error] [pid 11769:tid 139678602733312] [client 172.17.0.1:46752] AH01071: Got error ‘li’; public $database_host = ‘localhost’; public $database_port = ‘3306’; public $transaction_opened = 0; public $lastquery = ‘SELECT count(p.rowid) as nb FROM llx_ticket as p LEFT JOIN llx_societe as s ON p.fk_soc = s.rowid WHERE p.entity IN (1)’; public $lastqueryerror = ‘SELECT count(p.rowid) as nb FROM llx_ticket as p LEFT JOIN llx_societe as s ON p.fk_soc = s.rowid WHERE p.entity IN (1)’; public $lasterror = 'Table \‘dbname_potdoli.llx_ticket\’ doesn\‘t exist’; public $lasterrno = ‘DB_ERROR_NOSUCHTABLE’; public $prefix_db = NULL; public $ok = TRUE; public $error = NULL; private $_results = FAL…PHP message: PHP 3. box_dolibarr_state_board->loadBox($max = 5) /home/dbname/portal01.domain.com/htdocs/core/class/html.formother.class.php:1371PHP message: PHP 4. Ticket->load_state_board() /home/dbname/portal01.domain.com/htdocs/core/boxes/box_dolibarr_state_board.php:266PHP message: PHP 5. dol_print_error($db = class DoliDBMysqli { public $db = class mysqli { public $affected_rows = -1; public $client_info = ‘mysqlnd 8.1.20’; public $client_version = 80120; public $connect_errno = 0; public $connect_error = NULL; public $errno = 1146; public $error = ‘Table \‘dbname_potdoli.llx_ticket\’ doesn\‘t exist’; public $error_list = […]; public $field_count = 1; public $host_info = ‘Localhost via UNIX socket’; public $info = NULL; public $insert_id = 0; public $server_info = ‘10.4.30-MariaDB’; public $server_version = 100430; public $sqlstate = ‘42S02’; public $protocol_version = 10; public $thread_id = 10668; public $warning_count = 0 }; public $type = ‘mysqli’; public $forcecharset = ‘utf8’; public $forcecollate = ‘utf8_general_ci’; private ${DoliDB}_results = NULL; public $connected = TRUE; public $database_selected = TRUE; public $database_name = ‘dbname_potdoli’; public $database_user = ‘dbname_potdoli’; public $database_host = ‘localhost’; public $database_port …PHP message: PHP 6. define($constant_name = ‘MAIN_CORE_ERROR’, $value = 1) /home/dbname/portal01.domain.com/htdocs/core/lib/functions.lib.php:5122’, referer: https://portal01.domain.com/admin/modules.php?mode=commonkanban&page_y=452.1600036621094
