can't install module successfully- error in newsletter module

[sannie]

Dear All,

I managed to install the Prestashop default software successfully. In addition I'm using a free theme (Fennecs) and am trying to install the newsletter block (which allows visitors to register for newsletter) via the Prestashop Backoffice. I keep getting an -unfortunately undescriptive- error "The following module(s) were not installed successfully: * blocknewsletter".

I tried uninstalling the module via the Backoffice, removing the module entirely from the server, and reinstalling the original Fennecs blocknewsletter module. But keep getting the same installation error. I can see the newsletter module appearing on my website, but when I try to register an emailaddress, I get the message "error during description". I.e.: the newsletter registration doesn't work.

I searched the errorlog on my server but can't find any hints of the cause.

I've only changed .css and enduser-text in .tpl and .php files (for localization of usermessages) of some modules. As I don't have any (php) programming knowledge, I haven't changed any programming logic neither have I touched the mysql database.

Could anybody please help me?

Thank you very much in advance!

P.S. I very much thank the Prestashop developers for making this fantastic, easy to use software! I keep getting amazed about the fact that even a non-developer can use this tool.

[sannie]

Hi,

I managed to solve the problem, the Fennecs newsletter module contained a bug. In case somebody else experienced the same issue, here's how I got it to work:

- removed Fennecs newsletter files from server
- copied original Prestashop newsletter module (blocknewsletter) to server
- in Prestashop backoffice: install (the Prestashop) newsletter module v1.4

this Prestashop module installed successfully and will create a newsletter table in the sql database

- copy Fennecs newsletter files to server, overwriting the Prestashop newsletter module files.
- transplant newsletter module to Footer and newsletter appears on website!

I can now succesfully subscribe new emailaddresses to newsletter via website.

Appearantly the fix below also works (if you know sql):

(newsletter fix)
go to your phpmyadmin
and open the db
then got to sql

then paste: »
CREATE TABLE ‘._DB_PREFIX_.’newsletter (
`id` int(6) NOT NULL AUTO_INCREMENT,
`email` varchar(255) NOT NULL,
`newsletter_date_add` DATETIME NULL,
`ip_registration_newsletter` varchar(15) NOT NULL,
`http_referer` VARCHAR(255) NULL,
PRIMARY KEY(`id`)
)

»

replacing DB_PREFIX with your db_prefix, the standard install prefix is
« ps_ » so instead of
‘._DB_PREFIX_.’newsletter
place
ps_newsletter

[birdawn]

Hi Sannie,

Thank you for post the problem and the solution of fennecs newsletter block .
I don't known too much about mysql... but I find some syntax error for me...

It works for me like the next:



CREATE TABLE ps_newsletter(
id INT(6) NOT NULL AUTO_INCREMENT,
email VARCHAR(255) NOT NULL UNIQUE,
newsletter_date_add DATETIME NULL,
ip_registration_newsletter varchar(15) NOT NULL,
http_referer VARCHAR (255) NULL, PRIMARY KEY (ID) )


Wish everyone can enjoy this solution.
Juan