Title: Rare PHP error Last modified: August 22, 2016 --- # Rare PHP error * [Marcelo Pedra](https://wordpress.org/support/users/kent-brockman/) * (@kent-brockman) * [11 years, 7 months ago](https://wordpress.org/support/topic/rare-php-error/) * Hello there. I want to share this only strange PHP error detected today. Software used: WP 4.0 with Hueman theme, Apache 2.4, PHP 5.4, MySQL 5.6. I have a couple more websites in the same server with the same theme and plugins and are working fine. I use CJT in this one just to add one set of custom CSS rules. * `[07-Sep-2014 15:27:34 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 ` * Any idea? what could have generated this exceptional error? Anything to be worried about? * [https://wordpress.org/plugins/css-javascript-toolbox/](https://wordpress.org/plugins/css-javascript-toolbox/) Viewing 15 replies - 1 through 15 (of 16 total) 1 [2](https://wordpress.org/support/topic/rare-php-error/page/2/?output_format=md) [→](https://wordpress.org/support/topic/rare-php-error/page/2/?output_format=md) * [Code Machine](https://wordpress.org/support/users/xpointer/) * (@xpointer) * [11 years, 7 months ago](https://wordpress.org/support/topic/rare-php-error/#post-5267861) * Hello, * There is any issue just fixed in Version 7.2. * We just released version 7.2 from few hours ago. * The issue is because latest WordPress releases start to use MYSQLI extension for connecting to database. * Please upgrade to latest version and let us know the result. * Regards, AHMeD * Thread Starter [Marcelo Pedra](https://wordpress.org/support/users/kent-brockman/) * (@kent-brockman) * [11 years, 7 months ago](https://wordpress.org/support/topic/rare-php-error/#post-5267911) * thanks! I’ll upgrade the sites tonight and if anything goes weird, I’ll let you know. 🙂 bye bye * Thread Starter [Marcelo Pedra](https://wordpress.org/support/users/kent-brockman/) * (@kent-brockman) * [11 years, 7 months ago](https://wordpress.org/support/topic/rare-php-error/#post-5268011) * 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 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 [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 ` * Thread Starter [Marcelo Pedra](https://wordpress.org/support/users/kent-brockman/) * (@kent-brockman) * [11 years, 7 months ago](https://wordpress.org/support/topic/rare-php-error/#post-5268012) * Looks like the first reported error. Any idea? * Thread Starter [Marcelo Pedra](https://wordpress.org/support/users/kent-brockman/) * (@kent-brockman) * [11 years, 6 months ago](https://wordpress.org/support/topic/rare-php-error/#post-5268085) * The plugin is still generating the last reported error. Across different websites using the CJT plugin. Any news? Any idea? * Plugin Author [wipeoutmedia](https://wordpress.org/support/users/wipeoutmedia/) * (@wipeoutmedia) * [11 years, 6 months ago](https://wordpress.org/support/topic/rare-php-error/#post-5268089) * Hi Marcelo, * Thanks for your patience. I am real sorry but we do not have any news as of yet. We are currently working hard on a number of modules at the moment. We hope to have some news after this development phase is done. * Kind Regards, Damian * Thread Starter [Marcelo Pedra](https://wordpress.org/support/users/kent-brockman/) * (@kent-brockman) * [11 years, 6 months ago](https://wordpress.org/support/topic/rare-php-error/#post-5268090) * 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 * [Code Machine](https://wordpress.org/support/users/xpointer/) * (@xpointer) * [11 years, 6 months ago](https://wordpress.org/support/topic/rare-php-error/#post-5268098) * Hello, * Sorry for the delay! We have been very busy working in the new version. * I believe that you might has a Plugin that makes a conflict! * Could you please disable all Plugins you’ve there and test only CJT. * You might also need to switch the Theme to any WordPress built0in theme. * Please let me know the result. * Regards, AHMeD * Thread Starter [Marcelo Pedra](https://wordpress.org/support/users/kent-brockman/) * (@kent-brockman) * [11 years, 6 months ago](https://wordpress.org/support/topic/rare-php-error/#post-5268099) * 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 * [Code Machine](https://wordpress.org/support/users/xpointer/) * (@xpointer) * [11 years, 6 months ago](https://wordpress.org/support/topic/rare-php-error/#post-5268100) * Thanks for the information. * Those all are great. * I’m happy to create the test site as it will help us discover the issue and may be other conflicts too. * The query error is because the WHERE clause condition “(pins.value IN ())))); doesn’t include the currently requested POST->ID that being retrived from $GLOBAL[‘ post’]->ID, the error means that $GLOBAL[‘post’] is not being set to the current displayed post/page! It should be something as FOLLOWING (pins.value IN (777))))); where 777 is the post id currently displayed! This is a little wiered and might be related to other Plugin might cleared this var. * I will check it and get back to you. * Thanks, AHMeD * Thread Starter [Marcelo Pedra](https://wordpress.org/support/users/kent-brockman/) * (@kent-brockman) * [11 years, 6 months ago](https://wordpress.org/support/topic/rare-php-error/#post-5268101) * Just in case you want to play with, two of the effected sites are using free theme Hueman ([https://wordpress.org/themes/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? * [Code Machine](https://wordpress.org/support/users/xpointer/) * (@xpointer) * [11 years, 6 months ago](https://wordpress.org/support/topic/rare-php-error/#post-5268103) * Thanks! * Sure there is a way but I don’t yet know what is it! * I will check it and get back to you real soon. * Thread Starter [Marcelo Pedra](https://wordpress.org/support/users/kent-brockman/) * (@kent-brockman) * [11 years, 6 months ago](https://wordpress.org/support/topic/rare-php-error/#post-5268104) * Great, let me know if I can check something to help * Thread Starter [Marcelo Pedra](https://wordpress.org/support/users/kent-brockman/) * (@kent-brockman) * [11 years, 5 months ago](https://wordpress.org/support/topic/rare-php-error/#post-5268106) * Not sure if you tried to address this error in the last update but just wanted to let you know it is still happenning. * `[19-Oct-2014 05:42:42 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` * [Code Machine](https://wordpress.org/support/users/xpointer/) * (@xpointer) * [11 years, 5 months ago](https://wordpress.org/support/topic/rare-php-error/#post-5268107) * No I didn’t worked in this issue * I don’t even considering this as CJT issue! * Its almost a Plugin conflict. * I will let you know once I figured out the issue. * Regards, AHMeD Viewing 15 replies - 1 through 15 (of 16 total) 1 [2](https://wordpress.org/support/topic/rare-php-error/page/2/?output_format=md) [→](https://wordpress.org/support/topic/rare-php-error/page/2/?output_format=md) The topic ‘Rare PHP error’ is closed to new replies. * ![](https://ps.w.org/css-javascript-toolbox/assets/icon-256x256.gif?rev=3132209) * [CSS & JavaScript Toolbox](https://wordpress.org/plugins/css-javascript-toolbox/) * [Frequently Asked Questions](https://wordpress.org/plugins/css-javascript-toolbox/#faq) * [Support Threads](https://wordpress.org/support/plugin/css-javascript-toolbox/) * [Active Topics](https://wordpress.org/support/plugin/css-javascript-toolbox/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/css-javascript-toolbox/unresolved/) * [Reviews](https://wordpress.org/support/plugin/css-javascript-toolbox/reviews/) * 16 replies * 3 participants * Last reply from: [Marcelo Pedra](https://wordpress.org/support/users/kent-brockman/) * Last activity: [11 years, 5 months ago](https://wordpress.org/support/topic/rare-php-error/page/2/#post-5268108) * Status: not resolved