Hi, we just started testing the SQL action for the last leg of a build we're doing for a client (CBSubs rocks btw!).
When we built our SQL action, we used the DOC and other helpful tip from the forums but, after enabling debug, it looks like we might have a problem with our SQL. One of the things we're doing is using an external MySQL table to authenticate Joomla with for logging in so therefore, we need to insert the password (clear text) into that DB.
When I constructed the SQL, I thought it might work but, we're getting an error with the password field from CB.
500 - JDatabaseMySQL::query: 1064 - 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 '[password], , , eric@web-jive.com, 501-588-1979)' at line 9 SQL=INSERT INTO users ( users.user_id, users.username, users.password, users.firstname, users.lastname, users.email, users.phone ) VALUES (1012, webjive, [password], , , eric@web-jive.com, 501-588-1979);
Here's the SQL we use..
INSERT INTO users ( users.user_id, users.username, users.password, users.firstname, users.lastname, users.email, users.phone )
VALUES ([user_id], [username], [password], [firstname], [lastname], [email], [cb_homephone]);
Any thoughts?