Forums

SuperMAG

Member

Registered: 2008-05-10

Posts: 707

Error when restoring database backup

hi, i just changed host and when tried to upload db, i got an error

Error

SQL query:

INSERT INTO `pbb_search_matches` (`post_id`, `word_id`, `subject_match`) VALUES (1306, 5335, 0), (1306, 3705, 0), (1306, 2951, 0), (1306, 6313, 0), (1306, 593, 0), (1306, 4005, 0), (1306, 3184, 0), (1306, 735, 0), (1306, 1163, 0), (1306, 406, 0), (1306, 7811, 0), (1306, 3598, 0), (1306, 5793, 0), (1306, 3876, 0), (1306, 1440, 0), (1306, 4907, 0), (1306, 5010, 0), (1306, 7816, 0), (1306, 449, 0), (1306, 912, 0), (1306, 404, 0), (1306, 492, 0), (1306, 867, 0), (1306, 6034, 0), (1306, 463, 0), (1306, 470, 0), (1306, 268, 0), (1306, 695, 0), (1306, 3176, 0), (1306, 4141, 0), (1306, 358, 0), (1306, 1319, 0), (1306, 4775, 0), (1306, 4064, 0), (1306, 7813, 0), (1306, 2044, 0), (1306, 4928, 0), (1306, 3189, 0), (1306, 9, 0), (1306, 349, 0), (1306, 4908, 0), (1306, 1, 0), (1306, 2933, 0), (1306, 4934, 0), (1306, 166, 0), (1306, 3315, 0), (1306, 1155, 0), (1306, 5334, 0), (1306, 3842, 0), (1306, 1807, 0), (1306, 4906, 0), (1306, 3197, 0), (1306, 5336, 0), (1306, 904, 0), (1306, 27, 0), (1306, 4[...]

MySQL said: Documentation
#1064 - 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 '' at line 181 

can any one have quick solutions please the site is down for two days now.

thanks

Smartys

Former Developer

Registered: 2008-04-27

Posts: 3,135

Website

Re: Error when restoring database backup

Modify your dump to remove the INSERT query for that table and then rebuild the search index when your forum is back up.

Smartys

Former Developer

Registered: 2008-04-27

Posts: 3,135

Website

Re: Error when restoring database backup

I also just edited your title to make it actually reflect the issue

SuperMAG

Member

Registered: 2008-05-10

Posts: 707

Re: Error when restoring database backup

Modify your dump to remove the INSERT query for that table and then rebuild the search index when your forum is back up.

mmm how do i do that, i can provide the db if needed.

SuperMAG

Member

Registered: 2008-05-10

Posts: 707

Re: Error when restoring database backup

any one

damaxxed

Member

From: Germany

Registered: 2008-05-16

Posts: 353

Re: Error when restoring database backup

Oh common SuperMAG, you should be able to do some research on your own or are you 11 years old?

1. Remove the INSERT INTO `pbb_search_matches` from the dumpfile (backup)

2. Upload it / execute it

3. Rebuild the search index in the admin panel

SuperMAG

Member

Registered: 2008-05-10

Posts: 707

Re: Error when restoring database backup

you mean i should open the backup file and search for pbb_search_matches line and delete it.

damaxxed

Member

From: Germany

Registered: 2008-05-16

Posts: 353

Re: Error when restoring database backup

Yes

SuperMAG

Member

Registered: 2008-05-10

Posts: 707

Re: Error when restoring database backup

ok its looks like that the whole db was corrupt so i uploaded an old one, so problem solved any way thanks