Top Level Fantasticto intallation

[sean]

I have an add-on domain that I recently purchased. I just tried to add the new Drupal 4.7 fantastico installation on the top level of this domain. I can see Drupal when I visit, but there is this at the top:

Warning: Illegal mix of collations (utf8_general_ci,COERCIBLE) and (latin1_swedish_ci,IMPLICIT) for operation 'like' query: SELECT * FROM access WHERE status = 1 AND type = 'host' AND LOWER('118.61.120.11') LIKE LOWER(mask) in /home/mydomain/public_html/econ/includes/database.mysql.inc on line 120

Warning: Illegal mix of collations (utf8_general_ci,COERCIBLE) and (latin1_swedish_ci,IMPLICIT) for operation 'like' query: SELECT * FROM access WHERE status = 0 AND type = 'host' AND LOWER('118.61.120.11') LIKE LOWER(mask) in /home/mydomain/public_html/econ/includes/database.mysql.inc on line 120the site obviously doesn't allow me to log in or work on the site, etc.

i imagine that i could move the installation down a directory and this would be fine, but i really wanted it on the top level without messing with .htaccess and the like.

[corris]

Hi

Any update ???

Does same for me and cannot do anything with it (as far as I can see)

[dvessel]

Fantastico! Well, it looks like the database is mixing the encoding method. They should all be 'utf8_general_ci'.

You'll have to go in and manually change the 'collation' through phpMyAdmin.

[corris]

Thanks dvessel

strangely only now looking at myphpadmin - all my databases are DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci

only the new Drupal installation has a problem - the other databases just work......

all installed via fantastico - why is Drupal 4.7 struggling (4.6 test (now defunct) on another domain some time ago was OK)?



Thanks

[dvessel]

Thanks dvessel

strangely only now looking at myphpadmin - all my databases are DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci

only the new Drupal installation has a problem - the other databases just work......

all installed via fantastico - why is Drupal 4.7 struggling (4.6 test (now defunct) on another domain some time ago was OK)?

Thanks

Don't know why exactly. Could be from the encodings being mixed. If they were all the same it should work even if it isn't 'utf8_general_ci'. Since this is just an initial install, it'll be easier to just redo the install manually unless you know how to get the encodings right.

It's really not that hard to do and you learn a bit more in the process. Good luck.

Here's a video podcast on how it's done.
http://lullabot.com/videocast/installing-drupal-4.7

Go through your control panel to create the database and assign a user to it when they instruct you to create a database with phpMyAdmin. Bluehost doesnt' allow that if I remember correctly.