Hazukiy Posted March 6, 2014 Share Posted March 6, 2014 Hi, I'm currently trying to get my database for my website to work but at the moment I'm having a lot of issues with the new version? Basically I'm trying to create a simple registration table setup which includes: - user_id - firstname - lastname - username - email - password And the problem is that when I put them all in, set the Index's and the data types, it comes up with a message saying: "This is not a number"? I have no idea why it keeps coming up with this, any ideas? Here's what it looks like at the moment http://i.imgur.com/faOXjrs.png Thanks. Link to comment https://forums.phpfreaks.com/topic/286758-phpmyadmin-table-creation-problems/ Share on other sites More sharing options...
Ch0cu3r Posted March 6, 2014 Share Posted March 6, 2014 You are getting that error because VARCHAR datatypes requires you to define the maximum number of characters that can be stored for each field. Link to comment https://forums.phpfreaks.com/topic/286758-phpmyadmin-table-creation-problems/#findComment-1471637 Share on other sites More sharing options...
Hazukiy Posted March 6, 2014 Author Share Posted March 6, 2014 Ah ok and apart from that, would you say that all the datatypes are correctish? Link to comment https://forums.phpfreaks.com/topic/286758-phpmyadmin-table-creation-problems/#findComment-1471640 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.