karelzemek Posted January 3, 2010 Share Posted January 3, 2010 Ahoj, nefunguje mi blok newsletter - když zákazník napíše svůj mail a dá "odeslat" skočí mu hláška "Error during subscription" a mě se samozřejmě jeho mail neobjeví v BO.Co s tím? Chyba v databázi?Poraďte prosím. Díky. Link to comment Share on other sites More sharing options...
JAKCRABBIT Posted January 3, 2010 Share Posted January 3, 2010 VERZE???? Link to comment Share on other sites More sharing options...
karelzemek Posted January 3, 2010 Author Share Posted January 3, 2010 VERZE???? Prestashop 1.2.5.0Newsletter block v1.4 Link to comment Share on other sites More sharing options...
JAKCRABBIT Posted January 3, 2010 Share Posted January 3, 2010 Zkus modul odinstalovat, znova nainstalovat, zkusit se přihlásit k odběru.Tím myslim jak v TOOLS -> Newsletter 2.0, tak v BLOCÍCH Newsletter 1.4. Link to comment Share on other sites More sharing options...
karelzemek Posted January 4, 2010 Author Share Posted January 4, 2010 Zkus modul odinstalovat, znova nainstalovat, zkusit se přihlásit k odběru.Tím myslim jak v TOOLS -> Newsletter 2.0, tak v BLOCÍCH Newsletter 1.4. V TOOLS ? Tam jsou jen tyhle položky:Languages Translations Tabs Quick Accesses Aliases Import Subdomains DB backup CMS GeneratorsZkusil jsem oba moduly (Newsletter v2.0, Newsletter block v1.4) odinstalovat, smazat, znovu nahrát a nainstalovat. NewsLetter 1.4 jsem musel instalovat nadvakrát - poprvé se ukázalo, že modul není správně nainstalován, tak jsem klikl podruhé na "instalovat" a nainstaloval se. Koukl jsem do databází a nikde není tabulka ps_newsletter. (?!)řešil jsem to před nedávnem na jednom anglickém fóru, dostal jsem odpověď, ale nepochopil jsem ji, zkus to:-)For Karel,my newsletter was not workingso i went into the blocknewsltter.php file and found the sql create table statment :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`)) »open your database and run the statment.it will create the appropriate table and replace »‘._DB_PREFIX_.’ »with you actual database prefix the standard is « ps_ »Good Luck Link to comment Share on other sites More sharing options...
JAKCRABBIT Posted January 4, 2010 Share Posted January 4, 2010 Máš ten sql příkaz vložit do toho souboru a nainstalovat, aby to v DB vytvořilo tabulku, ale je mi záhadný, pokud používáš officiální instalaci, že ti to nefunguje... Link to comment Share on other sites More sharing options...
karelzemek Posted January 4, 2010 Author Share Posted January 4, 2010 Máš ten sql příkaz vložit do toho souboru a nainstalovat, aby to v DB vytvořilo tabulku, ale je mi záhadný, pokud používáš officiální instalaci, že ti to nefunguje... Tak v tom případě netuším kam ho mám vložit do toho souboru v příloze.....?Je to oficiální verze, jen upravená (vzhled) pro šablonu kterou používám.blocknewsletter.php Link to comment Share on other sites More sharing options...
JAKCRABBIT Posted January 4, 2010 Share Posted January 4, 2010 Jéé, sem si to blbě přečetl, stačí když tam na řádku tušim 33 přepíšeš to: ._DB_PREFIX_. na tvůj prefix kterej používáš v DB, standardně je ps_ takže ten tvůj sql co tam je bude vypadat takhle: CREATE TABLE 'ps_'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`) ) ENGINE=MyISAM default CHARSET=utf8'); Link to comment Share on other sites More sharing options...
karelzemek Posted January 4, 2010 Author Share Posted January 4, 2010 S tím už jsem si právě hrál, ať jsem zkusil nahradit ._DB_PREFIX_. za ps_ jenom ve zmiňovaném odstavci nebo v celém .php, tak pokaždé se při nahrání modulu na ftp ukázala hláška:Parse error(s) in module(s)blocknewslettera modul nebyl vůbec vidět v seznamu modulů...... Link to comment Share on other sites More sharing options...
karelzemek Posted January 7, 2010 Author Share Posted January 7, 2010 Nakonec se mi to podařilo rozchodit, ale sám vlastně nevim jak - zkusil jsem nainstalovat NL ze starší verze presty....ta nefungovala, tak jsem jí odinstaloval a nainstaloval opět tuhle verzi...a vida.funguje...nj, někdy prostě stačí zapnout a vypnout :-D Link to comment Share on other sites More sharing options...
sm3004 Posted January 11, 2010 Share Posted January 11, 2010 Thanks jakcrabbit, your post helped me (and so did google translate) since i don't speak one word of Czech, here's what I did:Ok, I have been looking for this too and have found the answer in the Czech forum, using google translate. It turns out that the newsletter table never got created in the database, which is why I could only register with customers that already existed in my customer database. It had nowhere to put the customers that had only used the subscription module and thus the error.Here's what you need to do:1. Go to the Prestashop backend and uninstall ALL Newsletter applications, I had three: Newsletterv2.0, Newsletter block v1.4, Newsletter v1.0. UNISTALL them by clicking the checkboxes next to them and do them all at once in a batch.2. Next, install only: Newsletterv2.0 & Newsletter block v1.4 (NOT Newsletter v1.0) You may or may not get an error, doesn't matter.3. Next go to your database admin tool. I use PHPMyAdmin where I click on my shop's database and then SQL at the top4. Enter the following query via SQL, make sure you change the YOURDATABASENAME in the below code to the full name of your database (jakcrabbit's was a little bit off, but close enough: CREATE TABLE `YOURDATABASENAME`.`ps_newsletter` ( `id` INT( 6 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , `email` VARCHAR( 255 ) NOT NULL , `newsletter_date_add` DATETIME NULL , `ip_registration_newsletter` VARCHAR( 15 ) NOT NULL , `http_referer` VARCHAR( 255 ) NULL ) ENGINE = MYISAM default CHARSET=utf8 5. ???????6. PROFIT!!!!I can confirm this worked for me on the newest prestashop! Now to export the customers, you go to the Modules in Backend and click configure on the Newsletterv2.0 module.The "Export Newsletter Subscribers" option will only export the customers in the table you just created. The "Export customers" section will only export data from the customers table, no matter what you chose, it will omit the newsletter table. All you need to do if combine the two tables and you have your subscriber base!Will accept beer as donations. Link to comment Share on other sites More sharing options...
JAKCRABBIT Posted January 11, 2010 Share Posted January 11, 2010 Thanks for the reply, it was not my practice, I just transcribed what someone advised my friend. If it was good or bad, I dont know, I have not conducted any test.If it works, good for you and congratulations Link to comment Share on other sites More sharing options...
feeldak Posted January 19, 2010 Share Posted January 19, 2010 Hi,thanks for the tips.Where did you get Newsletter 2.0? I couldn't find it anywhere. Link to comment Share on other sites More sharing options...
JAKCRABBIT Posted January 19, 2010 Share Posted January 19, 2010 Newsletter 2.0 is coremodul of Presta 1.2.5. Link to comment Share on other sites More sharing options...
feeldak Posted January 19, 2010 Share Posted January 19, 2010 Thanks jakcrabbit for the reply. I have downloaded the latest Presta 1.2.5 but the version of the newsletter is still 1.0...EDIT: It was indeed in French for me... Link to comment Share on other sites More sharing options...
JAKCRABBIT Posted January 19, 2010 Share Posted January 19, 2010 Wtf?This from module newsletter from instalation: $this->name = 'newsletter'; $this->tab = 'Tools'; $this->version = 2.0; Link to comment Share on other sites More sharing options...
sm3004 Posted January 19, 2010 Share Posted January 19, 2010 Thanks jakcrabbit for the reply. I have downloaded the latest Presta 1.2.5 but the version of the newsletter is still 1.0...EDIT: It was indeed in French for me... Newsletter v2.0 is located in the tools section of the modules page. Hit CTRL + F and search for "newsl", it should be there Link to comment Share on other sites More sharing options...
enjay82 Posted September 6, 2010 Share Posted September 6, 2010 Hi there,I've followed sm3004's instructions, but still am receiving "error during subscription"Does anyone know what else I can do to fix this problem? Link to comment Share on other sites More sharing options...
a a a Posted November 20, 2010 Share Posted November 20, 2010 Hello, I have tried these methods and still can't get it to work, I need help pleaseRegardsCraig Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now