Announcement

Collapse
No announcement yet.

Database Error

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

  • Gulf-Soul
    replied
    Thanks

    Leave a comment:


  • Steve Machol
    replied
    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.

    Leave a comment:


  • Gulf-Soul
    replied
    Yes

    Leave a comment:


  • lyco
    replied
    was your forum working before all this started

    Leave a comment:


  • Gulf-Soul
    replied
    no .. and i disabled all the hook

    Leave a comment:


  • lyco
    replied
    hummm when did the issue start happening did you change anything about your forum or install an addon before it started

    Leave a comment:


  • Gulf-Soul
    replied
    When I want to delete a post

    Leave a comment:


  • lyco
    replied
    need more information on the problem like when did it occur what were you doing when it happened etc.

    Leave a comment:


  • Gulf-Soul
    started a topic Database Error

    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,
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X