header

Collapse

DB Errors: 1412 and 1064

Collapse
X
Collapse
 
  • Page of 3
  • Time
  • Show
Clear All
new posts
Previous 1 2 3 template Next
  • Go to Thank You mito22
    Senior Member
    ✅✅
    ❤️
    • 02.2021
    • 120
    • 47
    • 69
    Font Size
    #1

    DB Errors: 1412 and 1064

    Go to Thank You
    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.comGo to Top of Post
    Last edited by mito22; 17.03.21, 07:58.
    Similar Threads
    Tags: 1064, 1412, errors:
    • Go to Thank You bosss
      Senior Member
      ✅✅
      ❤️❤️
      • 03.2021
      • 124
      • 5.7.5
      • 65
      • 69
      Font Size
      #2
      Go to Thank You
      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);

      Go to Top of Post
      Last edited by bosss; 17.03.21, 13:45.
      I invite you to visit my IPS forum 👍
      I invite you to visit my vB5 forum 👍
        👍 1

        Comment

        • Go to Thank You mito22
          Senior Member
          ✅✅
          ❤️
          • 02.2021
          • 120
          • 47
          • 69
          Font Size
          #3
          Go to Thank You
          Originally posted by bosss
          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 Go to Top of Post

            Comment

            • Go to Thank You bosss
              Senior Member
              ✅✅
              ❤️❤️
              • 03.2021
              • 124
              • 5.7.5
              • 65
              • 69
              Font Size
              #4
              Go to Thank You
              Originally posted by mito22

              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 !Go to Top of Post
              I invite you to visit my IPS forum 👍
              I invite you to visit my vB5 forum 👍

                Comment

                • Go to Thank You mito22
                  Senior Member
                  ✅✅
                  ❤️
                  • 02.2021
                  • 120
                  • 47
                  • 69
                  Font Size
                  #5
                  Go to Thank You
                  Originally posted by bosss

                  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! Go to Top of Post

                    Comment

                    Previous 1 2 3 template Next
                    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

                        Related Topics

                        Collapse
                        Topics Statistics Last Post
                        switch from wsc to vBulletin
                        by Prometheus
                        Started by Prometheus, 23.06.23, 21:32
                        0 responses
                        68 views
                        0 reactions
                        		 Last Post Prometheus
                        by Prometheus
                        23.06.23, 21:32
                        View All

                        multiplex reklam paga

                        Collapse
                        Working...
                        😀
                        😂
                        🥰
                        😘
                        🤢
                        😎
                        😞
                        😡
                        👍
                        👎
                        ☕

                        We process personal data about users of our site, through the use of cookies and other technologies, to deliver our services, personalize advertising, and to analyze site activity. We may share certain information about our users with our advertising and analytics partners. For additional details, refer to our Privacy Policy.

                        By clicking "I AGREE" below, you agree to our Privacy Policy and our personal data processing and cookie practices as described therein. You also acknowledge that this forum may be hosted outside your country and you consent to the collection, storage, and processing of your data in the country where this forum is hosted.

                        I Agree

                        AdBlock Detected

                        Please Disable Adblock

                        Please consider supporting us by disabling the ad blocker.

                        I've Disabled AdBlock
                        ▲ Home ▼