site requirements for ravennuke

Posted: Wed Sep 30, 2009 12:58 pm

fkelly wrote:

Are there pre-existing tables? If so, drop them separately from the installer and try it again and let us know. We have seen some situations where the installer doesn't have the privileges needed to drop the tables.

The BD's are empty, i droped per hand

Apache Version 2.2.10

PHP version >= 4.3.0 Yes : Version 5.2.9
- zlib compression support Available
- GD graphics support Available : Version bundled (2.0.34 compatible)
- Freetype support Available : Version 2.3.7
- MySQL support Available
- MySQL Server API Version 5.0.67-Max
- MySQL Client API Version 5.0.67
- Server API apache2handler
- Allow Short Open Tags Yes
.htaccess Found - Writeable
.staccess Found - Writeable
cache/ Found - Writeable
modules/Forums/files/ Found - Writeable
modules/Forums/files/thumbs/ Found - Writeable
modules/Forums/images/avatars/ Found - Writeable
modules/HTML_Newsletter/archive/ Found - Writeable
uploads/file/ Found - Writeable
uploads/flash/ Found - Writeable
uploads/image/ Found - Writeable
uploads/media/ Found - Writeable

Directive Recommended Actual

Safe Mode OFF OFF
Display Errors ON ON
File Uploads ON ON
Magic Quotes GPC ON ON
Magic Quotes Runtime OFF OFF
Register Globals OFF ON
Output Buffering ON ON
Session auto start OFF OFF

rn 2.3 & 2.4:

DB User xxxxxxxx:

Select | Insert | Update | Delete | Create | Drop | Alter

DB xxxxxxxx:

Select | Insert | Update | Delete | Create | Drop | Alter

2.3:

Installer:

config.php file found!
Successfully connected to localhost as user xxxxxx and assigned password!
Database xxxxxx found!
Tables will be installed with a prefix of xxxxx.
User Tables will be installed with a prefix of xxxxxx.
If this is not correct, edit your config.php file and correct the $prefix or the $user_prefix settings.

Step 1:

The exact error message that your MySQL server reported is:
MySQL Error # 4 at line 115 in file installSQL.php ==> ALTER command denied to user 'xxxxxx'@'localhost' for table 'xxxxx_users_temp'

Error in rn_core.sql at line 525:
ALTER TABLE `xxxxx_users_temp` ADD `requestor` VARCHAR( 25 ) NOT NULL;

Step 3a:

The exact error message that your MySQL server reported is:
MySQL Error # 4 at line 115 in file installSQL.php ==> ALTER command denied to user 'xxxxx'@'localhost' for table 'xxxxx_nsnst_ip2country'

Error in rn_ip2c1.sql.gz at line 3:
ALTER TABLE `xxxxx_nsnst_ip2country` DISABLE KEYS;

3h:

The exact error message that your MySQL server reported is:
MySQL Error # 4 at line 115 in file installSQL.php ==> ALTER command denied to user 'xxxxx'@'localhost' for table 'xxxxx_nsnst_ip2country'

Error in rn_ip2c16.sql.gz at line 5824:
ALTER TABLE `xxxxxx_nsnst_ip2country` ENABLE KEYS;

Its havy: I controlled the DB now, not all tables are in it and the next Step don't come.

2.4:

Installer:

config.php file found!
Successfully connected to localhost as user xxxxxx and assigned password!
Database xxxxxx found!
Tables will be installed with a prefix of xxxxx.
User Tables will be installed with a prefix of xxxxxx.
If this is not correct, edit your config.php file and correct the $prefix or the $user_prefix settings.

Step 1:

The exact error message that your MySQL server reported is:
MySQL Error # 4 at line 117 in file installSQL.php ==> ALTER command denied to user 'xxxxx'@'localhost' for table 'xxxxxx_users_temp'

Error in rn_core.sql at line 518:
ALTER TABLE `xxxxx_users_temp` ADD `requestor` VARCHAR( 25 ) NOT NULL;

Here is it only Step 1, but the same with the DB. Not all tables are in it, too.

Best Regards

Peter

Posted: Wed Sep 30, 2009 1:24 pm

It looks like your user doesn't have sufficient privileges to complete the ALTER command.

Posted: Wed Sep 30, 2009 1:35 pm

Posted: Sun Oct 04, 2009 9:34 am

Ok works now, it was my mistake.

I have added now the alter comand in my db & dbuser and its works now.

Thanx for help

Best Regards

Your Peter

Posted: Sun Oct 04, 2009 9:39 am

OK thanks for letting us know. Very Happy