When WordPress Databases don’t play nice

Don’t you just hate it when you know something is supposed to work and it just doesn’t? Then you start second guessing yourself, maybe I missed a step, maybe I did this wrong. Sometimes you did, but in most cases if you know what you’re doing, you didn’t!

Working with an Apache Webserver with cPanel installed for hosting account management it should be easiest to perform simple tasks. Ran into a rather odd issue between WPTouch and Woocommerce Conversion Tracking Plugin.

 

Short version is that the two plugins listed above don’t work together as of 8/8/2017. I do see that the WPTouch plugin isn’t listed to be tested with the latest version of WordPress so that certainly could be the cause. Will be testing again once they do release the next update to see if the problem persists.

 

Long way around. Performed all updates across the entire site including WordPress Core, Plugins, and Themes. Everything seemed to be working fine at first, but, when we went to make a change in WPTouch, BAM! The whole site is erroring out, errors in the error log. First thought was to restore a backup, sure, that worked but undid a few hours of product changes which was not cool. First tried to export Products + Variations from a working dev copy of the of the website and Import them via WordPress to no avail. It created the new variable products but they were all blank. Odd right, that’s what I thought. Alright so let’s force it and take that restored site that is back working and combine some database tables to restore only the products and pages. We were able to use this method to do so via PHPMyadmin. Well that lead into another problem, PHPMyadmin is seizing up and not allowing us to drop the existing tables to replace them. Possibly the cause behind why the Export/Import wouldn’t work directly through WordPress. After connecting new tables, run velvetblues to update any incorrect URL’s. It was still acting funky and threw up an internal 500 which led us to the error log that showed the following:

[08-Aug-2017 13:27:02 UTC] PHP Fatal error: Cannot redeclare class WeDevs_WC_Tracking_Integration in /home2/user/public_html/mobile/wp-content/plugins/woocommerce-conversion-tracking/includes/integration.php on line 0
[08-Aug-2017 13:30:40 UTC] PHP Fatal error: Cannot redeclare class WeDevs_WC_Tracking_Integration in /home2/user/public_html/mobile/wp-content/plugins/woocommerce-conversion-tracking/includes/integration.php on line 0
[08-Aug-2017 13:31:01 UTC] PHP Fatal error: Cannot redeclare class WeDevs_WC_Tracking_Integration in /home2/user/public_html/mobile/wp-content/plugins/woocommerce-conversion-tracking/includes/integration.php on line 0
[08-Aug-2017 13:32:01 UTC] PHP Fatal error: Cannot redeclare class WeDevs_WC_Tracking_Integration in /home2/user/public_html/mobile/wp-content/plugins/woocommerce-conversion-tracking/includes/integration.php on line 0

After Deactivating this plugin the website now loads and works as it should.

 

mysql, phpmyadmin, wordpress, wptouch, woocommerce, conversion tracking

 

https://wordpress.stackexchange.com/questions/67840/where-does-the-media-library-live-in-the-database

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply