| Author |
 Topic  |
|
|
Webbo
Average Member
United Kingdom
982 Posts |
 Posted - 02 November 2008 : 07:55:47
|
I've added this Mod to my forums but when trying to set up a default group using the exisiting members (nearly 11,000) the maximum number of members it allows into the group is 500
I've made a change to selectbox.js (line 107) to increase the count from 500 to 20000 as so:
function selectAllOptions(obj) {
var iMax = 20000;
var iMaxCounter = obj.options.length;
if (iMaxCounter > iMax) {
iMaxCounter = iMax;
...but for some reason I cannot add more than 500 into the database (MySql)
Has anyone else experienced this problem and if so how was it fixed?
Thanks< |
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 02 November 2008 : 10:15:26
|
| That issue isn't part of the UserGroup mod, unless it's possibly the lack of pagination which is causing it.< |
 |
|
|
Webbo
Average Member
United Kingdom
982 Posts |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 02 November 2008 : 11:07:14
|
off hand I think this is a problem with the code that moves members from one listbox to another, I remember this being a problem in the base code at one time, so if it is using the same javascript code then that is likely to be the issue.
unless you are specifically getting a database error it is unlikely to be the database that is causing the problem.
what size is the filed in the db ? it needs to be big enough to contain all the 500 members id's so will need to be pretty big< |
MVC .net dev/test site | MVC .net running on Raspberry Pi |
|
|
|
Etymon
Advanced Member
United States
2385 Posts |
Posted - 02 November 2008 : 11:16:20
|
| Though a bit clunky, you could make individual groups that contain 500 each and then include each usergroup into your target usergroup.< |
|
|
|
Podge
Support Moderator
Ireland
3775 Posts |
|
|
Webbo
Average Member
United Kingdom
982 Posts |
Posted - 02 November 2008 : 11:34:16
|
Hi HuwR
As far as I know there are no restrictions on the size of the table in the database, and it seems to be functioning okay
Using the admin options in the mod I cannot add more than 500 members in total to the database table even if I move them one at a time
I can take one away to total 499 and then add one back, but if I add two then only one gets added, limiting at 500
Would you know what query I would need to use within phpMyAdmin to add all the members into USERGROUP_ID = 4 within the table and set their respective MEMBER_TYPE and MEMBER_ID ?
This wouldn't solve the problem but at least it would test the database< |
Edited by - Webbo on 02 November 2008 11:34:32 |
|
|
|
Webbo
Average Member
United Kingdom
982 Posts |
Posted - 02 November 2008 : 13:03:43
|
I've just added 2 new rows into the database table using the following with no problems:
INSERT INTO `forum_usergroup_users` (`USERGROUP_ID`, `MEMBER_ID`, `MEMBER_TYPE`) VALUES ('4', '11000', '1')
INSERT INTO `forum_usergroup_users` (`USERGROUP_ID`, `MEMBER_ID`, `MEMBER_TYPE`) VALUES ('4', '11001', '1')
...and the rows have been added successfully, so it must be a problem somewhere within the code< |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 02 November 2008 : 13:24:59
|
quote:
Originally posted by Podge
I think the 500 user restriction was to prevent javascript memory problems within the browser.
yes, I agree, but webbo says he changed it to var iMax = 20000;
webbo if you made the above change than you may need to clear your browser cache, .js files are cached locally by default so your browser may not have picked up the change< |
MVC .net dev/test site | MVC .net running on Raspberry Pi |
|
|
|
Webbo
Average Member
United Kingdom
982 Posts |
Posted - 02 November 2008 : 15:34:59
|
HuwR - clearing the cache has worked and all 11,240 records were added to the database 
Only problem is now it takes that long to populate the webpages in admin options they time out, but that's not a problem now that I know it works
Many thanks everyone< |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
|
|
Webbo
Average Member
United Kingdom
982 Posts |
Posted - 02 November 2008 : 16:13:57
|
Lol
< |
|
|
| |
Topic |
|
Topic Locked
