Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> v2.3 RN Documentation
Author Message
bdmdesign
Worker
Worker


Joined: May 11, 2009
Posts: 154
Location: Winsen/Luhe; Germany

PostPosted: Wed Sep 30, 2009 12:58 pm Reply with quote

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
 
View user's profile Send private message Visit poster's website
jakec
Site Admin


Joined: Feb 06, 2006
Posts: 3048
Location: United Kingdom

PostPosted: Wed Sep 30, 2009 1:24 pm Reply with quote

It looks like your user doesn't have sufficient privileges to complete the ALTER command.
 
View user's profile Send private message
bdmdesign
PostPosted: Wed Sep 30, 2009 1:35 pm Reply with quote

The DB Users for the rn's have this rights:

Select | Insert | Update | Delete | Create | Drop | Alter Routine
 
bdmdesign
PostPosted: Sun Oct 04, 2009 9:34 am Reply with quote

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
 
jakec
PostPosted: Sun Oct 04, 2009 9:39 am Reply with quote

OK thanks for letting us know. Very Happy
 
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> v2.3 RN Documentation

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©