vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   vba problem (https://vborg.vbsupport.ru/showthread.php?t=224844)

ukdalai 10-08-2009 06:18 PM
vba problem
 
1 Attachment(s)
hi all, i have a bit of a problem on our forum, all seems ok but on the usergroup edit page i have a box with no title and just yes and no radio buttons, i have not idea what its for.
but it causes a db error when i submit the page.

this only happend after installing a gallery mod, i uninstalled it to see if it would make a difference but it did not.
i can see that its to do with vba but i cant see what the hell the new option on the edit page is.

any help would be greatly appreciated, attached is an image of the offending option in edit usergroup.
does anyone now how i can remove it from the page and the field list
Craig
the error is:

Code:
Invalid SQL:
UPDATE VB_usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
        `title` = 'Administrators',
        `description` = '',
        `usertitle` = 'Administrator',
        `opentag` = '<strong style=\"color:black;\">',
        `closetag` = '</strong>',
        `passwordexpires` = '180',
        `passwordhistory` = '360',
        `ms_wic4_addon_vba_permissions` = '0',
        `forumpermissions` = '16777215',
        `genericpermissions` = '2113929151',
        `attachlimit` = '0',
        `pmquota` = '100',
        `pmpermissions` = '7',
        `pmsendmax` = '25',
        `pmthrottlequantity` = '0',
        `calendarpermissions` = '63',
        `wolpermissions` = '31',
        `adminpermissions` = '3',
        `genericpermissions2` = '1',
        `genericoptions` = '63',
        `profilepicmaxwidth` = '180',
        `profilepicmaxheight` = '180',
        `profilepicmaxsize` = '100000',
        `avatarmaxwidth` = '180',
        `avatarmaxheight` = '180',
        `avatarmaxsize` = '262144',
        `signaturepermissions` = '245759',
        `sigpicmaxwidth` = '500',
        `sigpicmaxheight` = '100',
        `sigpicmaxsize` = '100000',
        `sigmaxrawchars` = '0',
        `sigmaxchars` = '0',
        `sigmaxlines` = '0',
        `sigmaxsizebbcode` = '7',
        `sigmaximages` = '0',
        `albumpermissions` = '255',
        `albumpicmaxwidth` = '600',
        `albumpicmaxheight` = '600',
        `albumpicmaxsize` = '100000',
        `albummaxpics` = '100',
        `albummaxsize` = '0',
        `usercsspermissions` = '63',
        `visitormessagepermissions` = '63',
        `socialgrouppermissions` = '65535',
        `maximumsocialgroups` = '5',
        `groupiconmaxsize` = '100000',
        `ms_wic4_addon_permissions` = '0',
        `fcpermissions` = '8'
WHERE usergroupid=6;

MySQL Error  : Unknown column 'ms_wic4_addon_vba_permissions' in 'field list'
Error Number  : 1054
Request Date  : Thursday, October 8th 2009 @ 09:02:14 PM
Error Date    : Thursday, October 8th 2009 @ 09:02:14 PM
Classname    : vB_Database
MySQL Version : 5.0.45-log

Speysider 10-08-2009 06:19 PM
Did you remove the phrase that contains that text?

Brandon Sheley 10-08-2009 06:20 PM
the title says it's a vbadvanced issue, but you say it's from a gallery mod?
which gallery mod is it

Lynne 10-08-2009 06:31 PM
This should be posted and dealt with over on the vbadvanced site since it is a vbadvanced issue.

ukdalai 10-08-2009 06:41 PM
guys, the reason i say its a vba issue is that the error is ms_wic4_addon_vba_permissions

but i cannot see why its there, i searched the vba forums for "ms_wic4_addon_vba_permissions" but found nothing, i was hopeing someone here would know what ms_wic4_addon_vba_permissions was from or how to remove it from the edit page.

Craig

James Birkett 10-08-2009 06:51 PM
I think the error is basically showing that the column doesn't exist in the table:
MySQL Error : Unknown column 'ms_wic4_addon_vba_permissions' in 'field list'

ukdalai 10-08-2009 07:24 PM
yes... that much i know, i was hoping someone more experienced with vb would be able to tell me how to remove the requirement.

i have removed it by removing to xml files
bitfield_ms_wic4_addon.xml
and
bitfield_ms_wic4_vba_addon.xml

but can anyone tell me what addon they are for

Craig

Lynne 10-08-2009 07:27 PM
Perhaps you installed a mod and then uninstalled it but didn't also delete any files you uploaded for it. You should always delete files uploaded for a mod after you uninstall it.

ukdalai 10-08-2009 07:32 PM
thanks lynne, the weird thing is ive installed UMG gallery, the author is doing some mods for me, but in truth, i decided to uninstall all the UMG stuff to do a reinstall, but then noticed that i had the prob.

i cant see why it has affected the vba xml files.
however removeing the to vba addon xml's has fixed it, i hope there is not a knock on effect.

Craig


All times are GMT. The time now is 10:54 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.00965 seconds
  • Memory Usage 1,730KB
  • 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
  • (9)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