F Flow New Member Jul 8, 2012 3 0 Oct 5, 2013 #1 Hello, when ii register at my hotel i get this: Field 'home_room' doesn't have a default value i'm using navicat premium the lastest update how can i fix that? You must be registered for see links
Hello, when ii register at my hotel i get this: Field 'home_room' doesn't have a default value i'm using navicat premium the lastest update how can i fix that? You must be registered for see links
Khalil IDK Dec 6, 2011 1,642 786 Oct 5, 2013 #2 Run this query: Code: ALTER TABLE `users` DROP COLUMN `home_room`, ADD COLUMN `home_room` INT(110) DEFAULT '0'; Oh and next time, don't go around the shoutbox asking for Habbo help, you'll get banned (again), just wait for your thread to be viewed and answered. Upvote 0 Downvote
Run this query: Code: ALTER TABLE `users` DROP COLUMN `home_room`, ADD COLUMN `home_room` INT(110) DEFAULT '0'; Oh and next time, don't go around the shoutbox asking for Habbo help, you'll get banned (again), just wait for your thread to be viewed and answered.