Announcement

Collapse
No announcement yet.

Database error in vBulletin 4.0.3

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

  • FaiSao
    replied
    Please ,,

    Leave a comment:


  • FaiSao
    replied
    PHP Code:
    Database error in vBulletin 4.0.4:

    Invalid SQL:

                
    SELECT searchgroup.groupidMATCH(searchgroup_text.title)  AGAINST ('    ..      ..') AS score
                FROM searchgroup 
    AS searchgroup JOIN searchgroup_text AS  searchgroup_text ON
                    
    (searchgroup.searchgroupid =  searchgroup_text.searchgroupid)
                
                
    WHERE MATCH(searchgroup_text.titleAGAINST ('     ..     ..') AND
                    
    searchgroup.contenttypeid 2
                    
                    
                HAVING score 
    4
                LIMIT 5
    ;

    MySQL Error   Unknown column 'searchgroup.groupid' in 'field list'
    Error Number  1054
    Request Date  
    WednesdayJune 23rd 2010 11:56:40 PM
    Error Date    
    WednesdayJune 23rd 2010 11:56:40 PM
    Script        
    :  http://www.al3ial.com/vb/newthread.php?do=postthread&f=25
    Referrer      :  http://www.al3ial.com/vb/newthread.php?do=newthread&f=25
    IP Address    111.11.11.1
    Username      
    admin
    Classname     
    vB_Database
    MySQL Version 
    5.0.90-community-log 

    Leave a comment:


  • FaiSao
    replied
    PHP Code:
    Database error in vBulletin 4.0.4:

    Invalid SQL:
    INSERT INTO searchgroup (usernamecontenttypeidgroupiduseriddateline)
                
    VALUES ''310)
                
    ON DUPLICATE KEY UPDATE  username VALUES(username), contenttypeid VALUES(contenttypeid), groupid VALUES(groupid), userid VALUES(userid), dateline VALUES(dateline);

    MySQL Error   Unknown column 'username' in 'field list'
    Error Number  1054
    Request Date  
    WednesdayJune 23rd 2010 11:33:46 PM
    Error Date    
    WednesdayJune 23rd 2010 11:33:46 PM
    Script        
    http://www.al3ial.com/vb/admincp/misc.php?do=updateforum
    Referrer      http://www.al3ial.com/vb/admincp/misc.php?do=chooser
    IP Address    111.11.11.1
    Username      
    admin
    Classname     
    vB_Database
    MySQL Version 
    5.0.90-community-log 
    Last edited by FaiSao; Thu 24th Jun '10, 3:53am.

    Leave a comment:


  • FaiSao
    replied
    Originally posted by borbole View Post
    Try to recreate it. You can get its structure from the mysql-schema.php file inside the install folder.

    it's Okay now ,,

    Thanks
    Last edited by FaiSao; Thu 24th Jun '10, 3:52am.

    Leave a comment:


  • borbole
    replied
    Originally posted by FaiSao View Post
    I Know, but what can I doing now ?
    Try to recreate it. You can get its structure from the mysql-schema.php file inside the install folder.

    Leave a comment:


  • FaiSao
    replied
    Originally posted by borbole View Post
    The mysql error you posted above says that it doesn''t exist.
    I Know, but what can I doing now ?

    Leave a comment:


  • borbole
    replied
    Originally posted by FaiSao View Post
    PHP Code:
    #1050 - Table 'contenttype' already exists 
    The mysql error you posted above says that it doesn''t exist.

    MySQL Error : Table 'al3ial_sao.contenttype' doesnt exist

    Leave a comment:


  • FaiSao
    replied
    Originally posted by borbole View Post
    According to the mysq error you are missing a db table (contacttype). Try to recreate it and see if it would help.

    PHP Code:
    #1050 - Table 'contenttype' already exists 

    Leave a comment:


  • borbole
    replied
    Originally posted by FaiSao View Post
    PHP Code:
    Database error in vBulletin 4.0.3:

    Invalid SQL:

                    
    SELECT contenttype.contenttypeid AS itemid
                        
                    FROM contenttype 
    AS contenttype
                        INNER JOIN package 
    AS package
                        ON package
    .packageid contenttype.packageid LEFT JOIN product AS product
                        ON product
    .productid package.productid 
                    WHERE
                        1 
    AND (product.active '1' OR package.productid 'vbulletin')  AND contenttype.cansearch '1';

    MySQL Error   Table 'al3ial_sao.contenttype' doesn't exist
    Error Number  : 1146
    Request Date  : Monday, June 21st 2010 @ 10:50:55 PM
    Error Date    : Monday, June 21st 2010 @ 10:50:55 PM
    Script        : http://www.al3ial.com/vb/al3ial_admin/misc.php?do=chooser
    Referrer      : http://www.al3ial.com/vb/al3ial_admin/index.php?do=nav
    IP Address    : 111.11.11.1
    Username      : admin
    Classname     : vB_Database
    MySQL Version : 5.0.90-community-log 
    please help me,

    According to the mysq error you are missing a db table (contacttype). Try to recreate it and see if it would help.

    Leave a comment:


  • FaiSao
    started a topic [Forum] Database error in vBulletin 4.0.3

    Database error in vBulletin 4.0.3

    PHP Code:
    Database error in vBulletin 4.0.3:

    Invalid SQL:

                    
    SELECT contenttype.contenttypeid AS itemid
                        
                    FROM contenttype 
    AS contenttype
                        INNER JOIN package 
    AS package
                        ON package
    .packageid contenttype.packageid LEFT JOIN product AS product
                        ON product
    .productid package.productid 
                    WHERE
                        1 
    AND (product.active '1' OR package.productid 'vbulletin')  AND contenttype.cansearch '1';

    MySQL Error   Table 'al3ial_sao.contenttype' doesn't exist
    Error Number  : 1146
    Request Date  : Monday, June 21st 2010 @ 10:50:55 PM
    Error Date    : Monday, June 21st 2010 @ 10:50:55 PM
    Script        : http://www.al3ial.com/vb/al3ial_admin/misc.php?do=chooser
    Referrer      : http://www.al3ial.com/vb/al3ial_admin/index.php?do=nav
    IP Address    : 111.11.11.1
    Username      : admin
    Classname     : vB_Database
    MySQL Version : 5.0.90-community-log 
    please help me,

Related Topics

Collapse

Working...
X