I have a few issues with my CRE [url removed, login to view] website. As I have more than one site some of the configuration may be affected on the other sites as well.
#1 - I am unable to add any new products which involve product attributes as I receive the following error:
Array ( [products_options_sort_order] => 3 ) 1064 - 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 '' at line 1
update products_attributes set products_options_sort_order = '3' where products_attributes_id =
Already copied over the attributes sorter php from a functioning site to this one and it did not fix the problem.
#2 - Since the upgrade from [url removed, login to view] to [url removed, login to view] I am unable to review what is active in the shopping carts that customers are adding when I used to be able to do so.
#3 - The Sales Over Time is seriously overreported since the upgrade to 6.4B2B.
#4 - Would like the security fixed on this site as some of the php may have been hacked (per a response to the CRE loaded forum thread I created last week for my attributes problem.
Any changes done to this site should be done to my two other sites as well as the configuration for this site was used on the other sites.
Would like this work done ASAP - Within 2-3 days if possible.