totallybike Posted November 16, 2009 Share Posted November 16, 2009 I'm about to throw my chair at the monitor!!!! ARRRRGHI'm having major problems today! I deleted the default customer group (trying to clean up BO), this then caused the deleting of the category module and blocking access to anyone!!!!I've tried deleting everything and uploading an old backup copy of PS, but it just reverts back to the same! I've tried adding a second group called default now, but it is listed as id 2, not 1 like the original and I've changed the categories to allow this new group access, but the problem is still there! Do you know how to fix this? Otherwise I'll be another 2 weeks away from finishing my site and will miss xmas all together!thanksGary Link to comment Share on other sites More sharing options...
jmass78 Posted November 16, 2009 Share Posted November 16, 2009 did you try changing the id number in your database to 1, i would think that may fix it Link to comment Share on other sites More sharing options...
totallybike Posted November 16, 2009 Author Share Posted November 16, 2009 Hi Jmashow do I do that though? Link to comment Share on other sites More sharing options...
jmass78 Posted November 16, 2009 Share Posted November 16, 2009 do you have phpmyadmin or something similar to edit your MySQL database? I dont know it well enough to give you step by step directions and I caution you that any changes you make by mistake will be permanent so only proceed if you have a good idea about what your doing. Maybe someone here can chime in with better details but if it were me, id poke around until i find the table that held the information for customer groups (it should be ps_group on your setup) and then click browse and you should see the groups you created and their assigned numbers. Let us know how you make out Link to comment Share on other sites More sharing options...
bello Posted November 30, 2009 Share Posted November 30, 2009 now i have the same problem, how can i fix this? Link to comment Share on other sites More sharing options...
jcs666a Posted December 2, 2009 Share Posted December 2, 2009 I solved the problem using "phpmyadmin", you have to modify the table "ps_group", creating a record with the value 1 in the "id_goup" and then on the table "ps_category_group" put all records in 1 in the "id_group".If you had customer records probably need to modify the table "ps_customer_group" putting in 1 all "id_group" associated with "id_customer" Link to comment Share on other sites More sharing options...
kdk Posted December 4, 2009 Share Posted December 4, 2009 If you had customer records probably need to modify the table "ps_customer_group" putting in 1 all "id_group" associated with "id_customer" But how? Do you now the correct syntax to do this? Link to comment Share on other sites More sharing options...
bello Posted December 5, 2009 Share Posted December 5, 2009 i solved this but don't know way in categories block categories doesn't appear Link to comment Share on other sites More sharing options...
jcs666a Posted December 7, 2009 Share Posted December 7, 2009 you're right, became my second trouble too, but in "ps_category_lang" look all "id_category" and put all of them in "ps_category_group" with the "id_group" in 1 specially the "home" whose "id_category" should be 1, watch the images to help you better Link to comment Share on other sites More sharing options...
bello Posted December 7, 2009 Share Posted December 7, 2009 thanks man Link to comment Share on other sites More sharing options...
rufyto Posted February 17, 2010 Share Posted February 17, 2010 solved.thank you very much. Link to comment Share on other sites More sharing options...
jtlswanson Posted April 28, 2010 Share Posted April 28, 2010 I am having the same issues as my categories block is not showing up and I am getting the same error: 01.you do not have access to this product.I'm a newby at all this including SQL. I'm clueless as to what I accidentally erased. Can anyone give me a step by step to add the tables back in please? Mine is stating its empty...Please, please, please anyone help?Fresh install of 1.2.5.0. on Linux Server, mySQL 5.0.67. I have access to myPHPAdmin, but I have no idea what to add/delete/etc. Plus, I'm pretty much a wussy as I'm totally scared to change anything in the PHPAdmin area.BTW, if I go to my Catalog tab, then edit the catagory/sub-catagory, scroll down to Groups access section, it states: No group created.Thank you in advance! Link to comment Share on other sites More sharing options...
Kalpesh Posted October 11, 2010 Share Posted October 11, 2010 Hi,anyone can help me on this ? please refer the thread... http://www.prestashop.com/forums/viewthread/72941/configuring___using_prestashop/sos__urgent_help_needed__problem_with_default_group/Thanks Link to comment Share on other sites More sharing options...
somits1 Posted October 19, 2015 Share Posted October 19, 2015 Hi, This is Somit, using Prestashop 1.5.6 English Version and my Website http://www.slmobileprice.com I am getting same error after Creating product , not able to access that product. After deleting product more than 10-15 times , sometime problem solved. And as Group Access is Default. Please help me to solve the issue, i am not able to create products.. Please check error below There is 1 error You do not have access to this product.« Back Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now