Resolved issue with smarty_lazy_cache’ doesn’t exist

Posted on by

The following method shows how to solve the problem when the import or manually create the table in prestashop for this query we get an error. Here's how to solve it.

When the import of the following query:

1
2
3
4
5
6
7
CREATE TABLE `ps_smarty_lazy_cache` (
`template_hash` varchar(32) NOT NULL DEFAULT '',
`cache_id` varchar(255) NOT NULL DEFAULT '',
`compile_id` varchar(32) NOT NULL DEFAULT '',
`filepath` varchar(255) NOT NULL DEFAULT '',
`last_update` datetime NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

We get an error as in Annex:

 

We make a small bypass.

We create a new MySQL database

We make it for exactly the same question.
In this case, if the database is new and is not affiliated with any party to a whole is successful.

The next step is to export our existing database table without this file.
When you export a whole, we can make it to import the new database already this table.
Whole should run correctly, after re-importing replaces the configuration file and directory /config/settings.inc.php

Set new data to our database.

How useful this post was?

Click on the star, to evaluate it!

Average grade / 5. number of votes:

So far, no votes! Be the first to rate this post.

Related entries:

Disabling package updates from Yum in Centos and AlmaLinux
Complete removal of the queue e-mail with Exim
how to pack and unpack files on the server - ZIP TAR TAR.GZ
Installation and security of the MariaDB database server in the Debian system 11
Installation of PostgreSQL and phpPgAdmin on Ubuntu 18.04