vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   Error database like this - a really difficult math (https://vborg.vbsupport.ru/showthread.php?t=276858)

vmhvn 01-12-2012 05:11 PM
Error database like this - a really difficult math
 
hi

I just import a new style, forum will be ok, run normal and all right

But, i enter in ADMINCP and: i run RSS Feed

OMG, in ADMINCP announce:

Quote:
Database error in vBulletin 4.1.8:

Invalid SQL:

SELECT searchgroup.groupid, MATCH(searchgroup_text.title) AGAINST ('HCM - B?n bộ jindo full 85c c?n đẹp 550k') AS score
FROM searchgroup AS searchgroup JOIN searchgroup_text AS searchgroup_text ON
(searchgroup.searchgroupid = searchgroup_text.searchgroupid)

WHERE MATCH(searchgroup_text.title) AGAINST ('HCM - B?n bộ jindo full 85c c?n đẹp 550k') AND
searchgroup.contenttypeid = 2


HAVING score > 4
LIMIT 5;

MySQL Error : Can't find FULLTEXT index matching the column list
Error Number : 1191
Request Date : Friday, January 13th 2012 @ 12:54:14 AM
Error Date : Friday, January 13th 2012 @ 12:54:14 AM
Script : cronadmin.php?do=runcron&varname=rssposter
Referrer : /rssposter.php
IP Address : 123.21.182.72
Username : abc123
Classname : vB_Database
MySQL Version : 5.1.56
I don't know, why ?

Please, help me

Lynne 01-12-2012 05:16 PM
<a href="https://www.vbulletin.com/forum/showthread.php/353011-Search-issue-since-upgrade-to-v4" target="_blank">https://www.vbulletin.com/forum/show...-upgrade-to-v4</a>

vmhvn 01-12-2012 05:26 PM
Quote:
Originally Posted by Lynne (Post 2286966)
Thanks you so much, but i am a newbie

Lynne, can you show me detail ?

please!

Lynne 01-12-2012 05:30 PM
Maintenance > Update Counters, under Rebuild Search Index is a link to "Click Here to empty the search index.". You need to click that first and then go back and Rebuild Search Indexes.

Do you have a lot of posts on your site? If so, you may want to turn off your forum for a bit before doing this since it is a server intensive process.

vmhvn 01-12-2012 05:36 PM
Thanks you Lynne

But, then i repair like you

I run RSS FEED again

it don't activities

This is announce: Internal Server Error

Please, help me again Lynne

Lynne 01-12-2012 05:52 PM
That was quick.... how many posts do you have on your site? Did you do both the Empty Index and then the Rebuild Index with no errors or timeouts for either step?

Internal Server Errors are server errors. You will need to look at your error_logs and possibly contact your host regarding it.


All times are GMT. The time now is 04:37 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01236 seconds
  • Memory Usage 1,720KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (6)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete