Without commenting on the exact details of the problem you've encountered, I will say one thing: I set up test site with Hostgator using Drupal installed by Fantastico and had nothing but problems. I eventually got a message back from Hostgator admins on their support forum saying more or less "don't use Fantastico to install Drupal, it's buggy"....my reply asking why the hell it was the suggested installation procedure in the CP obviously went unanswered. :-S
I don't know how far along the installation road you are (not far by the sounds of it) but I would strongly suggest you wipe the installation and do a fresh MANUAL reinstallation.
just my 2 cents
Neil
----- Original Message ----- From: "Krister Ekstrom" krister@kristersplace.ws To: support@drupal.org Sent: Sunday, September 09, 2007 2:43 PM Subject: [support] Drupal weirdness, please help
Hello, I'm helping a friend get started with her web site which we are planning on creating in Drupal. She has a remote server using CPanel and fantastico and it's through this that we have installed Drupal. When we installed, nothing seemed to go wrong, it indicated that the installation had gone all right but when we started enabling modules and create user roles the following error message started to appear: user warning: Got error 28 from storage engine query: SELECT DISTINCT b.* FROM blocks b LEFT JOIN blocks_roles r ON b.module = r.module AND b.delta = r.delta WHERE b.theme = 'garland' AND b.status = 1 AND (r.rid IN (2) OR r.rid IS NULL) ORDER BY b.region, b.weight, b.module in /home/nanna/public_html/includes/database.mysql.inc on line 172.
After this we no longer can access administrative tasks and we can't do anything else than read the newly created home page and the pages it points to, but no user login or nothing. What could I/we have done wrong? Do i have to uninstall the whole system and reinstall it again? /Krister -- [ Drupal support list | http://lists.drupal.org/ ]