Announcement

Collapse
No announcement yet.

Database Error

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Database Error

    Hello

    This is the error:-

    PHP Code:
    Database error in vBulletin 3.8.0:
     
    Invalid SQL:
     
                        
    SELECT title
                        FROM usertitle
                        WHERE minposts 
    <= 0
                        ORDER BY minposts DESC
                        LIMIT 1
    ;
     
    MySQL Error   Unknown column 'minposts' in 'where clause'
    Error Number  1054
    Request Date  
    WednesdayJune 17th 2009 03:17:55 PM
    Error Date    
    WednesdayJune 17th 2009 03:17:55 PM
    Script        
    http://www.my-forum.com/vb/admincp/misc.php?do=updateuser
    Referrer      http://www.my-forum.com/vb/admincp/misc.php
    IP Address    78.101.246.203
    Username      
    admin
    Classname     
    vB_Database
    MySQL Version 
    5.0.77-community 
    Can anybody help me please

    Regards,

  • #2
    need more information on the problem like when did it occur what were you doing when it happened etc.
    Developer of the VB-PBWoW Skin
    TUAGuild from vb.org
    http://www.vb-pbwow.com

    Comment


    • #3
      When I want to delete a post

      Comment


      • #4
        hummm when did the issue start happening did you change anything about your forum or install an addon before it started
        Developer of the VB-PBWoW Skin
        TUAGuild from vb.org
        http://www.vb-pbwow.com

        Comment


        • #5
          no .. and i disabled all the hook

          Comment


          • #6
            was your forum working before all this started
            Developer of the VB-PBWoW Skin
            TUAGuild from vb.org
            http://www.vb-pbwow.com

            Comment


            • #7
              Yes

              Comment


              • #8
                Run this query to add that field:

                ALTER TABLE usertitle ADD minposts INT UNSIGNED NOT NULL DEFAULT '0'


                You can run queries in the SQL tab in phpMyAdmin, or to run queries from the Admin CP:

                Admin CP -> Maintenance -> Execute SQL Query -> Manual Query


                Then enter your query in the Manual Query box and click on 'Continue'.

                To run queries you first need to give yourself permission to run queries in the Admin CP. To do this, edit this section of config.php:

                $config['SpecialUsers']['canrunqueries'] = 'x';


                ...with x being your userid number.
                Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                Change CKEditor Colors to Match Style (for 4.1.4 and above)

                Steve Machol Photography


                Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                Comment


                • #9
                  Thanks

                  Comment

                  widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                  Working...
                  X