DBD::mysql::st execute failed: 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 'FROM og_uid ou INNER JOIN users u ON ou.uid = u.uid WHERE u.uid != '1' AND ou.ni' at line 4 at ./mail-out.pl line 308.
DBD::mysql::st execute failed: 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 'FROM og_uid ou INNER JOIN users u ON ou.uid = u.uid WHERE u.uid != '1' AND ou.ni' at line 4 at ./mail-out.pl line 308.

On a customers box with the latest checkout from CVS we get these errors at the end of 10K emails being sent. Running mail-out as blackhole.

Kieran

Comments

Amazon’s picture

Amazon commented

I re-sent mail after clearing out the outgoing_* tables to ensure there was no corrupt data.

outgoing_content, and outgoing_arguments seemed fine. outgoing_recipients is not populated and give this error:

time ./mail-out.pl
DBD::mysql::st execute failed: 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 'FROM og_uid ou INNER JOIN users u ON ou.uid = u.uid WHERE u.uid != '1' AND ou.ni' at line 4 at ./mail-out.pl line 308.

Also, when content is submitted it is no longer part of the group. I keep trying to add it to the group and it won't stay added to the group after a submit. This is preventing me from doing further testing because I can't submit content.

Kieran

killes@www.drop.org’s picture

killes@www.drop.org commented
Status: Active » Fixed

sorry, typo in sql statement. fixed and devel site updated.

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.