[Forum] Database error in vBulletin 4.0.3

[FaiSao]

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 = 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,

[borbole]

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 = 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.

[FaiSao]

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

#1050 - Table 'contenttype' already exists 

[borbole]

#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

[FaiSao]

The mysql error you posted above says that it doesn''t exist.

I Know, but what can I doing now ?

[borbole]

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.

[FaiSao]

Try to recreate it. You can get its structure from the mysql-schema.php file inside the install folder.

it's Okay now ,,

Thanks

[FaiSao]

Database error in vBulletin 4.0.4:

Invalid SQL:
INSERT INTO searchgroup (username, contenttypeid, groupid, userid, dateline)
            VALUES ( '', 3, 1, 0, 0 )
            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  : Wednesday, June 23rd 2010 @ 11:33:46 PM
Error Date    : Wednesday, June 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 

[FaiSao]

Database error in vBulletin 4.0.4:

Invalid SQL:

            SELECT searchgroup.groupid, MATCH(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.title) AGAINST ('æÇááå Çäí  ãÊÝÔá ãäÜÜÜÜÜÜÜÜÜÜÜÜßã .. ÈÓ áæ ÓãÍÊæÇ ÊÚÇáæÇÇÇÇ ..') AND
                searchgroup.contenttypeid = 2
                
                
            HAVING score > 4
            LIMIT 5;

MySQL Error   : Unknown column 'searchgroup.groupid' in 'field list'
Error Number  : 1054
Request Date  : Wednesday, June 23rd 2010 @ 11:56:40 PM
Error Date    : Wednesday, June 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 

[FaiSao]

Please ,,