vBulletin 4.2.5 is end of life and will not be receiving any future development. Warning: vBulletin 4.2.5 is not compatible with PHP 7.2.0 or higher.
Welcome to the vBulletin support forums! In our community forums you can receive professional support and assistance with any issues you might have with your vBulletin Products.
If you are having problems posting in the relevant areas for your software, please see this topic.
Upgrade to vBulletin 5
We're pleased to announce a special promotion for upgrading your vBulletin 3/4 sites to vBulletin 5. From now until December 31st, we are offering vBulletin 5 license upgrades at $169 each. This promotion is available to all vBulletin 3 (owned) and vBulletin 4 license holders, entitling you to the latest version of vBulletin 5.
If you would like to purchase this upgrade, please log into the vBulletin Members Area and use Promo Code: vB5UPGRADE during checkout to apply the discount.
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
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.
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
Upgrading to 5.0.1 Alpha 2
----------------------------------
Step 35 -
Database error in vBulletin 5.0.1 Alpha 1:
...
Wed 3rd Apr '13, 7:41am
Working...
X
We process personal data about users of our site, through the use of cookies and other technologies, to deliver our services, personalize advertising, and to analyze site activity. We may share certain information about our users with our advertising and analytics partners. For additional details, refer to our Privacy Policy.
By clicking "I AGREE" below, you agree to our Privacy Policy and our personal data processing and cookie practices as described therein. You also consent to the transfer of your data to our servers in the United States, where data protection laws may be different from those in your country.
Comment