DB Errors

[shadowdancer36]

Not sure if this is a bug or if I'm doing something wrong within my install, BUT...Once VBA is installed, for some odd reason the link showing where you are within the VB tree (right above the menu bar, showing the main forum, sub-forum, sub-sub forum, etc) is sending me to my root. Then I recieve a DB error.

<!--
Database error in vBulletin 3.6.4:

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 vb_user AS user
		LEFT JOIN vb_userfield AS userfield ON (user.userid = userfield.userid)
		LEFT JOIN vb_usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN vb_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'
Error Number : 1054
Date         : Thursday, January 11th 2007 @ 09:46:39 AM
Script       : http://www.picturemeclubbing.com/cmps_index.php
Referrer     : 
IP Address   : 68.74.2.163
Username     : 
Classname    : vb_database
-->

Everything else links up fine and syncs well with VB. It's just that annoying little thing.

I was trying to do a screen capture but my photoshop is messed up. You can check it out here tho:

http://www.picturemeclubbing.com/dem...cmps_index.php

[Brian]

The navbar link is controlled by your "Forum URL" setting under your main vB options. I'm assuming you've figured that out now though since it seems to be pointing to your forums.
As for the DB error, it looks like somebody tried to view the page before the install script was run.

[shadowdancer36]

Maybe this will make more sense? Notice how the link is pointing to the root of the domain instead of the root of my folder? Why is this? Everything else works fine in the Navbar and other links. Just that part is messed up. Not to mention it's a DB error.

[Brian]

The PMC link you've circled there is pointing to http://www.picturemeclubbing.com/demo/forum/index.php for me...

[shadowdancer36]

What the hell? Are u serious? I just tried it twice in two different browers and all my temp files and cookies erased!

[shadowdancer36]

The where? Excuse the typos (lol)



As you can see, on my end I get the wrong path in each browser. Where does that folder pull the link from exactly?

[Brian]

Sorry, I was looking at the pages where "PMC" was actually a link and didn't notice the little folder icon. It looks like that might be due to your CMPS URL setting. Go to Admin CP => vBa CMPS => Default Settings => CMPS URL and make sure you have that option set to the full URL to your cmps_index.php file.

[shadowdancer36]

Ok that fixed the problem, but why did it occur? Shouldn't it have pulled it during the install?

[Brian]

No, it's just set to "/cmps_index.php" by default since that's where the file is instructed to be uploaded during a new install. Many people will place it in another location as well though, and there's really not a way to automatically find it.