[support] Drupal weirdness, please help

[Neil: esl-lounge.com]

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 at kristersplace.ws>
To: <support at 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/ ]
>