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

Problems with non-standard naming / SQL

  • therapynottingham
  • Auteur du sujet
  • Hors Ligne
  • Nouveau membre
  • Nouveau membre
Plus d'informations
il y a 7 ans 4 mois #5678 par therapynottingham
Problems with non-standard naming / SQL a été créé par 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

Connexion ou Créer un compte pour participer à la conversation.

Plus d'informations
il y a 7 ans 4 mois #5679 par tom
Réponse de tom sur le sujet 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.

Connexion ou Créer un compte pour participer à la conversation.

  • therapynottingham
  • Auteur du sujet
  • Hors Ligne
  • Nouveau membre
  • Nouveau membre
Plus d'informations
il y a 7 ans 4 mois #5680 par therapynottingham
Réponse de therapynottingham sur le sujet 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) ?

Connexion ou Créer un compte pour participer à la conversation.

Plus d'informations
il y a 7 ans 4 mois #5681 par tom
Réponse de tom sur le sujet 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;

Connexion ou Créer un compte pour participer à la conversation.

Temps de génération de la page : 0.135 secondes
Copyright © 2026 The Xerte Project.
Xerte logo Apereo logo OSI Logo