Mealtime Extension :: Column not found: 1054 Unknown column 'mealtime_id'

pjscuisine

I have installed Mealtime Extension on beta.22.2 however in attempting to assign the new mealtime to a menu item it generates the following error message:

“SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘mealtime_id’ in ‘field list’ (SQL: update ti_menus set mealtime_id = where menu_id = 55)” on line 669 of /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php

Can someone guide me in resolving/troubleshooting this one?

Thanks in advance.

brad

Hi,
I had the same issue. I know this is most likely not the way to fix it as I’m sure something needs to be changed in the code. But as a workaround I created an int10 field of mealtime_id in table ti_menus and it works again.
Cheers,
Brad

pjscuisine

brad
Really grateful for the workaround. Creating the mealtime_id field in table ti_menus did resolve the SQLSTATE error, but I am still unable to get the extension working. It seems to be pulling the old mealtimes without the day of the week.

Have I missed an installation step?

ryanmitchell

Yeah sorry I need to update the extension to work with multiple mealtimes in beta 22. Its on my list to do!

ryanmitchell

ryanmitchell I’ve updated the plugin now - let me know if you run into any issues.

pjscuisine

ryanmitchell Thanks for the prompt response and update to the extension.

I did a clean installation of the extension but had the following issues:

After modifying CartManager.php the following error was generated on the menus page:

ParseError syntax error, unexpected ‘throw’ (T_THROW) in CartManager.php line 282

Changing the Availability Status from Yes to No produces the following error:
Error Exception Undefined index: status in flexible.php line 73

ryanmitchell

@pjscuisine the throw error is due to you missing a bracket at the end of line 282. The whole line should be:

if (!$menuItem->isAvailable($this->location->orderDateTime())) {

I’m going to push a v1.3 for the other issue - I also noticed the readme had become corrupted as some of the instructions are missing, so will update that too.