Jump to content

Problema al ingresar al back office

tomasmessina

By tomasmessina
in Discusión general

 Share

Recommended Posts

tomasmessina Rookie

tomasmessina

Posted
Posted

Hola! que tal? estoy teniendo problemas para entrar al back office de mi tienda, me sale el siguiente error
´El empleado no existe o la contraseña introducida es incorrecta'

Estoy intentado hacer el cambio de contraseña a través del administrador de archivos siguiendo estos pasos
https://www.creativanet.com/blog/prestashop/cambio-de-password-de-emergencia-en-prestashop
 

Pero estoy teniendo el problema de que no encuentro la tabla ps_employee en la bdd.

Link to comment
Share on other sites
tomasmessina Rookie

tomasmessina

Posted
  • Author
Posted
6 minutes ago, ComGrafPL said:

¿Ha intentado buscar algún "empleado" en las tablas? ¿Has hecho alguna actualización, cambios en el servidor? Si aún no puede encontrarlo, deberá crear una tabla de empleados.

Si, intente buscar y tampoco aparece. Lo último que hice fue una actualización de Prestashop a la versión 1.7.8.5. Tendras algun tutorial para poder crear la tabla correctamente? Gracias.

Link to comment
Share on other sites
ExpertoPrestaShop Proficient

ExpertoPrestaShop

Posted
Posted

Pues tienes que crearla. El problema es que esa tabla ha tenido varios cambios en las ultimas versiones, así que tendrías que copiarte la estructura de la tabla y la menos el primero registro de otra tienda con exactamente la misma version que la tuya. Te paso al menos la estructura de las 3 tablas relacionadas con empleados a ver si te sirve de ayuda: 

--
-- Table structure for table `ah_employee`
--

CREATE TABLE `ah_employee` (
  `id_employee` int UNSIGNED NOT NULL,
  `id_profile` int UNSIGNED NOT NULL,
  `id_lang` int UNSIGNED NOT NULL DEFAULT '0',
  `lastname` varchar(255) NOT NULL,
  `firstname` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `passwd` varchar(255) NOT NULL,
  `last_passwd_gen` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `stats_date_from` date DEFAULT NULL,
  `stats_date_to` date DEFAULT NULL,
  `stats_compare_from` date DEFAULT NULL,
  `stats_compare_to` date DEFAULT NULL,
  `stats_compare_option` int UNSIGNED NOT NULL DEFAULT '1',
  `preselect_date_range` varchar(32) DEFAULT NULL,
  `bo_color` varchar(32) DEFAULT NULL,
  `bo_theme` varchar(32) DEFAULT NULL,
  `bo_css` varchar(64) DEFAULT NULL,
  `default_tab` int UNSIGNED NOT NULL DEFAULT '0',
  `bo_width` int UNSIGNED NOT NULL DEFAULT '0',
  `bo_menu` tinyint(1) NOT NULL DEFAULT '1',
  `active` tinyint UNSIGNED NOT NULL DEFAULT '0',
  `optin` tinyint UNSIGNED DEFAULT NULL,
  `id_last_order` int UNSIGNED NOT NULL DEFAULT '0',
  `id_last_customer_message` int UNSIGNED NOT NULL DEFAULT '0',
  `id_last_customer` int UNSIGNED NOT NULL DEFAULT '0',
  `last_connection_date` date DEFAULT NULL,
  `reset_password_token` varchar(40) DEFAULT NULL,
  `reset_password_validity` datetime DEFAULT NULL,
  `has_enabled_gravatar` tinyint UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `ah_employee_session`
--

CREATE TABLE `ah_employee_session` (
  `id_employee_session` int UNSIGNED NOT NULL,
  `id_employee` int UNSIGNED DEFAULT NULL,
  `token` varchar(40) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `ah_employee_shop`
--

CREATE TABLE `ah_employee_shop` (
  `id_employee` int UNSIGNED NOT NULL,
  `id_shop` int UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `ah_employee`
--
ALTER TABLE `ah_employee`
  ADD PRIMARY KEY (`id_employee`),
  ADD KEY `employee_login` (`email`,`passwd`),
  ADD KEY `id_employee_passwd` (`id_employee`,`passwd`),
  ADD KEY `id_profile` (`id_profile`);

--
-- Indexes for table `ah_employee_session`
--
ALTER TABLE `ah_employee_session`
  ADD PRIMARY KEY (`id_employee_session`);

--
-- Indexes for table `ah_employee_shop`
--
ALTER TABLE `ah_employee_shop`
  ADD PRIMARY KEY (`id_employee`,`id_shop`),
  ADD KEY `id_shop` (`id_shop`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `ah_employee`
--
ALTER TABLE `ah_employee`
  MODIFY `id_employee` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ah_employee_session`
--
ALTER TABLE `ah_employee_session`
  MODIFY `id_employee_session` int UNSIGNED NOT NULL AUTO_INCREMENT;
COMMIT;

 

Link to comment
Share on other sites
tomasmessina Rookie

tomasmessina

Posted
  • Author
Posted
1 minute ago, ExpertoPrestaShop said:

Pues tienes que crearla. El problema es que esa tabla ha tenido varios cambios en las ultimas versiones, así que tendrías que copiarte la estructura de la tabla y la menos el primero registro de otra tienda con exactamente la misma version que la tuya. Te paso al menos la estructura de las 3 tablas relacionadas con empleados a ver si te sirve de ayuda: 

--
-- Table structure for table `ah_employee`
--

CREATE TABLE `ah_employee` (
  `id_employee` int UNSIGNED NOT NULL,
  `id_profile` int UNSIGNED NOT NULL,
  `id_lang` int UNSIGNED NOT NULL DEFAULT '0',
  `lastname` varchar(255) NOT NULL,
  `firstname` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `passwd` varchar(255) NOT NULL,
  `last_passwd_gen` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `stats_date_from` date DEFAULT NULL,
  `stats_date_to` date DEFAULT NULL,
  `stats_compare_from` date DEFAULT NULL,
  `stats_compare_to` date DEFAULT NULL,
  `stats_compare_option` int UNSIGNED NOT NULL DEFAULT '1',
  `preselect_date_range` varchar(32) DEFAULT NULL,
  `bo_color` varchar(32) DEFAULT NULL,
  `bo_theme` varchar(32) DEFAULT NULL,
  `bo_css` varchar(64) DEFAULT NULL,
  `default_tab` int UNSIGNED NOT NULL DEFAULT '0',
  `bo_width` int UNSIGNED NOT NULL DEFAULT '0',
  `bo_menu` tinyint(1) NOT NULL DEFAULT '1',
  `active` tinyint UNSIGNED NOT NULL DEFAULT '0',
  `optin` tinyint UNSIGNED DEFAULT NULL,
  `id_last_order` int UNSIGNED NOT NULL DEFAULT '0',
  `id_last_customer_message` int UNSIGNED NOT NULL DEFAULT '0',
  `id_last_customer` int UNSIGNED NOT NULL DEFAULT '0',
  `last_connection_date` date DEFAULT NULL,
  `reset_password_token` varchar(40) DEFAULT NULL,
  `reset_password_validity` datetime DEFAULT NULL,
  `has_enabled_gravatar` tinyint UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `ah_employee_session`
--

CREATE TABLE `ah_employee_session` (
  `id_employee_session` int UNSIGNED NOT NULL,
  `id_employee` int UNSIGNED DEFAULT NULL,
  `token` varchar(40) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `ah_employee_shop`
--

CREATE TABLE `ah_employee_shop` (
  `id_employee` int UNSIGNED NOT NULL,
  `id_shop` int UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `ah_employee`
--
ALTER TABLE `ah_employee`
  ADD PRIMARY KEY (`id_employee`),
  ADD KEY `employee_login` (`email`,`passwd`),
  ADD KEY `id_employee_passwd` (`id_employee`,`passwd`),
  ADD KEY `id_profile` (`id_profile`);

--
-- Indexes for table `ah_employee_session`
--
ALTER TABLE `ah_employee_session`
  ADD PRIMARY KEY (`id_employee_session`);

--
-- Indexes for table `ah_employee_shop`
--
ALTER TABLE `ah_employee_shop`
  ADD PRIMARY KEY (`id_employee`,`id_shop`),
  ADD KEY `id_shop` (`id_shop`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `ah_employee`
--
ALTER TABLE `ah_employee`
  MODIFY `id_employee` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ah_employee_session`
--
ALTER TABLE `ah_employee_session`
  MODIFY `id_employee_session` int UNSIGNED NOT NULL AUTO_INCREMENT;
COMMIT;

 

Perfecto! muchas gracias por la respuesta, voy a probarlo 

Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing
×
×
  • Create New...