I just looked at the table in phpMyAdmin and looked at the user rows I've been trying to update in cbSubs. Instead of being NULL they are 0000-00-00. So it seems to be putting something in there, but not the date.

Ideas?

Thanks!
Todd

Scratch that. I realized that the 0000-00-00 was being inserted if I saved the user profile from the cbSubs User Management, not from the subscription SQL query.

Todd

No. I am still at this point:

I just tried phpMyAdmin and the following worked:

UPDATE `jos_comprofiler` SET `cb_workshop001` = DATE_FORMAT( CURDATE(), '%Y-%m-%d' ) WHERE `user_id` = 66

But then I put the following in cbSubs... and the field is still blank:

UPDATE `jos_comprofiler` SET `cb_workshop001` = DATE_FORMAT( CURDATE(), '%Y-%m-%d' ) WHERE `user_id` = [user_id]

Thoughts?

Todd

The following works great in my SQL software (ie phpMyAdmin)

UPDATE `jos_comprofiler` SET `cb_workshop001` = DATE_FORMAT( CURDATE(), '%Y-%m-%d' ) WHERE `user_id` = 66

UPDATE `jos_comprofiler` SET `state` = "TX" WHERE `user_id` = 66

But the following doesn't work in cbSubs:

UPDATE `jos_comprofiler` SET `cb_workshop001` = DATE_FORMAT( CURDATE(), '%Y-%m-%d' ) WHERE `user_id` = [user_id]

UPDATE `jos_comprofiler` SET `state` = "TX" WHERE `user_id` = [user_id]

So it almost seems that cbSubs is not passing the user_id. Are there any error logs? Some way to see why it isn't running.

argh.
Todd Fletcher