Welcome Guest, Not a member yet? Register   Sign In
Ion Auth - Lightweight Auth System based on Redux Auth 2

[eluser]ZaLiTHkA[/eluser]
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:

Quote:Error Number:

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 protected]', '', 1343032245, 1343032245, 1)

Filename: C:\EasyPHP\www\AESPortal_CI\system\database\DB_driver.php

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?


Messages In This Thread
Ion Auth - Lightweight Auth System based on Redux Auth 2 - by El Forum - 07-23-2012, 01:47 AM



Theme © iAndrew 2016 - Forum software by © MyBB