Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • kandsgroup Friend
    #172842

    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

    Blaine Friend
    #434108

    Iy would help to know the version of Joomla being used but this is a simple SQL error.
    Please read this Joomla.org thread and see if it helps you to sort this out.
    Thanks!

Viewing 2 posts - 1 through 2 (of 2 total)

This topic contains 2 replies, has 2 voices, and was last updated by  Blaine 12 years, 10 months ago.

We moved to new unified forum. Please post all new support queries in our New Forum