hi, I'm having trouble figuring out what's wrong with this mysql insert statement.

It was actually exported from another database via phpmyadmin, then placed within an xml file (so that it executes during a Joomla component installation).

Unfortunately, Joomla is returning an error message regarding the syntax.

Here's a link -> http://www.bobscottsinsights.com/syntax.sql

there's nothing wrong with it, other than the fact that it contains two INSERT statements

(i ran it via HeidiSQL, which has no problem handling multiple SQL statements in a single file)

use a text editor, split the two INSERT statements into separate .sql files, and try running them separately

perfect! Thanks a lot man, I didn't see that second Insert.