Byron Fitzgerald Beginner

The only remaining thought I have is that the language set is causing the decimal to be converted to a comma. Can you try set the language to English?

Yes sorry, only saw the last one! Will look through it quickly

If you go to yoursite.local/admin/core/settings/diagnostics/?extended it should have a list of your perch settings and your environment. It may be that you're missing some php extensions. If your site is publicly accessible you'll need to hide your db…

As it's getting to there fine, and I think the values should be doubles and not strings, then it seems most likely that there is an issue preparing the statements. Can you post your extended perch diagnostic?

Sort of grasping at straws now, but if you got to the PerchShop_Orders.class.php file and look for the create_from_cart function.

If you could add the following
(Code, 11 lines)

This will hopefully output something into the debug that might hint to…

From looking at the Perch Shop order code the two offending fields seem to be
(Code, 2 lines)

So it looks like it could be a type coercion error. Can you check your cart for the fields above?

It looks like a comma is being used as a separator instead of a decimal for the total values, so I thought the currency format may be doing this.

Yes that would make sense, how are you formatting the currency?

There are 30 columns listed in the query, however there are 32 values trying to be inserted. So for some reason there are some extra values been added to the order.

I've not used the Mollie gateway before, so it could be related to that. Would you be…

You'll have to loop through each block individually as well. Can't remember the exact syntax, but you can always do a var_dump() to get the exact structure of the array returned
(Code, 9 lines)

The <perch:if> tag doesn't work with the output attribute. Your best bet would be to use the each option in perch_content_custom and add a key if the description exists

(Code, 7 lines)

Then in the template you can use
(Code, 5 lines)

You'll likely need…

You could try reduce the PERCH_UNDO_BUFFER to something lower (Defaults to 30). This should hopefully reduce the number of revisions stored, however I'm not sure if this removes older revision retroactively.

If you are using an email address that has already been signed up, mailchimp will error out. This is the case even if you haven't completed the double optin or if you have unsubscribed.

Not sure if you've see this page of documentation, which covers using WorldPay. Using test mode will make the gateway use the test settings you've set in your perch/config/shop.php, and will still show the order in the CMS

You could try calling the index function on the Collection Factory
(Code, 7 lines)

Whats the structure of the data your are passing to the importer? It might be that you are using the field ID for the asset ID, which I don't think works. You should have it set similar to the following (At least its worked for me in the past)
(Code, 5…

You might be able to get some more information checking through the DB. Collections should be using revisions so you can check the collection_items table and you can check if the dynamicFieldsJSON is actually saving the assets or if they are been…

How are the cropped images generated? Do they come straight from the zip file or are they created from the CollectionImporter?

I think you have misunderstood what a TLD is. In the example above the TLD's you are using are .ca and .net. The local perch keys will not work with this. To use perch with a local key you will need to use one of the TLD's that Drew mentioned above. For…

MySQL 5.7 is a lot more strict than previous versions. I haven't encountered the exact error you are facing, but have had similar issues of SQL queries not working correctly after upgrading to 5.7. If you google "disabling strict mode MySQL 5.7" you…