DamanC

Is it the Channel column or message_id that defines "yes, they have already been emailed, don't email them again"?

Cord @MailBeez, Many thanks, excuse the delay, I wanted to make sure I wasn't going bonkers and what I was stating above was happening. After closing a "RMA", from an order say 2 years ago, we change the order status back to shipped - 6 days later (the time set to ask a customer to write us an email) MB will then email them requesting a review on the purchased product. Its not ideal as not everyone will be happy if their RMA costs money etc and maybe inclined to leave a negative review. The customer would have been previously sent an email 2 years ago asking for a review so technically they have already had a review email. Sure enough over the last week, MB has been emailing old orders where a status has changed to "shipped" 6 days earlier. I have had a look at the mailbeez_tracking table and have found the following: http://i21.photobucket.com/albums/b296/DamanC/tracking.jpg (click the magnifying glass to enlarge) It looks like as of just under a year ago there are no entries in the channel or message_id column meaning if any orders older than this date change to a shipped status at any point - 6 days later they will get an email asking them to leave a review. Is there an easy way to set a date range in the module itself (maybe future development) or for me to simply stop this - I'm sure I could probably edit every entry manually and replicate a "DEFAULT" for the channel a copy one of the already used message_id entries but with 5K odd orders and several years it will take some time - is there a quick way? Could I simply delete the entries for the review module or will that simply replicate them again? Essentially I want to tell the DB that these customer have already been emailed and not to email them again........ I would appreciate your input :)

Cord @@MailBeez, Last question :) - where does MB store the information on the past customers/email address/orders it has emailed - both my review and winback modules now want to email past customers that have already been emailed - Its not too much of a problem currently as I have set an upper and lower day range, but if an order status is changed for some reason and then set back to the final "closed/shipped" order status, it will go and email them again.

Switched to define('DIR_FS_CATALOG', '/home/XXX/public_html/'); so far, so good :) @@MailBeez Cord you are a legend! Absolutely splendid - spent a day on this! Seems a bit odd having to do that, I did try; define('DIR_FS_CATALOG', '/'); Which seems like the logical path - clearly not :mellow:

STORE/includes/configure.php entry states; define('DIR_FS_CATALOG', dirname($HTTP_SERVER_VARS['SCRIPT_FILENAME']) . '/');

Blimey that was quick!!!

Just to clairify I have added the FWR Security exclusion $security_pro->addExclusion( 'mailhive.php' ); however I do not believe this is the issue.

Hi Cord, @@MailBeez I have been using your module for a couple of years now to excellent sucess - anyone reading this that doesnt use MB really should. I have run into a problem which I cant work out. Our Host moved us over to a new server along with a new static IP. Now my two MB modules (Winback Simple and Review Simple) wont work properly. When calling the Cron Job in a browser I get the following error; Warning: require_once(/mailhive/common/functions/compatibility.php) [function.require-once]: failed to open stream: No such file or directory in /home/XXX/public_html/mailhive/common/main/inc_mailhive.php on line 57 Fatal error: require_once() [function.require]: Failed opening required '/mailhive/common/functions/compatibility.php' (include_path='.:/opt/alt/php53/usr/share/pear:/opt/alt/php53/usr/share/php') in /home/XXX/public_html/mailhive/common/main/inc_mailhive.php on line 57 When I preview the email templates the same error jumps up in the BeeBox popup. I was running MB 2.9.5 on a 2.2RC2 Store - I have upgraded to the latest 2.9.8-7 version and now when I call the cron or email preview I simply get a blank page. The issue occurs when I Try to view recepients, send a test email or run either module. My Host is asking "What about if you change the code so that the full path is set to the files that are being referenced?" which Isnt really helpful - The file exists! Kinda Stuck so any input is appreciated. :(

Just so you guys know I have read https://support.sagepay.com/forum/Topic12167-21-1.aspx and http://www.oscommerce.com/forums/topic/368275-sagepay-server-integration-resolved/ No far off giving up tbh

Another day in, have spend a good 3 hours on the phone to sagepay tech support who basically know naff all. OSC is the last line of support. I have installed the module to the test site which resides on the same domain, same issue.

Just browsing though old transaction details - before I had setup the IP addresses Sage pay end, the transaction would fail even before stuffing in card details but it did log the request; Towards the end of the request I note notificationurl=https://www.mydomain.co.uk/checkout_process.php?check=SERVER&osCsid=07859e3396eba48a966ab5164f53296a Does that look right?

Just to add, Sage pay Form in simulator mode works perfectly! Its just sage pay Server in either simulator or Test is not having any of it! Im not the only one having problems, it seems many are having the same problem but with an unresolved outcome :(

Hi Guys, I have spent the last few days trying to solve a problem I am having with Sage Pay Server 1.1 on my 2.2RC2 Store. I have been given a test account from sage and in order to get our live account I have to process a dummy transaction through the test server and then refund it. Easy you would think! Its all setup, works nicely though the iframe however when the proceed button is clicked (or cancel) i get the dreaded 5006 error; HTTP Status Code: 500 HTTP Status Message: The request was unsuccessful due to an unexpected condition encountered by the server. Error Code : 5006 Error Description : Unable to redirect to Vendor's web site. The Vendor failed to provide a RedirectionURL. I have read thread after thread on here and on the sage forum to no avail and just cannot make head or tail of it. Im fairly sure its something to do with a redirection URL IE - The checkout_success page but im at a loss as to where its defined, or why it would need to be edited? So anyone able to help?

Hi guys, hoping someone in here maybe able to help. I visit my homepage and am greeted with; "2006 - MySQL server has gone away insert into whos_online (customer_id, full_name, session_id, ip_address, hostname, time_entry, time_last_click, last_page_url, http_referer, user_agent) values ('0', 'Guest', 'be64181d5801fdc905a0b9f5f967f3b7', '81.101.185.100', '81.101.185.100', '1266345893', '1266345893', '/', 'https://www.MYURL.co.uk/admin/configuration.php?gID=1&selected_box=configuration', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.9.1.7) Gecko/20091221 Firefox/3.5.7 GTB6 (.NET CLR 3.5.30729)') [TEP STOP]" Is it a SQL database issue?

Ah, well this is naff then :( I was looking at getting WPP integrated my my heavily modified site. "Go Compare" is not an acceptable answer. Paypals tech support is nothing short of pap. Its taken them nearly 1 month to tell me website payments standard will only accept upto £900 per transaction. The only way to accept more is to implement WPP which I cant with sh1te intructions. :mellow: Im going to give it a few days, if there is no real instructions we will have to move to another merchant that has "hold my hand" install instructions. Oh joy!

Well I added it, and it worked as normal :) There were two entries in the Google XML Sitemap controls but it wasn't a problem. It continued to work as normal, generating overnight etc and now has just stopped working again. Same fault, entries missing from SQL Tables :S

I checked the table configuration_group and configuration. Not a trace :S Ill give it a run and report back.....

The entry in the SQL Table is also missing. Run the SQL again?

The config part in the control panel is now missing .....

Same sort of problem as perderb except my config files are fine. As of Crimbo Eve it stopped generating. The only thing that had been done prior was to install the google base feed. I cant see anywhere where I would affect the sitemap though. Permissions are all correct, tried replacing with the stock xml files but still get the error. Anyone have any pointers? Warning: fopen(/sitemapproducts.xml) [function.fopen]: failed to open stream: Permission denied in /home/ukgaming/public_html/googlesitemap/sitemap.class_Alternate.php on line 354 ERROR: Google Product Sitemap Generation FAILED! Warning: fopen(/sitemapcategories.xml) [function.fopen]: failed to open stream: Permission denied in /home/ukgaming/public_html/googlesitemap/sitemap.class_Alternate.php on line 354 ERROR: Google Category Sitemap Generation FAILED! Warning: fopen(/sitemappages.xml) [function.fopen]: failed to open stream: Permission denied in /home/ukgaming/public_html/googlesitemap/sitemap.class_Alternate.php on line 354 ERROR: Google Pages Sitemap Generation FAILED! Warning: fopen(/sitemapindex.xml) [function.fopen]: failed to open stream: Permission denied in /home/ukgaming/public_html/googlesitemap/sitemap.class_Alternate.php on line 354 ERROR: Google Sitemap Index Generation FAILED! Array ( [QUERY] => Array ( [PRODUCTS] => Array ( [sTATUS] => success [NUM_ROWS] => 18 ) [CATEOGRY] => Array ( [sTATUS] => success [NUM_ROWS] => 7 ) ) [sAVE_FILE_XML] => Array ( [0] => Array ( [file] => /sitemapproducts.xml [status] => failure [file_exists] => false ) [1] => Array ( [file] => /sitemapcategories.xml [status] => failure [file_exists] => false ) [2] => Array ( [file] => /sitemappages.xml [status] => failure [file_exists] => false ) [3] => Array ( [file] => /sitemapindex.xml [status] => failure [file_exists] => false ) ) )

Hi James, My Index page text is simply the welcome text found in includes\languages\english\index.php :) Would be a fantastic contribution!

The index page is 90% of the time the landing page for customers. Cramming information into that welcome box is a superb SEO technique. However, it soon fills up and can look out of place with large amounts of text.....

Upgraded from 1.3 to 1.4 and...... That fixed my issue, thanks :) Can confirm everything else still works a charm and URLS generated for articles and topics are SEO friendly. Bonza :D

Ah, well they seem to be installed correctly but the articles themselves are not being generated in sitemappages. Sitemap pages is generating; article-submit.php article-topics.php article_info.php article_reviews_info.php article_reviews_write.php articles.php articles_new.php articles.php?tPath=2 articles.php?tPath=3 articles.php?tPath=4 But no articles themselves.......

Perfect, thanks :) Regarding the articles themselves. Are they not generated then?