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
Announcement
Collapse
No announcement yet.
Can't post new Threads
Collapse
X
-
Code:Last edited by Aaron217; Mon 18th Oct '10, 2:54am.Tags: None
-
Can you paste the full error in here please.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)
- Highlight the correct navigation tab when you are on a custom page
- "Quick Route" Interface...
- Allow to use custom icons for individual forums
Comment
-
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
-
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*
- *PM - Add ability to reply to originator only*
- Add Admin ability to auto-subscribe users to specific channel(s)
- Highlight the correct navigation tab when you are on a custom page
- "Quick Route" Interface...
- Allow to use custom icons for individual forums
Comment
-
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 8th Jan '11, 11:41pm.
Comment
-
Please start your own thread with all the relevant detailsVote 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)
- Highlight the correct navigation tab when you are on a custom page
- "Quick Route" Interface...
- Allow to use custom icons for individual forums
Comment
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Comment