Help, Database Error 1052 when I try to send mail to users by usergroupid

[smdani]

Suddenly I noticed that my ?send mail to users? option didn?t work properly, I suppose that a plugin breaks it, but I don?t know which or when could be and how to fix.

The problem:
In the admincp >> user >> send mail to users
I select one or various usergroups to send them a mail, and when I click send, I get this database error:

 Database error in vBulletin 3.5.0:

Invalid SQL:

				SELECT user.userid, user.usergroupid, user.username, user.email, user.joindate,
					useractivation.activationid
				FROM user AS user
				LEFT JOIN userfield AS userfield ON (userfield.userid = user.userid)
				LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid)
				LEFT JOIN useractivation AS useractivation ON (useractivation.userid = user.userid AND useractivation.type = 0)
				WHERE 
		1=1 AND (usergroupid = 3)
		AND user.email <> ''
		
				ORDER BY userid
				LIMIT 0, 500;

MySQL Error  : Column: 'usergroupid' in where clause is ambiguous
Error Number : 1052
Date         : Monday, May 15th 2006 @ 09:41:37 AM
Script       : http://**********/email.php
Referrer     : http:// **********/email.php?do=start

Testing different SQL queries I noticed that if I would remove the part from the ?useractivation.activationid? I mean:

,useractivation.activationid

before the ?from? and

 LEFT JOIN useractivation AS useractivation ON (useractivation.userid = user.userid AND useractivation.type = 0)

The query must be fine, although I looked into the email.php and saw that this line isn?t part of the original code

The questions are ?Am I looking at the right direction? ?Any one knows which hack would did this? Any way ?how can I fix it? I didn?t found where this line was added

Thanks for any help you bring me

[smdani]

Don’t know if it would be connected with the issue that I posted before, but just now I see that I have permanent php warnings like this in my forum:

Warning: file_exists(): open_basedir restriction in effect. File(/proc/loadavg) is not within the allowed path(s): (*******************/httpdocs:/tmp) in *****************/httpdocs/global.php on line 70
Date: Monday 22nd of May 2006 06:26:03 PM
Username:
IP Address: **********

And some other like this

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in ***************/includes/class_core.php on line 744
Date: Monday 22nd of May 2006 06:19:47 PM
Username: No Registrado
IP Address: *************

This is line 70 from my global.php

 if ($vbulletin->options['loadlimit'] > 0 AND PHP_OS == 'Linux' AND @file_exists('/proc/loadavg') AND $filestuff = @file_get_contents('/proc/loadavg'))

And this is line 744 from clas_core.php

 		return @$this->functions['free_result']($queryresult);

I don’t know how to afford those warnings and db errors, orient me please


-------------------------------

I’ve just “solved” the first php warning, the one about /proc/loadavg
I was using the admincp option that controls the server load

*NIX Server Load Limit
vBulletin can read the overall load of the server on certain *NIX setups (including Linux).

This allows vBulletin to determine the load on the server and processor, and to turn away further users if the load becomes too high.

If you do not want to use this option, set it to 0.
A typical level would be 5.00 for a reasonable warning level.

and now when I try to disable this the 20warnings/minute had gone
Don’t know clearly what the NIX is and how to use it or if the problem is just with this, ?any one could point me?

[smdani]

At this thread
are dealing with my same problem, then this one will be closed

edited
this was the correcto URL https://vborg.vbsupport.ru/showthrea...759#post994759