Table ... doesn't exist during update 1.7.6.9 to 1.7.7.1

[elektro-kot]

Hey. I checked the test update on the local server. The upgrade to version 1.7.7.1 was successful, but the error log remained:

SQL 1.7.7.0 1146 in ALTER TABLE `ps_connections` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci: Table 'ps_cl.ps_connections' doesn't exist
SQL 1.7.7.0 1146 in ALTER TABLE `ps_connections_page` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci: Table 'ps_cl.ps_connections_page' doesn't exist
SQL 1.7.7.0 1146 in ALTER TABLE `ps_connections_source` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci: Table 'ps_cl.ps_connections_source' doesn't exist
SQL 1.7.7.0 1146 in ALTER TABLE `ps_guest` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci: Table 'ps_cl.ps_guest' doesn't exist
SQL 1.7.7.0 1146 in ALTER TABLE `ps_statssearch` CHANGE `keywords` `keywords` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL: Table 'ps_cl.ps_statssearch' doesn't exist
SQL 1.7.7.0 1146 in ALTER TABLE `ps_connections` CHANGE `http_referer` `http_referer` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL: Table 'ps_cl.ps_connections' doesn't exist

I checked the database and no such tables exist. They should be? Why are tables not being created at the time of update?
Can anyone show a list of tables for 1.7.7.1?

 

P.S: Sorry, my mistake. Database user permissions were set incorrectly. Solved

Edited January 17, 2021 by elektro-kot (see edit history)

[texxo]

Hello elektro-kot,

i have the same issue, what do you mean when you say database user permissions were set incorrectly?

the user that connects to my prestashop has full rights.

i must mention that i tried the update from 1.7.6.2 to 1.7.7.2

Share some more info please.

Thank you.

[diego dz]

On 13/1/2021 at 10:58, elektro-kot said:

Oye. Revisé la actualización de prueba en el servidor local. La actualización a la versión 1.7.7.1 se realizó correctamente, pero el registro de errores permaneció:

SQL 1.7.7.0 1146 en ALTER TABLE `ps_connections` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci: La tabla 'ps_cl.ps_connections' no existe
SQL 1.7.7.0 1146 en ALTER TABLE` ps_connections_page` CONVERT TO CHARACTER SET utf8mb4 COLLATE 'utf8mb4 Table ps_cl.ps_connections_page 'no existe
SQL 1.7.7.0 1146 en ALTER TABLE `ps_connections_source` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci: La tabla' ps_cl.ps_connections_source 'no existe
SQL 1.7.7.0 1146 en ALTER TABLE` ps_guest` CONVERT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci: La tabla 'ps_cl.ps_guest' no existe
SQL 1.7.7.0 1146 en ALTER TABLE `ps_statssearch` CHANGE` keywords` `keywords` varchar (255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL: La tabla 'ps_cl.ps_statssearch' no existe
SQL 1.7.7.0 1146 en ALTER TABLE` ps_connections `CHANGE` http_referer` `http_referer` varchar (255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL: La tabla 'ps_cl.ps_connections' no existe

Revisé la base de datos y no existen tales tablas. ¿Ellos deberían ser? ¿Por qué no se crean tablas en el momento de la actualización?
¿Alguien puede mostrar una lista de tablas para 1.7.7.1?

 

PD: Lo siento, mi error. Los permisos de usuario de la base de datos se establecieron incorrectamente. Resuelto

Buenas tardes,

 

Podrías explicar para torpes , por favor, como lo solucionaste, 

 

Gracias,

 

[solsol69]

hi

 

[elektro-kot]

On 3/5/2021 at 5:39 PM, texxo said:

Hello elektro-kot,

Share some more info please.

Thank you.

Hi, Texxo. I made some errors in the MySQL server (user permission - can create table). So, in my case, this is was not problem of prestashop, this is mistake config of server settings only.

Edited March 21, 2021 by elektro-kot (see edit history)

[texxo]

Hello.

i finally solved the issue myself.

i had a running installation of 1.7.2.3 version on a server.

i exported the missing tables and simply imported them manually in the 1.7.6.2 version that i wanted to upgrade.

the 1 click upgrade found the tables and updated them normally after so it gave me no errors at the end.

all good. 

[diego dz]

Gracias Texxo por compartilo. 

[Nawfel_hf]

On 17/03/2021 at 22:48, solsol69 said:

salut

 

j'ai fait ça, problème résolu pour plusieurs tables mais il me reste que ce-ci

meme quand je cherche dans le fichier généré je ne trouve pas cette table..  

[Exception de la base de données PrestaShop]

La table '******.ps_statssearch' n'existe pas<br /><br /><pre>INSERT INTO `ps_statssearch` (`id_shop`, `id_shop_group`, `keywords`, `results`, `date_add`) VALEURS (1 , 1, 'ddd', 130, NOW())</pre>
à la ligne 769 dans le fichier classes/db/Db.php