Guest MrLeN Posted November 24, 2016 Share Posted November 24, 2016 (edited) I am trying to create new database tables, but I got an error saying:Incorrect column specifier for column user_id What did I do wrong? Edited November 24, 2016 by MrLeN Quote Link to comment https://forums.phpfreaks.com/topic/302611-what-did-i-do-wrong/ Share on other sites More sharing options...
Solution mac_gyver Posted November 24, 2016 Solution Share Posted November 24, 2016 an auto-increment column needs to be an integer data type. Quote Link to comment https://forums.phpfreaks.com/topic/302611-what-did-i-do-wrong/#findComment-1539661 Share on other sites More sharing options...
Guest MrLeN Posted November 24, 2016 Share Posted November 24, 2016 Oops, that's what I get fro trying to copy videos lol. Ok, I un-ticked A_I Thanks Quote Link to comment https://forums.phpfreaks.com/topic/302611-what-did-i-do-wrong/#findComment-1539662 Share on other sites More sharing options...
mac_gyver Posted November 25, 2016 Share Posted November 25, 2016 the primary id column should be an auto-increment integer. it should not be a character data type. Quote Link to comment https://forums.phpfreaks.com/topic/302611-what-did-i-do-wrong/#findComment-1539664 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.