vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Forum Home Enhancements - Member Visit Tracking (https://vborg.vbsupport.ru/showthread.php?t=232636)

dosadno 02-03-2010 08:19 AM

I have a problem with setining premissions in usergrou manager, i get this error

Where is the problem?
Code:

Database error in vBulletin 4.0.1:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
        `title` = 'Administrators',
        `description` = '',
        `usertitle` = 'Administrator',
        `opentag` = '<span style=\"color: #3333FF;\">',
        `closetag` = '</span>',
        `passwordexpires` = '0',
        `passwordhistory` = '0',
        `edithistorypermissions` = '0',
        `forumpermissions` = '16777215',
        `genericpermissions` = '2113929151',
        `attachlimit` = '0',
        `pmquota` = '5000',
        `pmpermissions` = '4',
        `pmsendmax` = '50',
        `pmthrottlequantity` = '0',
        `calendarpermissions` = '63',
        `wolpermissions` = '31',
        `adminpermissions` = '3',
        `genericpermissions2` = '1',
        `genericoptions` = '63',
        `profilepicmaxwidth` = '100',
        `profilepicmaxheight` = '100',
        `profilepicmaxsize` = '65535',
        `avatarmaxwidth` = '130',
        `avatarmaxheight` = '110',
        `avatarmaxsize` = '20000',
        `signaturepermissions` = '237567',
        `sigpicmaxwidth` = '500',
        `sigpicmaxheight` = '100',
        `sigpicmaxsize` = '20000',
        `sigmaxrawchars` = '0',
        `sigmaxchars` = '0',
        `sigmaxlines` = '0',
        `sigmaxsizebbcode` = '7',
        `sigmaximages` = '0',
        `albumpermissions` = '255',
        `albumpicmaxwidth` = '600',
        `albumpicmaxheight` = '600',
        `albummaxpics` = '100',
        `albummaxsize` = '0',
        `usercsspermissions` = '63',
        `visitormessagepermissions` = '63',
        `socialgrouppermissions` = '262143',
        `maximumsocialgroups` = '5',
        `groupiconmaxsize` = '65535',
        `trmpermissions` = '15'
WHERE usergroupid=6;

MySQL Error  : Unknown column 'edithistorypermissions' in 'field list'
Error Number  : 1054
Request Date  : Wednesday, February 3rd 2010 @ 11:15:57 AM
Error Date    : Wednesday, February 3rd 2010 @ 11:15:57 AM
Script        : http://www.xxxxxxxxx.com/forum/admincp/usergroup.php?do=update
Referrer      : http://www.xxxxxxxxx.com/forum/admincp/usergroup.php?do=edit&usergroupid=6
IP Address    : xxxxxxx
Username      : xxxxxxxx
Classname    : vB_Database
MySQL Version : 5.1.40-log


Paul M 02-03-2010 11:00 AM

That has nothing to do with this modifcation, you have not correctly uninstalled another mod (edithistory, according to the error).

Toni3055 02-08-2010 09:44 PM

Just installed this and Who Read This Thread. Love them both! Thank you, Paul!

mummy 02-11-2010 10:18 AM

Quote:

Originally Posted by dosadno (Post 1973759)
I have a problem with setining premissions in usergrou manager, i get this error

Where is the problem?
Code:

Database error in vBulletin 4.0.1:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
        `title` = 'Administrators',
        `description` = '',
        `usertitle` = 'Administrator',
        `opentag` = '<span style=\"color: #3333FF;\">',
        `closetag` = '</span>',
        `passwordexpires` = '0',
        `passwordhistory` = '0',
        `edithistorypermissions` = '0',
        `forumpermissions` = '16777215',
        `genericpermissions` = '2113929151',
        `attachlimit` = '0',
        `pmquota` = '5000',
        `pmpermissions` = '4',
        `pmsendmax` = '50',
        `pmthrottlequantity` = '0',
        `calendarpermissions` = '63',
        `wolpermissions` = '31',
        `adminpermissions` = '3',
        `genericpermissions2` = '1',
        `genericoptions` = '63',
        `profilepicmaxwidth` = '100',
        `profilepicmaxheight` = '100',
        `profilepicmaxsize` = '65535',
        `avatarmaxwidth` = '130',
        `avatarmaxheight` = '110',
        `avatarmaxsize` = '20000',
        `signaturepermissions` = '237567',
        `sigpicmaxwidth` = '500',
        `sigpicmaxheight` = '100',
        `sigpicmaxsize` = '20000',
        `sigmaxrawchars` = '0',
        `sigmaxchars` = '0',
        `sigmaxlines` = '0',
        `sigmaxsizebbcode` = '7',
        `sigmaximages` = '0',
        `albumpermissions` = '255',
        `albumpicmaxwidth` = '600',
        `albumpicmaxheight` = '600',
        `albummaxpics` = '100',
        `albummaxsize` = '0',
        `usercsspermissions` = '63',
        `visitormessagepermissions` = '63',
        `socialgrouppermissions` = '262143',
        `maximumsocialgroups` = '5',
        `groupiconmaxsize` = '65535',
        `trmpermissions` = '15'
WHERE usergroupid=6;

MySQL Error  : Unknown column 'edithistorypermissions' in 'field list'
Error Number  : 1054
Request Date  : Wednesday, February 3rd 2010 @ 11:15:57 AM
Error Date    : Wednesday, February 3rd 2010 @ 11:15:57 AM
Script        : http://www.xxxxxxxxx.com/forum/admincp/usergroup.php?do=update
Referrer      : http://www.xxxxxxxxx.com/forum/admincp/usergroup.php?do=edit&usergroupid=6
IP Address    : xxxxxxx
Username      : xxxxxxxx
Classname    : vB_Database
MySQL Version : 5.1.40-log


I have the same problem

Paul M 02-11-2010 11:12 AM

... and the answer is also the same (post #52).

SpankMe 02-24-2010 04:34 AM

Upgraded to 4.0.2 and no one can access the forum page with IE8. All other browsers ok. I disabled this mod, and IE8 can access the forums page again,

Dennis Kaczor 03-14-2010 04:11 PM

Paul, I was checking to see if there was any updates and noticed that I had version 4.0.5 and you had an update to 4.0.7. Downloaded and installed and got this error below

Item no longer shows in the plugins, and the program seems to be still showing on the forum page. Can you please advise on how I can correct this. vb 4.0.2 First time I have ever had an issue with your stuff, but always a first time, and thanks in advance

PHP Code:

Database error in vBulletin 4.0.2:

Invalid SQL:

            
UPDATE template SET
                styleid 
= -10
            WHERE product 
'paulm_trm_40' AND styleid = -1;

MySQL Error   Duplicate entry 'Display_Memberview--10-template' for key 2
Error Number  
1062
Request Date  
SundayMarch 14th 2010 12:41:30 PM
Error Date    
SundayMarch 14th 2010 12:41:36 PM
Script        
http://www.XXXXXXXX.com/forums/admincp/plugin.php?do=productimport
Referrer      http://www.XXXXXXXX.com/forums/admincp/plugin.php?do=productadd
IP Address    XX.XXX.XXXX.X
Username      
XXXXX
Classname     
vB_Database_MySQLi
MySQL Version 
5.0.82-msl-usrs-sure2-log 


Paul M 03-14-2010 04:20 PM

This is a vb issue, please see the announcement.

https://vborg.vbsupport.ru/announcement.php?a=47

Dennis Kaczor 03-14-2010 04:28 PM

Quote:

Originally Posted by Paul M (Post 2003494)
This is a vb issue, please see the announcement.

https://vborg.vbsupport.ru/announcement.php?a=47

Thank you Paul fix the problem.

Dennis

parks72 03-16-2010 12:40 AM

great one thanks............


All times are GMT. The time now is 01:22 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.01287 seconds
  • Memory Usage 1,765KB
  • 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
  • (2)bbcode_code_printable
  • (1)bbcode_php_printable
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)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