I’ve got a problem adding users using the form found in ‘/auth/create_user.php’, when I try add a user, I get an error page with the following message:
Implicit conversion from data type varchar to varbinary is not allowed. Use the CONVERT function to run this query.
INSERT INTO AESW_users (first_name, last_name, company, username, password, email, ip_address, created_on, last_login, active) VALUES (‘First’, ‘Last’, ‘Company’, ‘first last’, ‘91d926115b5d238dd12fd83e3cb7d8b7014e34ca’, ‘email@example.com’, ‘’, 1343032245, 1343032245, 1)
Line Number: 330
Looking at the values in the query, it’s trying to write an empty string to the [ip_address] field.. I’m not too worried about logging IP addresses though, this will only be used on a company WAN.
I’m using EasyPHP 12 in my dev environment, with PHP 5.3.9 using a DB on SQL2005. The provided SQL scripts didn’t work for me, so I manually created the tables in Management Studio, as per the ‘ion_auth.mssql.sql’ file in the download, I setup [ip_address] with a data type of varbinary(16).
Any suggestions here?