WebsiteBaker Support (2.8.x) > Bakery Shop

WB 2.8.3 SP5 Bakery and WB Portable

<< < (2/3) > >>

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:

--- Quote from: jacobi22 on January 19, 2016, 04:14:15 PM ---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

--- End quote ---

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:

--- Quote ---Maybe this issue is too new to be widely known
--- End quote ---
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


--- Quote ---In my case, bakery was already installed on my live server website.
--- End quote ---

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.

Navigation

[0] Message Index

[#] Next page

[*] Previous page