Ion Auth - Lightweight Auth System based on Redux Auth 2

[eluser]eddt[/eluser]
[quote author="tropiburguer" date="1311794404"]I’m getting an mysql syntax error on the ion auth mysql install file on line 2 (see message below), any idea why?

Message:

Error Number: 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 'WHERE `0` = 'admin@admin.com'' at line 2

SELECT COUNT(*) AS `numrows` WHERE `0` = 'admin@admin.com'[/quote]

Looking at the ion_auth.sql file from what I think is the most recent version available from Ben's site, there's not a single "SELECT" in the sql file - its all "CREATE" and "INSERTS" to setup the tables you'll need in the DB. So I don't know what .sql script you've got, but I don't think it is the install script!