vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Quick SQL Help (https://vborg.vbsupport.ru/showthread.php?t=75700)

Kaldes 02-04-2005 02:31 AM
Quick SQL Help
 
I'm getting this error from a mod I installed then remove, obviously a part is still there
Code:
Database error in vBulletin 3.0.6:

Invalid SQL: UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
      title = 'Registered Users',
      description = '',
      usertitle = '',
      opentag = '',
      closetag = '',
      passwordexpires = '0',
      passwordhistory = '0',
      gtpcanreadcontent = '0',
      attachlimit = '0',
      avatarmaxwidth = '120',
      avatarmaxheight = '120',
      avatarmaxsize = '20000',
      profilepicmaxwidth = '100',
      profilepicmaxheight = '100',
      profilepicmaxsize = '65535',
      pmquota = '50',
      pmsendmax = '5',
      forumpermissions = '53759',
      pmpermissions = '3',
      calendarpermissions = '19',
      wolpermissions = '1',
      adminpermissions = '0',
      genericpermissions = '267843',
      genericoptions = '31'
WHERE usergroupid=2
mysql error: Unknown column 'gtpcanreadcontent' in 'field list'

mysql error number: 1054
So obviously I have to "gtpcanreadcontent" and remove it, but for some reason I can not find it.

Zachery 02-04-2005 02:51 AM
its in one of the cron files in /includes/cron

Kaldes 02-04-2005 03:06 AM
Strange I looked, but no luck...

Dean C 02-04-2005 09:48 AM
You obviously haven't removed all file changes on that modification. Go back and make sure that all the changes you made to each file are reversed.


All times are GMT. The time now is 08:16 PM.

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.01016 seconds
  • Memory Usage 1,711KB
  • 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)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (4)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