WB 2.8.3 SP5 Bakery and WB Portable

[sky writer]

First question, can you run Bakery on WB Portable?  I have bakery v1.72 functioning on a 2.8.3 SP4 live website and all is working well.  I downloaded a copy of the web files and database to my local machine and everything seems to work, except when I add an item to the cart it refreshes to the Products page and displays "The shopping cart is empty", "Continue Shopping".  I have shorturl module running on the site, and I thought it might be something to do with bakery not being able to find the correct page.  But I can't find the cause.  Nothing is listed in the error logs.

I tried installing bakery 1.76 on a local test site that doesn't use shorturls.  But this particular site is set to not use the "/pages" directory, so this might be a whole other issue.  I couldn't get bakery to work properly here either.  Even trying to change general settings like changing the country, would refresh and just reset to the previous country.  I then deleted the bakery page and tried to uninstalled the bakery module, but it didn't complete and give me a success notice.  When I refreshed the page I got an error page.  I checked and my entire local website directory and files have been deleted.  Well everything except this empty folder:
G:\WB-Portable-2.8.3-SP5\root\mywebsite\modules\ckeditor\ckeditor\plugins\div
This is just bizarre to me.  I'm not worried as I have a backup, but I can't understand what just happened.

I might just need some sleep.  But most importantly, I need to know if I can even test Bakery in a local WB Portable environment on 2.8.3 SP4 or SP5.  I can't find any info on the forum.

Thanks!

[jacobi22]

basicly its possible, to work with all wb-modules on portable too, but bakery needs a working mail function. On my system, i can send only via smtp, not via php-mail. maybe its work, but i dont have the time for this. to work with bakery, i have to change the mail function from the original to $wb->mail, but then, i cannot send invoices in a good looking quality.
But all this has nothing to do with the basket btw shopping cart
if i have time in the afternoon, i copy a test project to portable and test it again

[jacobi22]

So, test it on Portable with actual portable and bakery 1.76 - work's without problems

Do you set your portable-sql to strict-mode?

[sky writer]

Do you set your portable-sql to strict-mode?

I have not changed anything in WB Portable.  Everything is default.
I checked \ WB-Portable-2.8.3-SP5 \ settings \ my.ini
sql_mode="STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE"

I'm going to try a fresh install today and see if I get different results.

[jacobi22]

I checked \ WB-Portable-2.8.3-SP5 \ settings \ my.ini
sql_mode="STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE"

I'm going to try a fresh install today and see if I get different results.

not really needed.....

its good and recommened to work in portable with the strict mode, if your server also work in strict mode - so you found problems faster in the old modules.
if you dont need the strict mode in portable, set only a # in the front of this line here
sql_mode="STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE"
and restart portable

i know, that bakery 1.76 is not working in mysql-strict mode, so i fix a version for myself

[jacobi22]

P.S.: if you installed bakery on a strict-server, you have only the half database tables. its not possible to delete items or section with bakery.
the only chance: delete the bakery table manually from the database and reload the modules

[sky writer]

Commenting out that line did the trick.  I thank you.

At the same time, it's worrying to have to so often rely on the kindness of a select few members such as yourself for answers to these kinds of issues, which in my mind should be more readily available.  First because it caused me a whole lot of time and frustration trying to figure out what I must have done wrong and stumbling along trying to troubleshoot, and then I have to bother others, taking time from their life to work through to a possible answer.  Don't get me wrong, I have no problem trying to troubleshoot my own issues, and never expect to be spoon fed or have my hand held to fix what I broke, but this is not a setting I changed and then everything went bad, it's a default setting.

Maybe this issue is too new to be widely known, but I would think this kind of info could easily be at least noted, on the forum, the Bakery site, the WB Portable site, somewhere!

Anyway, I do thank you for your time and solution.  Cheers!

[sky writer]

P.S.: if you installed bakery on a strict-server, you have only the half database tables. its not possible to delete items or section with bakery.
the only chance: delete the bakery table manually from the database and reload the modules

Again... very important info to know BEFORE installing.   
In my case, bakery was already installed on my live server website.  So, with your suggested commenting out the strict line, everything seems to be working locally.
But in the case of when I was trying to troubleshoot and installed bakery fresh on another local website, this information you just provided probably contributed to the "weird" issues I ended up having.  So, thanks once again.

[jacobi22]

Maybe this issue is too new to be widely known

my teacher's tells me: write the code, that its work in mysql-strict mode, so its work also in the simple mode. maybe other people has other teachers...

in the last 20 years i found in germany or in europe only a handfull private or secure servers, running in strict mode, but in the last six mounths we have here in this forum only ~50 problems with the strict mode. And this strict mode was one of the points for the SP5.

problem is, that the most users cannot change this mode on a server, so he need a working cms. but not every module run in this mode, so we can fix it only from time to time, if there is not active autor. target is, that all addons in the addon area working in strict mode

P.S.: its not a WB-Problem, its the same like the utf8, you found this problems in every cms

In my case, bakery was already installed on my live server website.

in this case, not every bakery function works in strict mode
its not possible to
- put items to the basket
- read the infos for payment method's and because of that, not possible to buy anything
- add new items
- add item new attributes
- add new images
- order status doesnt work

[sky writer]

Okay.  So, is this a safe work-flow?
My live site had bakery already installed and functioning properly.
I download a copy of the web files and the database to my local machine.
I comment out the line you suggested in my.ini    #sql_mode="STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE"
I work with (possibly do upgrades) and test locally.
When finished I send everything back to my live server.
Remove comment my.ini    sql_mode="STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE"
when working on local sites without bakery module installed, for debugging.

[jacobi22]

see my last post   

with the working strict mode, you can only check the bakery pages and sub-pages, but not test the functions from my list

i develope sometime's new functions or designs  - for example: a non-table-used-design for the basket or the item-view - thats not possible, because the insert into the database-table mod_bakery_customer s doesnt work in mysql-strict mode

in my personal case, i build every new or upgrade-project on my locale pc first, so maybe also a complete bakery shop with 100 items, but i cannot add items or images (for a non-lightbox-gallery) in mysql-strict mode
but i must prepare my whole project to work in strict mode, its not possible, to fix all the customer WB's at the same time, if a provider set the strict mode tomorrow.

so, you have to know: is it enough for your work in portable to see only the pages in bakery?
if you want to found possible problems in bakery or all other modules or core-files, work on your locale systems only with the strict mode. its easyer to fix all this without a deadline from the provider