Supporting each other

Community forums

Welcome, Guest
Username: Password: Remember me
Questions on getting Xerte Toolkits installed on your server and questions about authentication and user logins.
  • Page:
  • 1

TOPIC: Installation error on DB Create

Installation error on DB Create 5 years 1 month ago #4095

  • bmbsmk
  • bmbsmk's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 2
  • Thank you received: 0
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

Please Log in or Create an account to join the conversation.

Last edit: by bmbsmk.

Installation error on DB Create 5 years 1 month ago #4096

  • bmbsmk
  • bmbsmk's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 2
  • Thank you received: 0
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

Please Log in or Create an account to join the conversation.

Installation error on DB Create 2 months 4 hours ago #7703

  • kemalokmen
  • kemalokmen's Avatar
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 2
  • Thank you received: 0
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

Please Log in or Create an account to join the conversation.

Last edit: by kemalokmen.

Installation error on DB Create 2 months 4 hours ago #7704

  • kemalokmen
  • kemalokmen's Avatar
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 2
  • Thank you received: 0
Fixed. I just forgot to flush privilleges :(

Please Log in or Create an account to join the conversation.

Installation error on DB Create 1 month 4 weeks ago #7706

  • tom
  • tom's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 1092
  • Thank you received: 234
Thabk you for getting back to us.

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
Time to create page: 0.051 seconds
Copyright © 2021 The Xerte Project.
Xerte logo Apereo logo OSI Logo

Search