npn2531 Posted February 7, 2014 Author Share Posted February 7, 2014 Try manually replacing every ' in the statement. Sometimes when you copy and paste sql statements across word processing platforms these marks are mis-read. Quote Oscommerce site: OSC to CSS, http://addons.oscommerce.com/info/7263 -Mail Manager, http://addons.oscommerce.com/info/8120 Link to comment Share on other sites More sharing options...
Guest Posted February 7, 2014 Share Posted February 7, 2014 I will try it this evening. I do hope it works because Ive been looking for a program like this. Used UHTML for some time but there where some bugs. (After the installation of mailmanager my complete site went blank. Could this be because of the SQL problems) Quote Link to comment Share on other sites More sharing options...
npn2531 Posted February 7, 2014 Author Share Posted February 7, 2014 If you can see the page you are on in the address bar when looking at the blank screen you can use echo statements to find the error. Just open up the page that is blank and then starting from just below the opening <?php mark, type in several places down the page something like: echo 'line 2'; or echo 'line 50'; As long as you haven't placed them within a 'if then' statement, then the echo statements you add above the error will print on the screen and the echo statements below the error will not print, and you can narrow down exactly where the error is. joli1811, Tsimi and Mort-lemur 3 Quote Oscommerce site: OSC to CSS, http://addons.oscommerce.com/info/7263 -Mail Manager, http://addons.oscommerce.com/info/8120 Link to comment Share on other sites More sharing options...
Guest Posted February 8, 2014 Share Posted February 8, 2014 Well, the import of the .sql file did not work for the file included with the addon february 6th. But after clicking on your signatures link I've imported that file and...mwuahahaha...succes. I can't see any difference at that level but I guess it will work....well..I hope ;) Quote Link to comment Share on other sites More sharing options...
Guest Posted February 8, 2014 Share Posted February 8, 2014 Well, the import of the .sql file did not work for the file included with the addon february 6th. But after clicking on your signatures link I've imported that file and...mwuahahaha...succes. I can't see any difference at that level but I guess it will work....well..I hope ;) Well, I used diffuse merge tool to compare both the .sql files and found 2 little diferences. For one instance the line: ALTER TABLE `customers` ADD `mmstatus` CHAR( 2 ) NOT NULL AFTER `customers_newsletter` -could not be found with mergetool so I imported it by hand. That gave me a .sql error. I replaced every `for ' and it worked. The database was made and gave no errors while using phpMyadmin. Then I used the .sql file without the above named code and...it imported without any errors. I thought this would be succes! Nevertheless it didn't bring me any luck. Again I had a blank screen at admin and public part of the website. I'm done with it. It doesn't work for me although it is still the addon I was looking for. Quote Link to comment Share on other sites More sharing options...
npn2531 Posted February 8, 2014 Author Share Posted February 8, 2014 I am willing to bet you have a typo or something somewhere. Quote Oscommerce site: OSC to CSS, http://addons.oscommerce.com/info/7263 -Mail Manager, http://addons.oscommerce.com/info/8120 Link to comment Share on other sites More sharing options...
KeesB Posted February 19, 2014 Share Posted February 19, 2014 Hi! I'm having the same problem..... Using osC 2.3.3.4 and installed (en tripple checked) al modifications in the php-files. While importing your file "HTML_mailmanager_DB__.sql" in phpMyAdmin it generates an error. (see picture in attachment) I am not a SQL programmer, so I hope you can tell me in plain English what to do ;-) This is really the tool I would like to use. Tried some others but they were never as good as you say this one is :-) Thanks in advance! Kees Quote Link to comment Share on other sites More sharing options...
KeesB Posted February 19, 2014 Share Posted February 19, 2014 Oh oops... forgot to mention that I installed your new version HTML-mailmanager-osc_2.3.3.4 Frontend and backend are both blanc :wacko: Quote Link to comment Share on other sites More sharing options...
KeesB Posted February 19, 2014 Share Posted February 19, 2014 (edited) Again it's me.... :-) In the past two hours I checked al the changes in the php-files CHARACTER BY CHARACTER. Nothing wrong. Still blanc screens in frontend and backend. Restoring my backup now (thank god I have it) and still hope there is a solution for both problems. Edited February 19, 2014 by KeesB Quote Link to comment Share on other sites More sharing options...
npn2531 Posted February 19, 2014 Author Share Posted February 19, 2014 (edited) HTML-mailmanager-osc_2.3.3.4, http://addons.oscommerce.com/info/9004 is a different contribution than Mail Manager, http://addons.oscommerce.com/info/8120 . I have not looked at HTML-mailmanager-osc_2.3.3.4, it doesn't appear to have it's own support thread, perhaps the author, Flaggi can assist. Edited February 19, 2014 by npn2531 Quote Oscommerce site: OSC to CSS, http://addons.oscommerce.com/info/7263 -Mail Manager, http://addons.oscommerce.com/info/8120 Link to comment Share on other sites More sharing options...
KeesB Posted February 19, 2014 Share Posted February 19, 2014 HTML-mailmanager-osc_2.3.3.4, http://addons.oscommerce.com/info/9004 is a different contribution than Mail Manager, http://addons.oscommerce.com/info/8120 . I have not looked at HTML-mailmanager-osc_2.3.3.4, it doesn't appear to have it's own support thread, perhaps the author, Flaggi can assist. Thank you, @@npn2531 Quote Link to comment Share on other sites More sharing options...
Flaggi Posted February 19, 2014 Share Posted February 19, 2014 Thank you, @@npn2531 I´ve set up a support forum here: http://www.oscommerce.com/forums/topic/396184-html-mailmanager-osc-2334/ However i have tons of work and might be alittle slow with the responses :) Quote Link to comment Share on other sites More sharing options...
Guest Posted May 15, 2014 Share Posted May 15, 2014 Hi, works perfect on 2.3.1 with very small modifications! It seems that the placeholder for customers name doesn't work in sale_followup module. Anyone know how to fix this? Thanks. Quote Link to comment Share on other sites More sharing options...
Mastermix Posted June 2, 2014 Share Posted June 2, 2014 Hello, I ask you to help: I installed order_editor_for2.3_v1.1 (http://addons.oscommerce.com/info/7844) When I update the order status comes with one email only text and not with the email template manager. The installed version of MailManager is this: HTML-MailManager osc_2.3.3.4_upd.3 Thanks Quote Link to comment Share on other sites More sharing options...
das_gruene Posted July 15, 2014 Share Posted July 15, 2014 Hello, I tried to install various contrubutions to get my shop (2.2ms2) sending (good looking) html mails. Most of them do not work for newsletters, status updates and product notifications. As my store is heavy modded, and I'm about to starting in a productive environment, I just want to ask if there is a chance to get this contribution running in ms2 or am I wasting my time? When the shop is running, I think I will start over again with a new version, get all the features and the design of my store working on it and then migrate the data of the original store (as upgrading is - well - not really possible)... So - should I give it a try? Quote Link to comment Share on other sites More sharing options...
npn2531 Posted July 15, 2014 Author Share Posted July 15, 2014 It should work fine on 2.2ms2. You find it easier to upgrade a 2.2ms2 than to start anew and reinstall your contributions, esp if you have the design you like. The important security functions can certainly be upgrade. The detailed instructions to do this are on this site. Perhaps someone else, who knows where it is can post the link. Quote Oscommerce site: OSC to CSS, http://addons.oscommerce.com/info/7263 -Mail Manager, http://addons.oscommerce.com/info/8120 Link to comment Share on other sites More sharing options...
das_gruene Posted July 24, 2014 Share Posted July 24, 2014 It should work fine on 2.2ms2. You find it easier to upgrade a 2.2ms2 than to start anew and reinstall your contributions, esp if you have the design you like. The important security functions can certainly be upgrade. The detailed instructions to do this are on this site. Perhaps someone else, who knows where it is can post the link. Okay, so I tried to install your contribution today, there is still some work left (templates). One problem with the 2.2.ms2 seems to be, that the order status update mails come from a different file than in newer versions of the shop. The order status updates are still the same old text mails as without any addon. I am very shure, that I have changed all files correctly, the orders.php included. Still the same old ugly, charset-buggy textmail for order status updates. Perhaps someone can help me... would be nice to be able to change this, as this is a very important mail. Quote Link to comment Share on other sites More sharing options...
das_gruene Posted July 24, 2014 Share Posted July 24, 2014 Okay, so I tried to install your contribution today, there is still some work left (templates). One problem with the 2.2.ms2 seems to be, that the order status update mails come from a different file than in newer versions of the shop. The order status updates are still the same old text mails as without any addon. I am very shure, that I have changed all files correctly, the orders.php included. Still the same old ugly, charset-buggy textmail for order status updates. Perhaps someone can help me... would be nice to be able to change this, as this is a very important mail. I have found the problem myself. Works fine now. Still some small issues with the placeholders in the mails: in the order status update mail the $statusnewhtml does not work (puts out nothing) while $statusnewtxt works fine. Any clue for this? (There are some other placeholders wich do not work as they should, i.e. store_owner. Quote Link to comment Share on other sites More sharing options...
drdecker Posted August 12, 2014 Share Posted August 12, 2014 Hi I'm getting a bit stuck with this.... My email templates preview just fine within admin, but are all over the place once they hit someone's inbox. Basically the HTML isn't rendering, with the footer in particular just showing the HTML as text. I've attached some screenshots. Any thoughts please....... Quote Link to comment Share on other sites More sharing options...
npn2531 Posted August 16, 2014 Author Share Posted August 16, 2014 I am willing to bet you have a couple of typos somewhere in the html. The html in the text is kinda of the typical thing you see when a < or > has been left out. The errors are being rendered, or read just a bit differently in the different programs that ar reading your preview and the mail. In other words, the preview screen is less sensitive to the typos than your mail program. Quote Oscommerce site: OSC to CSS, http://addons.oscommerce.com/info/7263 -Mail Manager, http://addons.oscommerce.com/info/8120 Link to comment Share on other sites More sharing options...
Guest Posted October 6, 2014 Share Posted October 6, 2014 Hi All, I have probably missed this somewhere in the documentation, but I was wondering what triggers the sales_followup function once it has been enabled. Is it just someone going to the site and accessing a page, or does there need to be a cron job created to run this feature? Quote Link to comment Share on other sites More sharing options...
npn2531 Posted October 6, 2014 Author Share Posted October 6, 2014 (edited) You manually send it. Go to mail manager>bulk mail> and then select the installed thank you letter. It is one of the bulk mail letters. It is written to send to any customer whose order has been changed to a status of 'shipped' more than about 10 days, but no older than about 3 weeks. Thus if you wait three weeks without manually sending the letter you start skipping customers. I simply send it every time I go to process orders each day. It will run in the background. It will also not resend the letter to the order twice. It sends to the email in the customers order, per order. It only sends to the customer once per order, because it sends only to the email in a customer orders whose status is 'paid'. Once it sends the email it changes the status of that order to 'thank you' . You can see the programming and change what the status is changed to by going to: admin>includes>modules>mail manager>sale_followup.php and making the appropriate programming changes. Edited October 6, 2014 by npn2531 Quote Oscommerce site: OSC to CSS, http://addons.oscommerce.com/info/7263 -Mail Manager, http://addons.oscommerce.com/info/8120 Link to comment Share on other sites More sharing options...
npn2531 Posted October 6, 2014 Author Share Posted October 6, 2014 It only sends to the customer once per order, because it sends only to the email in a customer orders whose status is 'paid'. Once it sends the email it changes the status of that order to 'thank you' . You can see the programming and change what the status is changed to by going to: I mean 'shipped' not paid. Quote Oscommerce site: OSC to CSS, http://addons.oscommerce.com/info/7263 -Mail Manager, http://addons.oscommerce.com/info/8120 Link to comment Share on other sites More sharing options...
Guest Posted October 7, 2014 Share Posted October 7, 2014 Thanks! No wonder I missed it!. I wonder if it would be possible to modify the script and set up a cron job that could be accessed to run the sale_followup once a day. I have installed it and it works fine, but if we could automate it that would take away one more thing that someone has to remember to do. Quote Link to comment Share on other sites More sharing options...
npn2531 Posted October 7, 2014 Author Share Posted October 7, 2014 If you ran the follow sale letter once or twice a week, you would be sending out to all your sales and it only takes about three clicks. I am not familiar with how to setup cron job, but it is going to involve setting up something on your web server outside the php script itself. Quote Oscommerce site: OSC to CSS, http://addons.oscommerce.com/info/7263 -Mail Manager, http://addons.oscommerce.com/info/8120 Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.