Cannot place an order - Githubissues

GoogleCodeExporter commented 8 years ago

What steps will reproduce the problem?
1. Template doesn't seem to update preview for multiple image templates, 
the process order returns server timeout error when we try to process order 
for any template that has more than one image preview.
2.
3.

What is the expected output? What do you see instead?

Expected output is to get email sent to the customer with a jpg attachment 
of the updated template and an email sent to the admin with pdf attachment 
for printing instead it just return can't update preview error.

SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
Trace:
#0 
/home/content/55/5500555/html/testing/magento_fact/lib/Zend/Db/Statement.ph
p(283): Zend_Db_Statement_Pdo->_execute(Array)
#1 
/home/content/55/5500555/html/testing/magento_fact/lib/Zend/Db/Adapter/Abst
ract.php(457): Zend_Db_Statement->execute(Array)
#2 
/home/content/55/5500555/html/testing/magento_fact/lib/Zend/Db/Adapter/Pdo/
Abstract.php(230): Zend_Db_Adapter_Abstract->query('SELECT `main_ta...', 
Array)
#3 
/home/content/55/5500555/html/testing/magento_fact/lib/Varien/Db/Adapter/Pd
o/Mysql.php(281): Zend_Db_Adapter_Pdo_Abstract->query('SELECT `main_ta...', 
Array)
#4 
/home/content/55/5500555/html/testing/magento_fact/lib/Zend/Db/Adapter/Abst
ract.php(687): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), 
Array)
#5 
/home/content/55/5500555/html/testing/magento_fact/app/code/core/Mage/Core/
Model/Mysql4/Design.php(163): Zend_Db_Adapter_Abstract-
>fetchRow(Object(Varien_Db_Select))
#6 
/home/content/55/5500555/html/testing/magento_fact/app/code/core/Mage/Core/
Model/Design.php(44): Mage_Core_Model_Mysql4_Design->loadChange('1', NULL)
#7 
/home/content/55/5500555/html/testing/magento_fact/app/code/core/Mage/Core/
Model/App/Area.php(158): Mage_Core_Model_Design->loadChange('1')
#8 
/home/content/55/5500555/html/testing/magento_fact/app/code/core/Mage/Core/
Model/App/Area.php(123): Mage_Core_Model_App_Area->_initDesign()
#9 
/home/content/55/5500555/html/testing/magento_fact/app/code/core/Mage/Core/
Model/App/Area.php(91): Mage_Core_Model_App_Area->_loadPart('design')
#10 
/home/content/55/5500555/html/testing/magento_fact/app/code/core/Mage/Core/
Model/App.php(567): Mage_Core_Model_App_Area->load()
#11 
/home/content/55/5500555/html/testing/magento_fact/app/code/core/Mage/Core/
Controller/Varien/Action.php(443): Mage_Core_Model_App-
>loadArea('frontend')
#12 
/home/content/55/5500555/html/testing/magento_fact/app/code/core/Mage/Core/
Controller/Front/Action.php(45): Mage_Core_Controller_Varien_Action-
>preDispatch()
#13 
/home/content/55/5500555/html/testing/magento_fact/app/code/core/Mage/Core/
Controller/Varien/Action.php(365): Mage_Core_Controller_Front_Action-
>preDispatch()
#14 
/home/content/55/5500555/html/testing/magento_fact/app/code/core/Mage/Core/
Controller/Varien/Router/Standard.php(248): 
Mage_Core_Controller_Varien_Action->dispatch('view')
#15 
/home/content/55/5500555/html/testing/magento_fact/app/code/core/Mage/Core/
Controller/Varien/Front.php(158): 
Mage_Core_Controller_Varien_Router_Standard-
>match(Object(Mage_Core_Controller_Request_Http))
#16 /home/content/55/5500555/html/testing/magento_fact/app/Mage.php(459): 
Mage_Core_Controller_Varien_Front->dispatch()
#17 /home/content/55/5500555/html/testing/magento_fact/index.php(65): 
Mage::run()
#18 {main}                

What version of the product are you using? On what operating system?

Magento ver. 1.3.2.4  

Please provide any additional information below.

We have created custom magento module to fetch updated preview images in 
jpg and pdf to send with order attachment via magento, all seems to work 
fine for any single image preview but with multiple images it just doesn't 
work.

The error is actually for receiving the orders
>>
>> The api code
>>
>> Curl url (API)  =
>>
>> http://realestate.factoryone.com.au/api.aspx?page=api-order-
save;ApiKey=b21c2708-2864-493f-a210-3b37eae8c549
>> Data : Array ( [TemplateID] =>  592CD787-DAA9-46AC-BA4A-D25DBEB30962
>>           [Previews] =>
>>
>> aca8f2fa-15cc-44cf-8a27-1c4691164692-0.jpg,ddc14994-d012-4e26-a93f-
018b1fad01b0-1.jpg
>>           [ID] =>  A09A9DF5-7B2B-3174-89B9-A9873793AA82
>>           [Hash] =>  dfb3cbbb35f199d6ab97666057d6cc3b)
>>

Original issue reported on code.google.com by akshay.s...@gmail.com on 27 Apr 2010 at 11:28

GoogleCodeExporter commented 8 years ago

Original comment by zetapri...@gmail.com on 28 Apr 2010 at 2:08

Changed title: Cannot place an order
Changed state: Accepted
Added labels: Type-Defect, Unit-0.5
Removed labels: Features, Help, Type-Enhancement, Unit-1, Wiki

GoogleCodeExporter commented 8 years ago

Original comment by zetapri...@gmail.com on 28 Apr 2010 at 2:09

Added labels: Stream-Customer

GoogleCodeExporter commented 8 years ago

The template in question (2260A995-8A0F-4043-9837-9C40C80E7D37) is faulty.
I see a heap of errors at the ZP end.

Original comment by zetapri...@gmail.com on 28 Apr 2010 at 11:47

GoogleCodeExporter commented 8 years ago

Original comment by zetapri...@gmail.com on 28 Apr 2010 at 10:37

Changed state: OhHold

GoogleCodeExporter commented 8 years ago

A designer is looking into the problem with the template.

Original comment by zetapri...@gmail.com on 28 Apr 2010 at 10:41

GoogleCodeExporter commented 8 years ago

I fixed and uploaded the template in the same catalog:
http://realestate.factoryone.com.au/?page=template;TemplateID=7ADA58AE-7816-40FE
-AC7A-FEEE53E3944A

The problem was with the image placeholders. I replaced them. The old image
placeholders that were inside PowerClips had different DPIs, over 500 DPI. I'm
guessing that after they were stretched to fill the different size PowerClips, 
the
were not converted back to 300 DPI bitmaps. That could have been the problem. 
Anyway
it works now, ran it through the system and got a PDF file generated no problem.

Original comment by agur...@gmail.com on 29 Apr 2010 at 11:00

Changed state: Finished

GoogleCodeExporter commented 8 years ago

There were 2 problems: faulty template and faulty code.
We fixed the faulty template and the customer fixed the faulty code before we 
got a
chance to review it.

Original comment by zetapri...@gmail.com on 10 May 2010 at 9:29

Changed state: Done

marianokit / magento-w2p

Cannot place an order #190