Need some help, I broke the permissions :P

[Pennylane]

Hello all!

I am setting up prestashop for a client who is not very web savvy. He was worried about breaking his store, so I set us up as Employees with myself as "Web Developer" and him as "Admin" and then I restricted some of his permissions so that he doesnt have to worry about playing with something that can break the store.

To make a long story short, his permissions were saved to both "Admin" and "Web Developer" so now I can't access things that I need, most specifically the modules tab.

Does anyone have an idea of how to fix this? I really would like to avoid a complete uninstall/reinstall since we have hundreds of products in the catalog already. I have backed up the database, but each backup overwrites earlier backups, and the last backup took place after the permissions had been changed.

Thanks a lot!

[illutic]

I hope you have access to your phpmyadmin (or something like phpmyadmin).

Here's a dump for ps_access for the profile with id#1 (administrator):

-- phpMyAdmin SQL Dump
-- version 2.11.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jul 14, 2008 at 11:35 PM
-- Server version: 5.0.37
-- PHP Version: 5.2.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `xxxxx`
--

-- --------------------------------------------------------

--
-- Table structure for table `ps_access`
--

CREATE TABLE `ps_access` (
 `id_access` int(11) NOT NULL auto_increment,
 `id_profile` int(10) unsigned NOT NULL,
 `id_tab` int(10) unsigned NOT NULL,
 `view` int(11) NOT NULL,
 `add` int(11) NOT NULL,
 `edit` int(11) NOT NULL,
 `delete` int(11) NOT NULL,
 PRIMARY KEY  (`id_access`),
 KEY `access_profile` (`id_profile`),
 KEY `access_tab` (`id_tab`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=50 ;

--
-- Dumping data for table `ps_access`
--

INSERT INTO `ps_access` VALUES(1, 1, 1, 1, 1, 1, 1);
INSERT INTO `ps_access` VALUES(2, 1, 2, 1, 1, 1, 1);
INSERT INTO `ps_access` VALUES(3, 1, 3, 1, 1, 1, 1);
INSERT INTO `ps_access` VALUES(4, 1, 4, 1, 1, 1, 1);
INSERT INTO `ps_access` VALUES(5, 1, 5, 1, 1, 1, 1);
INSERT INTO `ps_access` VALUES(6, 1, 6, 1, 1, 1, 1);
INSERT INTO `ps_access` VALUES(7, 1, 7, 1, 1, 1, 1);
INSERT INTO `ps_access` VALUES(8, 1, 8, 1, 1, 1, 1);
INSERT INTO `ps_access` VALUES(9, 1, 9, 1, 1, 1, 1);
INSERT INTO `ps_access` VALUES(10, 1, 10, 1, 1, 1, 1);
INSERT INTO `ps_access` VALUES(11, 1, 11, 1, 1, 1, 1);
INSERT INTO `ps_access` VALUES(12, 1, 12, 1, 1, 1, 1);
INSERT INTO `ps_access` VALUES(13, 1, 13, 1, 1, 1, 1);
INSERT INTO `ps_access` VALUES(14, 1, 14, 1, 1, 1, 1);
INSERT INTO `ps_access` VALUES(15, 1, 15, 1, 1, 1, 1);
INSERT INTO `ps_access` VALUES(16, 1, 16, 1, 1, 1, 1);
INSERT INTO `ps_access` VALUES(17, 1, 17, 1, 1, 1, 1);
INSERT INTO `ps_access` VALUES(18, 1, 18, 1, 1, 1, 1);
INSERT INTO `ps_access` VALUES(19, 1, 19, 1, 1, 1, 1);
INSERT INTO `ps_access` VALUES(20, 1, 20, 1, 1, 1, 1);
INSERT INTO `ps_access` VALUES(21, 1, 21, 1, 1, 1, 1);
INSERT INTO `ps_access` VALUES(22, 1, 22, 1, 1, 1, 1);
INSERT INTO `ps_access` VALUES(23, 1, 23, 1, 1, 1, 1);
INSERT INTO `ps_access` VALUES(24, 1, 24, 1, 1, 1, 1);
INSERT INTO `ps_access` VALUES(26, 1, 26, 1, 1, 1, 1);
INSERT INTO `ps_access` VALUES(27, 1, 27, 1, 1, 1, 1);
INSERT INTO `ps_access` VALUES(28, 1, 28, 1, 1, 1, 1);
INSERT INTO `ps_access` VALUES(29, 1, 29, 1, 1, 1, 1);
INSERT INTO `ps_access` VALUES(30, 1, 30, 1, 1, 1, 1);
INSERT INTO `ps_access` VALUES(31, 1, 31, 1, 1, 1, 1);
INSERT INTO `ps_access` VALUES(32, 1, 32, 1, 1, 1, 1);
INSERT INTO `ps_access` VALUES(33, 1, 33, 1, 1, 1, 1);
INSERT INTO `ps_access` VALUES(34, 1, 34, 1, 1, 1, 1);
INSERT INTO `ps_access` VALUES(35, 1, 35, 1, 1, 1, 1);
INSERT INTO `ps_access` VALUES(36, 1, 36, 1, 1, 1, 1);
INSERT INTO `ps_access` VALUES(37, 1, 37, 1, 1, 1, 1);
INSERT INTO `ps_access` VALUES(38, 1, 38, 1, 1, 1, 1);
INSERT INTO `ps_access` VALUES(39, 1, 39, 1, 1, 1, 1);
INSERT INTO `ps_access` VALUES(40, 1, 40, 1, 1, 1, 1);
INSERT INTO `ps_access` VALUES(41, 1, 41, 1, 1, 1, 1);
INSERT INTO `ps_access` VALUES(42, 1, 42, 1, 1, 1, 1);
INSERT INTO `ps_access` VALUES(43, 1, 43, 1, 1, 1, 1);
INSERT INTO `ps_access` VALUES(44, 1, 44, 1, 1, 1, 1);
INSERT INTO `ps_access` VALUES(45, 1, 45, 1, 1, 1, 1);
INSERT INTO `ps_access` VALUES(46, 1, 46, 1, 1, 1, 1);
INSERT INTO `ps_access` VALUES(47, 1, 47, 1, 1, 1, 1);
INSERT INTO `ps_access` VALUES(48, 1, 48, 1, 1, 1, 1);
INSERT INTO `ps_access` VALUES(49, 1, 49, 1, 1, 1, 1);

[Pennylane]

Thank you so much, it worked like a charm I never thought about doing a second install and dumping it!

Much appreciated!

[FranWeb]

Can you say to me in French what about what it is a question because I didn't understand everything both in the problem and in the solution. Thanks and sorry for my english.

[Pennylane]

Je me sers d'un logiciel de traduction en ligne de ce que je vous présente mes excuses si elle est pauvre en français. J'ai été mise en permissions dans l'arrière du magasin et prestashop sauvé la même permis à tous les 3 profils d'utilisateurs. En raison de cela, je ne pouvait pas modifier les modules ou de plusieurs autres fonctions dans le magasin. La solution était de supprimer le tableau ps_access utilisant myphpadmin et ensuite utiliser le sql dump ci-dessus pour mettre la bonne permissions paramètres dans la base de données.

Encore une fois, je vous présente mes excuses pour la traduction. Je ne parle pas le français à tous.

[plouise]

Pour FranWeb..

Pennylane utilise 3 profils pour le site de son client.
Il a enlevé par erreur des droits à l'administrateur par le module de permission en croyant régler le profil Utilisateur.
Il ne pouvait donc pas réouvrir le module de permission.

La solution proposée consiste à supprimer la table, puis à le recréer puis ajouter les paramètres standard du compte Administrateur.

En ce qui me concerne, j'ai également décoché certaine fonction de l'administrateur en croyant paramétrer un profil utilisateur.
J'ai réglé le pb sans faire de dump, juste en allant directement dans la même table (ps_access si vous avez gardé ps_ comme souche) pour remettre tout admin à Oui, notamment la ligne permission.