Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Page 2 of 2 FirstFirst 12
Results 16 to 20 of 20

Thread: Database errors

  1. #16
    Senior Coder
    Join Date
    Feb 2011
    Location
    Your Monitor
    Posts
    4,281
    Thanks
    57
    Thanked 523 Times in 510 Posts
    Blog Entries
    5
    Another one a few minutes ago:

    <!--
    Database error in vBulletin :

    mysql_connect() [&lt;a href='function.mysql-connect'&gt;function.mysql-connect&lt;/a&gt;]: User cfgeorge_master already has more than 'max_user_connections' active connections
    /home/cfgeorge/public_html/includes/class_core.php on line 311

    MySQL Error :
    Error Number :
    Request Date : Tuesday, June 4th 2013 @ 06:01:17 AM
    Error Date : Tuesday, June 4th 2013 @ 06:01:17 AM
    Script : http://www.codingforums.com/php/
    Referrer :
    IP Address : <Masked - Thank you >
    Username :
    Classname : vB_Database
    MySQL Version :
    -->
    Note the part about too many sql connections..
    See my new CodingForums Blog: http://www.codingforums.com/blogs/tangoforce/

    Many useful explanations and tips including: Cannot modify headers - already sent, The IE if (isset($_POST['submit'])) bug explained, unexpected T_CONSTANT_ENCAPSED_STRING, debugging tips and much more!

  2. #17
    The fat guy next door VIPStephan's Avatar
    Join Date
    Jan 2006
    Location
    Halle (Saale), Germany
    Posts
    8,606
    Thanks
    6
    Thanked 997 Times in 970 Posts
    I got an interesting one while I was trying to delete a post: I had a spammer with several threads, one of them with one unsubstantial reply. I deleted the spam threads while I had this one thread open in another tab. I then issued an infraction and wanted to delete the stupid reply in that remaining open tab and I got this:

    Code:
    Database error in vBulletin 3.8.2:
    
    Invalid SQL:
    
    				SELECT postid, dateline
    				FROM post
    				WHERE threadid = 
    				ORDER BY dateline
    				LIMIT 1;
    
    MySQL 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 'ORDER BY dateline
    				LIMIT 1' at line 4
    Error Number  : 1064
    Request Date  : Wednesday, September 25th 2013 @ 02:53:32 AM
    Error Date    : Wednesday, September 25th 2013 @ 02:53:34 AM
    Script        : http://www.codingforums.com/infraction.php?do=update
    Referrer      : http://www.codingforums.com/infraction.php?do=report&p=1359314
    IP Address    : [removed]
    Username      : VIPStephan
    Classname     : vB_Database
    MySQL Version : 5.0.96-community-log

  3. #18
    God Emperor Fou-Lu's Avatar
    Join Date
    Sep 2002
    Location
    Saskatoon, Saskatchewan
    Posts
    16,987
    Thanks
    4
    Thanked 2,660 Times in 2,629 Posts
    Looks to me like you issued a delete on a post that you then had refreshed (with the infraction for the next set), but the post was already gone. I would assume that's using the checkbox for all posts instead of just the one post. Its an oversight in the code for sure, but it doesn't look like anything to be concerned of.
    Edit:
    Another thought that may make more sense. Perhaps you had already checked a thread, deleted via cascade, and then it recalled it when you tried again from the cookies with the checked items.
    PHP Code:
    header('HTTP/1.1 420 Enhance Your Calm'); 

  4. #19
    The fat guy next door VIPStephan's Avatar
    Join Date
    Jan 2006
    Location
    Halle (Saale), Germany
    Posts
    8,606
    Thanks
    6
    Thanked 997 Times in 970 Posts
    Yeah, I mass deleted the threads (using the “remove other posts by this user” feature), so the open thread in the other tab was already deleted when I tried to delete the reply to that thread. So I can totally understand that this raises a conflict in the system but I would assume there is some kind of error handling. I’m not particularly concerned about the error, I just wanted to point it out.

  5. #20
    God Emperor Fou-Lu's Avatar
    Join Date
    Sep 2002
    Location
    Saskatoon, Saskatchewan
    Posts
    16,987
    Thanks
    4
    Thanked 2,660 Times in 2,629 Posts
    I think the mass handling for posts is perhaps a non-official addon? I'm sure its a part of official now, but I don't know what version introduced it. I haven't had a vB since like 3.1, and it wasn't a standard option then.
    PHP Code:
    header('HTTP/1.1 420 Enhance Your Calm'); 


 
Page 2 of 2 FirstFirst 12

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •