Announcement

Collapse
No announcement yet.

Error Number : 1033

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

  • [Forum] Error Number : 1033

    Please let me know what I have to do. Thanks in advance for any help.


    Database error in vBulletin 4.0.3:

    Invalid SQL:

    SELECT data.tagid, data.tagtext, SUM(data.searchcount) AS searchcount
    FROM
    (
    SELECT tagcontent.tagid, tag.tagtext, COUNT(*) AS searchcount
    FROM tagcontent AS tagcontent
    INNER JOIN tag AS tag ON (tagcontent.tagid = tag.tagid) INNER JOIN thread AS thread ON (tagcontent.contentid = thread.threadid)
    WHERE tagcontent.contenttypeid IN (2) AND
    tagcontent.dateline > 1268967102 AND thread.open <> 10 AND thread.visible = 1 AND thread.forumid IN (17,39,50,51,54,58,4,69,66,68,72,67,56,16,33,34,35,73,65,70,71,64,60,62,57,61,55,18,24,25, 32,45,46,47,42,52,49,53,43)
    GROUP BY tagcontent.tagid, tag.tagtext
    UNION ALL
    SELECT tagcontent.tagid, tag.tagtext, COUNT(*) AS searchcount
    FROM tagcontent AS tagcontent
    INNER JOIN tag AS tag ON (tagcontent.tagid = tag.tagid) JOIN cms_node AS cms_node ON
    tagcontent.contenttypeid = cms_node.contenttypeid AND tagcontent.contentid = cms_node.contentid

    WHERE tagcontent.contenttypeid IN (18) AND
    tagcontent.dateline > 1268967102 AND cms_node.publishdate < 1300503102
    GROUP BY tagcontent.tagid, tag.tagtext
    ) AS data
    GROUP BY data.tagid, data.tagtext
    ORDER BY searchcount DESC
    LIMIT 90;

    MySQL Error : Incorrect information in file: './desithai_forum/tagcontent.frm'
    Error Number : 1033
    Request Date : Friday, March 18th 2011 @ 09:51:42 PM
    Error Date : Friday, March 18th 2011 @ 09:51:42 PM
    Script : http://www.funandbliss.com/forum.php
    Referrer : [url]http://www.funandbliss.com/xxxxxxxxx
    IP Address : 60.254.96.87
    Username : admin
    Classname : vB_Database
    MySQL Version : 5.0.91-community

  • #2
    You need to repair your tagcontent table in vbulletin, phpmyadmin, or via your webhost.

    Comment


    • #3
      The Webhost is also unable to find and solve the problem, Like You to please help in the matter.

      Comment


      • #4
        If they can't find the problem on their own servers, then I'd worry.

        This isn't a vBulletin problem, it's a hosting problem and they'll need to fix this (unless it's fixed itself already)
        Vote for:

        - *Admin Settable Paid Subscription Reminder Timeframe*
        -
        *PM - Add ability to reply to originator only*
        - Add Admin ability to auto-subscribe users to specific channel(s)
        - "Quick Route" Interface...

        Comment


        • #5
          Sir, from where I may get the mysql-schema.php file

          Comment


          • #6
            It is in the 'install' directory.
            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
              ok right- file is there - after Fixing unique indexes - this message appeared ( problem is still there )

              >>


              Fix Unique Indexes

              Table access already has a unique index
              Table adminhelp already has a unique index
              Table attachmentpermission already has a unique index
              Table bbcode already has a unique index
              Table bbcode_video already has a unique index
              Table action already has a unique index
              Table contenttype already has a unique index
              Table forumpermission already has a unique index
              Table moderator already has a unique index
              Table package already has a unique index
              Table phrase already has a unique index
              Table pollvote already has a unique index
              Table reputation already has a unique index
              Table rsslog already has a unique index
              Database error
              The Fun and Bliss database has encountered a problem.
              Please try the following:
              Load the page again by clicking the Refresh button in your web browser.
              Open the www.funandbliss.com home page, then try to open another page.
              Click the Back button to try another link.
              The www.funandbliss.com forum technical staff have been notified of the error, though you may contact them if the problem persists.

              We apologise for any inconvenience.
              Database error in vBulletin 4.0.3:

              Invalid SQL:
              SHOW KEYS FROM searchcore;

              MySQL Error : Incorrect information in file: './desithai_forum/searchcore.frm'
              Error Number : 1033
              Request Date : Monday, April 18th 2011 @ 01:50:54 PM
              Error Date : Monday, April 18th 2011 @ 01:50:54 PM
              Script : http://www.funandbliss.com/admincp/r...p?do=fixunique
              Referrer : http://www.funandbliss.com/admincp/repair.php?do=list
              IP Address : 60.254.96.87
              Username : admin
              Classname : vB_Database
              MySQL Version : 5.0.92-community

              Comment


              • #8
                What did you do exactly?

                Have you tried repairing that table?
                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
                  Yes, sir. .....
                  (1) not getting Opening the forum page and the Front Page (Home Page)
                  (2) every page (which is opening ) shows page contents on the top left - whats that?
                  Last edited by Fun and Bliss; Mon 18 Apr '11, 7:50pm.

                  Comment


                  • #10
                    Can I get the Customer Support Manager's help to upgrade the site as well as to get it back to good running position?

                    Comment


                    • #11
                      still helpless

                      Comment


                      • #12
                        You've opened a support ticket?

                        Comment

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