• Resolved Marcelo Pedra

    (@kent-brockman)


    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->select

    These 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!

    https://ww.wp.xz.cn/plugins/css-javascript-toolbox/

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author wipeoutmedia

    (@wipeoutmedia)

    Hi Marcelo,

    Good to hear from you again.
    Thank you for posting this error from the logs. I will study it more in depth when I get a chance after the new front-end development is finished. I will let you know how things go.

    Thanks for your patience.

    Regards,
    Damian

    Thread Starter Marcelo Pedra

    (@kent-brockman)

    Thank you. Let me know your findings.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Recurrent MySQL error with your plugin’ is closed to new replies.