I get the following errors upon activating the Framework and User modules (prior to activating any other dependent modules and after activating the Messaging module):
sms error:
Sending SMS to %number failed.
php errors:
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 '' at line 1 query: SELECT * FROM users u WHERE in /home/.../includes/database.mysql.inc on line 174.
and
Invalid argument supplied for foreach() in /home/,,,/modules/user/user.module on line 53.
These appear to be generated every time a db query is made that involves some user data. The errors are so numerous that my log just fills up with them.
Comments
Comment #1
Will White CreditAttribution: Will White commentedHi rkdesantos,
I'm a little unclear about when the error occurs and what other modules you have enabled. Can you please clarify? I'm not sure why an SMS message would even try to send on every page load.
Cheers,
Will
Comment #2
rkdesantos CreditAttribution: rkdesantos commentedThanks, Will. I'm unclear, too, as to why but this is repeatable on the site in question. As soon as I enable the Framework & User modules the log starts to fill up. Literally, that is all it takes. An uninstall and reinstall of the Messaging, Notification, and SMS modules did not help.
I have these modules in the message and notification enabled (at present nothing in SMS is enabled because of the errors):
Mime Mail 6.x-1.x-dev
Mime Mail CSS Combiner 6.x-1.x-dev
Simplenews 6.x-1.0-rc6
Message notifications 6.x-2.0-beta2
Messaging 6.x-2.0
Messaging Mime Mail 6.x-2.0
Messaging PHPMailer 6.x-2.0
Simple Mail 6.x-2.0
Simple messaging 6.x-2.0
Content Notifications 6.x-2.0
Custom subscriptions 6.x-2.0-beta2
FeedAPI Subscriptions 6.x-2.0-beta2
Nice links 6.x-2.0-beta2
Notifications 6.x-2.0
Notifications Autosubscribe 6.x-2.0
Notifications Lite 6.x-2.0
Notifications UI 6.x-2.0
Notifications Views 6.x-2.0
Taxonomy Notifications 6.x-2.0
Organic Groups Notifications 6.x-1.3
If you would like access to the site to investigate that can be arranged.
Comment #3
ycimlynn CreditAttribution: ycimlynn commentedI am having the same issue. But here is how mine is happening....
I have all modules enabled and apparently working (notifcations, messaging, sms). I have setup the appropriate account with ClickATell, purchased credits, and was able to setup my account and get a notification back. So far, so good. There is no indication that there is an issue at all with the setups.
I have a content type enabled in the notifications. When the notification type (send method) is set to MAIL, everything works just fine. But as soon as I turn on the notification type (Send method) to SMS, the issues arise.
Here are the exact steps:
Create a content type that the SMS has notifications set to. Submit it. Error comes up (same error as noted above).
I have many many modules enabled on this site, so I will start to disable and see if I can find a connection. Will post back if I am successful.
Comment #4
ycimlynn CreditAttribution: ycimlynn commentedJust checking back on the testing of this error. I have a brand new installation. The same error and behaviour is being generated. MAIL works fine, and sends without issue. SMS not so good! Generated the errors as listed above.
I enabled only the following modules:
Drupal core - optional
-Menu
Messaging
-Messaging
-SMS Messaging
Notifications
-Content Notifications
-Notifications
-Simple Mail
Other
-Token
SMS Framework
-Clickatell
-SMS Framework
-SMS User
Comment #5
ycimlynn CreditAttribution: ycimlynn commentedsorry...forgot to mention the versions....
Drupal core - optional
-Menu 5.19
Messaging
-Messaging 5x-1.3
-SMS Messaging 5x - 1.3
-Simple Mail 5x - 1.3
Notifications
-Content Notifications 5x - 1.3
-Notifications 5x - 1.3
Other
-Token 5x - 1.11
SMS Framework
-Clickatell 5x - 1.2
-SMS Framework 5x - 1.2
-SMS User 5x - 1.2
Comment #6
ycimlynn CreditAttribution: ycimlynn commentedOK...further testing shows....
-I redownloaded the SMS Framework and reinstalled. Although it was the same version, the error then went away. (I didn't run update.php...I just overwrote the files).
-However, no messages are sending. This doesn't appear to be an issue with this module, however, so I will track into the notifications module.
The SEND TO PHONE module works absolutely fine, and the previously reported error disappeared. Wierd...
So for now, I guess all is well. Strange....but well.
Comment #7
aspope CreditAttribution: aspope commentedThis issue seems to have gone stale (4 months). Closing...
Comment #8
rkdesantos CreditAttribution: rkdesantos commentedThe issue hasn't been forgotten, I just gave up on getting any further help with it.
Comment #9
rkdesantos CreditAttribution: rkdesantos commentedThe issue is still there and unfortunate that it doesn't work properly.
Comment #10
univate CreditAttribution: univate commentedThis probably needs someone to write down a set of clearly repeatable steps to setting up a site with this error.
Also with D7 around the corner, D5 is going to become un-supported.
Comment #11
rkdesantos CreditAttribution: rkdesantos commentedThe site where I first experienced this will be upgraded to v6 later this month and I will retest it there and report.
Comment #12
dpiDrupal 5 is deprecated