Cant creat SQL tables

fresh · Regular Joined: Mar 12, 2008 Posts: 74

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

fkelly · Posted: Thu Mar 13, 2008 9:28 am

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.

fresh · Regular Joined: Mar 12, 2008 Posts: 74

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

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 · Regular Joined: Mar 12, 2008 Posts: 74

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 Joined: May 13, 2006 Posts: 89

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.

spurtus · Regular Joined: May 13, 2006 Posts: 89

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 · Posted: Mon Sep 22, 2008 5:06 am

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).