Category Error

sampoyigi

Thanks for creating a new post :)

Good, I was going to suggest you do a fresh install. You're getting the Query error because your database is in strict mode which means you can't insert NULL values on field that doesn't have a default value and in TI's case not all fields have default values. Anyways, you can fix it by running this SQL in your database.

 SET sql_mode = '';

Upload a no_photo.png file to assets/images/data to remove the getimagesize error.

sampoyigi

Good good, that should work now.. You'll have to do a fresh install again and this time your error log should be empty :) BTW, wrap your code when pasting next time, makes it easy to read ;)

Mike1508

I made a fresh install of tastyigniter in case I might of messed something up tinkering to get it to install.

When I try to make a category, I get an error that says "An error occurred, nothing added." Bellow is the error log.

ERROR - 2016-02-09 20:18:50 --> Severity: Warning --> getimagesize(C:\Websites\Testing\TastyIgniter\assets\images/data/no_photo.png): failed to open stream: No such file or directory C:\Websites\Testing\TastyIgniter\system\tastyigniter\models\Image_tool_model.php 36 ERROR - 2016-02-09 20:18:50 --> 404 Page Not Found: /index ERROR - 2016-02-09 20:19:12 --> Severity: Warning --> getimagesize(C:\Websites\Testing\TastyIgniter\assets\images/data/no_photo.png): failed to open stream: No such file or directory C:\Websites\Testing\TastyIgniter\system\tastyigniter\models\Image_tool_model.php 36 ERROR - 2016-02-09 20:19:12 --> Query error: Field 'parent_id' doesn't have a default value - Invalid query: INSERT INTO `ti_categories` (`name`, `description`, `image`, `priority`) VALUES ('test', 'test', 'data/00001.GIF', '1')

Thanks for the help!

Mike1508

Thanks again for helping.

Putting an image in the file took care of several errors, but I'm still getting one when I try to make a category and I've run the SET sql_mode = ''; error is bellow

ERROR - 2016-02-10 10:07:39 --> Query error: Field 'parent_id' doesn't have a default value - Invalid query: INSERT INTO `ti_categories` (`name`, `description`, `image`, `priority`) VALUES ('test', 'test', 'data/no_photo.png', '1')

I made another new install, this time a also created a new database for it aswell and got this error just from installing, not sure if I got this error before, never checked the log right after install, see bellow

ERROR - 2016-02-10 10:01:08 --> 404 Page Not Found: /index
ERROR - 2016-02-10 18:03:32 --> Query error: Field 'priority' doesn't have a default value - Invalid query: 
REPLACE INTO `ti_categories` (`category_id`, `name`, `description`, `parent_id`, `image`)
VALUES
(15, 'Appetizer', '', 0, 'data/no_photo.png'),
(16, 'Main Course', '', 0, ''),
(17, 'Salads', '', 0, ''),
(18, 'Seafoods', '', 0, ''),
(19, 'Traditional', '', 0, ''),
(20, 'Vegetarian', '', 0, ''),
(21, 'Soups', '', 0, ''),
(22, 'Desserts', '', 0, ''),
(23, 'Drinks', '', 0, ''),
(24, 'Specials', '', 0, ''),
(26, 'Rice Dishes', '', 16, 'data/vegetable-fried-rice.jpg');

ERROR - 2016-02-10 18:03:32 --> Query error: Field 'order_restriction' doesn't have a default value - Invalid query: 


REPLACE INTO `ti_coupons` (`coupon_id`, `name`, `code`, `type`, `discount`, `min_total`, `redemptions`, `customer_redemptions`, `validity`, `fixed_date`, `fixed_from_time`, `fixed_to_time`, `period_start_date`, `period_end_date`, `recurring_every`, `recurring_from_time`, `recurring_to_time`, `description`, `status`, `date_added`) VALUES
(11, 'Half Sundays', '2222', 'F', '100.00', '500.00', 0, 0, 'forever', NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, '', 1, '0000-00-00'),
(12, 'Half Tuesdays', '3333', 'P', '30.00', '1000.00', 0, 0, 'forever', NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, '', 1, '0000-00-00'),
(13, 'Full Mondays', 'MTo6TuTg', 'P', '50.00', '0.00', 0, 1, 'forever', NULL, '00:00:00', '23:59:00', NULL, NULL, '', '00:00:00', '23:59:00', '', 1, '0000-00-00'),
(14, 'Full Tuesdays', '4444', 'F', '500.00', '5000.00', 0, 0, 'recurring', NULL, '00:00:00', '23:59:00', NULL, NULL, '0, 2, 4, 5, 6', '00:00:00', '23:59:00', '', 1, '0000-00-00'),
(15, 'Full Wednesdays', '5555', 'F', '5000.00', '5000.00', 0, 0, 'forever', NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, '', 1, '0000-00-00');

ERROR - 2016-02-10 18:03:38 --> Query error: Field 'status' doesn't have a default value - Invalid query: INSERT INTO `ti_activities` (`domain`, `context`, `user`, `user_id`, `action`, `message`, `date_added`) VALUES ('admin', 'staffs', 'staff', '11', 'logged in', '<a href=\"http://scanstest.ddns.net/admin/staffs/edit?id=11\">Mike</a> <b>logged</b> in.', '2016-02-10 18:03:38')

Now I assume I'm running your sql right, in phpmyadmin, I went to the database and clicked the sql at the top of the screen.

Thanks for the help

I did a little searching and found this SET @ @global.sql_mode = ''; and it seems to have worked