I'm trying to restore a database, IPB 2.2
onto a mysql 5.0.22.


My previous mysql may have been different.

When restoring, I'm getting this error:

ERROR 1064 (42000) at line 13332: 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 'INSERT INTO `ibf_member_extra`
(`id`,`notes`,`links`,`bio`,`ta_size`,`photo_type' at line 591


What's wrong with that line?


Thanks!

On Thu, 04 Oct 2007 09:03:41 +0200, <pig.fatt@gmail.com> wrote:

> I'm trying to restore a database, IPB 2.2
> onto a mysql 5.0.22.
>
>
> My previous mysql may have been different.
>
> When restoring, I'm getting this error:
>
> ERROR 1064 (42000) at line 13332: 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 'INSERT INTO `ibf_member_extra`
> (`id`,`notes`,`links`,`bio`,`ta_size`,`photo_type' at line 591
>
>
> What's wrong with that line?

Up to there: nothing. What is the original, total, query?
--
Rik Wasmus

On 4 Oct, 08:03, pig.f...@gmail.com wrote:
> I'm trying to restore a database, IPB 2.2
> onto a mysql 5.0.22.
>
> My previous mysql may have been different.
>
> When restoring, I'm getting this error:
>
> ERROR 1064 (42000) at line 13332: 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 'INSERT INTO `ibf_member_extra`
> (`id`,`notes`,`links`,`bio`,`ta_size`,`photo_type' at line 591
>
> What's wrong with that line?
>
> Thanks!

Look at what comes immediately before that query.