dvmorris1

THanks for the advice. I will consider the reserve stock add-in and see if we adopt that.

WOw. Thanks for the quick response! Website is https://www.thepacc.org.uk Most classes are behind a secure page accessible only by members, however Workshops are open to the public and you can see the checkout pages for these at https://thepacc.org.uk/workshops/ .

Sorry i’m not sure what the difference is between Checkout Blocks or Legacy Checkout.

I also discovered with some background reading that Virtual stock orders end in a status of Processing while Virtual +Download end in a status of Completed. I’ve tended to just leave our orders at Processing because I couldnt see what difference it made. I may change the proucts to virtual + download just for neatness even though they don’t have any downloads, unless there is some option I am missing to have virtuals end in status Completed without any further intervention from me.

OK Thanks. I’ll do that.

HI. I face the same problem but your replacement file at https://ufile.io/a201e seems to have expired. Can you post it again please ( or perhaps fix the error in an update to your plugin? )

Thanks
David

Hi Elise,

Sent off account details in email to you as requested.

David

Hi Elise. Added the suggested code to functions.php in my Theme (Canape). Logged out, closed browser and flushed cache and then reopened our WP website and logged in. No apparent change. Still fatal errors. Still suggesting there are items in the shopping cart and looking at data in SQL database it looks like all is unchanged on record with metakey _it_exchange_cached_cart.

Do I need to do something special to cause functions.php to run?
Copy of code entered is shown below
——extract from end of functions.php—–
add_action( ‘pre_get_posts’, ‘canape_menu_posts’ );

/**
* Load plugin enhancement file to display admin notices.
*/
require get_template_directory() . ‘/inc/plugin-enhancements.php’;

/**
* TEmp update to clear carts
*/
add_action( ‘init’, ‘it_exchange_db_delete_all_sessions’ );

Hi Elise.

Thanks for this. IS this clearing the cart contents for each user as they log onto the WordPress application on our site or clearing all contents of all carts? (I’m guessing the former?)

Secondly. Although I’ve done some programming in the past I am not familiar with PHP and WordPress. Do I add the code line you gave me ie:
add_action( ‘init’, ‘it_exchange_db_delete_all_sessions’ );
into wp_setting.php? …Does it need to be before do_action (‘init’)?

Further checking seems that all users with fatal error have old deleted products (signified by 3 digits eg 334,309, 488) in _it_exchange_cached_cart. Longer 4 digit product numbers (eg 2345, 2339) are current products in store. Can’t think of a sql search to list all userswith these products in shopping carts. Any further advice on how to purge these? Happy to purge all current shopping carts contents if there is a way.

Thanks
David

Hi Elise.
I think you are overassumiing the extent of my knowledge of WordPress.

“Drop user meta and the sessions in wp_options” – I need more explanation of what is required here.

Which table holds the ID code for products? Anyway if I have binned and then deleted the products (using the exchange application) would they still be in the table anyway?

Don’t understand what I have to do to answer this question: “Can you also ask if he can confirm if the product he deleted has in ID of 488? The options have a key matching _it_exchange_db_session_* or for products ids 488, 334, 2339.”

Sorry.

A number of other users have now experienced this “fatal error” problem while trying to buy product. Not sure that they will all be due to old deleted products sitting in cached carts but can’t be sure. Will try to do more testing with dummy users.

Thanks for suggestions so far.
David

Hi Elise. Still have an error. Removed the following.

User ID 293 Meta_key _it_exchange_cached_cart Meta_value a:4:{s:7:”cart_id”;a:1:{i:0;s:27:”1478646407008458225a8702110″;}s:28:”pps_transient_transaction_id”;a:1:{i:0;s:27:”1478646413899358225a8ddb904″;}i:0;a:1:{i:0;s:0:””;}s:8:”products”;a:3:{s:36:”488-40cd750bba9870f18aada2478b24840a”;a:6:{s:15:”product_cart_id”;s:36:”488-40cd750bba9870f18aada2478b24840a”;s:10:”product_id”;i:488;s:13:”itemized_data”;s:6:”a:0:{}”;s:15:”additional_data”;s:6:”a:0:{}”;s:13:”itemized_hash”;s:32:”40cd750bba9870f18aada2478b24840a”;s:5:”count”;i:1;}s:36:”334-40cd750bba9870f18aada2478b24840a”;a:6:{s:15:”product_cart_id”;s:36:”334-40cd750bba9870f18aada2478b24840a”;s:10:”product_id”;i:334;s:13:”itemized_data”;s:6:”a:0:{}”;s:15:”additional_data”;s:6:”a:0:{}”;s:13:”itemized_hash”;s:32:”40cd750bba9870f18aada2478b24840a”;s:5:”count”;i:1;}s:37:”2339-40cd750bba9870f18aada2478b24840a”;a:6:{s:15:”product_cart_id”;s:37:”2339-40cd750bba9870f18aada2478b24840a”;s:10:”product_id”;i:2339;s:13:”itemized_data”;s:6:”a:0:{}”;s:15:”additional_data”;s:6:”a:0:{}”;s:13:”itemized_hash”;s:32:”40cd750bba9870f18aada2478b24840a”;s:5:”count”;i:1;}}}

Came up with different Fatal Error
Error Message
Fatal Error: Call to a member function supports_feature() on a non-object in /homepages/13/d634055017/htdocs/clickandbuilds/WordPress/PACC/wp-content/plugins/ithemes-exchange/api/cart.php on line 412

Any ideas?
David

Hi,

Thanks Elise. I haven’t upgraded to the latest version simply because I have taken over someone else’s work here and I am trying to change things as little as possible until I am familiar with it. .. but I do intend to move the plugin(s) to the latest version.

RE: usermeta table. I’ve listed this using sql Every user seems to have a row with this meta_key. When you say ” remove this”, do you mean remove the data in meta_value (for the problem users) or do you mean delete the whole row (for the problem users).

Understandably I’m cautious about manipulating the raw data without knowing the impact on the applications.

Thanks for the help.
David