Recurrent MySQL error with your plugin
-
Hello! How you’re doing?
I’m seeing this error being captured in the PHP error log since ages. I think I have reported this before, but couldn’t find the post here, so here we are. The error was “usual” in past versions of your plugin, but it became REALLY REALLY frequent after upgrading to 8.2:[02-Jun-2016 01:16:26 UTC] Error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ) ) ) )' at line 5 de la base de datos de WordPress para la consulta SELECT blocks.id, blocks.owner, blocks.name, blocks.pinPoint, blocks.location, blocks.links, blocks.expressions, (blocks.pinPoint & 4353) blocksGroup FROM <code>iai3hciy_cjtoolbox_blocks</code> blocks LEFT JOIN <code>iai3hciy_cjtoolbox_block_pins</code> pins ON blocks.<code>id</code> = pins.<code>blockId</code> WHERE ( ( ( <code>backupId</code> IS NULL ) AND ( <code>state</code> = 'active' ) ) AND ( ( blocks.<code>pinPoint</code> & 4353 ) OR ( ( blocks.<code>pinPoint</code> & 512 ) AND ( pins.pin = 'posts' ) AND ( pins.<code>value</code> IN ( ) ) ) ) ); realizada por require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), do_action('template_redirect'), call_user_func_array, CJTBlocksCouplingController->initCoupling, CJTBlocksCouplingController->getBlocks, CJTCouplingModel->getPinsBlocks, CJTPinsBlockSQLView->exec, CJTMYSQLQueueDriver->select [02-Jun-2016 10:08:29 UTC] Error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ) ) ) )' at line 5 de la base de datos de WordPress para la consulta SELECT blocks.id, blocks.owner, blocks.name, blocks.pinPoint, blocks.location, blocks.links, blocks.expressions, (blocks.pinPoint & 4353) blocksGroup FROM <code>iai3hciy_cjtoolbox_blocks</code> blocks LEFT JOIN <code>iai3hciy_cjtoolbox_block_pins</code> pins ON blocks.<code>id</code> = pins.<code>blockId</code> WHERE ( ( ( <code>backupId</code> IS NULL ) AND ( <code>state</code> = 'active' ) ) AND ( ( blocks.<code>pinPoint</code> & 4353 ) OR ( ( blocks.<code>pinPoint</code> & 512 ) AND ( pins.pin = 'posts' ) AND ( pins.<code>value</code> IN ( ) ) ) ) ); realizada por require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), do_action('template_redirect'), call_user_func_array, CJTBlocksCouplingController->initCoupling, CJTBlocksCouplingController->getBlocks, CJTCouplingModel->getPinsBlocks, CJTPinsBlockSQLView->exec, CJTMYSQLQueueDriver->select [02-Jun-2016 10:46:53 UTC] Error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ) ) ) )' at line 5 de la base de datos de WordPress para la consulta SELECT blocks.id, blocks.owner, blocks.name, blocks.pinPoint, blocks.location, blocks.links, blocks.expressions, (blocks.pinPoint & 4353) blocksGroup FROM <code>iai3hciy_cjtoolbox_blocks</code> blocks LEFT JOIN <code>iai3hciy_cjtoolbox_block_pins</code> pins ON blocks.<code>id</code> = pins.<code>blockId</code> WHERE ( ( ( <code>backupId</code> IS NULL ) AND ( <code>state</code> = 'active' ) ) AND ( ( blocks.<code>pinPoint</code> & 4353 ) OR ( ( blocks.<code>pinPoint</code> & 512 ) AND ( pins.pin = 'posts' ) AND ( pins.<code>value</code> IN ( ) ) ) ) ); realizada por require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), do_action('template_redirect'), call_user_func_array, CJTBlocksCouplingController->initCoupling, CJTBlocksCouplingController->getBlocks, CJTCouplingModel->getPinsBlocks, CJTPinsBlockSQLView->exec, CJTMYSQLQueueDriver->selectThese are 3 of the occurrences in one single site. I have PHP error logs of up to 50 MB filled with these errors in almost 60 websites.
What can you do to find the cause and fix it.
I didn’t find any correlation between kind of themes/plugins used and this happens whether you have only one block of code in CJT or 20 (yes, I have sites with 10+ code blocks with your plugin)Any idea is welcome.
Thanks!
The topic ‘Recurrent MySQL error with your plugin’ is closed to new replies.