Reply From Nicolaas:
Hey Snowboarder82
You should get a lot of orders - that is pretty normal, but they should also be removed after a while. What version of e-commerce are you using?
You can browse to www.yoursite.com/dev/ecommerce/ and review the options there. That might help?
On what page are you getting the error? What I am trying to do right now is to make the product selection less memory intensive.
What are your product settings? Do you have the site on SVN / GIT?
Cheers
Nicolaas
-------------------------------------------------------------------------------
From Snowboarder82:
Hi Nicolaas,
Thank you very much for your quick reply – I definitely appreciate it!
In answer to your questions:
What version of e-commerce are you using?
I am using the "ecommerce module v0.8.1", as well as the "E-commerce Product Variations Colour Extension" from the SSU Demo Site
You can browse to www.yoursite.com/dev/ecommerce/ and review the options there. That might help?
Tried to access this but received a server error “Server Error <br /> Sorry, there was a problem handling your request.”…
On what page are you getting the error? What I am trying to do right now is to make the product selection less memory intensive.
The memory exhausted error is occurring only while loading the “Orders” page of the CMS.
What are your product settings?
I have all of the product settings commented out in the sites mysite/_config.php
Do you have the site on SVN / GIT?
No sorry, just copies on my local environment and the live version online. If it would help to have it up somewhere for you to reference please let me know and I’ll get this up asap – if so is there anywhere you would recommend?
Thank you, again I appreciate you looking into this so promptly Nicolaas.
Best regards,
-------------------------------------------------------------------------------
From Nicolaas:
Hi Snowboarder82
I have a few recommendations:
1. put your site on SVN/ GIT (will save you TONS of time in the long run)
2. upgrade to either Jeremy's shop or the latest version of e-commerce.
OR
go into the Order Class and remove some of the fields in the getCMSfields method to find out where it runs out of memory (which may or may not work)
OR
replace the search fields for Order and see if that makes a difference.
Hope that helps for now.... Hopefully I can come back to you on this one.
Cheers
Nicolaas
Hi Snowboarder82
The other temp fix you could apply is to delete all the orders from the database that do NOT have any order items associated with them
DELETE FROM \"Order\" LEFT JOIN \"OrderAttribute\" ON \"OrderAttribute\".\"OrderID\" = \"Order.\"ID\" WHERE \"OrderAttribute\".\"ID\" is NULL; [UNTESTED!]
-------------------------------------------------------------------------------
From Snowboarder82
Hi Nicolaas,
Thank you for the recommendations and advice for the temp fix to the database.
I tried the SQL as well as changing the syntax of it but couldn’t get it to work unfortunately… I have attached a copy of the database for your reference. As another idea what are your thoughts about deleting all orders in this instance where country is “NULL” as a quick fix?
I will look into putting the site on SVN / GIT, and will upgrade to the latest version of ecommerce – just wanted to confirm this is the svn-trunk-r1284 version from the silverstripe.org modules download page, or do I need to go to the code.google.com/p/silverstripe-ecommerce/ downloads section for the latest – For this situation I would prefer the most stable version available?
Thank you again for your help on this Nicolaas, it is much appreciated!
-------------------------------------------------------------------------------
From Nicolaas:
try https://silverstripe-ecommerce.googlecode.com/svn/branches
End of correspondence: