fatal error on sending mail
dalin - April 4, 2006 - 00:44
| Project: | Mass Mailer |
| Version: | HEAD |
| Component: | Code - PHPlist engine |
| Category: | bug report |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | closed |
Description
When trying to send a message manually I get this error:
Warning: parse_url() expects parameter 1 to be string, array given in /home/*my_user*/public_html/modules/massmailer/engines/phplist/phplist.module on line 860
Fatal error: 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 'WHERE loginname = 'admin'' at line 1 query: REPLACE INTO phplist_admin (email, password) VALUES ('', '') WHERE loginname = 'admin' in /home/*my_user*/public_html/includes/database.mysql.inc on line 66
also cron is giving conflicting messages. If I run cron.php there are two entries in watchdog, cron completed and cron did not complete. Odd.
#1
Here is my first ever patch.
This only partly solves the problem. There was incorrect syntax with the SQL statement. And the variable $db_url had already been parsed into an array. However the password in that array is blank. I'm not sure if that's the way that it's supposed to be.
Now there's a new problem though. The script continues on and I am presented with a "Page not Found" when it tries to go to the following url:
/admin/massmailer/queue?confirm=1
I'm leaving this as unassigned as I don't have the knowhow to fix it.
Not quite sure what is up with that.
#2
I've committed a different fix for the parse_url issue and also committed a fix for the SQL issue (which was a follow up).
WRT the blank page: The recent change to use curl instead of a bash script requires a db update. see the last things in phplist.mysql. It is also possible that Drupal will log you out if you process the queue manually. See http://drupal.org/node/56312
#3