crsurf Posted December 1, 2017 Report Share Posted December 1, 2017 I am getting this error each hour in my debug.php file: Nov 08 08:18:13 +0000 OX-maintenance-5a02bdc454ff9 [ error] ERROR: Could not migrate raw bucket data from the 'ox_data_bkt_a' bucket table Nov 08 08:18:13 +0000 OX-maintenance-5a02bdc454ff9 [ error] Error message was: MDB2 Error: syntax error What does it mean and how can I fit it? Quote Link to comment Share on other sites More sharing options...
andrewatfornax Posted January 4, 2018 Report Share Posted January 4, 2018 Hi @crsurf, This means that not all of your "raw" stats data in the ox_data_bkt_a table was able to be migrated into the summary tables that sit "higher up" in the chain, so, you might be missing statistics. To fix it, we'd have to understand what the syntax error is first. Do you have logging enabled for your database, and can you determine the SQL command that is trying to be executed at that time which is causing the issue? Quote Link to comment Share on other sites More sharing options...
crsurf Posted January 5, 2018 Author Report Share Posted January 5, 2018 I don't know the answer to this as I am not that experienced with SQL. Do you offer a service that helps fix problems with Revive? Right now none of my ads are appearing. The only change I made from a week ago is deleting the cache and updating myPHP to the latest version. Quote Link to comment Share on other sites More sharing options...
andrewatfornax Posted January 9, 2018 Report Share Posted January 9, 2018 Hi @crsurf, Sorry, no, as an open source project, we don't offer a paid support offering. If the change was that you updated myPHP, I would carefully at that change, and what it did - seems like that might be somehow related. Did the myPHP upgrade also make other changes, e.g. MySQL permissions, etc? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.