Announcement

Collapse
No announcement yet.

Database Problems...

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

  • Database Problems...

    Code:
    Database jasperschrijver_nl_-_vbulletin wordt uitgevoerd op localhost 
      Structuur
        SQL
        Exporteer
        Zoeken
        Query opbouwen
        
    
    
    SQL-query
     
    SQL-query : [Wijzigen] [Creëer PHP Code]
    REPAIR TABLE `access` , `adminhelp` , `administrator` , `adminlog` , `adminutil` , `announcement` , `attachment` , `attachmenttype` , `attachmentviews` , `avatar` , `bbcode` , `calendar` , `calendarcustomfield` , `calendarmoderator` , `calendarpermission` , `cpsession` , `cron` , `cronlog` , `customavatar` , `customprofilepic` , `datastore` , `deletionlog` , `editlog` , `event` , `faq` , `forum` , `forumpermission` , `gamechallenges` , `gamenews` , `games` , `gamesessions` , `holiday` , `icon` , `imagecategory` , `imagecategorypermission` , `language` , `mailqueue` , `moderation` , `moderator` , `moderatorlog` , `passwordhistory` , `phrase` , `phrasetype` , `pm` , `pmreceipt` , `pmtext` , `poll` , `pollvote` , `post` , `post_parsed` , `posthash` , `postindex` , `profilefield` , `ranks` , `regimage` , `reminder` , `reputation` , `reputationlevel` , `search` , `session` , `setting` , `settinggroup` , `smilie` , `stats` , `strikes` , `style` , `subscribeevent` , `subscribeforum` , `subscribethread` , `subscription` , `subscriptionlog` , `template` , `thread` , `threadrate` , `threadviews` , `upgradelog` , `user` , `useractivation` , `userban` , `userfield` , `usergroup` , `usergroupleader` , `usergrouprequest` , `usernote` , `userpromotion` , `usertextfield` , `usertitle` , `vbfields` , `word`  
    
    
    
    
    Table  Op  Msg_type  Msg_text  
    jasperschrijver_nl_-_vbulletin.access repair status OK 
    jasperschrijver_nl_-_vbulletin.adminhelp repair status OK 
    jasperschrijver_nl_-_vbulletin.administrator repair status OK 
    jasperschrijver_nl_-_vbulletin.adminlog repair status OK 
    jasperschrijver_nl_-_vbulletin.adminutil repair status OK 
    jasperschrijver_nl_-_vbulletin.announcement repair status OK 
    jasperschrijver_nl_-_vbulletin.attachment repair status OK 
    jasperschrijver_nl_-_vbulletin.attachmenttype repair status OK 
    jasperschrijver_nl_-_vbulletin.attachmentviews repair error Can't find file: 'attachmentviews.MYD' (errno: 2) 
    jasperschrijver_nl_-_vbulletin.avatar repair status OK 
    jasperschrijver_nl_-_vbulletin.bbcode repair status OK 
    jasperschrijver_nl_-_vbulletin.calendar repair status OK 
    jasperschrijver_nl_-_vbulletin.calendarcustomfield repair status OK 
    jasperschrijver_nl_-_vbulletin.calendarmoderator repair status OK 
    jasperschrijver_nl_-_vbulletin.calendarpermission repair status OK 
    jasperschrijver_nl_-_vbulletin.cpsession repair error The handler for the table doesn't support check/re... 
    jasperschrijver_nl_-_vbulletin.cron repair status OK 
    jasperschrijver_nl_-_vbulletin.cronlog repair status OK 
    jasperschrijver_nl_-_vbulletin.customavatar repair status OK 
    jasperschrijver_nl_-_vbulletin.customprofilepic repair status OK 
    jasperschrijver_nl_-_vbulletin.datastore repair status OK 
    jasperschrijver_nl_-_vbulletin.deletionlog repair status OK 
    jasperschrijver_nl_-_vbulletin.editlog repair status OK 
    jasperschrijver_nl_-_vbulletin.event repair status OK 
    jasperschrijver_nl_-_vbulletin.faq repair status OK 
    jasperschrijver_nl_-_vbulletin.forum repair status OK 
    jasperschrijver_nl_-_vbulletin.forumpermission repair status OK 
    jasperschrijver_nl_-_vbulletin.gamechallenges repair status OK 
    jasperschrijver_nl_-_vbulletin.gamenews repair status OK 
    jasperschrijver_nl_-_vbulletin.games repair status OK 
    jasperschrijver_nl_-_vbulletin.gamesessions repair status OK 
    jasperschrijver_nl_-_vbulletin.holiday repair status OK 
    jasperschrijver_nl_-_vbulletin.icon repair status OK 
    jasperschrijver_nl_-_vbulletin.imagecategory repair status OK 
    jasperschrijver_nl_-_vbulletin.imagecategorypermis... repair status OK 
    jasperschrijver_nl_-_vbulletin.language repair status OK 
    jasperschrijver_nl_-_vbulletin.mailqueue repair status OK 
    jasperschrijver_nl_-_vbulletin.moderation repair status OK 
    jasperschrijver_nl_-_vbulletin.moderator repair status OK 
    jasperschrijver_nl_-_vbulletin.moderatorlog repair status OK 
    jasperschrijver_nl_-_vbulletin.passwordhistory repair status OK 
    jasperschrijver_nl_-_vbulletin.phrase repair status OK 
    jasperschrijver_nl_-_vbulletin.phrasetype repair status OK 
    jasperschrijver_nl_-_vbulletin.pm repair status OK 
    jasperschrijver_nl_-_vbulletin.pmreceipt repair status OK 
    jasperschrijver_nl_-_vbulletin.pmtext repair status OK 
    jasperschrijver_nl_-_vbulletin.poll repair status OK 
    jasperschrijver_nl_-_vbulletin.pollvote repair status OK 
    jasperschrijver_nl_-_vbulletin.post repair status OK 
    jasperschrijver_nl_-_vbulletin.post_parsed repair status OK 
    jasperschrijver_nl_-_vbulletin.posthash repair status OK 
    jasperschrijver_nl_-_vbulletin.postindex repair status OK 
    jasperschrijver_nl_-_vbulletin.profilefield repair status OK 
    jasperschrijver_nl_-_vbulletin.ranks repair status OK 
    jasperschrijver_nl_-_vbulletin.regimage repair status OK 
    jasperschrijver_nl_-_vbulletin.reminder repair status OK 
    jasperschrijver_nl_-_vbulletin.reputation repair status OK 
    jasperschrijver_nl_-_vbulletin.reputationlevel repair status OK 
    jasperschrijver_nl_-_vbulletin.search repair status OK 
    jasperschrijver_nl_-_vbulletin.session repair error The handler for the table doesn't support check/re... 
    jasperschrijver_nl_-_vbulletin.setting repair status OK 
    jasperschrijver_nl_-_vbulletin.settinggroup repair status OK 
    jasperschrijver_nl_-_vbulletin.smilie repair status OK 
    jasperschrijver_nl_-_vbulletin.stats repair status OK 
    jasperschrijver_nl_-_vbulletin.strikes repair status OK 
    jasperschrijver_nl_-_vbulletin.style repair status OK 
    jasperschrijver_nl_-_vbulletin.subscribeevent repair status OK 
    jasperschrijver_nl_-_vbulletin.subscribeforum repair status OK 
    jasperschrijver_nl_-_vbulletin.subscribethread repair status OK 
    jasperschrijver_nl_-_vbulletin.subscription repair status OK 
    jasperschrijver_nl_-_vbulletin.subscriptionlog repair status OK 
    jasperschrijver_nl_-_vbulletin.template repair status OK 
    jasperschrijver_nl_-_vbulletin.thread repair status OK 
    jasperschrijver_nl_-_vbulletin.threadrate repair status OK 
    jasperschrijver_nl_-_vbulletin.threadviews repair error Can't find file: 'threadviews.MYD' (errno: 2) 
    jasperschrijver_nl_-_vbulletin.upgradelog repair status OK 
    jasperschrijver_nl_-_vbulletin.user repair status OK 
    jasperschrijver_nl_-_vbulletin.useractivation repair status OK 
    jasperschrijver_nl_-_vbulletin.userban repair status OK 
    jasperschrijver_nl_-_vbulletin.userfield repair status OK 
    jasperschrijver_nl_-_vbulletin.usergroup repair status OK 
    jasperschrijver_nl_-_vbulletin.usergroupleader repair status OK 
    jasperschrijver_nl_-_vbulletin.usergrouprequest repair status OK 
    jasperschrijver_nl_-_vbulletin.usernote repair status OK 
    jasperschrijver_nl_-_vbulletin.userpromotion repair status OK 
    jasperschrijver_nl_-_vbulletin.usertextfield repair status OK 
    jasperschrijver_nl_-_vbulletin.usertitle repair status OK 
    jasperschrijver_nl_-_vbulletin.vbfields repair status OK 
    jasperschrijver_nl_-_vbulletin.word repair status OK 
    
    
    
    Printopmaak 
    
    Exporteer
    What can i do???

  • #2
    The session and cpsession tables will always return errors, that's normal. But the two views tables have problems.

    If running the repair again does not fix the problem then those tables cannot be repaired and you need to restore a backup of your database. The command to restore a backup is detailed on this page.

    Comment


    • #3
      Pff i have no recent backup...
      Have to import my phpBB agian i guess...

      Hope its over, i had never problems with phpBB2...

      Comment


      • #4
        You dont need to reimport a backup.

        You should be able to drop and recreate each of thoughs tables.


        Let me see if i can find the instructions

        For threadviews
        Code:
        DROP TABLE IF EXISTS threadviews;
        CREATE TABLE threadviews (
        threadid INT UNSIGNED NOT NULL DEFAULT '0',
        KEY threadid (threadid)
        );
        for attachmentviews

        Code:
        DROP TABLE IF EXISTS attachmentviews;
        CREATE TABLE attachmentviews (
        attachmentid INT UNSIGNED NOT NULL DEFAULT '0',
        KEY postid (attachmentid)
        );
        Last edited by Zachery; Sat 23 Oct '04, 5:19am.

        Comment


        • #5
          Just keep in mind that if you recreate those tables then you will lose their information. So basically your thread and attachment views will be reset.

          Comment


          • #6
            They are gone as it is O.o

            Comment


            • #7
              Originally posted by Jake Bunce
              So basically your thread and attachment views will be reset.
              Actually they are stored in thread.views and attachment.counter.

              The table threadviews is used for the hourly update of the thread view counter, if "Update Thread Views Immediately" is disabled.
              The table attachmentviews is used for the hourly update of the attachment view counter, if "Update Attachment Views Immediately" is disabled.

              After each of the two updates, these tables will be emptied anyway, so I don't think he has lost much

              Comment


              • #8
                Originally posted by Zachery
                You dont need to reimport a backup.

                You should be able to drop and recreate each of thoughs tables.


                Let me see if i can find the instructions

                For threadviews
                Code:
                DROP TABLE IF EXISTS threadviews;
                CREATE TABLE threadviews (
                threadid INT UNSIGNED NOT NULL DEFAULT '0',
                KEY threadid (threadid)
                );
                for attachmentviews

                Code:
                DROP TABLE IF EXISTS attachmentviews;
                CREATE TABLE attachmentviews (
                attachmentid INT UNSIGNED NOT NULL DEFAULT '0',
                KEY postid (attachmentid)
                );

                I know I'm late to the party, but how and where to you apply this code? I have an error in the exact same two tables. Is this done through the admin panel, through FTP, or via myphpadmin?

                Thanks!!

                ----

                Nevermind - I found out how to execute an SQL command on my own through the myphpadmin. thanks for the code!!!
                Last edited by erkme73; Fri 4 Mar '05, 3:20pm. Reason: I'm a dummy

                Comment


                • #9
                  Those are queries. You can run them in the SQL tab in phpMyAdmin.
                  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


                  • #10
                    Originally posted by Steve Machol
                    Those are queries. You can run them in the SQL tab in phpMyAdmin.
                    Thanks again Steve - that's two today that you answered nearly immediately. Thanks!!!

                    Comment


                    • #11
                      argh

                      THis is what I get when trying to fix my attachmentID problem. I get about 300 emails/day for months now.

                      Code:
                      An error occurred while attempting to execute your query. The following information was returned. 
                      error number: 1064 
                      error desc: You have an error in your SQL syntax near ';
                      CREATE TABLE attachmentviews (
                      attachmentid INT UNSIGNED NOT NULL DEFAULT '0' at line 1

                      Comment

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