Hi, I am trying to install a 3rd party chat module onto an online content system..... Here is the error I get....


Database error: _SPCHAT_INSERTINTOTABLEFAILED
SQL error: "You have an error in your SQL syntax near '5,0)' at line 6" SQL query: "INSERT INTO nuke_spchat_grpmember ( nuke_spchat_grpmember.uid, nuke_spchat_grpmember.gid, nuke_spchat_grpmember.rid) VALUES (,5,0);"


Mysql version is 3.23.58

Thanks for your time..... I am not a programmer its all swahili to me..

VALUES (,5,0) has nothing between the opening parenthesis and the first comma

that's the syntax error

if uid is an auto_increment, you can try this:

INSERT INTO nuke_spchat_grpmember ( gid, rid ) VALUES ( 5, 0 );

hmm... I don't think I did that right....


query looks like this

"INSERT INTO nuke_spchat_grpmember( gid, rid ) VALUES ( 5, 0 ); ( nuke_spchat_grpmember.uid, nuke_spchat_grpmember.gid, nuke_spchat_grpmember.rid) VALUES (,5,0);"

drop everything after the first semi-colon

INSERT INTO nuke_spchat_grpmember( gid, rid ) VALUES ( 5, 0 );

Thanks that seems to have done it....viola!

Nigel