Jump to content


  • Posts

  • Joined

  • Last visited

Everything posted by toast691

  1. Sorry Bsmither - The last few days have been very long days at work. It was 27th August not July. I immediately tried to replicate the order but I was not able to. The product was still at 0 stock count with "Use Stock Setting' selected when I checked it Php is 7.4.22 SQL is 5.7.35
  2. I have had what you describe happen to me with the customer adding to cart before we take it offline and they still get the product on the order. Often it's hard to know exactly how it has occurred but this time was obvious. Product was last updated 2nd June 2021 so presuming that's when it was put to 0 stock count and the customer ordered on 27th July so last week. We are on version 6.4.2 of cubecart.
  3. Occasionally on our website we get products ordered that are out of stock - We use the 'Stock Level' function and set it to 0 when something is not available then un-tick 'Use Stock Level' to make something available again. Despite doing this we still get the odd product being ordered that has a zero stock level and the box ticked to use stock level.. Is this something others experience or a known bug in cubecart? Stami
  4. I tried what you mentioned above and also cleared the cache in maintenance with the invisible recaptcha but it still reverted to 'off'. I have since changed to V2 of recaptcha with new keys and done as you mentioned above plus also clearing the cache and it has stuck for 24 hours so far. Seems odd that CC62 might remember old settings - could become rather annoying. Thanks for the help bsmither I will update again if anything changes.
  5. For the last 3 months I have been using invisible reCAPTCHA without any issues at all and over the weekend it has turned it self off. I am referring to the setting in Store Settings>Features then under Bot Protection the field ' Enable Google reCAPTCHA' automatically changes to 'Off (Not Recommended)'. I then change it back to 'Invisible reCAPTCHA * (Recommended)' Roughly 20 minutes later I refresh the page and the setting is changed to Off again. I have put a new site and secrete key in but it is still happening. I am using retail therapy skin on version 6.2.0-b1
  6. I have tried changing to SMTP details and immediately there is a log of the following error: Request Sent - mailto:[email protected] Subject: Testing CubeCart Error: Mailer Failed Response received SERVER -&gt; CLIENT: 421 Too many concurrent SMTP connections; please try again later.<br> CLIENT -&gt; SERVER: EHLO www.greenpatchseeds.com.au<br> SERVER -&gt; CLIENT: <br> SMTP ERROR: EHLO command failed: <br> SMTP NOTICE: EOF caught while checking if connected<br> SMTP Error: Could not authenticate.<br> SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/Troubleshooting Maybe cubecart doesn't log when using the email set up as PHP?
  7. Yes CubeCart_email_log exists in the database and there were logs for customers up until 20th June 2017 mostly order updates and some password recovery. In classes/mailer.class.php is the below code $log_days = $GLOBALS['config']->get('config', 'r_email'); if(ctype_digit((string)$log_days) && $log_days > 0) { $GLOBALS['db']->insert('CubeCart_email_log', $email_data); $GLOBALS['db']->delete('CubeCart_email_log', 'date < DATE_SUB(NOW(), INTERVAL '.$log_days.' DAY)'); } elseif(empty($log_days) || !$log_days) { $GLOBALS['db']->insert('CubeCart_email_log', $email_data);
  8. Done exactly as you said.. Test newsletter sent to a personal hotmail address. The email was sent and showed up in my inbox. Not showing up in the log though.
  9. It has 30 entered in all of the log retention fields...
  10. There have been no emails logged since 11th of July which is when I was playing around with email settings and used the test email option. New orders come in every day and we have been getting emails to our admin email as I said but there is nothing in the log about them either. I updated to 6.1.8 today with no change. Stami
  11. Good Morning. (Morning in Australia anyway) Since upgrading to 6.1.7 customers have not received email updates in regard to their orders. We have still been getting order notifications to our admin email and the settings are correct in Settings>store settings>Advanced It is currently set up as PHP.. Previously it SMTP with SSL but it was the same with only admin getting emails. Any ideas where to start looking? Cheers Stami
  12. Ok so I had a closer look at the license key in the configuration plugin and it wasn't right so I put the correct key in and that has fixed it. Unsure why without this plugin the logo doesn't show up.. For now though it seems ok.
  13. I am using the same logo which was used on v 1.4 retail therapy. Under the logo tab the correct logos are assigned to where they should appear. I just checked the skin configuration plugin and the "Hide Store Logo" box has not been ticked so it shouldn't be causing it.
  14. I noticed my website logo is not showing up now that I upgraded to the latest version. I done a manual upgrade and was coming from version 6.1.5. I have looked in my error log file and this is the re-occurring error: [16-May-2017 08:33:22 Australia/Sydney] PHP Notice: No image mode set in /home/augreenpatchseed/public_html/classes/catalogue.class.php on line 1403 Any idea on how to resolve this? Thanks I should also point out that I upgraded my skin the same afternoon to retail therapy 1.5. If I change my skin to foundation then the logo appears again.. so perhaps it is a skin issue?
  15. I Have also got the same error in my store error log. With a bit over 300 errors since upgrading to the latest version in November. File: [catalogue.class.php] Line: [1715] "SELECT I.* FROM ccmo_CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM ccmo_CubeCart_pricing_group WHERE group_id = 0 GROUP BY product_id) as G ON G.product_id = I.product_id WHERE I.product_id IN (SELECT product_id FROM `ccmo_CubeCart_category_index` as CI INNER JOIN ccmo_CubeCart_category as C where CI.cat_id = C.cat_id AND C.status = 1) AND I.status = 1 AND (I.name fulltext '%dry%' OR I.description fulltext '%dry%' OR I.product_code fulltext '%dry%') LIMIT 30 OFFSET 0 " - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'fulltext '%dry%' OR I.description fulltext '%dry%' OR I.product_code fulltext '%' at line 1
  16. Hi, I am trying to link my SQL Database to Microsoft Excel. Excel already has the function to do this link but it asks for the "Server Name". Where can this be located and is there any tricks to creating this link between the online database and Excel? Cheers! Stami
  17. Awesome! Thanks bsmither.. xmlwriter and xmlreader were missing so I just enabled them in cpanel which solved the problem! This must have happened last time I upgraded cubecart because I had to upgrade the php version as well for cubecart to run. Thanks again! Stami
  18. Ok so I understand what you were trying to achieve bsmither and there was already a file there named error_log so i had a look at what the last error was and it is as follows: [21-Jul-2016 14:44:53 Australia/Sydney] PHP Fatal error: Class 'XMLWriter' not found in /home/augreenpatchseed/public_html/classes/xml.class.php on line 21 [21-Jul-2016 04:44:57 UTC] PHP Warning: Invalid Security Token in /home/augreenpatchseed/public_html/classes/sanitize.class.php on line 112 The error_log file has been recording errors but they are not being shown in the store admin area... It just appears empty without any errors. Line 21-30 of that file is as follows: class XML extends XMLWriter { ############################################## public function __construct($xml_header = true, $indent_string = ' ') { $this->openMemory(); $this->setIndent(true); $this->setIndentString($indent_string); if ($xml_header) { $this->startDocument('1.0', 'UTF-8');
  19. Hi Dirty Butter, I do have debug enabled but no information appears at all after i click rebuild sitemap. If I click the browsers back button and try to navigate to another page in admin I get a 'Possible cross site request forgery (CSRF) or browser back button used' error. Debug then shows a warning: PHP: [Warning] /home/augreenpatchseed/public_html/classes/sanitize.class.php:112 - Invalid Security Token[Notice] /home/augreenpatchseed/public_html/includes/functions.inc.php:202 - Undefined variable: _GET[Notice] /home/augreenpatchseed/public_html/includes/functions.inc.php:202 - Undefined variable: _GET[Notice] /home/augreenpatchseed/public_html/includes/functions.inc.php:202 - Undefined variable: _GET[Notice] /home/augreenpatchseed/public_html/admin/sources/dashboard.index.inc.php:193 - Undefined offset: 0[Notice] /home/augreenpatchseed/public_html/admin/sources/dashboard.index.inc.php:259 - Undefined variable: smarty_data Regards Stami
  20. Thanks Bsmither - I wasn't sure if I could just create the folder but I have done that and it is fine. Stami
  21. Hi, I have had this problem for a little while now.. When I try to re-build my sitemap I get a blank page and no errors in cubecart or cpanel. The link it goes to is https://www.greenpatchseeds.com.au/admin.php?_g=maintenance Any idea what it could be? Regards Stami
  22. Using cubecart 6.0.12 on Retail therapy skin. URL is www.greenpatchseeds.com.au Hi, I'm not sure if these two are related but when I go to rebuild my sitemap I get a blank page without any error messages and nothing appears in the error log. I did find an error in my cpanel admin area that the robots.txt file could not be found. Below is that error. "2016-06-24 00:24:28.355 [INFO] [] File not found [/home/augreenpatchseed/public_html/robots.txt] " What I am wondering is how I re-generate the robots.txt file and would it resolve the sitemap issue as well? Cheers Stami
  23. Hi, It seems over the weekend a gremlin has done something to the PayPal express checkout integration on my website. It has been working fine for appox. 8 months now but when clicking the express checkout button for PayPal it takes you to the following page which is blank... https://greenpatchseeds.com/index.php?_a=gateway&module=PayPal_Pro Any Ideas at all? I have checked all the api details which are correct and also un-installed and re-installed both standard paypal and express paypal. Standard PayPal is working at the moment as a quick fix. Using the latest cubecart version. Nothing in error logs either. Regards Stami
  24. Hi Brian, Problem solved! The user name was correct but the password was something way different in that file. I had presumed the password would have been the same as original log in details for cpanel but it looks like something auto generated. Thanks again!!
  25. Hi Brian, Thanks for the reply. In the MySQL maintenance area I can't find where it would show that either and there is no options when creating a new user to select the source of connection so I am presuming it auto assigns to @localhost. In phpmyadmin all mentions are of @localhost.
  • Create New...