[Forum] Can't post new Threads

[Aaron217]

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?

[Aaron217]

I have found a fix for this,

Thanks anyway.

[deluxmall]

What is the fix for this?

I also have this problem

[Trevor Hannant]

Can you paste the full error in here please.

[deluxmall]

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

[Trevor Hannant]

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?

[deluxmall]

No it does not happen at all.

Anyone pls help

[TI Master]

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

 
        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');

[dhemitz]

i have the same problem ...

[Trevor Hannant]

Please start your own thread with all the relevant details