Announcement

Collapse
No announcement yet.

Thread View not updating

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

  • Thread View not updating

    Our Thread views are not updating and we keep getting these errors (see below). Should I upload the threadviews.MYD file?

    *******
    Database error in vBulletin 3.0.3:

    Invalid SQL: SELECT threadid , COUNT(*) AS views FROM threadviews GROUP BY threadid mysql error: Can't find file: 'threadviews.MYD' (errno: 2)

    mysql error number: 1017

    Date: Friday 10th of September 2004 01:12:38 PM

    Script:
    http://digitalimagingassociation.org/members/forum/cron.php?&rand=202337

    Referer: http://www.digitalimagingassociation.org/members/forum/index.php

    Username: Unregistered

    IP Address: 198.81.26.81


  • #2
    Error code 2: No such file or directory

    Run this query to recreate this table (assuming you have no table prefix):

    CREATE TABLE threadviews (
    threadid INT UNSIGNED NOT NULL DEFAULT '0',
    KEY threadid (threadid)
    );
    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


    • #3
      Thanks for the quick reply. I ran the query and this is what I got:


      Error

      SQL-query :



      CREATE TABLE threadviews( threadid INT UNSIGNED NOT NULL DEFAULT '0',
      KEY threadid( threadid )
      )


      MySQL said:


      #1050 - Table 'threadviews' already exists

      Comment


      • #4
        run
        Code:
        DROP TABLE threadviews;
        Then run steves query again.

        Comment


        • #5
          Thanks again.

          Both queries worked, but I'm not seeing Thread Views being updated. I read in another thread that they are only updated every hour and that setting is in the admin cp, but I can't seem to find it.

          This is only the second forum I've set up for a client, so forgive my ignorance on some of the troubleshooting methods.

          The client is receiving the error messages by e-mail since I have him set up to be the administrator. Is there a way I can modify the e-mail address and have those e-mails sent to me in the time-being? I'm using his log-in information to go in and make changes through the control panel.

          John

          Comment


          • #6
            It is the technacal email listed in the config.php which error emails are sent to.

            Comment


            • #7
              Zachery,

              Thanks! Got it changed.

              Thread views are still not updating however. I'll keep my eye out for any database error e-mails.

              Comment


              • #8
                Admin CP -> vBulletin Options -> Server Settings and Optimization Options -> Update Thread Views Immediately
                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


                • #9
                  Thank you gentlemen. That seems to have done the trick.


                  John

                  Comment


                  • #10
                    Follow-up issue:

                    The client is getting this error message every time they log out. When I use their log-in info and do the log-out, I do not get the error message. Must be something on their end. Any ideas?



                    vBulletin Message
                    An error occurred while attempting to log you out. Click here to log out.


                    vBulletin Message

                    Comment


                    • #11
                      Revert your navbar template.

                      Comment


                      • #12
                        Sorry, but do you mean revert the header to remove the Digital Imaging Association logo?

                        Comment

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