SQL

[david-strejc]

This module is missing tables in database.

Is there any sql file I can import into DB?

Or what is the proper way to install this module?

Many thanks.

[xpert-idea]

please uninstall and install module again the db table will be create automatically.

[StephanoAlberteni]

I get the error too, and reinstalling doesn't seem to solve this issue. I get this error:

Bad SQL query
Table 'prestashopmama.ps_xipposts' doesn't exist

[johanmater]

Same problem reinstall does not work from module panel in prestashop 1.7 dbase tables gone!

[chadidi]

I have the same problem and @xpert-idea solution not working.

[Romezzn]

@chadidi hey i have the solution only download the master of github and unzip on directory modules i fix it issue easy and sorry for my english im spanish

P.D dont unzip all files and directorys create first directory xipblog or delete files in this directory and unzip all files on xipblog directory

[chadidi]

@Romezzn I already did that, thanks for your help, and your English is great, by the way, i am also not English I am Arab.

[Romezzn]

@chadidi read the explication on P.D

[chadidi]

@Romezzn what explication are you referring too cause I don't know what is P.D

[Romezzn]

@chadidi dont unzip all files and directorys create first directory xipblog or delete files in this directory and unzip all files on xipblog directory

[Romezzn]

@chadidi have you been able to solve the problem?

[chadidi]

@Romezzn I already solved the problem 9 days ago

[xavier-bs]

I had the same issue with mySQL 5.7 and strict sql mode. Two kind of errors occured:

• #1171 - All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
• #1067 - Invalid default value for 'post_date'

So, I changed /db/dbfiles.php for the tables creation process:

1. For all tables, removed NOT NULL for PRIMARY KEY. Be careful xipposts_lang, xipposts_shop, xipposts_lang have 2 PRIMARY KEYS,
2. ps_xipposts: '0000-00-00 00:00:00' -> CURRENT_TIMESTAMP.

After that, installation had created tables in database.