Announcement

Collapse
No announcement yet.

cleaning database.

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

  • cleaning database.

    Is it ok to empty adminlog ,Word tables?

  • #2
    No, do not empty the word table!

    It's safe to clean the adminlog table though, you will only use all the past logs your admins created (you can also do this through the Admin CP btw).
    Chen Avinadav
    Better to remain silent and be thought a fool than to speak out and remove all doubt.

    גם אני מאוכזב מסיקור תחרות לתור מוטור של NRG הרשת ע"י מעריב

    Comment


    • #3
      Where is the option? I am unable to locate it.

      Originally posted by FireFly
      No, do not empty the word table!

      It's safe to clean the adminlog table though, you will only use all the past logs your admins created (you can also do this through the Admin CP btw).

      Comment


      • #4
        admin log -> prune admin log
        :: Always Back Up Forum Database + Attachments BEFORE upgrading !
        :: Nginx SPDY SSL - World Flags Demo [video results]
        :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

        Comment


        • #5
          Make sure your config.php is set up right (it has a $canpruneadminlog or something like that variable you need to set to your userid).
          Chen Avinadav
          Better to remain silent and be thought a fool than to speak out and remove all doubt.

          גם אני מאוכזב מסיקור תחרות לתור מוטור של NRG הרשת ע"י מעריב

          Comment


          • #6
            Okie. I had to reupload my config.php as my original config.php was from.. vb 2.0.0

            Originally posted by FireFly
            Make sure your config.php is set up right (it has a $canpruneadminlog or something like that variable you need to set to your userid).

            Comment


            • #7
              What happens if you clear the word table? Because I've been getting this error? The original error was toooo long to paste so I attached it.

              Database error in vBulletin Control Panel 2.2.1:

              Database error in vBulletin Control Panel 2.2.1:

              Invalid SQL: INSERT IGNORE INTO word (wordid,title) VALUES (NULL,'20089'),(NULL,'20101'),(NULL,'20107'),(NULL,'20113'),(NULL,'20117'),(NULL,'20123'), (NULL,'20129'),(NULL,'20143'),(NULL,'20147'),(NULL,'20149'),(NULL,'20161'),(NULL,'20173'), (NULL,'20177'),(NULL,'20183'),(NULL,'20201'),(NULL,'20219'),(NULL,'20231'),(NULL,'20233'), (NULL,'20249'),(NULL,'20261'),(NULL,'20269'),(NULL,'20287'),(NULL,'20297'),(NULL,'20323'), (NULL,'20327'),(NULL,'20333'),(NULL,'20341'),(NULL,'20347'),(NULL,'20353'),(NULL,'20357'), (NULL,'20359'),(NULL,'20369'),(NULL,'20389'),(NULL,'20393'),(NULL,'20399'),(NULL,'20407'), (NULL,'20411'),(NULL,'20431'),(NULL,'20441'),(NULL,'20443'),(NULL,'20477'),(NULL,'20479'), (NULL,'20483'),(NULL,'20507'),(NULL,'20509'),(NULL,'20521'),(NULL,'20533'),(NULL,'20543'), (NULL,'20549'),(NULL,'20551'),(NULL,'20563'),(NULL,'20593'),(NULL,'20599'),(NULL,'20611'), (NULL,'20627'),(NULL,'20639'),(NULL,'20641'),(NULL,'20663')...(NULL,'1299689'),(NULL,'1299 709'),(NULL,'1299721'),(NULL,'1299743'),(NULL,'1299763'),(NULL,'1299791'),(NULL,'1299811') ,(NULL,'1299817'),(NULL,'1299821'),(NULL,'1299827')
              mysql error: MySQL server has gone away

              Comment

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