vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   User created error in Db. (https://vborg.vbsupport.ru/showthread.php?t=262098)

mikem164 04-16-2011 02:22 PM
User created error in Db.
 
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.

Code:
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 04-16-2011 04:30 PM
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

PHP Code:
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 04-16-2011 09:14 PM
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 04-16-2011 09:20 PM
you can only add the CMS is you upgrade to the Suite and then install that.

mikem164 04-16-2011 11:06 PM
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 04-16-2011 11:23 PM
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 04-17-2011 12:11 AM
Great, thanks lynne, gonna check it out


All times are GMT. The time now is 09:47 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01092 seconds
  • Memory Usage 1,724KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (1)bbcode_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (7)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete