Stuck at Stage 5

mboy

Joined: 2007-09-19
Posts: 1
Posted: Thu, 2007-09-20 00:14

Hi:

I'm stuck at Step 5 (db setup) with the following error msg's:

The database you specified does not exist. Please create it.

We received the following database related errors:

(mysqli): SHOW TABLES
Query: SHOW TABLES failed. Query was empty
1065: Query was empty
ADODB_mysqli._Execute(SHOW TABLES, false) % line 889, file: adodb.inc.php
ADODB_mysqli.Execute(SHOW TABLES) % line 2226, file: adodb.inc.php
ADODB_mysqli.MetaTables(false, false) % line 460, file: adodb-mysqli.inc.php
ADODB_mysqli.MetaTables() % line 170, file: DatabaseSetupStep.class
DatabaseSetupStep.loadTemplateData(Array[2]) % line 169, file: index.php

I am trying to install Gallery2 within a drupal installation, which is on a linux-based VPS account with Plesk installed.

Mysql: ver4.1.20

I've scoured the forums and done everything I can think of.

I've tried using SET PASSWORD FOR user@localhost = OLD_PASSWORD('newpass'); based on what I read about a possible glitch with mysql4.1 but it didn't help.

I know I'm using the correct db/username/pw cause I can get in to the db via mysql command prompt.

Any help on this would be greatly appreciated!

mboy
Login or register to post comments
paulg1981

Joined: 2007-10-14
Posts: 4
Posted: Sun, 2007-10-14 15:43

I am having the EXACT same problem! It is so frustrating! Did you or anyone else find a solution? Thanks for your help in advance.
Login or register to post comments
valiant

Joined: 2003-01-04
Posts: 32356
Posted: Tue, 2007-10-16 13:28

when googling for "1065: Query was empty" you'll find some other mysql issues with the same error, all not related to gallery.

i guess it could be a problem with your mysql server version, a bug in mysql. the same SQL works on other mysql servers, we have tested it with a lot of different mysql versions (3.2*, 4.0.*, 4.1.*, 5.0*).

--------------
Documentation: Support / Troubleshooting | Installation, Upgrade, Configuration and Usage
Login or register to post comments
annoyeduser

Joined: 2007-12-17
Posts: 1
Posted: Mon, 2007-12-17 22:16

Using the pre 3 mySQL option in the combobox fixed the problem for me.

--
You get what you pay for.
Login or register to post comments