Problems with the Windows version of XAMPP, questions, comments, and anything related.
by 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.
-
typomaniac
-
- Posts: 6
- Joined: 16. August 2015 01:16
- Operating System: Windows 7
by 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: 788
- Joined: 30. January 2012 13:44
- XAMPP version: 5.5.15
- Operating System: Windows 10 Pro x64
by 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.
-
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 190 guests