Jump to content

toast691

Member
  • Posts

    58
  • 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. Hi bsmither, For our purposes I would need product name, product code, category ID & quantity sold. Others may need further information for their needs?? The online function works well but once you have a large product range its slow filtering through all the pages trying to pick out slow selling products.
  5. I am just wondering if it is possible to export a list off all products into an excel document listing the qty that has been sold as it is listed in Reporting>statistics>Best Selling Products? I went into SQL database and it lists each products 'popularity' under the inventory tab but it doesn't seem to correspond with the QTY of product that has been sold. Any ideas?
  6. I am trying to purchase the Action Popup Plugin on the marketplace but I am getting an error stopping the purchase. I have logged in to my PayPal account and even tried a different personal PayPal account and it still won't work. Any suggestions? The error is as follows: There has been a problem setting up this payment. Account Account not found. Unilateral receiver not allowed in chained payment is restricted
  7. Any recommendations on this? It is a very simple code change but I just don't remember the file that needs changing.
  8. Hi, Just wondering how to export extra fields using the 'Sales Reports' function then 'Export' Specifically I want to export the 'order weight' and also the 'Method/Name Description' (think its called shipping product in the back end) from all in one shipping so I can use it to generate our shipping labels. I did have this setup in the past but site has been upgraded and the code has gone back to it default. Cheers Stami
  9. 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.
  10. 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
  11. 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?
  12. 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);
  13. 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.
  14. It has 30 entered in all of the log retention fields...
  15. 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
  16. 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
  17. 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.
  18. 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.
  19. 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?
  20. 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
  21. 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
  22. 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
  23. 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');
  24. 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
  25. Thanks Bsmither - I wasn't sure if I could just create the folder but I have done that and it is fine. Stami
×
×
  • Create New...