Announcement

Collapse
No announcement yet.

SQL Error!!!

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

  • SQL Error!!!

    Code:
    #1226 - User 'micorill' has exceeded the 'max_updates' resource (current value: 10000)
    How can I fix this?

  • #2
    When does this occur?
    What is the full MySQL error that vB displays?

    Comment


    • #3
      This is a server restriction:

      User 'micorill' has exceeded the 'max_updates' resource (current value: 10000)

      Only your host can remove this restriction.
      Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
      Change CKEditor Colors to Match Style (for 4.1.4 and above)

      Steve Machol Photography


      Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


      Comment


      • #4
        Originally posted by Steve Machol View Post
        This is a server restriction:

        User 'micorill' has exceeded the 'max_updates' resource (current value: 10000)

        Only your host can remove this restriction.
        my host is not change this limit. how can i step to step this resources.
        etc. one hour 9.000, later one hour 9.000 resources

        regards

        Comment


        • #5
          can help me admincp/misc.php
          i want edit this section for 8000 resources and wait 60min and again 8000 resources
          Code:
          // ###################### Start update threads #######################
          if ($_REQUEST['do'] == 'updatethread')
          {
          if (empty($vbulletin->GPC['perpage']))
          {
          $vbulletin->GPC['perpage'] = 2000;
          }
          $finishat = $vbulletin->GPC['startat'] + $vbulletin->GPC['perpage'];
          echo '<p>' . $vbphrase['updating_threads'] . '</p>';
          $threads = $db->query_read("
          SELECT threadid
          FROM " . TABLE_PREFIX . "thread
          WHERE threadid >= " . $vbulletin->GPC['startat'] . " AND
          threadid < $finishat
          ORDER BY threadid
          ");
          while ($thread = $db->fetch_array($threads))
          {
          build_thread_counters($thread['threadid']);
          echo construct_phrase($vbphrase['processing_x'], $thread['threadid'])."<br />\n";
          vbflush();
          }
          if ($checkmore = $db->query_first("SELECT threadid FROM " . TABLE_PREFIX . "thread WHERE threadid >= $finishat LIMIT 1"))
          {
          print_cp_redirect("misc.php?" . $vbulletin->session->vars['sessionurl'] . "do=updatethread&startat=$finishat&pp=" . $vbulletin->GPC['perpage']);
          echo "<p><a href=\"misc.php?" . $vbulletin->session->vars['sessionurl'] . "do=updatethread&amp;startat=$finishat&amp;pp=" . $vbulletin->GPC['perpage'] . "\">" . $vbphrase['click_here_to_continue_processing'] . "</a></p>";
          }
          else
          {
          define('CP_REDIRECT', 'misc.php');
          print_stop_message('updated_threads_successfully');
          }
          }
          


          regards

          Comment


          • #6
            Sorry, I don't understand what you are asking. Please explain.
            Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
            Change CKEditor Colors to Match Style (for 4.1.4 and above)

            Steve Machol Photography


            Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


            Comment


            • #7
              my hosting is not change this limit;
              'max_updates' resource (current value: 20000)
              and i cant repair my forum database and i m find any alternative.
              sorry my english is not good.

              regards

              Comment


              • #8
                There is no function to do this. This requires modifying the code. We cannot officially support code modifications or forums running modified code, however you can try searching or asking for help with this over at www.vbulletin.org.
                Best Regards
                Colin Frei

                Please don't contact me per PM.

                Comment

                Related Topics

                Collapse

                Working...
                X