Problema categorii!

[|^Wind^|]

Deci a umblat un administrator noob si mia dat categoriile peste cap,el din forum mia facut forum fara forum-parinte si cand incerc la Forumul asta sai pun Forum parinte imi da eroarea asta :

Cod: Selectaţi tot

SQL ERROR [ mysqli ]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND right_id >' at line 4 [1064]

SQL

UPDATE phpbb_forums SET right_id = right_id - 2, forum_parents = '' WHERE left_id < AND right_id >

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: includes/acp/acp_forums.php
LINE: 1286
CALL: dbal_mysqli->sql_query()

FILE: includes/acp/acp_forums.php
LINE: 1209
CALL: acp_forums->move_forum()

FILE: includes/acp/acp_forums.php
LINE: 189
CALL: acp_forums->update_forum_data()

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

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

Deci chiar nu stiu ce sa fac mia stricat tot mi lea dat peste cap

[bogdan]

Cea mai simpla si sigura solutie e sa restaurezi baza de date (in cazul in care ai un backup).

Alta varianta (eventual poti aplica solutia pe local ca sa vezi daca merge) ar fi sa folosesti Support Toolkit sa repari structura forumurilor si modulelor (vezi optiunea Fix Left/Right ID's)