Category Specific Access Restriction (CSAR) - [Support Thread]

[linuxguy2]

zc 1.5.1

When installing "CSAR_install.sql" via the admin "install sql patches"(send) it fails if you have first installed "fec_1-14-2_by Numinixi.
"CSAR_install.sql" Installs just fine on a installation without fec installed.

The error is very generic and I am not getting any debug data in the logs folder.
WARNING: An Error occurred, please refresh the page and try again.

I changed the gID=32 and associated entries from 32 to 36 but no joy....

I'm not a programmer let alone a MySql guy so I just spent 4 hours debugging the problem.
Here's what I found.......................
In the "configuration" tables fec adds a "configuration_tab" column.
Well CSAR_install.sql doesn't take that into account so it just fails with the above generic message.

My 2 questions are:
1:
if I add ,' ' to the end of all three of these INSERT(s) it seems to install the "CSAR_install.sql" OK.....

INSERT INTO configuration VALUES ('', 'Hide Prices for Specific Categories', 'CATEGORY_RESTRICTION_HIDEPRICE_CATEGORY', '0', 'Restrict product price display for specific categories if the customer is not logged in.<br /><br />Enter the categories ID as a comma delimited list - do not use spaces (eg 12,19,45, 7_45).<br /><br />In this example categories 12, 19 and 45 can be restricted (Because category 45 is a subcategory of category 7 you need to enter both 45 and 7_45).<br />', 32, 150, '0001-01-01 00:00:00', now(), NULL, NULL, ' ');
Is that a good workaround?

2:
Other plugin's have already used gID=32 so with
INSERT INTO admin_pages VALUES ('csar_regn', 'BOX_CONFIGURATION_CATEGORY_RESTRICTION', 'FILENAME_CONFIGURATION', 'gID=32', 'catalog', 'Y', @sortorder+1);
I now have two plugins using gID=32. Why doesn't the csar plugin increment to the next highest gID?
Can I change it manually at the above entry and the other 4 places it's referenced?

Keep in mind I have not done the complete install of CSAR so I'm wanting to know if the above will work as it's a very tedious plugin to install over other plugins like fec and easy populate
Thanks

[linuxguy2]

jt1020

I gave it a quick once over and you are missing this define around line 612
define('TABLE_HEADING_DECRIPTION', 'Description');

Other than that the file looks normal.
In case I missed something compare it the the original.

[frank18]

...........
2:
Other plugin's have already used gID=32 so with
INSERT INTO admin_pages VALUES ('csar_regn', 'BOX_CONFIGURATION_CATEGORY_RESTRICTION', 'FILENAME_CONFIGURATION', 'gID=32', 'catalog', 'Y', @sortorder+1);
I now have two plugins using gID=32. Why doesn't the csar plugin increment to the next highest gID?
Can I change it manually at the above entry and the other 4 places it's referenced?

Keep in mind I have not done the complete install of CSAR so I'm wanting to know if the above will work as it's a very tedious plugin to install over other plugins like fec and easy populate
Thanks

You are on the right track.

It is a known issue. The gID (as it stands) is hardcoded - it does not automatically increment to the next gID. This will be corrected in the next update of CSAR.

As a workaround (on a fresh install) change gID=32 to something much higher, such as (example) gID=132.

[frank18]

jt1020

I gave it a quick once over and you are missing this define around line 612
define('TABLE_HEADING_DECRIPTION', 'Description');

Other than that the file looks normal.
In case I missed something compare it the the original.

Thanks for pointing that out. I will have a look at this.

As for installation please bear in mind that CSAR involves a stack of module and template files which need to to be adapted to to what CSAR is all about.

So, the merging and installing process is a bit more complicated than FEC or other mods.

Hope this helps

Cheers / Frank

[rbarbour]

I just got around to playing with this, huge difference from similar or previous versions.

from me on this, love it's flexibility!

Awesome job Frank!

[frank18]

I just got around to playing with this, huge difference from similar or previous versions.

from me on this, love it's flexibility!

Awesome job Frank!

Thanks mate - just have to get around and iron out a few bugs such as the auto increment gID. My time is currently *very* limited so your input to fix the install-sql file would be much appreciated

[rbarbour]

Thanks mate - just have to get around and iron out a few bugs such as the auto increment gID. My time is currently *very* limited so your input to fix the install-sql file would be much appreciated

I did not have any issues but I also did not include the category_specific_access_restriction_admin_page_reg.php, I understand why it is included and it's a great idea. I simply ran the install sql file.

I also used the admin page keys plugin to see if 'gID=32' existed first.

I will take a look and add the sql to auto increment in both category_specific_access_restriction_admin_page_reg.php and install.sql

[linuxguy2]

Frank18

Yes, Awesome Plugin!!!!

What about this database issue when installing over other plugins?
Is this an acceptable workaround? See red stuff.

1:
If I add , ' ' to the end of all three of these INSERT(s) it seems to install the "CSAR_install.sql" OK when I already have fec installed.....

INSERT INTO configuration VALUES ('', 'Hide Prices for Specific Categories', 'CATEGORY_RESTRICTION_HIDEPRICE_CATEGORY', '0', 'Restrict product price display for specific categories if the customer is not logged in.<br /><br />Enter the categories ID as a comma delimited list - do not use spaces (eg 12,19,45, 7_45).<br /><br />In this example categories 12, 19 and 45 can be restricted (Because category 45 is a subcategory of category 7 you need to enter both 45 and 7_45).<br />', 32, 150, '0001-01-01 00:00:00', now(), NULL, NULL, ' ');

I guess I missed something in the readme/install instructions.. what is the function of "category_specific_access_restriction_admin_page_reg.php" ?

[linuxguy2]

To Clarify my earlier post.

In the "configuration" tables fec adds a "configuration_tab" column.
CSAR_install.sql doesn't take that into account so it just fails with this generic message.
WARNING: An Error occurred, please refresh the page and try again.

[frank18]

To Clarify my earlier post.

In the "configuration" tables fec adds a "configuration_tab" column.
CSAR_install.sql doesn't take that into account so it just fails with this generic message.
WARNING: An Error occurred, please refresh the page and try again.

Fec is another third party plugin. CSAR can not take all other contribs into account, it is designed to work with the basic ZC 1.5.1 file system.

If other third party plugins have been previously installed then it is up to the op to make additional changes.