When someone after fill-up all the field and send the form to register itself, it’s showing the flowing error:
“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 member_id = 74 AND msc_id = 3’ at line 1 SQL=UPDATE `tm4tv_osemsc_member` SET `start_date` = ‘2012-01-16 12:03:15’ , `expired_date` = DATE_ADD(‘2012-01-16 12:03:15’,INTERVAL ) WHERE member_id = 74 AND msc_id = 3”
If the user retry to re-send the form, another message show the following:
“The username you entered is not available. Please pick another username.
The email address you entered is already in use or invalid. Please enter another email address.”
How we can solve this problem?
Thank you for any solution.
Kabil