Can't post new Threads

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Aaron217
    New Member
    • May 2008
    • 21
    • 4.1.x

    [Forum] Can't post new Threads

    Code:
    Database error in vBulletin 4.0.7:
    
    Invalid SQL:
    
    		  SELECT t.tagtext, p.tagtext as canonicaltagtext
    			FROM tag t JOIN
    				tag p ON t.canonicaltagid = p.tagid
    			WHERE t.tagtext IN ('');
    
    MySQL Error   : Unknown column 't.tagtext' in 'field list'
    Error Number  : 1054
    Request Date  : Monday, October 18th 2010 @ 02:39:36 AM
    Error Date    : Monday, October 18th 2010 @ 02:39:36 AM
    Script        : 
    Referrer      : 
    IP Address    : ##########(Hidden)
    Username      : Mike
    Classname     : ##########(Hidden)
    MySQL Version : 5.0.91
    It isn't letting my make any new threads. Can someone tell me what is the about database error about?
    Last edited by Aaron217; Mon 18 Oct '10, 2:54am.
  • Aaron217
    New Member
    • May 2008
    • 21
    • 4.1.x

    #2
    I have found a fix for this,

    Thanks anyway.

    Comment

    • deluxmall
      Member
      • Jul 2009
      • 82

      #3
      What is the fix for this?

      I also have this problem

      Comment

      • Trevor Hannant
        vBulletin Support
        • Aug 2002
        • 24188
        • 5.7.X

        #4
        Can you paste the full error in here please.
        Vote for:

        - Admin Settable Paid Subscription Reminder Timeframe (vB6)
        - Add Admin ability to auto-subscribe users to specific channel(s) (vB6)

        Comment

        • deluxmall
          Member
          • Jul 2009
          • 82

          #5
          I solved the problem by by dropping and recreating the following tables that are corrupted

          contenttype
          searchcore
          searchgroup
          searchlog
          tag
          tagcontent

          It is working but now when I try to Rebuild Search Index under maintance ... i get the following ... sigh!


          Warning: array_shift() [function.array-shift]: The argument should be an array in [path]/admincp/misc.php on line 143

          Fatal error: Call to a member function get_max_id() on a non-object in /home/xxxxxxx/public_html/admincp/misc.php on line 161

          Comment

          • Trevor Hannant
            vBulletin Support
            • Aug 2002
            • 24188
            • 5.7.X

            #6
            Can you try re-downloading the ZIP file from the Members Area and re-upload all files (except install/install.php and includes/config.php.new) making sure you overwrite all files currently on your server.

            Does this resolve the problem?
            Vote for:

            - Admin Settable Paid Subscription Reminder Timeframe (vB6)
            - Add Admin ability to auto-subscribe users to specific channel(s) (vB6)

            Comment

            • deluxmall
              Member
              • Jul 2009
              • 82

              #7
              No it does not happen at all.

              Anyone pls help

              Comment

              • TI Master
                New Member
                • Mar 2001
                • 6

                #8
                Here is how I fixed this for my boards (currently on 4.0.8 pl2)

                I ran the following SQL query to populate my contenttype table. Then I was able to rebuild my search indexes. Note that this assumes you rebuilt these 6 InnoDB tables with their proper schemas first.

                contenttype
                searchcore
                searchgroup
                searchlog
                tag
                tagcontent

                Code:
                 
                        INSERT INTO ***YOURDATABASENAME***.contenttype
                                (contenttypeid, class, packageid, canplace, cansearch, cantag, canattach)
                        VALUES
                                (1, 'Post', 1, '0', '1', '0', '1'),
                                (2, 'Thread', 1, '0', '0', '1', '0'),
                                (3, 'Forum', 1, '0', '1', '0', '0'),
                                (4, 'Announcement', 1, '0', '0', '0', '0'),
                                (5, 'SocialGroupMessage', 1, '0', '1', '0', '0'),
                                (6, 'SocialGroupDiscussion', 1, '0', '0', '0', '0'),
                                (7, 'SocialGroup', 1, '0', '1', '0', '1'),
                                (8, 'Album', 1, '0', '0', '0', '1'),
                                (9, 'Picture', 1, '0', '0', '0', '0'),
                                (10, 'PictureComment', 1, '0', '0', '0', '0'),
                                (11, 'VisitorMessage', 1, '0', '1', '0', '0'),
                                (12, 'User', 1, '0', '0', '0', '0'),
                                (13, 'Event', 1, '0', '0', '0', '0'),
                                (14, 'Calendar', 1, '0', '0', '0', '0');
                Last edited by TI Master; Sat 8 Jan '11, 11:41pm.

                Comment

                • dhemitz
                  New Member
                  • Oct 2007
                  • 3

                  #9
                  i have the same problem ...

                  Comment

                  • Trevor Hannant
                    vBulletin Support
                    • Aug 2002
                    • 24188
                    • 5.7.X

                    #10
                    Please start your own thread with all the relevant details
                    Vote for:

                    - Admin Settable Paid Subscription Reminder Timeframe (vB6)
                    - Add Admin ability to auto-subscribe users to specific channel(s) (vB6)

                    Comment

                    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                    Working...
                    😀
                    😂
                    🥰
                    😘
                    🤢
                    😎
                    😞
                    😡
                    👍
                    👎