On 23 Jun 2003 at 8:56, Dave Page wrote:
> > For what it's worth, the migration gets this error:
> >
> > Creating table: newforum1_bodies
> > Copying data...
> >
> > An error occured at: 22/06/2003 5:11:40 PM:
> > -2147467259: ERROR: parser: unterminated quoted string at or near
> > "'<HTML>tr -d "" at character 72
> >
> >
> > If you want me to try a patch etc, I can do that. Otherwise, I'll
> > just modify the data.
>
> Odd, it should escape the data - in fact the code looks like:
>
> Values = Values & "'" & Replace(Replace((szValue), "\", "\\"), "'",
> "''") & "', "
>
> Thing is with that though, it's not escaping double quotes, but that's
> because it doesn't need to. In PostgreSQL, the following will work just
> fine:
>
> INSERT INTO foo (bar) VALUES ('"');
>
> Can you provide a log with the SQL query that's failing in it please?
23/06/2003 9:04:58 AM - SQL (phorum_conversion): INSERT INTO "newforum1_bodies" ("id", "body", "thread") VALUES ('151',
'<HTML>Uh,Internal Server Errors may be triggered by a particular browser, but the problem _lies on the server itself_,
soyou''d best off scouring your error logs for
clues.</HTML>', '133')
23/06/2003 9:04:58 AM - SQL (phorum_conversion): INSERT INTO "newforum1_bodies" ("id", "body", "thread") VALUES ('155',
'<HTML>tr-d "
23/06/2003 9:04:58 AM - SQL (phorum_conversion): ROLLBACK
If there's anything else, let me know.
--
Dan Langille : http://www.langille.org/