code #1089 error

Problems with the Windows version of XAMPP, questions, comments, and anything related.

code #1089 error

Postby typomaniac » 12. September 2015 04:57

Can anybody explain this one to me. Just installed XAMPP for Windows 5.6.12 on my pc and I was putting a table together with only three columns which were "cid"with auto increment & integer and length of 5, username with varchar at 55, and date with timestamp. When I went to save the table it appeared in a popup tooltip.

Code: Select all
#1089 Incorrect prefix key; the used key part isn't a string, the used length is longer than the key part, or the storage engine doesn't support unique prefix keys.
Image
typomaniac
 
Posts: 6
Joined: 16. August 2015 01:16
Operating System: Windows 7

Re: code #1089 error

Postby JJ_Tagy » 12. September 2015 14:42

Looks like you were trying to name the table with invalid characters at the front.
JJ_Tagy
 
Posts: 678
Joined: 30. January 2012 13:44
Operating System: Windows 10 Pro x64

Re: code #1089 error

Postby typomaniac » 12. September 2015 17:56

That is what I thought at first but for some reason I was suspicious of the fact that the column cid was given a primary key and auto increment. I started over and created the table without those attributes and it came together as planned, after which I assigned the primary key and auto-increment. I'm wondering what kind of problems it will cause in the future.
Image
typomaniac
 
Posts: 6
Joined: 16. August 2015 01:16
Operating System: Windows 7


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 75 guests