vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.7 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=228)
-   -   Add-On Releases - PS - HelpCenter (https://vborg.vbsupport.ru/showthread.php?t=176367)

Tettinntil 05-26-2008 06:17 AM

I only get this error when I try to edit usergroups
Quote:

Database error in vBulletin 3.7.0:

Invalid SQL:
UPDATE vbulletinusergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Administrators',
`description` = '',
`usertitle` = 'Administrator',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '180',
`passwordhistory` = '360',
`pm_search` = '1',
`vbblog_general_permissions` = '126',
`vbblog_entry_permissions` = '24188',
`vbblog_comment_permissions` = '990',
`forumpermissions` = '8388607',
`genericpermissions` = '2147483583',
`attachlimit` = '0',
`pmquota` = '1000',
`pmpermissions` = '7',
`pmsendmax` = '15',
`calendarpermissions` = '63',
`wolpermissions` = '31',
`adminpermissions` = '3',
`genericpermissions2` = '1',
`genericoptions` = '63',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '100',
`avatarmaxheight` = '100',
`avatarmaxsize` = '20000',
`signaturepermissions` = '245759',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '20000',
`sigmaxrawchars` = '0',
`sigmaxchars` = '0',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '0',
`albumpermissions` = '255',
`albumpicmaxwidth` = '600',
`albumpicmaxheight` = '600',
`albumpicmaxsize` = '100000',
`albummaxpics` = '100',
`albummaxsize` = '0',
`usercsspermissions` = '31',
`favsmiliepermissions` = '1',
`visitormessagepermissions` = '63',
`socialgrouppermissions` = '511',
`fcpermissions` = '8',
`ugphelpcenter` = '8191',
`itraderpermissions` = '7',
`mgccustomusergroupperms` = '0',
`nbmsgshowchatbox` = '',
`mysmiliesvb_permissions` = '1',
`mysmiliesvb_maxwidth` = '60',
`mysmiliesvb_maxheight` = '60',
`mysmiliesvb_maxsize` = '32768',
`mysmiliesvb_totalsmilies` = '50',
`mysmiliesvb_totalsize` = '1048576',
`groupvbmembermap` = '7',
`gb_permissions` = '3',
`unreq_perms` = '3'
WHERE usergroupid=6;

MySQL Error : Unknown column 'mgccustomusergroupperms' in 'field list'
Error Number : 1054

Jase2 05-26-2008 09:09 AM

If you had a previous install, please could you uninstall before trying to install the new updated, product file.

Tettinntil 05-26-2008 09:58 AM

I haven't installed it before. And I've uninstalled and tried to install again several times.

SpeedyHire 05-26-2008 10:05 AM

The hack looks good, only 1 think i dont like and maybe i just not installed it right. When you open a ticket is opens a new thread great, but when you close a ticket it dont close the thread:(:(

dancue 05-26-2008 03:35 PM

Paul or Jase,
I just upgraded to gold and was wondering if the settings were automatically saved from one version to another?

I looked at my settings and they looked like they had been kept the same, but I just want to make sure that I did install it correctly.

Thanks.

---edit---
After looking at the above post about uninstalling before upgrading I realized that I did not do that.
I have not gotten an error thus far, and I can see that the branding is now saying 1.0 gold. Should I still uninstall and then reinstall?

Thanks.

Jase2 05-26-2008 03:49 PM

It should just say: (Powered By HelpCenter Version 1.0)

However, I don't think Paul updated the product file. So, I have posted the product in post #482. There is no need to uninstall then re-install - you can just overwrite, providing you get no errors.

dancue 05-26-2008 03:56 PM

(Powered By HelpCenter Version 1.0 Gold!)

that is what it says on mine. Did I do something wrong?

dancue 05-26-2008 03:59 PM

I think it's Hasann's mod that is changing it to add "Gold!" in there.

Jase2 05-26-2008 06:28 PM

Ah, yes it must be that. Hassan will need to change it.

Tettinntil 05-26-2008 06:47 PM

I'm sorry. It wasn't this mod that caused my error.


All times are GMT. The time now is 03:09 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.02164 seconds
  • Memory Usage 1,742KB
  • 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_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete