Fatal Error – Shopping Cart -iThemes Exchange

Hi,

The latest version of Exchange is 1.36.1. Is there a specific reason you haven’t updated? If not, I would suggest updating to the most recent version of Exchange.

In the usermeta table, there is a meta_key, _it_exchange_cached_cart. If you remove this, it should remove any carts that are cached.

Give that a try and let us know how it goes.

Thanks,

Elise

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

Hi David,

I certainly understand your trepidation.

You can just remove the data, you don’t need to remove the whole row.

Let me know how it goes.

Thanks,

Elise

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 David,

Can you also drop both the user meta and the sessions in wp_options for those users?

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.

Let me know how it goes.

Thanks,

Elise

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

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 David,

Sorry for the confusion.

You can purge all the cart contents using

it_exchange_db_delete_all_sessions()

wrapped in an init hook. So it would be like this:

add_action( ‘init’, ‘it_exchange_db_delete_all_sessions’ );

Give that a try and let me know how it goes.

Thanks,

Elise

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’)?

Hi David,

This code will clear all the sessions in the database. So it will empty any carts that are currently in the database and will log out anyone currently logged in.

You would simply add that exact code to the bottom of your theme’s functions.php file. Just add_action( ‘init’, ‘it_exchange_db_delete_all_sessions’ );

Let me know how it goes.

Thanks,

Elise

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,

Sent off account details in email to you as requested.

David