You have an error in your SQL syntax

Report bugs and share your ideas to improve WarcraftPets.
Post Reply
User avatar
Blubibulga
Top Rater
Posts:3
Joined:January 18th, 2010
Pet Score:6178
Realm:La Croisade écarlate-eu
Contact:
You have an error in your SQL syntax

Post by Blubibulga » September 26th, 2012, 4:05 am

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.

User avatar
Paladiac
Posts:21
Joined:September 8th, 2009
Pet Score:9583
Realm:Feathermoon-us
Contact:

Re: You have an error in your SQL syntax

Post by Paladiac » September 26th, 2012, 4:30 pm

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.

Post Reply