Questions on getting Xerte Toolkits installed on your server and questions about authentication and user logins.

Problems with non-standard naming / SQL

  • therapynottingham
  • Onderwerp Auteur
  • Offline
  • Nieuw lid
  • Nieuw lid
Meer
7 jaren 3 maanden geleden #5678 door therapynottingham
Problems with non-standard naming / SQL werd gestart door therapynottingham
Hi
I'm trying to install Xerte in a shared hosting environment, which dictates how database names are created and which include hyphens. Mostly this doesn't cause too many issues, but I'm running in to issues installing Xerte. Im getting to:

Creating MySQL Database Failed!
Your Xerte Online Toolkits database has not been created! Please investigate the error messages and return to the previous page by pressing the button below!

Failed to execute query line 89 page2.php


And that is only if I hard code the basic.sql to include the `database-name` (with the additional ` ` 's).
But the DROP TABLE IF command is still failing (I also added in the $query so I could see where it failed). If I run the basic.SQL directly (within phpMyAdmin) then it all executes without error. How can I get past this to continue with the install?

Thanks (I hope)

Justin

Graag Inloggen of een account aanmaken deelnemen aan het gesprek.

Meer
7 jaren 3 maanden geleden #5679 door tom
Beantwoord door tom in topic Problems with non-standard naming / SQL
I have no idea why the drop tables are still failing, because these do include the ` characters.

But as the tables are not present anyway, you might consider removing or commenting out the drop tables for now, to be able to continue.

I'll investigate why it's not working later.

Graag Inloggen of een account aanmaken deelnemen aan het gesprek.

  • therapynottingham
  • Onderwerp Auteur
  • Offline
  • Nieuw lid
  • Nieuw lid
Meer
7 jaren 3 maanden geleden #5680 door therapynottingham
Beantwoord door therapynottingham in topic Problems with non-standard naming / SQL
I had the same idea after posting - but the CREATE TABLE fails as well. Maybe it's an issue with the username (which is also mandated to include hyphens)?
Is there a way to bypass this stage completely (because I can actually successfully execute the SQL in phpMyAdmin) ?

Graag Inloggen of een account aanmaken deelnemen aan het gesprek.

Meer
7 jaren 3 maanden geleden #5681 door tom
Beantwoord door tom in topic Problems with non-standard naming / SQL
You're moving into tricky territory. If the installation later doesn't work it will be difficult to make sure why that is.

If you're willing to continue, you can comment out lines 73-98 of setup/page2.php and add the following line in stead of that block (right after line 98):
Code:
$success = true;

Graag Inloggen of een account aanmaken deelnemen aan het gesprek.

Tijd voor maken pagina: 0.139 seconden
Copyright © 2026 The Xerte Project.
Xerte logo Apereo logo OSI Logo