Rare PHP error

Hello again, today I noticed lots of these errors in one of my sites using your plugin.

[11-Sep-2014 04:35:32 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 4 de la base de datos de WordPress para la consulta SELECT blocks.id,blocks.name,blocks.pinPoint,blocks.location,blocks.links,blocks.expressions,(blocks.pinPoint & 4353) blocksGroup FROMcu2vn4ah_cjtoolbox_blocks` blocks
LEFT JOIN cu2vn4ah_cjtoolbox_block_pins pins
ON blocks.id = pins.blockId WHERE (((backupId IS NULL) AND (state = ‘active’)) AND
((blocks.pinPoint & 4353) OR ((blocks.pinPoint & 512) AND (pins.pin = ‘posts’) AND (pins.value 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
[11-Sep-2014 18:43:48 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 4 de la base de datos de WordPress para la consulta SELECT blocks.id,blocks.name,blocks.pinPoint,blocks.location,blocks.links,blocks.expressions,(blocks.pinPoint & 4353) blocksGroup FROM cu2vn4ah_cjtoolbox_blocks blocks
LEFT JOIN cu2vn4ah_cjtoolbox_block_pins pins
ON blocks.id = pins.blockId WHERE (((backupId IS NULL) AND (state = ‘active’)) AND
((blocks.pinPoint & 4353) OR ((blocks.pinPoint & 512) AND (pins.pin = ‘posts’) AND (pins.value 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
`

The plugin is still generating the last reported error. Across different websites using the CJT plugin. Any news? Any idea?

ok, I think I can wait for your release. This bug doesn’t seem to make the websites fail or stay down, BUT it is filling the error logs with tons of entries like the one above.

Hope you can find what’s generating the annoyance and fix it. 🙂

Best regards!
Marcelo

Hello Ahmed, It’s not that easy to test, since all the sites are in production. I should have to setup a staging copy and let it be some days to see if this error happens again.
Although, there are a couple sites using CJT which doesnt show this error.

The curious thing is that although these are sites with 1k-5k visitors/day, the error is logged only 1-4 times a day. So, probably it’s being generated when specific cron task are run. Maybe?

The sites having the issue are all using different themes, and the only plugins in common where the error is showing up are:

– BackWPup
– iThemes Security
– W3 Total Cache
– WordPress SEO
– wp-optimize
– wp-missed-schedule
– shareaholic
– jetpack
– google-analytics-dashboard-for-wp

The real curious thing I noticed is that issue happened in sites using PHP 5.4 and MySQL 5.6. Sites using PHP 5.3 or MySQL 5.5 are not presenting the error. May be an incompatibility with PHP 5.4 and/or MySQL 5.6? I think this last thing may give you a good clue to determine the point of failure.

As the error point out, it’s something in your MySQL query:

[15-Oct-2014 07:42:25 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 4:
SELECT blocks.id,blocks.name,blocks.pinPoint,blocks.location,blocks.links,blocks.expressions,(blocks.pinPoint & 4353) blocksGroup FROM cu2vn4ah_cjtoolbox_blocks blocks
LEFT JOIN cu2vn4ah_cjtoolbox_block_pins pins
ON blocks.id = pins.blockId WHERE (((backupId IS NULL) AND (state = ‘active’)) AND
((blocks.pinPoint & 4353) OR ((blocks.pinPoint & 512) AND (pins.pin = ‘posts’) AND (pins.value 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

Just in case you want to play with, two of the effected sites are using free theme Hueman (https://wordpress.org/themes/hueman). Others have several themes, some free, some paid.

If the post id is not being specified, is there any way to see if this is happenning when some specific page is being viewed?

Great, let me know if I can check something to help