#302 phpBB Database Restore Error

[Anonymous]

everything should be perfect! i broke down my phpBB2
restore file into 17 pieces (it was 4.55mb but server only
allows small transfers). I uploaded the first 9 of them,
but on the 10th it says this:

===================================
Error

SQL-query :

INSERT INTO phpbb_search_wordmatch
INSERT INTO phpbb_search_wordmatch( post_id,
word_id, title_match )
VALUES (

'650', '259', '0'
)

MySQL said:

You have an error in your SQL syntax near 'INSERT INTO
phpbb_search_wordmatch (post_id, word_id,
title_match) VALUES('650',' at line 1
====================================

I am uploading in the correct order and i am 99% sure
that i split it correctly. I even checked over them all
again.

What is causing this error?

Thank youuu!!

My email is mooncow@ntlworld.com

Thanx again - From Scott

[Garvin Hicking]

Logged In: YES
user_id=473563

Hi Scott!

Your INSERT-Syntax contains a double INSERT INTO
phpbb_search_wordmatch string. The first one is without any
VALUES so you should remove that line, it is without effect
- well, apart from causing a syntax error, that is.

Regards,
Garvin.

[Nobody/Anonymous]

Logged In: NO

(follow up) : Hi again - thanks for your kind reply! ^_^

ok then - so i should delete a line yes? But the line the error
says is:
---

INSERT INTO phpbb_search_wordmatch (post_id, word_id,
title_match) VALUES('650', '259', '0');

---
this is near the middle of the 10th one. Did you say delete
the first? The first one is:
---

INSERT INTO phpbb_search_wordmatch (post_id, word_id,
title_match) VALUES('622', '914', '0');

---

So what one do you think i should delete? Thank you again
From Scott (email - mooncow@ntlworld.com)

[Garvin Hicking]

Logged In: YES
user_id=473563

Hi Scott!

The error saying is on this line because that's where the
first syntax is broken. The incomplete line "INSERT INTO
phpbb_search_wordmatch" is missing a ';' as well as VALUE
attributes. Ergo, the next line is declared as the one where
an error happens. Kinda hard to explain :)

So, just make this line:
----------
INSERT INTO phpbb_search_wordmatch
INSERT INTO phpbb_search_wordmatch( post_id,
word_id, title_match )
VALUES (

'650', '259', '0'
)
-----------
into this:
------------
INSERT INTO phpbb_search_wordmatch( post_id,
word_id, title_match )
VALUES (

'650', '259', '0'
) ;
-------------

and everything should be fine.

Regards,
Garvin.

[Garvin Hicking]

Logged In: YES
user_id=473563

No reply.