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
fresh
Regular
Regular


Joined: Mar 12, 2008
Posts: 74

PostPosted: Wed Mar 12, 2008 9:14 pm Reply with quote

When i try to create the table in installation/install.sql i get this msg in the step 1
The exact error message that your MySQL server reported is:
MySQL Error # 4 = Specified key was too long. Max key length is 500

but when i check the mysql admin area it says all the tables are created. I can see the tables in the mysql admin area
step 2 to 3g work fine


by the way i am using v 2. 20.X sorry i posted in the wrong place and i got screen capture now

Image
 
View user's profile Send private message
fkelly
Former Moderator in Good Standing


Joined: Aug 30, 2005
Posts: 3312
Location: near Albany NY

PostPosted: Thu Mar 13, 2008 9:28 am Reply with quote

Search the forums a bit. You are mostly creating your tables as UTF8 and MYSQL is gagging on that on a certain table we added recently. But the answer has been posted in the last week or so.
 
View user's profile Send private message Visit poster's website
fresh
PostPosted: Thu Mar 13, 2008 11:38 am Reply with quote

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

ok i found the page but still im having problems
After i did the changes
now i get this msg

The exact error message that your MySQL server reported is:
MySQL Error # 4 = Duplicate entry 'Feeds-use_fb' for key 1
 
fresh
PostPosted: Thu Mar 13, 2008 12:41 pm Reply with quote

Ok guys i think i found the solution i was using MYSQL version 4 that's why i couldn't find the way to change it to latin1 swedish so i went to the admin pannel and created mysql v5 database and i think i am set to go now
 
spurtus
Regular
Regular


Joined: May 13, 2006
Posts: 89

PostPosted: Sun Sep 21, 2008 1:02 pm Reply with quote

Anyone else ever get this far and still have the issue after doing everything above? I am at a deadstop on this for 3 days, and not sure where to go next. I am still getting the:

MySQL Error # 4 = Duplicate entry 'Feeds-use_fb' for key 1

error. I have done the "255-->150" change for seo_config. It appears that, also, while my tables are all Latin_swedish_ci the "main" database appears to be staying at UTF8. Not sure if this remains an issue after shortening those other variables, but this is the error that popped up next. It does not seem that I have the ability, however, to change the entire DB to Latin. Just the tables appear to be ok.

So, if anyone has any other ideas, help would be appreciated.
 
View user's profile Send private message Yahoo Messenger
spurtus
PostPosted: Sun Sep 21, 2008 1:10 pm Reply with quote

Well...can't explain it. After I wrote this post, I decided to try to just delete all the tables in the DB. I reran the sql installation script, and the core tables loaded first time. Can't explain it, but thought I would past that in here, lest anyone else end up where I was at (very frustrated). So, to summarize:
- Open up the control panel on my website
- used the DB admin tool to open the db and DROP all the tables (leaving DB "empty")
- ran the sql install script again
- press button to load core tables
- worked that time. Can't explain it.
 
Guardian2003
Site Admin


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

PostPosted: Mon Sep 22, 2008 5:06 am Reply with quote

Sorry for the late reply, the erro you are getting Duplicate entry 'Feeds-use_fb' for key 1 indicates there is data already in the first row (key 1) of the database so emptying that table would fix the issues (as you found).
 
View user's profile Send private message Send e-mail
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 ©