queXF

adodb related error on debian stable

Asked by PW

I installed queXF on a debian stable system.

I can access the queXF homepage and the admin interface.

However most pages are blank (not loading) and admin interface says "Error, try with Firefox" (I use firefox).

For these actions, Apache logs reports adodb errors such as:

[Mon Jan 15 13:04:09.912981 2024] [php:error] [pid 314451] [client 193.54.21.81:59292] PHP Fatal error: Uncaught TypeError: mysqli_query(): Argument #1 ($mysql) must be of type mysqli, bool given in /usr/share/php/adodb/drivers/adodb-mysqli.inc.php:1150\nStack trace:\n#0 /usr/share/php/adodb/drivers/adodb-mysqli.inc.php(1150): mysqli_query()\n#1 /usr/share/php/adodb/adodb.inc.php(1318): ADODB_mysqli->_query()\n#2 /usr/share/php/adodb/adodb.inc.php(1295): ADOConnection->_Execute()\n#3 /home/myuser/sites/quexf/admin/testconfig.php(23): ADOConnection->Execute()\n#4 {main}\n thrown in /usr/share/php/adodb/drivers/adodb-mysqli.inc.php on line 1150, referer: http://myquexfsite/admin/

adodb is installed by the package libphp-adodb (version 5.21.4-1 debian stable). The path to adodb indicated in config.inc.php (/usr/share/php/adodb/) is correct. This directory contains:

# ls /usr/share/php/adodb/ -1
adodb-active-record.inc.php
adodb-active-recordx.inc.php
adodb-csvlib.inc.php
adodb-datadict.inc.php
adodb-errorhandler.inc.php
adodb-error.inc.php
adodb-errorpear.inc.php
adodb-exceptions.inc.php
adodb.inc.php
adodb-lib.inc.php
adodb-loadbalancer.inc.php
adodb-memcache.lib.inc.php
adodb-pager.inc.php
adodb-pear.inc.php
adodb-perf.inc.php
adodb-time.inc.php
adodb-xmlschema03.inc.php
adodb-xmlschema.inc.php
datadict
drivers
lang
perf
pivottable.inc.php
rsfilter.inc.php
server.php
session
toexport.inc.php
tohtml.inc.php
xmlschema03.dtd
xmlschema.dtd
xsl

Is there something peculiar to do in order to have quexf working?

P-S : I use php 8.2

Question information

Language:
English Edit question
Status:
Solved
For:
queXF Edit question
Assignee:
No assignee Edit question
Solved by:
PW
Solved:
Last query:
Last reply:
Revision history for this message
Adam Zammit (adamzammit) said : 		#1

Hi,

The error message isn't very clear - but the issue is that queXF wasn't able to connect to the database.

Please ensure you have created a DB for queXF, and granting user privileges, and loaded queXF db

(from queXF directory)

mysql
> create database `quexf`;
> create user `quexf`@`localhost` identified by `quexf`;
> grant all privileges on `quexf`.* to `quexf`@`localhost` ;
> exit;

mysql quexf < database/quexf.sql

Then edit config.inc.php and make sure DB_USER, DB_PASS and DB_NAME are all: quexf

Adam

Revision history for this message
PW (pierre-willaime) said : 		#2

Thank for the answer.

The issue was caused by a typo error in my config.inc.php (locahost instead of localhost...).

Sorry for that.