Page 1 of 1

You have an error in your SQL syntax

Posted: September 26th, 2012, 4:05 am
by Blubibulga
Greetings,

Thanks for your awesome site !

Here is an error when updating collection via "Armory import":

Code: Select all

DB-main: 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 1
This 3 times.

Thanks.

Re: You have an error in your SQL syntax

Posted: September 26th, 2012, 4:30 pm
by Paladiac
I just came in here to mention this also.

And a second item - which may relate to this error - is that after I did an import, it said Congratulations, I have 215 pets - but looking at my account, or at the green progress bar, and it only says 213. This may make sense, as when I did the import, I had 2 lines of this syntax error. No chance just yet to look at all the pets and see what I am missing though - assuming it will have me missing 2 pets.

UPDATE! I think I have this figured out.
I only recently created a Horde toon (so I can get the credit for mounts and pets) - and I had all my Horde only pets Excluded since I could not get them. I removed them from the Exclusion - imported again - and tada ... everything is now saying I have 215 pets, with no errors.