XF 1.5 Help: Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: You have an error in your SQL syntax

Y

YungJedi

Active member
Hello, for a little while I still have the same errator that appears but I do not find the problem could you help me? thank you

Code: 
Erreur Info
Mysqli prepare 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 - library/Zend/Db/Statement/Mysqli.php:77

Trace de la pile
#0 /home/clients/de990ceef7bef05487eb473da8e5d1b9/web/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('\r\n\t\t\tINSERT IGN...')
#1 /home/clients/de990ceef7bef05487eb473da8e5d1b9/web/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '\r\n\t\t\tINSERT IGN...')
#2 /home/clients/de990ceef7bef05487eb473da8e5d1b9/web/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('\r\n\t\t\tINSERT IGN...')
#3 /home/clients/de990ceef7bef05487eb473da8e5d1b9/web/library/XenForo/Model/UserUpgrade.php(856): Zend_Db_Adapter_Abstract->query('\r\n\t\t\tINSERT IGN...', Array)
#4 /home/clients/de990ceef7bef05487eb473da8e5d1b9/web/library/XenForo/CronEntry/CleanUp.php(111): XenForo_Model_UserUpgrade->downgradeUserUpgrades(Array)
#5 /home/clients/de990ceef7bef05487eb473da8e5d1b9/web/library/XenForo/Model/Cron.php(356): XenForo_CronEntry_CleanUp::runUserDowngrade(Array)
#6 /home/clients/de990ceef7bef05487eb473da8e5d1b9/web/library/XenForo/Deferred/Cron.php(24): XenForo_Model_Cron->runEntry(Array)
#7 /home/clients/de990ceef7bef05487eb473da8e5d1b9/web/library/XenForo/Model/Deferred.php(295): XenForo_Deferred_Cron->execute(Array, Array, 7.9999990463257, '')
#8 /home/clients/de990ceef7bef05487eb473da8e5d1b9/web/library/XenForo/Model/Deferred.php(429): XenForo_Model_Deferred->runDeferred(Array, 7.9999990463257, '', false)
#9 /home/clients/de990ceef7bef05487eb473da8e5d1b9/web/library/XenForo/Model/Deferred.php(374): XenForo_Model_Deferred->_runInternal(Array, 8, '', false)
#10 /home/clients/de990ceef7bef05487eb473da8e5d1b9/web/deferred.php(23): XenForo_Model_Deferred->run(false)
#11 {main}

État de la demande
Array
(
    [url] => https://hack-shop.fr/deferred.php
    [_GET] => Array
        (
        )

    [_POST] => Array
        (
            [_xfRequestUri] => /threads/vps-ndd-herbergement-web-gratuit.1390/
            [_xfNoRedirect] => 1
            [_xfToken] => ********
            [_xfResponseType] => json
        )

)

bbf3ab372cffc9fdf9e3bf5cadd76242.png


P.s
other error for some day I am told that admin.php and not protect, yet he and well protected with password encrypt before I was not worried
b8e221cb5b91e7170cc268032a92c095.png
The "admin.php" is not protected! Click here for more information!
 
Sort by date Sort by votes
I don't think that message about admin.php being unprotected comes from XenForo, if I had to guess it'd be from DBTech's Security add-on or something similar. Could you click on one of the mysql errors and screenshot the stack trace from it? Should help debug your issue as well :)
 
Upvote 0 Downvote
Jake B. said:
I don't think that message about admin.php being unprotected comes from XenForo, if I had to guess it'd be from DBTech's Security add-on or something similar. Could you click on one of the mysql errors and screenshot the stack trace from it? Should help debug your issue as well :)
Click to expand...

Thank You Friend
Zend_Db_Statement_Mysqli_Exception: Mysqli prepare 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 - library/Zend/Db/Statement/Mysqli.php:77
Généré par: Compte inconnu, Hier à 22:51
Trace de la pile #0 /home/clients/de990ceef7bef05487eb473da8e5d1b9/web/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('\r\n\t\t\tINSERT IGN...')
#1 /home/clients/de990ceef7bef05487eb473da8e5d1b9/web/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '\r\n\t\t\tINSERT IGN...')
#2 /home/clients/de990ceef7bef05487eb473da8e5d1b9/web/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('\r\n\t\t\tINSERT IGN...')
#3 /home/clients/de990ceef7bef05487eb473da8e5d1b9/web/library/XenForo/Model/UserUpgrade.php(856): Zend_Db_Adapter_Abstract->query('\r\n\t\t\tINSERT IGN...', Array)
#4 /home/clients/de990ceef7bef05487eb473da8e5d1b9/web/library/XenForo/CronEntry/CleanUp.php(111): XenForo_Model_UserUpgrade->downgradeUserUpgrades(Array)
#5 /home/clients/de990ceef7bef05487eb473da8e5d1b9/web/library/XenForo/Model/Cron.php(356): XenForo_CronEntry_CleanUp::runUserDowngrade(Array)
#6 /home/clients/de990ceef7bef05487eb473da8e5d1b9/web/library/XenForo/Deferred/Cron.php(24): XenForo_Model_Cron->runEntry(Array)
#7 /home/clients/de990ceef7bef05487eb473da8e5d1b9/web/library/XenForo/Model/Deferred.php(295): XenForo_Deferred_Cron->execute(Array, Array, 7.9999990463257, '')
#8 /home/clients/de990ceef7bef05487eb473da8e5d1b9/web/library/XenForo/Model/Deferred.php(429): XenForo_Model_Deferred->runDeferred(Array, 7.9999990463257, '', false)
#9 /home/clients/de990ceef7bef05487eb473da8e5d1b9/web/library/XenForo/Model/Deferred.php(374): XenForo_Model_Deferred->_runInternal(Array, 8, '', false)
#10 /home/clients/de990ceef7bef05487eb473da8e5d1b9/web/deferred.php(23): XenForo_Model_Deferred->run(false)
#11 {main}
État de la demande array(3) {
["url"] => string(33) "https://hack-shop.fr/deferred.php"
["_GET"] => array(0) {
}
["_POST"] => array(4) {
["_xfRequestUri"] => string(47) "/threads/vps-ndd-herbergement-web-gratuit.1390/"
["_xfNoRedirect"] => string(1) "1"
["_xfToken"] => string(8) "********"
["_xfResponseType"] => string(4) "json"
}
}


Supprimer...Fermer
 
Upvote 0 Downvote
You must log in or register to reply here.
Back
Top Bottom