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

TOPIC: Problems with non-standard naming / SQL

Problems with non-standard naming / SQL 1 month 2 weeks ago #5678

  • Justin Clark
  • Justin Clark's Avatar
  • Offline
  • Fresh Boarder
  • Posts: 2
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
The administrator has disabled public write access.

Problems with non-standard naming / SQL 1 month 2 weeks ago #5679

  • Tom Reijnders
  • Tom Reijnders's Avatar
  • Offline
  • Administrator
  • Posts: 811
  • Thank you received: 154
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.
The administrator has disabled public write access.

Problems with non-standard naming / SQL 1 month 2 weeks ago #5680

  • Justin Clark
  • Justin Clark's Avatar
  • Offline
  • Fresh Boarder
  • Posts: 2
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) ?
The administrator has disabled public write access.

Problems with non-standard naming / SQL 1 month 2 weeks ago #5681

  • Tom Reijnders
  • Tom Reijnders's Avatar
  • Offline
  • Administrator
  • Posts: 811
  • Thank you received: 154
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):
$success = true;
The administrator has disabled public write access.
Time to create page: 0.348 seconds
Powered by Kunena Forum