vb.org Archive
Page 7 of 18 « First 56 7 8917 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Administrative and Maintenance Tools - Username Request (https://vborg.vbsupport.ru/showthread.php?t=149377)

King Kovifor 09-09-2007 06:20 PM
Updated.

BBF 09-09-2007 06:40 PM
when i am try to upload the xml file (with overwrite) i get this error:
Quote:
Database error in vBulletin 3.6.8:

Invalid SQL:
ALTER TABLE `usergroup` ADD `unreq_perms` INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL;

MySQL Error : Duplicate column name 'unreq_perms'
Error Number : 1060
Date : Sunday, September 9th 2007 @ 10:38:44 PM
Script : http://www.root.co.il/forums/admincp...=productimport
Referrer : http://www.root.co.il/forums/admincp...?do=productadd
IP Address : 84.229.*.*
Username : Smile
Classname : vb_database

King Kovifor 09-09-2007 06:44 PM
Edit the .xml file on your hard drive. Change this code:

HTML Code:
                        <installcode><![CDATA[$vbulletin->db->query("ALTER TABLE `" . TABLE_PREFIX . "usergroup` ADD `unreq_perms` INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL") ;]]></installcode>
to:

HTML Code:
                        <installcode><![CDATA[//$vbulletin->db->query("ALTER TABLE `" . TABLE_PREFIX . "usergroup` ADD `unreq_perms` INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL") ;]]></installcode>
That should fix your problem if you are getting that error.

BBF 09-09-2007 06:52 PM
Quote:
Originally Posted by King Kovifor (Post 1335629)
Edit the .xml file on your hard drive. Change this code:

HTML Code:
                        <installcode><![CDATA[$vbulletin->db->query("ALTER TABLE `" . TABLE_PREFIX . "usergroup` ADD `unreq_perms` INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL") ;]]></installcode>
to:

HTML Code:
                        <installcode><![CDATA[//$vbulletin->db->query("ALTER TABLE `" . TABLE_PREFIX . "usergroup` ADD `unreq_perms` INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL") ;]]></installcode>
That should fix your problem if you are getting that error.
it's doesn't work :(

King Kovifor 09-09-2007 06:56 PM
OK. Try to remove:
PHP Code:
$vbulletin->db->query("ALTER TABLE `" . TABLE_PREFIX . "usergroup` ADD `unreq_perms` INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL"); 
from the code all together. Since you installed 1.0.4 and it was in there (trying to re add it since some people didn't install 1.0.4).

BBF 09-09-2007 07:01 PM
ok it's works :)
i am just remove the previous version and install this version :)
hope it's work fine

Stifler 09-09-2007 07:03 PM
hmm.. where do u set usergroup permissions? the new version seems to have borked my permissions..

King Kovifor 09-09-2007 07:03 PM
That should work too.

King Kovifor 09-09-2007 07:06 PM
Quote:
Originally Posted by Stifler (Post 1335643)
hmm.. where do u set usergroup permissions? the new version seems to have borked my permissions..
User group permissions should be under usergroup permissions. Are they not there? I have had this installed by several people and they have had not trouble.

BBF 09-09-2007 07:08 PM
when i try to edit usergroup permissions i get this error:
Quote:
Database error in vBulletin 3.6.8:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'משתמש רשום',
`description` = '',
`usertitle` = '',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`unreq_perms` = '2',
`forumpermissions` = '782847',
`attachlimit` = '0',
`pmquota` = '50',
`pmpermissions` = '3',
`pmsendmax` = '5',
`calendarpermissions` = '63',
`wolpermissions` = '1',
`adminpermissions` = '0',
`genericpermissions` = '472389319',
`genericoptions` = '62',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '80',
`avatarmaxheight` = '80',
`avatarmaxsize` = '20000',
`signaturepermissions` = '237567',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '20000',
`sigmaxrawchars` = '1000',
`sigmaxchars` = '500',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '4'
WHERE usergroupid=2;

MySQL Error : Unknown column 'unreq_perms' in 'field list'
Error Number : 1054
Date : Sunday, September 9th 2007 @ 11:06:08 PM
Script : http://www.root.co.il/forums/admincp....php?do=update
Referrer : http://www.root.co.il/forums/admincp...&usergroupid=2
IP Address : 84.229.*.*
Username : Smile
Classname : vb_database
my mysql version is 4.1.22

King Kovifor 09-09-2007 07:11 PM
It looks like you removed the install code, but was not receiving the error that I said you should need to install. Run the following query through your ACP:

[sql]ALTER TABLE `usergroup` ADD `unreq_perms` INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL[/sql]

Be sure to add your table prefix to usergroup.

BBF 09-09-2007 07:16 PM
now i doesn't get errors but the permissions doesn't update

zell_11 09-09-2007 07:19 PM
I've installed this modification and am still getting permission errors. ive reinstalled it twice already. If there anyway i can install it manually.

FireFish 09-09-2007 08:50 PM
Same problem here.
I made all modifications & followed all steps discussed above.
I think a 1.0.7 is due that has an installer that works & a user permissions edit that works too as these are the two problems I'm also facing.

For now, I disabled it.

King Kovifor; I certainly appreciate your work in putting this module together as it is a nice idea for a plugin. Would it be difficult to update it again so that the installer works & user permissions work without much manual adjustments?

jellybaby 09-09-2007 09:31 PM
I just get the following - even though I have enabled permissions to change

Username Request Permissions: Your group does not have the necessary permissions required to request a username change.

King Kovifor 09-09-2007 09:42 PM
Quote:
Originally Posted by BBF (Post 1335657)
now i doesn't get errors but the permissions doesn't update
It isn't updating? At All?

Quote:
Originally Posted by zell_11 (Post 1335661)
I've installed this modification and am still getting permission errors. ive reinstalled it twice already. If there anyway i can install it manually.
Are you sure that all the plugins / files / install codes were updated?

Quote:
Originally Posted by FireFish (Post 1335718)
Same problem here.
I made all modifications & followed all steps discussed above.
I think a 1.0.7 is due that has an installer that works & a user permissions edit that works too as these are the two problems I'm also facing.

For now, I disabled it.

King Kovifor; I certainly appreciate your work in putting this module together as it is a nice idea for a plugin. Would it be difficult to update it again so that the installer works & user permissions work without much manual adjustments?
I have had several people install this and have had no trouble once so ever... I am starting to hate this modification. <<

Quote:
Originally Posted by jellybaby (Post 1335760)
I just get the following - even though I have enabled permissions to change

Username Request Permissions: Your group does not have the necessary permissions required to request a username change.
Are you sure that you have updated plugins? If you can look through your "Username Request" plugin and see if the permissions read:

$vbulletin->bf_upg_unreq_perms['canchangeun'];

Thanks.

Stifler 09-09-2007 11:59 PM
we all are using modified admincp templates.. my only guess..

BBF 09-10-2007 05:05 AM
yes, i check it again.
for example:
i do that usergroups Members can edit their username.
and i got this error:
Username Request Permissions: Your group does not have the necessary permissions required to request a username change.

so it's doesn't update the permissions

jellybaby 09-10-2007 05:40 AM
Quote:
Originally Posted by King Kovifor (Post 1335769)


Are you sure that you have updated plugins? If you can look through your "Username Request" plugin and see if the permissions read:

$vbulletin->bf_upg_unreq_perms['canchangeun'];

Thanks.
I did this as a fresh install

jellybaby 09-10-2007 06:42 PM
Has anyone managed to resolve this

King Kovifor 09-10-2007 06:51 PM
Quote:
Originally Posted by jellybaby (Post 1335958)
I did this as a fresh install
Odd.

Quote:
Originally Posted by BBF (Post 1335945)
yes, i check it again.
for example:
i do that usergroups Members can edit their username.
and i got this error:
Username Request Permissions: Your group does not have the necessary permissions required to request a username change.

so it's doesn't update the permissions
Weird. Rebuiding the bitfields should have added it to the update list...

Quote:
Originally Posted by Stifler (Post 1335835)
we all are using modified admincp templates.. my only guess..
Nothing in the ACP should have been modified by code...

zell_11 09-10-2007 06:52 PM
Quote:
Originally Posted by King Kovifor (Post 1335769)
Are you sure that all the plugins / files / install codes were updated?
Yeah. I tried installing it a few times myself. A few others, that use this account as well, reinstalled it to see if I messed up, since I'm sort of new to this kinda thing. But they couldn't get it to work either. It's the darn permissions error that keeps popping up.

King Kovifor 09-10-2007 07:06 PM
You could comment out the permissions in the the plugins (but in the Username History it would show for nobody but the owner.)

Username History Plugin:
REMOVE
PHP Code:
 OR $vbulletin->bf_ugp_unreq_perms['canviewunhistory']; 
from the first line of code.

Username Request:

Comment out this code:
PHP Code:
    if(!$vbulletin->bf_ugp_unreq_perms['can_change_un'])
    {
        unreq_add_error($vbphrase['unreq_perms'], $vbphrase['unreq_perms_txt']);
    } 
and

PHP Code:
    if(!$vbulletin->bf_ugp_unreq_perms['canchangeun'])
    {
        unreq_add_error($vbphrase['unreq_perms'], $vbphrase['unreq_perms_txt']);
    } 
To Comment out lines of php, add "//" in front of the line.

BBF 09-10-2007 07:33 PM
i reinstalled the mod and nothing changed

johnrizz 09-10-2007 07:44 PM
Question! I downloaded the zip file but when I unzip it I get nothing but error's? not sure what to do here...
error 25235

King Kovifor 09-10-2007 07:52 PM
On your computer? I'm a Mac OS X user, so I don't know what error 25235 is or how to fix it.

johnrizz 09-10-2007 08:17 PM
Thats just a "error opening file" error 25235. Would it be possible that the zip file is corrupted?

King Kovifor 09-10-2007 11:19 PM
Um. Any Windows User know how to fix that? And I have been pointed out in the errors of my ways. So I will be releasing v1.0.7 very shortly.

Thanks Paul M!

johnrizz 09-10-2007 11:24 PM
I can wate for v1.0.7 its no biggie... thanks man!

FireFish 09-10-2007 11:35 PM
Seriously, King Kovifor;

Can we expect a 1.0.7 that works? I know you replied to my post that many people have it working fine; i just wish they posted here in this thread so that we can get advice as to how they got it working.

I, like everyone else here, is stuck at the Usergroup Permissions Error, whether the group does or doesn't have the permissions to change username. I tried running the SQL too, nothing.

Can you please do us all a great service by making a 1.0.7 that works?

Maybe strip out features since 1.0.4; as the 1.0.4 worked fine.

:up: ---->Can you at least PM me & maybe e-mail me a copy of 1.0.4 so that I can get it working for now until these issues are resolved? :(

I would be very greatful if you could at least send me the 1.0.4 or post a download link for it so I can uninstall & reinstall it knowing it'll work for now.

Thanks again! I appreciate your efforts in developing this mod.

King Kovifor 09-10-2007 11:40 PM
Quote:
Originally Posted by FireFish (Post 1336607)
Seriously, King Kovifor;

Can we expect a 1.0.7 that works? I know you replied to my post that many people have it working fine; i just wish they posted here in this thread so that we can get advice as to how they got it working.

I, like everyone else here, is stuck at the Usergroup Permissions Error, whether the group does or doesn't have the permissions to change username. I tried running the SQL too, nothing.

Can you please do us all a great service by making a 1.0.7 that works?

Maybe strip out features since 1.0.4; as the 1.0.4 worked fine.

:up: ---->Can you at least PM me & maybe e-mail me a copy of 1.0.4 so that I can get it working for now until these issues are resolved? :(

I would be very greatful if you could at least send me the 1.0.4 or post a download link for it so I can uninstall & reinstall it knowing it'll work for now.

Thanks again! I appreciate your efforts in developing this mod.
My Permissions errors were in the way I was checking it. The way I wrote the code (and misinterpreted how the bit fields work), it was always going to come out as a "1", returning true. This gave the results your gave.

Paul M pointed out all my mistakes and how to fix it, meaning that it should work, and I 99.99% sure that this will work. I think if it doesn't, I will ask someone to come on board for permissions who knows how to do them.

FireFish 09-10-2007 11:48 PM
Quote:
Originally Posted by King Kovifor (Post 1336608)
My Permissions errors were in the way I was checking it. The way I wrote the code (and misinterpreted how the bit fields work), it was always going to come out as a "1", returning true. This gave the results your gave.

Paul M pointed out all my mistakes and how to fix it, meaning that it should work, and I 99.99% sure that this will work. I think if it doesn't, I will ask someone to come on board for permissions who knows how to do them.
Hallelujah! Uninstalled the mod, Downloaded today's 1.0.7, uploaded new files & installed.

**** It works!!!! ****

Thanks King! :)

King Kovifor 09-10-2007 11:50 PM
Your welcome. And I feel like an idiot for actually making the mistakes. :D Glad these worked. I hope to expand on the actual feature set, permissions, and ease of use on everyone in v1.1.x! Any feature suggestions would be welcomed!

Kaleem 09-11-2007 12:46 AM
Code:

Invalid SQL:
ALTER TABLE `usergroup` ADD `unreq_perms` INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL;

MySQL Error  : Duplicate column name 'unreq_perms'
Error Number : 1060
I get thsi error when i try to upgrade

GekkoPixie 09-11-2007 12:52 AM
Quote:
Originally Posted by LightInClouds (Post 1336640)
Code:

Invalid SQL:
ALTER TABLE `usergroup` ADD `unreq_perms` INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL;

MySQL Error  : Duplicate column name 'unreq_perms'
Error Number : 1060
I get thsi error when i try to upgrade
Same here.

SuperTaz 09-11-2007 03:59 AM
Edit: Found the issue

FireFish 09-11-2007 04:09 AM
Quote:
Originally Posted by LightInClouds (Post 1336640)
Code:

Invalid SQL:
ALTER TABLE `usergroup` ADD `unreq_perms` INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL;

MySQL Error  : Duplicate column name 'unreq_perms'
Error Number : 1060
I get thsi error when i try to upgrade
Try uninstalling the previous version altogether first. Then, install fresh.

FreshFroot 09-11-2007 04:40 AM
just a nice feature would be if anytime a username is changed, it saves the old username in their user notes, each time they have their names changed.

jellybaby 09-11-2007 05:32 AM
Sorry but it still doesnt work for me, I have the permissions problem

Just to say I have uninstalled and re-installed new version and checked permissions several times.

BigDog56 09-11-2007 07:33 AM
Installed the mod, no problems. Now I'll have to wait for someone to request a change before I know it's working without a hitch. Nice mod. Thank you very much for the time you spent creating it! :up:


All times are GMT. The time now is 04:08 AM.
Page 7 of 18 « First 56 7 8917 Last »
Show 40 post(s) from this thread on one page

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.02160 seconds
  • Memory Usage 1,856KB
  • 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
  • (3)bbcode_code_printable
  • (4)bbcode_html_printable
  • (4)bbcode_php_printable
  • (17)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
  • (40)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