mysql - SQL error in this query -

mysql - SQL error in this query -

im trying create register cms system. whenever seek create it, gives me error

the next info meant website developer debugging purposes. error occurred while processing request error executing database query. have error in sql syntax; check manual corresponds mysql server version right syntax utilize near '', '0', '500000', '500000', ''2012-11-02 22:12:11'', '20', '1', 'hr-165-45.hd-20' @ line 2

the sql query this:

<cfquery name="insertmale" datasource = "#dsn#"> insert users (id, username, real_name, password, auth_ticket, rank, vip_points, credits, activity_points, activity_points_lastupdate, seasonal_currency, loyalty_points, look, gender, motto, mail, account_created, last_online, online, ip_last, ip_reg, home_room, newbie_status, is_muted, mutant_penalty, mutant_penalty_expire, trade_lock, trade_lock_expire, block_newfriends, hide_online, hide_inroom, vip, vip_expire, birth, talent_status, mysterybox_key_colour, last_name_change, client_volume, nux_passed, seckey, voted, vandeweek, home_txt, donateur, stemmen, waarschuwing) values('#countusers.recordcount+1#', '#form.username#', 'donny', '#password#', 'grandcms-', 1', '0', '500000', '500000', '#dateadd("s", 1351894331, createdatetime(1970, 1, 1, 0, 0, 0))#', '20', '1', 'hr-165-45.hd-208-2.ch-250-64.lg-285-82.sh-290-64', 'm', 'nieuw op grandhotel!', '#form.mail#', '#dateadd("s", 1351894331, createdatetime(1970, 1, 1, 0, 0, 0))#', '#dateadd("s", 1351894331, createdatetime(1970, 1, 1, 0, 0, 0))#', '0', '#cgi.remote_addr#', '#cgi.remote_addr#', '0', '0', '0', '0', '#dateadd("s", 1351894331, createdatetime(1970, 1, 1, 0, 0, 0))#', '0', '#dateadd("s", 1351894331, createdatetime(1970, 1, 1, 0, 0, 0))#', '0', '0', '0', '0', '#dateadd("s", 1351894331, createdatetime(1970, 1, 1, 0, 0, 0))#', '24-12-1995', '0', '0', '#dateadd("s", 1351894331, createdatetime(1970, 1, 1, 0, 0, 0))#', '100', '0', '0', '1', '0', 'geenhometxt', '0', '0', '0'); </cfquery>

i counted column's, it's same isn't problem. know's doing wrong?

sorry bad bad english. i'm netherlands!

change 1', there missing!

mysql sql coldfusion