vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Help, Database Error 1052 when I try to send mail to users by usergroupid (https://vborg.vbsupport.ru/showthread.php?t=115637)

smdani 05-15-2006 06:58 AM
Help, Database Error 1052 when I try to send mail to users by usergroupid
 
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:

HTML Code:
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:
HTML Code:
,useractivation.activationid
before the ?from? and
HTML Code:
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 05-22-2006 03:42 PM
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:

Quote:
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
Quote:
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
HTML Code:
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
HTML Code:
                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
Quote:
*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 06-01-2006 11:54 AM
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


All times are GMT. The time now is 07:19 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.00984 seconds
  • Memory Usage 1,729KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (5)bbcode_html_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (3)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete