Announcement

Collapse
No announcement yet.

Repair/Optimize Tables weird error

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

  • Repair/Optimize Tables weird error

    Repair / Optimize Tables
    Please Wait...
    Results Table Action Message searchcore Optimize Note: Table does not support optimize, doing recreate + analyze instead searchcore Optimize Error: Duplicate entry '1778803' for key 'PRIMARY' searchcore Optimize Status: Operation failed
    JerzeeDevil

  • #2
    Why are you running this? This isn't a general maintenance tool and should not just be run without purpose.

    The error above indicates the table is an INNODB table and repair does not work on INNODB tables. Don't know why there is a duplicate entry but you can simply truncate the search* tables and rebuild the search index to eliminate any such issues.

    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API - Full / Mobile
    Vote for your favorite feature requests and the bugs you want to see fixed.

    Comment


    • #3
      I am trying to get to the bottom of a very long lag when posting, looking around for any possible help...I eventually ended up at Repair & Optimize tables. I posted here because I am almost at my wit's end with my server company.
      JerzeeDevil

      Comment


      • #4
        Repair / Optimize does not provide any noticeable performance benefits. Optimize doesn't even really optimize anything. What it does is remove previously deleted data from the tables and is only useful if you bulk delete threads, users, or attachments.


        Please answer the questions in this thread:
        http://www.vbulletin.com/forum/forum...swered-quickly
        Translations provided by Google.

        Wayne Luke
        The Rabid Badger - a vBulletin Cloud demonstration site.
        vBulletin 5 API - Full / Mobile
        Vote for your favorite feature requests and the bugs you want to see fixed.

        Comment


        • #5
          OK, I will not use repair/optimize ever again. I thought it was included in the software because it worked, sorry about that.
          1. vBulletin Version (I am in the queue for an update, but currently 4.2.3 Beta)
          2. PHP Version 5.5.20
          3. MySQL Version 5.6.23
          4. Any Addons installed PhotoPost Pro Gallery & vbadvanced v4.2.1
          5. Does the issue occur in a default style? No
          6. Error message on the screen' No
          7. Browser and Browser version used. All
          8. A list of steps that can be used to recreate the issue. Hit reply to thread and it posts immediately, but it takes sometimes up to 30 seconds for the browser to return to full functionality.

          JerzeeDevil

          Comment


          • AusPhotography
            AusPhotography commented
            Editing a comment
            Repair/Optimize does work. It should only be used when needed and only when the site is offline. You need to read up on MySQL as to why.when you should use this tool. In the right circumstances it is very useful

        • #6
          Been a while, anyone? Anything? :/
          JerzeeDevil

          Comment


          • #7
            What do you have for Email Options > Use Mailqueue System? The sending of subscription emails could cause a delay if you're not using the mail queue.

            Comment


            • #8
              Use Mailqueue System = Yes. Should I change it? What do you suggest?
              JerzeeDevil

              Comment


              • #9
                'Yes' is good. I guess that's not the problem.

                Comment


                • #10
                  You said you ended up at Repair and Optimize tables, is that because you narrowed it down to being a database issue?

                  Comment


                  • #11
                    I was looking for possible causes, and went over many different things with my server company. I still cannot figure it out
                    JerzeeDevil

                    Comment


                    • #12
                      Yeah, that is a pretty good guess. Did you temporarily turn off plugins just to make sure it isn't an add-on that's causing the problem?

                      I was going to suggest that you turn on debug mode, which lets you see a display of all the queries that were done for a page and how long they took. But then I realized that after you post you get redirected to the thread page so you never get a chance to see the debug info from the post. You;d have to hack the code in some way to see it, I guess.

                      Comment


                      • #13
                        Man, as always I am thankful for your guidance first & foremost. You are always helpful, so for that I thank you.

                        I use Firefox, so I will hit reply, and open another tab to my forum and see the post already there. The 1st tab has the little spinning (Working) icon and the 2nd tab is locked up until the 1st one goes through. Sometimes it is instant, other times it can take up to 30 seconds.
                        JerzeeDevil

                        Comment


                        • #14
                          I see. Well, I can't think of anything else right now. Hopefully someone else will have a suggestion.

                          Comment


                          • #15
                            Please try the following:

                            1. To disable the plugin/hook system completely, edit includes/config.php and add the following code:
                            Just below
                            Code:
                            <?php
                            enter
                            Code:
                            define('DISABLE_HOOKS', true);
                            2. Now go to AdminCP > Style Manager
                            and create a new style with no parent.
                            Now browse your forum using this new style.

                            Do you still have the same problem?
                            MARK.B | vBULLETIN SUPPORT

                            TalkNewsUK - My vBulletin 5.6.2 Demo
                            AdminAmmo - My Cloud Demo

                            Comment

                            widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                            Working...
                            X