As a beginner I got this message during the database setup

Ed Wagner

Joined: 2005-09-22
Posts: 1
Posted: Thu, 2005-09-22 09:06

I got this message during the db setup.

1142: drop command denied to user: 'entwai@webhosting1.sea5.speakeasy.net' for table 'g2dbtest4_Schema'
adodb_mysql._execute(DROP TABLE g2dbtest4_Schema, false) % line 855, file: adodb.inc.php
adodb_mysql.execute(DROP TABLE g2dbtest4_Schema) % line 389, file: DatabaseSetupStep.class
databasesetupstep._testprivileges(mysql, Array[4]) % line 136, file: DatabaseSetupStep.class
databasesetupstep.loadtemplatedata(Array[1]) % line 167, file: index.php

Then I tried deleting the g2data folder and got a error message from
WS FTP saying
WS_FTP failed to delete the selected file or folder.
with these details
CWD /
250 Directory successfully changed.
RMD g2data
550 Remove directory operation failed.

Here is some of the data you asked for...
first official release of Gallery 2.0
PHP 4.3.x

Apache 1.3.29
MySQL 3.23.58
Activated toolkits not sure
Linux
Browser IE6
1 gig web space

Thanks in advance,
Eddie
 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Thu, 2005-09-22 09:24

G2 does a couple of sanity tests during the installer before it let's you finally install G2.
in the database setup step, it checks whether you have the correct database permissions.
and obviously, you haven't. you need drop table permissions to run g2.

the ftp delete error is also normal. you need to use g2 / bharat's cleanup script if you want to delete the stuff in g2data.