Announcement

Collapse
No announcement yet.

DB Errors: 1412 and 1064

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Font Size
    #1

    DB Errors: 1412 and 1064

    I have two issues on db in a week......

    I've installed and uninstalled about 3-4 yilmaz plugin.....

    But have this two problems.... (the forum 1 time every 3 give 'database error' when u post anything too and appears slower about 50%....):



    1064:

    Database error in vBulletin 5.6.3: Invalid SQL: SELECT tagnode.nodeid as tagnodeid, node.iconid, node.prefixid, node.nodeid as nodeidsi, node.title as konubasligi, node.lastcontentid, node.parentid, node.textcount, node.totalcount, icon.iconpath, icon.title as icontitle, closure.parent as forumidesi, closure.depth, forum.title as forumtitle, node.authorname FROM tag AS tag LEFT JOIN tagnode AS tagnode ON (tagnode.tagid = tag.tagid) LEFT JOIN node AS node ON (node.nodeid = tagnode.nodeid) LEFT JOIN closure AS closure ON (closure.child = node.nodeid) LEFT JOIN node AS forum ON (forum.nodeid = closure.parent) LEFT JOIN user AS user ON (user.userid = node.lastauthorid) LEFT JOIN icon AS icon ON (icon.iconid = node.iconid) WHERE () AND closure.depth = 1 AND node.title !='' AND node.inlist = 1 AND tagnode.nodeid != '27012' AND tagnode.nodeid = node.starter GROUP BY tagnode.nodeid ORDER BY tagnode.nodeid DESC LIMIT 5; MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND closure.depth = 1 AND node.title !='' AND node.inlist = 1 AND ta...' at line 9 Error Number : 1064 Request Date : Wednesday, March 17th 2021 @ 07:49:57 AM Error Date : Wednesday, March 17th 2021 @ 07:50:00 AM Script : https://www.daidegasforum.com/forum/...video/27012-r7 Referrer : IP Address : 185.191.171.35 Username : Ospite Classname : vB_Database_MySQLi MySQL Version : Stack Trace: #0 vB_Database->getErrorData() called in phar://[path]/vb/vb.phar/database.php on line 1207 #1 vB_Database->halt() called in phar://[path]/vb/vb.phar/database/mysqli.php on line 249 #2 vB_Database_MySQLi->execute_query() called in phar://[path]/vb/vb.phar/database.php on line 576 #3 vB_Database->query_read() called in [path]/packages/yilmazsimilarthreads/api/template.php on line 69 #4 YilmazSimilarThreads_Api_Template::fetchBulk() called in phar://[path]/vb/vb.phar/api/wrapper.php on line 219 #5 vB_Api_Wrapper->__call() called in /ddg/web/prod/includes/api/interface/collapsed.php on line 105 #6 Api_Interface_Collapsed->callApi() called in /ddg/web/prod/includes/vb5/template/cache.php on line 224 #7 vB5_Template_Cache->fetchTemplate() called in /ddg/web/prod/includes/vb5/template/cache.php on line 110 #8 vB5_Template_Cache->replacePlaceholders() called in /ddg/web/prod/includes/vb5/template.php on line 421 #9 vB5_Template->render() called in /ddg/web/prod/includes/vb5/template/cache.php on line 134 #10 vB5_Template_Cache->replacePlaceholders() called in /ddg/web/prod/includes/vb5/template.php on line 421 #11 vB5_Template->render() called in /ddg/web/prod/includes/vb5/template/cache.php on line 134 #12 vB5_Template_Cache->replacePlaceholders() called in /ddg/web/prod/includes/vb5/template.php on line 421 #13 vB5_Template->render() called in /ddg/web/prod/includes/vb5/template/cache.php on line 134 #14 vB5_Template_Cache->replacePlaceholders() called in /ddg/web/prod/includes/vb5/template.php on line 421 #15 vB5_Template->render() called in /ddg/web/prod/includes/vb5/template/cache.php on line 134 #16 vB5_Template_Cache->replacePlaceholders() called in /ddg/web/prod/includes/vb5/template.php on line 421 #17 vB5_Template->render() called in /ddg/web/prod/includes/vb5/template/cache.php on line 134 #18 vB5_Template_Cache->replacePlaceholders() called in /ddg/web/prod/includes/vb5/template.php on line 421 #19 vB5_Template->render() called in /ddg/web/prod/includes/vb5/frontend/controller/page.php on line 274 #20 vB5_Frontend_Controller_Page->index() called in /ddg/web/prod/index.php on line 74
    and 1412:

    Database error in vBulletin 5.6.3: Invalid SQL: SELECT * FROM cache WHERE `cacheid` IN ('vBAtchmnts_10907152'); MySQL Error : Table definition has changed, please retry transaction Error Number : 1412 Request Date : Wednesday, March 17th 2021 @ 08:30:22 AM Error Date : Wednesday, March 17th 2021 @ 08:30:22 AM Script : https://www.daidegasforum.com/create-content/text/ Referrer : https://www.daidegasforum.com/forum/...ori-di-ricerca IP Address : 93.41.35.127 Username : mito22 Classname : vB_Database_MySQLi MySQL Version : Stack Trace: #0 vB_Database->getErrorData() called in phar://[path]/vb/vb.phar/database.php on line 1207 #1 vB_Database->halt() called in phar://[path]/vb/vb.phar/database/mysqli.php on line 249 #2 vB_Database_MySQLi->execute_query() called in phar://[path]/vb/vb.phar/database.php on line 576 #3 vB_Database->query_read() called in phar://[path]/vb/vb.phar/db/result.php on line 144 #4 vB_dB_Result->rewind() called in phar://[path]/vb/vb.phar/db/result.php on line 68 #5 vB_dB_Result->__construct() called in phar://[path]/vb/vb.phar/db/query/select.php on line 121 #6 vB_dB_Query_Select->doSelect() called in phar://[path]/vb/vb.phar/db/query/select.php on line 98 #7 vB_dB_Query_Select->execSQL() called in phar://[path]/vb/vb.phar/db/assertor.php on line 293 #8 vB_dB_Assertor->assertQuery() called in phar://[path]/vb/vb.phar/cache/db.php on line 154 #9 vB_Cache_Db->readCacheArray() called in phar://[path]/vb/vb.phar/cache.php on line 761 #10 vB_Cache->read() called in phar://[path]/vb/vb.phar/library/node.php on line 1763 #11 vB_Library_Node->fetchNodeAttachments() called in phar://[path]/vb/vb.phar/api/node.php on line 1128 #12 vB_Api_Node->getNodeAttachments() called in phar://[path]/vb/vb.phar/library/content/text.php on line 165 #13 vB_Library_Content_Text->addContentInfo() called in phar://[path]/vb/vb.phar/library/content/text.php on line 84 #14 vB_Library_Content_Text->getFullContent() called in phar://[path]/vb/vb.phar/library/content/text.php on line 744 #15 vB_Library_Content_Text->add() called in phar://[path]/vb/vb.phar/api/content/text.php on line 173 #16 vB_Api_Content_Text->add() called in phar://[path]/vb/vb.phar/api/wrapper.php on line 201 #17 vB_Api_Wrapper->__call() called in /ddg/web/prod/includes/api/interface/collapsed.php on line 105 #18 Api_Interface_Collapsed->callApi() called in /ddg/web/prod/includes/vb5/frontend/controller/createcontent.php on line 446 #19 vB5_Frontend_Controller_CreateContent->createNewNode() called in /ddg/web/prod/includes/vb5/frontend/controller/createcontent.php on line 296 #20 vB5_Frontend_Controller_CreateContent->actionTextNodeInternal() called in /ddg/web/prod/includes/vb5/frontend/controller/createcontent.php on line 186 #21 vB5_Frontend_Controller_CreateContent->index() called in /ddg/web/prod/index.php on line 74
    Anyone can help me? I'm not a db code expert.... thanks guys...

    The forum is: www.daidegasforum.com
    Last edited by mito22; 17-03-2021, 07:58.
    Similar Threads

  • Font Size
    #2
    If you unintsalled some plugins (you must delete uploaded files from your server).
    Try disable plugins one by one and test!

    try this
    disable all products and plugins by adding this line to your config.php file under <?php:
    define('DISABLE_HOOKS', true);

    Last edited by bosss; 17-03-2021, 13:45.
    mito22 likes this.
    I invite you to visit my IPS forum 👍

    My vB 5 test forum 👍

    Comment


    • Font Size
      #3
      Originally posted by bosss View Post
      If you unintsalled some plugins (you must delete uploaded files from your server).
      Try disable plugins one by one and test!

      try this
      disable all products and plugins by adding this line to your config.php file under <?php:
      define('DISABLE_HOOKS', true);
      Ok thanks boss.. but I have some plugins and customization on my board.... also If i disable all... ok... probably all will be ok... but... I've got 15 millions messages...

      Isn't the solution..

      I'll wait for yilmaz maybe in little time he knows what's wrong

      Comment


      • Font Size
        #4
        Originally posted by mito22 View Post

        Ok thanks boss.. but I have some plugins and customization on my board.... also If i disable all... ok... probably all will be ok... but... I've got 15 millions messages...

        Isn't the solution..

        I'll wait for yilmaz maybe in little time he knows what's wrong
        If you disable all plugins or one by one - your customizations will be ok - no panic
        because error 1064 is plugin error !
        I invite you to visit my IPS forum 👍

        My vB 5 test forum 👍

        Comment


        • Font Size
          #5
          Originally posted by bosss View Post

          If you disable all plugins or one by one - your customizations will be ok - no panic
          because error 1064 is plugin error !
          Thanks for the info boss....

          Ok.... I'll try...

          And maybe yilmaz... make a miracle!

          Comment


          • Font Size
            #6
            Originally posted by mito22 View Post

            Thanks for the info boss....

            Ok.... I'll try...

            And maybe yilmaz... make a miracle!
            You can try and yilmaz will fix rest of problems... 😀
            mito22 likes this.
            I invite you to visit my IPS forum 👍

            My vB 5 test forum 👍

            Comment


            • Font Size
              #7
              Originally posted by bosss View Post

              You can try and yilmaz will fix rest of problems... 😀
              The savior.... yes.... I hope so.... many plugins are very useful....

              But if the forum give errors and go at 10% of the normal speed..... isn't suitable for users...

              Comment


              • Font Size
                #8
                Update.... like Yil tell me.... I tried to uninstall SIMILAR THREADS and the error 1064 gone....

                But... there is the table error 1412.... and 'db error' when u send answer or new topic.... 70%...

                Database error in vBulletin 5.6.3: Invalid SQL: SELECT * FROM cache WHERE `cacheid` IN ('vB_UserPerms0');
                MySQL Error : Table definition has changed, please retry transaction
                Error Number : 1412
                Request Date : Thursday, March 18th 2021 @ 08:53:13 AM
                Error Date : Thursday, March 18th 2021 @ 08:53:13 AM
                Script : https://www.daidegasforum.com/create-content/text/
                Referrer : https://www.daidegasforum.com/forum/...apitolo/page38
                IP Address : 151.42.180.103
                Username : MikyRacing
                Classname : vB_Database_MySQLi MySQL Version : Stack Trace: #0 vB_Database->getErrorData() called in phar://[path]/vb/vb.phar/database.php on line 1207 #1 vB_Database->halt() called in phar://[path]/vb/vb.phar/database/mysqli.php on line 249 #2 vB_Database_MySQLi->execute_query() called in phar://[path]/vb/vb.phar/database.php on line 576 #3 vB_Database->query_read() called in phar://[path]/vb/vb.phar/db/result.php on line 144 #4 vB_dB_Result->rewind() called in phar://[path]/vb/vb.phar/db/result.php on line 68 #5 vB_dB_Result->__construct() called in phar://[path]/vb/vb.phar/db/query/select.php on line 121 #6 vB_dB_Query_Select->doSelect() called in phar://[path]/vb/vb.phar/db/query/select.php on line 98 #7 vB_dB_Query_Select->execSQL() called in phar://[path]/vb/vb.phar/db/assertor.php on line 293 #8 vB_dB_Assertor->assertQuery() called in phar://[path]/vb/vb.phar/cache/db.php on line 154 #9 vB_Cache_Db->readCacheArray() called in phar://[path]/vb/vb.phar/cache.php on line 761 #10 vB_Cache->read() called in phar://[path]/vb/vb.phar/usercontext.php on line 142 #11 vB_UserContext->reloadUserPerms() called in phar://[path]/vb/vb.phar/usercontext.php on line 115 #12 vB_UserContext->__construct() called in [path]/vb/vb.php on line 940 #13 vB::getUserContext() called in phar://[path]/vb/vb.phar/library/external.php on line 44 #14 vB_Library_External->checkExternalForChannels() called in phar://[path]/vb/vb.phar/library/external.php on line 101 #15 vB_Library_External->getExternalDataForChannels() called in phar://[path]/vb/vb.phar/library/content/channel.php on line 1025 #16 vB_Library_Content_Channel->assembleContent() called in phar://[path]/vb/vb.phar/library/content.php on line 2569 #17 vB_Library_Content->getFullContent() called in phar://[path]/vb/vb.phar/library/content/channel.php on line 386 #18 vB_Library_Content_Channel->getFullContent() called in phar://[path]/vb/vb.phar/library/node.php on line 2350 #19 vB_Library_Node->getNodeFullContent() called in phar://[path]/vb/vb.phar/library/content.php on line 909 #20 vB_Library_Content->requiresModeration() called in phar://[path]/vb/vb.phar/library/content.php on line 625 #21 vB_Library_Content->add() called in phar://[path]/vb/vb.phar/library/content/text.php on line 743 #22 vB_Library_Content_Text->add() called in phar://[path]/vb/vb.phar/api/content/text.php on line 173 #23 vB_Api_Content_Text->add() called in phar://[path]/vb/vb.phar/api/wrapper.php on line 201 #24 vB_Api_Wrapper->__call() called in /ddg/web/prod/includes/api/interface/collapsed.php on line 105 #25 Api_Interface_Collapsed->callApi() called in /ddg/web/prod/includes/vb5/frontend/controller/createcontent.php on line 446 #26 vB5_Frontend_Controller_CreateContent->createNewNode() called in /ddg/web/prod/includes/vb5/frontend/controller/createcontent.php on line 296 #27 vB5_Frontend_Controller_CreateContent->actionTextNodeInternal() called in /ddg/web/prod/includes/vb5/frontend/controller/createcontent.php on line 186 #28 vB5_Frontend_Controller_CreateContent->index() called in /ddg/web/prod/index.php on line 74
                Speed of the forum... better but ... slow... step by step....

                Thanks for support!
                Last edited by mito22; 18-03-2021, 08:00.
                bosss likes this.

                Comment


                • Font Size
                  #9
                  OPS..... a vb expert tell me... maybe the problem was..... (OPS) I've installed a plugin with forum active (YES) or maybe when the forum deleting the cache (Don't know)..

                  Any ideas to resolve?

                  Comment


                  • Font Size
                    #10
                    Originally posted by mito22 View Post
                    OPS..... a vb expert tell me... maybe the problem was..... (OPS) I've installed a plugin with forum active (YES) or maybe when the forum deleting the cache (Don't know)..

                    Any ideas to resolve?
                    You can install plugins when forum is active - no problems!

                    Try to run upgrade script - maybe helps to resolve problem.
                    Like said before - disable plugins one by one and test!
                    I invite you to visit my IPS forum 👍

                    My vB 5 test forum 👍

                    Comment


                    • Font Size
                      #11
                      Originally posted by bosss View Post

                      You can install plugins when forum is active - no problems!

                      Try to run upgrade script - maybe helps to resolve problem.
                      Like said before - disable plugins one by one and test!
                      Sorry boss..... but.... wich upgrade script? Upgrade the forum? From 5.6.3 to 5.6.4? Do u mean that?

                      I've disabled... but the error still remain.. (disabled... the last plugins..... NOT ALL)

                      Comment


                      • Font Size
                        #12
                        Originally posted by mito22 View Post

                        Sorry boss..... but.... wich upgrade script? Upgrade the forum? From 5.6.3 to 5.6.4? Do u mean that?

                        I've disabled... but the error still remain.. (disabled... the last plugins..... NOT ALL)
                        Try disable all - maybe some plugins are in conflict

                        You can run upgrade (5.6.3)
                        Copy your install directory (if you deleted before) - and just run - install/upgrade.php

                        you will lose nothing - maybe that fix problem (disable your board before run upgrade)
                        mito22 likes this.
                        I invite you to visit my IPS forum 👍

                        My vB 5 test forum 👍

                        Comment


                        • Font Size
                          #13
                          Thanks boss.... Maybe... let's try to restart the server... before the upgrade...

                          Comment


                          • Font Size
                            #14
                            Originally posted by mito22 View Post
                            Thanks boss.... Maybe... let's try to restart the server... before the upgrade...
                            You must check your error.log file on your server (in forum root) - just edit file and see what errors you have!
                            I invite you to visit my IPS forum 👍

                            My vB 5 test forum 👍

                            Comment


                            • Font Size
                              #15
                              Solved..... appear it was relative at hide links from guest.... that reset cache every second about... and was heavy to uninstall.

                              Thanks for support guys.
                              bosss likes this.

                              Comment

                              X

                              Thread Information

                              Collapse

                              Users Browsing this Thread

                              There are currently 1 users browsing this thread. (0 members and 1 guests)

                                Those who read this thread

                                Collapse

                                Members who have read this thread: 0

                                  Working...
                                  X

                                  AdBlock Detected

                                  Please Disable Adblock

                                  Please consider supporting us by disabling the ad blocker.

                                  I've Disabled AdBlock
                                  0x0