TOPIC:

I am trying to install Xerte 3.3 on CentOS Linux using a remote database server.

The host can connect to the DB server and the DB is created. When I run the install I get the error

Failed to execute query line 89 page2.php

But nothing is being logged on the apache server logs and I cannot work out why it is failing to proceed.

Any thoughts or pointers where to look?

Cheers

-- Sean

Fixed the problem. Turns out that our DB Admin by default doesn't grant "DROP" on DBs. Even though the DB was empty, the first query it tries to run is

DROP TABLE IF EXISTS `$additional_sharing`;

which is failing, causing the installation to fail.

Any way to get this to log the actual SQL command that is failing, which would have helped fix the issue much quicker.

Thanks

I have the same issue.

I got error "Failed to execute query line 89 page2.php" on zerte 3.10, but at line 1 of the SQL.

CREATE DATABASE IF NOT EXISTS `<databasename>`;
USE `<databasename>`;
...

I deleted the first line, because i am sure the database exsist, and again the same error occured.

Any suggestion?

Thanks

Fixed. I just forgot to flush privilleges :(

Thabk you for getting back to us.