restaurare baza de date - SQL Error : 1064 You have an error

[lolutzu]

am salvat baza de date iar a 2 a zi cand am vrut sa o restaurez pe acceasi versiune de phpbb (deci era totul identic am vrut sa testez restaurarea) mi-a dat eroarea urmatoare :

Error importing backup file

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near '158', '6038dd46e7', '', '[color=red:6038dd46e7][b:6038dd46e7]Un deosebit respect' at line 1

INSERT INTO forum_posts_text (post_id, bbcode_uid, post_subject, post_text) VALUES('157', '8613625890', 'Canale Irc', '#La-Familia - Moderator Lucky INSERT INTO forum_posts_text (post_id, bbcode_uid, post_subject, post_text) VALUES('158', '6038dd46e7', '', '[color=red:6038dd46e7][b:6038dd46e7]Un deosebit respect celor care ne sustin...[/color:6038dd46e7][/b:6038dd46e7]'); INSERT INTO forum_posts_text (post_id, bbcode_uid, post_subject, post_text) VALUES('159', 'ff838e25ac', 'Fetele Rele din Rap`ul romanesc', 'mah fratilor...de Marijuana ce se mai aude??? Gunja ???...Nico...Honey...Anda Adam..Catalina Toma? [img:ff838e25ac]http://www.asasina.ro/62.gif[/img:ff838e25ac]'); ................

Line : 948
File : /softure/forum/scandalosmusic/admin/admin_db_utilities.php

CE ARE ? CE SA-I FAC ?

[bogdan]

tu ai in acel cod:

Cod: Selectaţi tot

INSERT INTO forum_posts_text (post_id, bbcode_uid, post_subject, post_text) VALUES('157', '8613625890', 'Canale Irc', '#La-Familia - Moderator Lucky

INSERT INTO forum_posts_text (post_id, bbcode_uid, post_subject, post_text) VALUES('158', '6038dd46e7', '', '[color=red:6038dd46e7][b:6038dd46e7]Un deosebit respect celor care ne sustin...[/color:6038dd46e7][/b:6038dd46e7]');

si normal trebuie sa fie (lipsesc cel putin 2 caractere la prima line de cod):

Cod: Selectaţi tot

INSERT INTO forum_posts_text (post_id, bbcode_uid, post_subject, post_text) VALUES('157', '8613625890', 'Canale Irc', '#La-Familia - Moderator Lucky');

INSERT INTO forum_posts_text (post_id, bbcode_uid, post_subject, post_text) VALUES('158', '6038dd46e7', '', '[color=red:6038dd46e7][b:6038dd46e7]Un deosebit respect celor care ne sustin...[/color:6038dd46e7][/b:6038dd46e7]');

[cip]

am vrut sa mut forumul pe alt server (de la lx.ro la xhost.ro), am facut back-up la bd (doar date) iar cand dau resotre pe serverul nou, imi da urmatoarea eroare:

Error importing backup file

DEBUG MODE

SQL Error : 1062 Duplicate entry '1' for key 1

INSERT INTO phpbb_banlist (ban_id, ban_userid, ban_ip, ban_email) VALUES('1', '0', '51b55a91', NULL)

Line : 980
File : admin_db_utilities.php

pe serverul nou, am pus un forum curat, v. 2.0.15 (pe lx, cel vechi era 2.0.11) si atat.. iar pt ca sql'ul avea aproape 4 mega, l-am impartit in doua.. nu e prima oara cand fac asta, dar e prima oara cand primesc eroarea asta

[dorin]

Pai normal daca ai facut backup doar la date, goleste tabelele de date si nu vei mai primi eroarea asta