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

Will White’s picture

Category: bug » support
Priority: Critical » Normal

Hi 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

rkdesantos’s picture

Thanks, 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.

ycimlynn’s picture

I 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.

ycimlynn’s picture

Just 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.

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.

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

ycimlynn’s picture

sorry...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

ycimlynn’s picture

OK...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.

aspope’s picture

Status: Active » Closed (fixed)

This issue seems to have gone stale (4 months). Closing...

rkdesantos’s picture

Status: Closed (fixed) » Active

The issue hasn't been forgotten, I just gave up on getting any further help with it.

rkdesantos’s picture

The issue is still there and unfortunate that it doesn't work properly.

univate’s picture

Status: Active » Postponed (maintainer needs more info)

This 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.

rkdesantos’s picture

The site where I first experienced this will be upgraded to v6 later this month and I will retest it there and report.

dpi’s picture

Issue summary: View changes
Status: Postponed (maintainer needs more info) » Closed (won't fix)

Drupal 5 is deprecated