Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> RN v2.20.00 - All Issues
Author Message
Flame_Outlaw
New Member
New Member


Joined: May 19, 2008
Posts: 4

PostPosted: Mon May 19, 2008 3:13 pm Reply with quote

Hello, I've been trying to instal RavenNuke onto the server I'm renting. I get through all the steps in the tutorial fine, upload them into the correct folder, than access the installation page, and I get this error when I try to install the core tables.

The exact error message that your MySQL server reported is:
MySQL Error # 4 = Specified key was too long; max key length is 1000 bytes

I trouble shooted it, and I found out something in the MySQL database being in the UTF8_bin and it needing to be switched to Latin1_bin charset...
Found Only registered users can see links on this board! Get registered or login!

I have no idea how to do that, or where to start. Here are the stats on the server, if you could help me, I'd really appreciate it.

Operating system: Linux
Kernel version: 2.6.24.7-grsec
Machine Type: i686
Apache version: 1.3.41 (Unix)
PERL version: 5.8.8
PHP version: 5.2.6
MySQL version: 5.0.45-community
cPanel Build: 11.18.6-STABLE 24255
Theme: cPanel X v2.6.0
 
View user's profile Send private message
evaders99
Former Moderator in Good Standing


Joined: Apr 30, 2004
Posts: 3221

PostPosted: Mon May 19, 2008 9:34 pm Reply with quote

You may want to search on the forums, I'm sure this has been addressed before

_________________
- Only registered users can see links on this board! Get registered or login! -

Need help? Only registered users can see links on this board! Get registered or login! 
View user's profile Send private message Visit poster's website
Flame_Outlaw
PostPosted: Tue May 20, 2008 1:30 am Reply with quote

Yeah, I saw a topic like this before, but I don't believe it told me how I could change it..
 
montego
Site Admin


Joined: Aug 29, 2004
Posts: 9449
Location: Arizona

PostPosted: Tue May 20, 2008 5:49 am Reply with quote

Well, putting that exact error message into a site-level google search produced only 5 or so results. Sad Did you try this one:
Only registered users can see links on this board! Get registered or login!

???

_________________
Only registered users can see links on this board! Get registered or login!
Only registered users can see links on this board! Get registered or login! 
View user's profile Send private message Visit poster's website
Flame_Outlaw
PostPosted: Tue May 20, 2008 6:30 am Reply with quote

I did what those told me to do, I changed the INSTALLATION/sql/rn_core.sql as well as the /INSTALLATION/rndb_upgrade.php to match this post. Only registered users can see links on this board! Get registered or login!

I also changed my database in phpMyAdmin on the main screen to latin1_swedish, as well as changed the database itself. So I'm ultamately lost.. But I do have a diffrent error now.

MySQL Error # 4 = Duplicate entry 'Feeds-use_fb' for key 1
Only registered users can see links on this board! Get registered or login! That posts tells me to drop or change the table or something, how would I do that and still be able to use the modules I wish to install?

While this post says the guy fixed it by creating a diffrent version on his database. Only registered users can see links on this board! Get registered or login!
 
montego
PostPosted: Tue May 20, 2008 6:01 pm Reply with quote

Well, you don't run both of those. I would delete all the tables within your database and re-run the installSQL.php script now that you have modified rn_core.sql. You shouldn't get an error for duplicate entry then.
 
Flame_Outlaw
PostPosted: Wed May 21, 2008 11:58 am Reply with quote

I fixed this acouple of days ago, if you get this error. First delete the database, and create a new one, go into phpmyadmin, go to operations, and change the database to latin1_. Than re-run the INSTALLTION/MySQL.
 
aykon
New Member
New Member


Joined: May 30, 2008
Posts: 2

PostPosted: Tue Jun 03, 2008 1:03 pm Reply with quote

I don't see the ability to change it to latin1_ anywhere on there...I just have the option to create a new table under operations...anyone know a way to fix it?
 
View user's profile Send private message
Guardian2003
Site Admin


Joined: Aug 28, 2003
Posts: 6792
Location: Ha Noi, Viet Nam

PostPosted: Tue Jun 03, 2008 2:07 pm Reply with quote

latin1 is a default so I'm not sure why you don't have it. I would ask your hosting provider.
 
View user's profile Send private message Send e-mail
dad7732
RavenNuke(tm) Development Team


Joined: Mar 18, 2007
Posts: 1242

PostPosted: Tue Jun 03, 2008 3:00 pm Reply with quote

I think I was the first one to report this and I also do not have Latin1 in the list. However, on very close inspection I noticed no ill effects in the DB. "False Positive" maybe?

Also of note, I think that MySQLDumper can be configured for Latin1. I installed the app but didn't get a chance to take a really good tour of the prefs yet.

Cheers
 
View user's profile Send private message
testy1
Involved
Involved


Joined: Apr 06, 2008
Posts: 484

PostPosted: Tue Jun 03, 2008 6:30 pm Reply with quote

i know i fixed it by importing the sql as latin1

also i think i used this in a query to set all tables,

SET NAMES latin1;
 
View user's profile Send private message
aykon
PostPosted: Wed Jun 04, 2008 8:52 am Reply with quote

I was using a MySQL4 database but once I moved to a MySQL 5 database, it flew through like a charm. Thanks for all the insight guys.
 
montego
PostPosted: Thu Jun 05, 2008 4:44 am Reply with quote

MySQL5, just like PHP5.2, is the way to go... if you can.
 
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> RN v2.20.00 - All Issues

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 ©