- This topic has 1 reply, 2 voices, and was last updated 8 years, 5 months ago by .
Viewing 1 reply thread
Viewing 1 reply thread
- You must be logged in to reply to this topic.
Home › Forums › Support Tickets › SQL Error found from error.log
Tagged: SQL error
Dear Damian Baker,
I frequently found below SQL error from my error.log, what is the problem? How can I fix it?
SELECT blocks.id,blocks.name,blocks.pinPoint,blocks.location,blocks.links,blocks.expressions,(blocks.pinPoint & 17) blocksGroup FROMwp_cjtoolbox_blocks` blocks
LEFT JOIN wp_cjtoolbox_block_pins pins
ON blocks.id = pins.blockId WHERE (((backupId IS NULL) AND (state = ‘active’)) AND
((blocks.pinPoint & 17) OR ((blocks.pinPoint & 32) AND (pins.pin = ‘pages’) AND (pins.value IN ())))); made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), do_action(‘template_redirect’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, CJTBlocksCouplingController->initCoupling, CJTBlocksCouplingController->getBlocks, CJTCouplingModel->getPinsBlocks, CJTPinsBlockSQLView->exec, CJTMYSQLQueueDriver->select`
Hi Kelvin,
Thanks for your support question. I apologise for the delay.
We see these errors from time to time and they can be caused by various means. Some due to syntax errors in the code blocks and others via unresolved errors within the plugin itself. This is generally not an issue, as these generated errors (or warnings) do not pose problems. That said, recently we have been dedicating more development on capturing and handling errors better, and also making the installer and uninstaller a lot more robust. Our aims are to make the plugin a lot more robust in general.
Regards,
Damian Baker