User created error in Db.

[mikem164]

Hi, I got an email with this Error, from my error log reporting. Any guess's what he did? I do NOT have Vb Suite, so CMS is NOT active, right? Yet errors show it came from that way. Thanks for input.


Database error in vBulletin 4.1.0:

Invalid SQL:

SELECT administrator.*,
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
language.phrasegroup_global AS phrasegroup_global,
language.phrasegroup_vbcms AS phrasegroup_vbcms,
language.phrasegroup_global AS phrasegroup_global,
language.phrasegroup_cpcms AS phrasegroup_cpcms,
language.phrasegroup_cphome AS phrasegroup_cphome,
language.phrasegroup_cpglobal AS phrasegroup_cpglobal,
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 user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN administrator AS administrator ON (administrator.userid = user.userid) LEFT JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid))

WHERE user.userid = 21;

MySQL Error : Unknown column 'language.phrasegroup_cpcms' in 'field list'
Error Number : 1054
Request Date : Friday, April 15th 2011 @ 08:11:32 PM
Error Date : Friday, April 15th 2011 @ 08:11:32 PM
Script : http://mysite/elite/admincp/cms_content_admin.php?do=category
Referrer : http://mysite/elite/search.php?searchid=34501

[Lynne]

Try disabling your modifications/plugins and see if you still have this problem.
Note: To temporarily disable the plugin system, edit includes/config.php and add this line right under <?php

define('DISABLE_HOOKS', true);

Why do you have cms files (admincp/cms_content_admin.php) if you don't have the cms? Did you used to have the cms installed?

[mikem164]

Ok, Found out one of the admins Clicked on the hack "admin tools" which is a drop down in subnavbar... edit blogs, cmsmanager, etc. was an option.

while we are on the topic, is it possible to add CMS to Regular Vb? Thanks Lynne.

[Lynne]

you can only add the CMS is you upgrade to the Suite and then install that.

[mikem164]

I know I should be on .com and ask, but you'll probly answer there too :) What's entailed on the upgrade? Will I lose anything? Do templates get changed....(can't have that ;) )

[Lynne]

There are always updated templates on an upgrade. If you read the notices, it tells you which are required reverts and which are just changes. If you upgrade from 4.1.3 forums to 4.1.3 suite, then you are basically just adding two new products to your site - many new template and files.

[mikem164]

Great, thanks lynne, gonna check it out