New Registration Error

Posted on : 2020-03-28 10:46:05 View Type: public

George Johnson

Hi Atteq

When a new user register via my register link

https://www.rossrevengeplans.co.uk/Maintenance_Portal/admin/register.php

They get the following error message when they submit their registration

Incorrect integer value : " for column 'from_id' at row 1

Any idea what this might be ? They still receive an email to confirm their registration

and, despite the error message, they are added to the user database when verifying their registration

Thanks

George

Posted on : 2020-03-28 12:32:56 View Type: public

George Johnson

This error happens when you are trying to set a string in place of Auto increment integer. It should be either 0, NULL or nothing.

That probably means that your id is an AUTO_INCREMENT integer and you're trying to send a string. You should specify a column list and omit it from your INSERT

INSERT INTO workorders (column1, column2) VALUES ($column1, $column2)

I checked after register form , the data is inserted to database successfuly without any problem.

This error happened cause you turned on the option send message to user group on new user registration. And that was sending empty string to From id. Which i have fixed.