LiveStreet CMS

Так в рабочем варианте?
UPDATE
wnr23034_topic
SET
blog_id = 16 // id нового блога
WHERE
wnr23034_topic.blog_id = '15' // id старого блога

Топиков много — 42126 штук вручную не получится это реализовать, нужен авто подход к делу.

Спасибо за ответ, но интересует момент как физически сразу все топики перенести из одного блога в другой? При удалении блога вроде спрашивается куда перенести но по факту они просто удаляются

Помогите кто-нибудь, здесь кто-нибудь остался?

Помогите пожалуйста!

Простите вы не решили эту проблему ????

Спасибо вам ort премногоблагодарен! Правда очень вам признателен!

То есть библиотеку сфинкс ЛС отключить у меня не удалось, поиск попросту ничего не выдает.

Да сразу проверил сам сфинкс работает:
search class

using config file '/etc/sphinx/sphinx.conf'…
index 'topicsIndex': query 'class ': returned 626 matches of 626 total in 0.000 sec

displaying matches:
1. document=57046, weight=2683, topic_date_add=Sat Jun 4 08:13:59 2011, topic_publish=1, tag=(328742,328743,328744,328746,328747,328748,328749)
2. document=51337, weight=2679, topic_date_add=Fri Aug 26 09:55:41 2011, topic_publish=1, tag=()
3. document=56486, weight=2673, topic_date_add=Sat Jun 11 06:11:50 2011, topic_publish=1, tag=(324035,324036,324038,324040,324041,324042,324043)
4. document=12942, weight=2665, topic_date_add=Mon Nov 19 11:52:54 2012, topic_publish=1, tag=(74091,74092,74093)
5. document=22979, weight=2665, topic_date_add=Sun Aug 5 09:05:40 2012, topic_publish=1, tag=(132181,132182,132183,132184)
6. document=31333, weight=2665, topic_date_add=Tue Apr 10 10:36:14 2012, topic_publish=1, tag=(176091,176092,176093)
7. document=25553, weight=2634, topic_date_add=Fri Jun 29 08:04:51 2012, topic_publish=1, tag=(146284,146285,146286,146288,146289,146290,146291,146292)
8. document=39192, weight=1710, topic_date_add=Fri Feb 10 10:08:46 2012, topic_publish=1, tag=(216438,216439,216443,216444,216445,216446)
9. document=16699, weight=1706, topic_date_add=Sat Oct 20 11:41:39 2012, topic_publish=1, tag=(95423,95424,95426,95428,95429)
10. document=28065, weight=1704, topic_date_add=Tue May 8 02:17:10 2012, topic_publish=1, tag=(159553)
11. document=19755, weight=1695, topic_date_add=Fri Sep 21 04:36:01 2012, topic_publish=1, tag=(113443,113445)
12. document=36375, weight=1695, topic_date_add=Wed Mar 7 19:28:30 2012, topic_publish=1, tag=(201308)
13. document=5739, weight=1691, topic_date_add=Sun Jan 6 06:25:59 2013, topic_publish=1, tag=(33454,33456,33457)
14. document=66810, weight=1691, topic_date_add=Thu Dec 30 03:07:42 2010, topic_publish=1, tag=(418434,418436,418437,418438,418439,418444)
15. document=69275, weight=1689, topic_date_add=Sun Jun 6 07:44:12 2010, topic_publish=1, tag=(437562,437563,437564,437566)
16. document=7220, weight=1686, topic_date_add=Wed Dec 26 03:32:23 2012, topic_publish=1, tag=(41632,41634,41635,41636,41637,41638,41639,41640)
17. document=49694, weight=1686, topic_date_add=Fri Oct 14 10:40:21 2011, topic_publish=1, tag=(268868)
18. document=82255, weight=1686, topic_date_add=Sun May 11 11:31:55 2014, topic_publish=1, tag=(526826,526827,526828,526829,526830)
19. document=4616, weight=1683, topic_date_add=Mon Jan 14 17:29:43 2013, topic_publish=1, tag=(26909,26911)
20. document=20347, weight=1683, topic_date_add=Thu Sep 13 05:52:15 2012, topic_publish=1, tag=(117014,117015,117017)

words:
1. 'class': 626 documents, 1114 hits

index 'commentsIndex': query 'class ': returned 42 matches of 42 total in 0.000 sec

displaying matches:
1. document=24691, weight=1727, comment_date=Sun May 19 19:50:15 2013, comment_delete=0
2. document=24034, weight=1699, comment_date=Sun May 5 21:14:35 2013, comment_delete=0
3. document=24249, weight=1699, comment_date=Thu May 9 00:38:14 2013, comment_delete=0
4. document=25675, weight=1699, comment_date=Wed Jun 5 03:47:49 2013, comment_delete=0
5. document=26092, weight=1699, comment_date=Mon Jun 10 18:29:21 2013, comment_delete=0
6. document=27543, weight=1699, comment_date=Fri Jul 5 19:56:57 2013, comment_delete=0
7. document=27944, weight=1699, comment_date=Sun Jul 14 19:44:34 2013, comment_delete=0
8. document=29811, weight=1699, comment_date=Sun Oct 6 13:18:34 2013, comment_delete=0
9. document=31021, weight=1699, comment_date=Sun Nov 24 10:08:35 2013, comment_delete=0
10. document=34234, weight=1699, comment_date=Wed Apr 30 04:15:48 2014, comment_delete=0
11. document=34275, weight=1699, comment_date=Thu May 1 05:31:59 2014, comment_delete=0
12. document=35402, weight=1699, comment_date=Fri May 16 21:22:10 2014, comment_delete=0
13. document=36648, weight=1699, comment_date=Wed Jun 4 19:02:06 2014, comment_delete=0
14. document=37131, weight=1699, comment_date=Wed Jun 11 22:47:15 2014, comment_delete=0
15. document=37913, weight=1699, comment_date=Sat Jun 21 22:29:05 2014, comment_delete=0
16. document=23419, weight=1644, comment_date=Sun Apr 21 22:42:42 2013, comment_delete=0
17. document=23422, weight=1644, comment_date=Sun Apr 21 23:12:17 2013, comment_delete=0
18. document=24441, weight=1644, comment_date=Mon May 13 03:31:18 2013, comment_delete=0
19. document=24854, weight=1644, comment_date=Tue May 21 23:21:05 2013, comment_delete=0
20. document=25900, weight=1644, comment_date=Sat Jun 8 16:55:42 2013, comment_delete=0

words:
1. 'class': 42 documents, 58 hits

Попробовал удалить строку

require_once(Config::Get('path.root.engine').'/lib/external/Sphinx/sphinxapi.php');

из файла sphinx.class.php поиск не дал результатов пишет

Большое спасибо за ответ ort , думаю что надо отключить именно на сервере, подскажите где найти include_path, в php.ini такого не прописано.

Проблема так и не была решена вами?

2. Скачиваем с ЯбаДабы и заменяем файл Topic.entity.class.php

МОжно файлик обновить? ОЧень надо. Заранее спасибо.

У меня почему то нотайсов даже нет, работает.
Так ну последний вариант что я смог сделать:

if ($http_user_agent ~* JikeSpider|proximic|Sosospider|Sogou web spider|aesop_com_spiderman|alexibot|backweb|batchftp|bigfoot|black.hole|blackwidow|blowfish|botalot|buddy|builtbottough|bullseye|cheesebot|cherrypicker|chinaclaw|collector|copier|copyrightcheck|cosmos|crescent|curl|custo|da|diibot|disco|dittospyder|dragonfly|drip|easydl|ebingbong|ecatch|eirgrabber|emailcollector|emailsiphon|emailwolf|erocrawler|exabot|eyenetie|filehound|flashget|flunky|frontpage|getright|getweb|go zilla|go-ahead-got-it|gotit|grabnet|grafula|harvest|hloader|hmview|httplib|httrack|humanlinks|ilsebot|infonavirobot|infotekies|intelliseek|interget|iria|jennybot|jetcar|joc|justview|jyxobot|kenjin|keyword|larbin|leechftp|lexibot|lftp|libweb|likse|linkscan|linkwalker|lnspiderguy|lwp|magnet|mag-net|markwatch|mata.hari|memo|microsoft.url|midown.tool|miixpc|mirror|missigua|mister.pix|moget|mozilla.newt|nameprotect|navroad|backdoorbot|nearsite|net vampire|netants|netcraft|netmechanic|netspider|nextgensearchbot|attach|nicerspro|nimblecrawler|npbot|octopus|offline explorer|offline.navigator|openfind|outfoxbot|pagegrabber|papa|pavuk|pcbrowser|php version tracker|pockey|propowerbot|prowebwalker|psbot|pump|queryn|recorder|realdownload|reaper|reget|true_robot|repomonkey|rma|internetseer|sitesnagger|siphon|slysearch|smartdownload|snake|snapbot|snoopy|sogou|spacebison|spankbot|spanner|sqworm|superbot|superhttp|surfbot|asterias|suzuran|szukacz|takeout|teleport|telesoft|the.intraformant|thenomad|tighttwatbot|titan|urldispatcher|turingos|turnitinbot|urly.warning|vacuum|vci|voideye|whacker|libwww-perl|widow|wisenutbot|wwwoffle|xaldon|xenu|zeus|zyborg|anonymouse|zip|emaile|enhancer|fetch|go is|auto|bandit|clip|copier|master|sauger|site.quester|whack|craftbot|download|extract|stripper|sucker|ninja|clshttp|webspider|leacher|grabber|webpictures|Jakarta|User-Agent|libwww|lwp-trivial|PHPCrawl|WEP Search|Missigua Locator|ISC Systems iRc|Aboundex|360Spider|Java|Cogentbot|BunnySlippers|Cegbfeieh|AIBOT|Demon|Devil|Wonder|Foobot|Kenjin Spider|Density|LinkextractorPro|LWP::Simple|MassDownloader|Mass Downloader|NetZIP|NG|Metasearch|WebFetch|WebCopier|Webclipping|WebBandit|WebAuto|WebGo|Web.Image.Collector|WebLeacher|WebmasterWorldForumBot|WebReaper|WebSauger|eXtractor|Webster|WebStripper|WebWhacker|WebZIP) {
return 403;
}

Вот вариант:

if ($http_user_agent ~* JikeSpider|proximic|Sosospider|Sogou web spider|aesop_com_spiderman|alexibot|backweb|batchftp|bigfoot|black.hole|blackwidow|blowfish|botalot|buddy|builtbottough|bullseye|cheesebot|cherrypicker|chinaclaw|collector|copier|copyrightcheck|cosmos|crescent|curl|custo|da|diibot|disco|dittospyder|dragonfly|drip|easydl|ebingbong|ecatch|eirgrabber|emailcollector|emailsiphon|emailwolf|erocrawler|exabot|eyenetie|filehound|flashget|flunky|frontpage|getright|getweb|go.?zilla|go-ahead-got-it|gotit|grabnet|grafula|harvest|hloader|hmview|httplib|httrack|humanlinks|ilsebot|infonavirobot|infotekies|intelliseek|interget|iria|jennybot|jetcar|joc|justview|jyxobot|kenjin|keyword|larbin|leechftp|lexibot|lftp|libweb|likse|linkscan|linkwalker|lnspiderguy|lwp|magnet|mag-net|markwatch|mata.hari|memo|microsoft.url|midown.tool|miixpc|mirror|missigua|mister.pix|moget|mozilla.newt|nameprotect|navroad|backdoorbot|nearsite|net.?vampire|netants|netcraft|netmechanic|netspider|nextgensearchbot|attach|nicerspro|nimblecrawler|npbot|octopus|offline.?explorer|offline.navigator|openfind|outfoxbot|pagegrabber|papa|pavuk|pcbrowser|php.?version.?tracker|pockey|propowerbot|prowebwalker|psbot|pump|queryn|recorder|realdownload|reaper|reget|true_robot|repomonkey|rma|internetseer|sitesnagger|siphon|slysearch|smartdownload|snake|snapbot|snoopy|sogou|spacebison|spankbot|spanner|sqworm|superbot|superhttp|surfbot|asterias|suzuran|szukacz|takeout|teleport|telesoft|the.intraformant|thenomad|tighttwatbot|titan|urldispatcher|turingos|turnitinbot|urly.warning|vacuum|vci|voideye|whacker|libwww-perl|widow|wisenutbot|wwwoffle|xaldon|xenu|zeus|zyborg|anonymouse|zip|emaile|enhancer|fetch|go.?is|auto|bandit|clip|copier|master|sauger|site.quester|whack|craftbot|download|extract|stripper|sucker|ninja|clshttp|webspider|leacher|grabber|webpictures|Jakarta|User-Agent|libwww|lwp-trivial|PHPCrawl|WEP Search|Missigua Locator|ISC Systems iRc|Aboundex|360Spider|Java|Cogentbot|BunnySlippers|Cegbfeieh|AIBOT|Demon|Devil|Wonder|Foobot|Kenjin Spider|Density|LinkextractorPro|LWP::Simple|MassDownloader|Mass Downloader|NetZIP|NG|Metasearch|WebFetch|WebCopier|Webclipping|WebBandit|WebAuto|WebGo|Web.Image.Collector|WebLeacher|WebmasterWorldForumBot|WebReaper|WebSauger|eXtractor|Webster|WebStripper|WebWhacker|WebZIP) {
return 403;
}

И вот такой вариант:

if ($http_user_agent ~* LWP::Simple|BBBike|wget) {
return 403;
}

Попробуйте отпишите

будет ошибку выдавать?

Поставьте для теста вот так:

if ($http_user_agent ~ msnbot) {
return 403;
}

нет я просто думаю что возможно из за знаков вопроса, я их удалил, попробуйте.

попробуйте так

if ($http_referer ~* (JikeSpider|proximic|Sosospider|Sogou web spider|aesop_com_spiderman|alexibot|backweb|batchftp|bigfoot|black.hole|blackwidow|blowfish|botalot|buddy|builtbottough|bullseye|cheesebot|cherrypicker|chinaclaw|collector|copier|copyrightcheck|cosmos|crescent|curl|custo|da|diibot|disco|dittospyder|dragonfly|drip|easydl|ebingbong|ecatch|eirgrabber|emailcollector|emailsiphon|emailwolf|erocrawler|exabot|eyenetie|filehound|flashget|flunky|frontpage|getright|getweb|go.zilla|go-ahead-got-it|gotit|grabnet|grafula|harvest|hloader|hmview|httplib|httrack|humanlinks|ilsebot|infonavirobot|infotekies|intelliseek|interget|iria|jennybot|jetcar|joc|justview|jyxobot|kenjin|keyword|larbin|leechftp|lexibot|lftp|libweb|likse|linkscan|linkwalker|lnspiderguy|lwp|magnet|mag-net|markwatch|mata.hari|memo|microsoft.url|midown.tool|miixpc|mirror|missigua|mister.pix|moget|mozilla.newt|nameprotect|navroad|backdoorbot|nearsite|net.vampire|netants|netcraft|netmechanic|netspider|nextgensearchbot|attach|nicerspro|nimblecrawler|npbot|octopus|offline.explorer|offline.navigator|openfind|outfoxbot|pagegrabber|papa|pavuk|pcbrowser|php.version.tracker|pockey|propowerbot|prowebwalker|psbot|pump|queryn|recorder|realdownload|reaper|reget|true_robot|repomonkey|rma|internetseer|sitesnagger|siphon|slysearch|smartdownload|snake|snapbot|snoopy|sogou|spacebison|spankbot|spanner|sqworm|superbot|superhttp|surfbot|asterias|suzuran|szukacz|takeout|teleport|telesoft|the.intraformant|thenomad|tighttwatbot|titan|urldispatcher|turingos|turnitinbot|urly.warning|vacuum|vci|voideye|whacker|libwww-perl|widow|wisenutbot|wwwoffle|xaldon|xenu|zeus|zyborg|anonymouse|zip|emaile|enhancer|fetch|go.is|auto|bandit|clip|copier|master|sauger|site.quester|whack|craftbot|download|extract|stripper|sucker|ninja|clshttp|webspider|leacher|grabber|webpictures|Jakarta|User-Agent|libwww|lwp-trivial|PHPCrawl|WEP Search|Missigua Locator|ISC Systems iRc|Aboundex|360Spider|Java|Cogentbot|BunnySlippers|Cegbfeieh|AIBOT|Demon|Devil|Wonder|Foobot|Kenjin Spider|Density|LinkextractorPro|LWP::Simple|MassDownloader|Mass Downloader|NetZIP|NG|Metasearch|WebFetch|WebCopier|Webclipping|WebBandit|WebAuto|WebGo|Web.Image.Collector|WebLeacher|WebmasterWorldForumBot|WebReaper|WebSauger|eXtractor|Webster|WebStripper|WebWhacker|WebZIP)) {
return 400;
}