|
|
Newbie question
- General Posted by Mike Fitzhugh (Saturday March 10 2001 @ 12:40AM EST) views: 142 |
Hi, I have a newbie question related to db setup: While trying to load tables.sql into my mysql db (named "objfdata"), I get the following error:
"ERROR 1064 at line 79: You have an error in your SQL syntax near 'KEY Name(Name)
) TYPE=MyISAM' at line 5"
I tried to get mysql to give me more info using perror, but it didn't get me anywhere. So, I went into tables.sql and removed all the lines in the CREATE statements which referred to UNIQUE keys, like "UNIQUE KEY Name(Name)", "UNIQUE KEY Url(Url)", etc. Then, I tried to create the tables one by one and was able to do so with no problems.
I fired up the admin screen to do initial setup and everything seemed to work just fine, but I supspect that I'm gonna pay for chopping those UNIQUES. Does anyone have any idea what might be going on?
For the record, I'm running MySql ver. 3.22.17 on FreeBSD 2.2.8-RELEASE.
Thanks in advance.
/mike
|
|
By Brian Milby (Saturday March 10 2001 @ 12:24PM EST)
|
You'll need to upgrade your version of MySQL to 3.23 for the UNIQUE index to work.
|
[ reply | parent ]
|
By Mike Fitzhugh (Saturday March 10 2001 @ 02:12PM EST)
|
Brian, will I lose functionality if I don't create those indexes or just performance?
|
[ reply | parent ]
|
|
By Brian Milby (Saturday March 10 2001 @ 04:38PM EST)
|
The only thing that I see is that the database won't prevent you from adding duplicate Topics, Links, or IndexNames. 2 out of 3 are purely admin functions, so that shouldn't be that big of a deal. Links would just end up with dupes, which you could delete.
|
[ reply | parent ]
|
|
|
|
|