[Therion] file.sql format

[Ladislav Blažek]

I think it should be corrected to begin/commit only as afaik most of the
sql servers use this syntax. L.

Dne středa, 24. července 2013, Andrew Atkinson napsal(a):

> Hello
>
> I have just been playing with the export database part of Therion again.
>
> The file outputted was imported into some application fine, but most
> would not work phpMyAdmin being one of the ones that I could not import
> with and the one that my ISP forces me to use.
>
> phpMyAdmin was giving the error
>
> #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 'TRANSACTION' at line 1
>
> After a bit of searching I found this
>
> http://dev.mysql.com/doc/refman/5.0/en/commit.html
>
> (there is a similar page for MySQL4 and 3.23 that seem to say the same)
>
> So editing the exported file first line
>
> from
>
> begin transaction;
>
> to
>
> begin;
>
> and last line
>
>
> from
>
> commit transaction;
>
> to
>
> commit;
>
> then it worked
> Not sure if this is a bug or my lack of understanding of the .sql file
> format
>
> Andrew
> _______________________________________________
> Therion mailing list
> Therion at speleo.sk <javascript:;>
> http://mailman.speleo.sk/mailman/listinfo/therion
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.speleo.sk/pipermail/therion/attachments/20130725/f155405f/attachment.htm>