database error

[dcraftjr]

ok when i try to access my cmps_index.php, like www.mydomain.com/forums/cmps_index.php, i get this error:

There seems to have been a slight problem with the dcraftjr database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

So then when i go to my email it says this:

Database error in vBulletin 3.0.3:

Invalid SQL:
SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
language.phrasegroup_calendar AS phrasegroup_calendar,
language.phrasegroup_adv_portal AS phrasegroup_adv_portal,
language.phrasegroup_postbit AS phrasegroup_postbit,
language.phrasegroup_global AS phrasegroup_global,
language.options AS lang_options,
language.languagecode AS lang_code,
language.charset AS lang_charset,
language.locale AS lang_locale,
language.imagesoverride AS lang_imagesoverride,
language.dateoverride AS lang_dateoverride,
language.timeoverride AS lang_timeoverride,
language.registereddateoverride AS lang_registereddateoverride,
language.calformat1override AS lang_calformat1override,
language.calformat2override AS lang_calformat2override,
language.logdateoverride AS lang_logdateoverride,
language.decimalsep AS lang_decimalsep,
language.thousandsep AS lang_thousandsep
FROM vb3_user AS user
LEFT JOIN vb3_userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN vb3_usertextfield AS usertextfield ON (usertextfield.userid = user.userid) INNER JOIN vb3_language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid))
WHERE user.userid = 1

mysql error: Unknown column 'language.phrasegroup_adv_portal' in 'field list'

mysql error number: 1054


Its prolly saying something about a file but im not sure what it is and what do i have to edit. If you need more information like the file text that needs to be edited, tell me.

I have had this problem many times even though i reinstalled vbulletin. Any help will be really appreciated.

Thanks and great program from what i have seen,
dCrAfTJR



ALSO BTW, if i installed a vbulletin style, will it merge with the vbadvanced portal?

[dcraftjr]

help brian.... ur the best person here..

[Our Sponsors]

[Brian]

Looks like you didn't run the install file...

[dcraftjr]

lol....when i read the readme, it never told me anything about the install file.

[Our Sponsors]

[Brian]

Step 5 - Run the Install Script
Now you're almost done! It's time to add the vBadvanced CMPS settings and templates. Run the install script from your browser by going to http://yoursite.com/forum/admincp/vbacmps_install.php.
This script will make all necessary changes to your database and install the templates, phrases, settings, and etc for you. Once the script is done go to your Admin CP and you will see a new group of options called "vBadvanced CMPS". That is where you will modify the settings, add/edit modules, and add/edit new pages.

For more information on how to use your new script, please see the User's Manual available at vbadvanced.com.

[dcraftjr]

lol. probably got blinded when that happened since im always in a hurry to install it. Cause before i got it to work but i had this errno2 error which i just fixed. Thx brian, your too awesome :)