Rebuild Search Index error

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Scam Warning
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
jorgefms
Registered User
Posts: 43
Joined: Sun Aug 24, 2008 2:16 pm

Rebuild Search Index error

Post by jorgefms » Sat Mar 07, 2009 12:23 pm

What version of phpBB are you using? phpBB 3.0.4
What is your board's URL? http://www.scarymule.com/forum
How did you install your board?
Is your board a fresh install or a conversion? Fresh Install with Database update
Do you have any MODs installed? Yes. Prime Quick Replay, ABBC3, ed2kMod, board3 Portal
What styles do you currently have installed? Aeroblue, Black Pearl
What language(s) is your board currently using? English and Porutguese
Which database type/version are you using? I Don't Know


When I try to rebuild the index search I got this error:

Code: Select all

Erro Geral
SQL ERROR [ mysql4 ]

Got a packet bigger than 'max_allowed_packet' bytes [1153]

SQL

SELECT search_key FROM phpbb_search_results WHERE search_keywords LIKE '%*%' OR search_keywords LIKE '%usar%' OR search_keywords LIKE '%sempre%' OR search_keywords LIKE '%função%' OR search_keywords LIKE '%pesquisar%' OR search_keywords LIKE '%antes%' OR search_keywords LIKE '%criar%' OR search_keywords LIKE '%novo%' OR search_keywords LIKE '%tópico%' OR search_keywords LIKE '%tópicos%' OR search_keywords LIKE '%repetidos%' OR search_keywords LIKE '%serão%' OR search_keywords LIKE '%imediatamanente%' OR search_keywords LIKE '%bloqueados%' OR search_keywords LIKE '%enviados%' OR search_keywords LIKE '%para%' OR search_keywords LIKE '%reciclagem%' OR search_keywords LIKE '%todos%' OR search_keywords LIKE '%alvo%' OR search_keywords LIKE '%moderação%' OR search_keywords LIKE '%que%' OR search_keywords LIKE '%não%' OR search_keywords LIKE '%respeitem%' OR search_keywords LIKE '%regras%' OR search_keywords LIKE '%encontrem%' OR search_keywords LIKE '%devida%' OR search_keywords LIKE '%secção%' OR search_keywords LIKE '%movidos%' OR search_keywords LIKE '%editados%' OR search_keywords LIKE '%aos%' OR search_keywords LIKE '%membros%' OR search_keywords LIKE '%comuns%' OR search_keywords LIKE '%permitido%' OR search_keywords LIKE '%abrir%' OR search_keywords LIKE '%zona%' OR search_keywords LIKE '%das%' OR search_keywords LIKE '%releases%' OR search_keywords LIKE '%podendo%' OR search_keywords LIKE '%apenas%' OR search_keywords LIKE '%responder%' OR search_keywords LIKE '%criados%' OR search_keywords LIKE '%respostas%' OR search_keywords LIKE '%considerados%' OR search_keywords LIKE '%lixo%' OR search_keywords LIKE '%spam%' OR search_keywords LIKE '%offtopics%' OR search_keywords LIKE '%imediatamente%' OR search_keywords LIKE '%apagados%' OR search_keywords LIKE '%proibido%' OR search_keywords LIKE '%qualquer%' OR search_keywords LIKE '%tipo%' OR search_keywords LIKE '%publicidade%' OR search_keywords LIKE '%através%' OR search_keywords LIKE '%imagens%' OR search_keywords LIKE '%links%' OR search_keywords LIKE '%mensagens%' OR search_keywords LIKE '%privadas%' OR search_keywords LIKE '%permitidas%' OR search_keywords LIKE '%referências%' OR search_keywords LIKE '%nas%' OR search_keywords LIKE '%assinaturas%' OR search_keywords LIKE '%desde%' OR search_keywords LIKE '%sejam%' OR search_keywords LIKE '%relativas%' OR search_keywords LIKE '%organizações%' OR search_keywords LIKE '%com%' OR search_keywords LIKE '%fins%' OR search_keywords LIKE '%lucrativos%' OR search_keywords LIKE '%comerciais%' OR search_keywords LIKE '%são%' OR search_keywords LIKE '%discussões%' OR search_keywords LIKE '%sobre%' OR search_keywords LIKE '%desbloqueio%' OR search_keywords LIKE '%tvcabo%' OR search_keywords LIKE '%satélite%' OR search_keywords LIKE '%telemóvies%' OR search_keywords LIKE '%consolas%' OR search_keywords LIKE '%jogos%' OR search_keywords LIKE '%imdediatamente%' OR search_keywords LIKE '%colocar%' OR search_keywords LIKE '%sites%' OR search_keywords LIKE '%warez%' OR search_keywords LIKE '%serials%' OR search_keywords LIKE '%cracks%' OR search_keywords LIKE '%quiserem%' OR search_keywords LIKE '%coloquem%' OR search_keywords LIKE '%link%' OR search_keywords LIKE '%ed2k%' OR search_keywords LIKE '%proibida%' OR search_keywords LIKE '%propaganda%' OR search_keywords LIKE '%politica%' OR search_keywords LIKE '%religiosa%' OR search_keywords LIKE '%comercial%' OR search_keywords LIKE '%bem%' OR search_keywords LIKE '%como%' OR search_keywords LIKE '%trocas%' OR search_keywords LIKE '%vendas%' OR search_keywords LIKE '%material%' OR search_keywords LIKE '%seja%' OR search_keywords LIKE '%ele%' OR search_keywords LIKE '%qual%' OR search_keywords LIKE '%for%' OR search_keywords LIKE '%respeitar%' OR search_keywords LIKE '%ser%' OR search_keywords LIKE '%respeitado%' OR search_keywords LIKE '%intolerável%' OR search_keywords LIKE '%ofensa%' OR search_keywords LIKE '%verbal%' OR search_keywords LIKE '%entre%' OR search_keywords LIKE '%proibidas%' OR search_keywords LIKE '%relacionados%' OR search_keywords LIKE.. e continua


BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: includes/search/search.php
LINE: 283
CALL: dbal_mysql->sql_query()

FILE: includes/search/fulltext_native.php
LINE: 1332
CALL: search_backend->destroy_cache()

FILE: includes/acp/acp_search.php
LINE: 414
CALL: fulltext_native->tidy()

FILE: includes/acp/acp_search.php
LINE: 46
CALL: acp_search->index()

FILE: includes/functions_module.php
LINE: 507
CALL: acp_search->main()

FILE: adm/index.php
LINE: 76
CALL: p_master->load_active()

Can you help me?



(I make the rebuild because this change - http://www.phpbbrasil.com.br/phpBB/view ... 48&t=19730
My forum - http://www.scarymule.com)

User avatar
Rahber
Former Team Member
Posts: 2720
Joined: Tue Feb 12, 2008 3:39 pm
Location: Pakistan
Name: Rahber
Contact:

Re: Rebuild Search Index error

Post by Rahber » Sat Mar 07, 2009 1:37 pm

if you can edit my.cnf edit it
set-variable=max_allowed_packet=xM
Change it to the size ('x') you want in Megabytes. Restart MySQL after making these changes.
16M is a good one.
If you cant edit it contact your hosting to increase the max_allowed_packet value.

jorgefms
Registered User
Posts: 43
Joined: Sun Aug 24, 2008 2:16 pm

Re: Rebuild Search Index error

Post by jorgefms » Sat Mar 07, 2009 3:10 pm

I can't edit it.
The host says: ''Ins´t our problem''

jorgefms
Registered User
Posts: 43
Joined: Sun Aug 24, 2008 2:16 pm

Re: Rebuild Search Index error

Post by jorgefms » Tue Mar 10, 2009 11:44 am

Problem solved!

I exported DB from online server to localhost, then I Rebuilded the search index.
Then I exported the DB from localhost to online server and everything is fine!

In localhost the rebuild search index is very fast!!!!! :D

Locked

Return to “[3.0.x] Support Forum”