I still have errors with the new code and an older copy of the SMF forums on a test server:
« MODx Parse Error »
MODx encountered the following error while attempting to parse the requested resource:
« Execution of a query to the database failed - UPDATE command denied to user 'tattoocms'@'localhost' for table 'smf_members' »
SQL: UPDATE tattoosmf.smf_members SET dateRegistered='1142975180',ID_GROUP='37',ID_POST_GROUP='4',showOnline='1',lastLogin='1126491154',gender='0',is_activated='1' WHERE ID_MEMBER='3205';
Incidentally, 3205 is the very last record in the smf_members table. The record also contains a hyphen in the email address, so I don’t know if that’s the problem or not... and it’s not as I deleted that record, and then got the following error:
MODx encountered the following error while attempting to parse the requested resource:
« Execution of a query to the database failed - UPDATE command denied to user 'tattoocms'@'localhost' for table 'smf_members' »
SQL: UPDATE tattoosmf.smf_members SET dateRegistered='1142976950',ID_GROUP='37',ID_POST_GROUP='4',showOnline='1',lastLogin='1135640509',gender='0',is_activated='1' WHERE ID_MEMBER='3206';
Member ID 3206 contains no crazy characters, but it’s the first one created (in fact it’s aNoble!).
Running it again, I get another error message with the same incremental member id and it adds one more record (banzai).
The SMF database is the big database, btw, and I’m hoping this will pull all the records, not just push them to there. This is strange.
The module will not run in Safari, I still get the file not found errors.
These tests were all performed with the files from the Mar 1 7PM email from Raymond and with the files in the first message here on rev 646.