Increase limit for stored templates in M.'s DB

JaimeChizavane / magento-w2p

Automatically exported from code.google.com/p/magento-w2p

0 stars 0 forks source link

Increase limit for stored templates in M.'s DB #794

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago

We store template details in the M. DB in template synchronization and use TEXT 
data type for it. But the type has limit of 65000 bytes in MySQL. Some 
templates can be bigger, so the will be truncated by MySQL.

We need to changed data type to MEDIUMTEXT.

Original issue reported on code.google.com by Anatoly....@gmail.com on 4 May 2012 at 8:41

GoogleCodeExporter commented 8 years ago

Diffs: http://code.google.com/p/magento-w2p/source/detail?r=1975

Original comment by Anatoly....@gmail.com on 4 May 2012 at 9:14

Changed state: Finished

GoogleCodeExporter commented 8 years ago

Original comment by Anatoly....@gmail.com on 4 May 2012 at 9:39

Added labels: Period-2012-05

GoogleCodeExporter commented 8 years ago

Please, test it with 2.1.2.0alpha1 release.

Create a template with a lot of fields and info in it for testing.

Original comment by Anatoly....@gmail.com on 11 May 2012 at 9:56

Changed state: ToTest

GoogleCodeExporter commented 8 years ago

Is this one sufficient?
https://d1.zetaprints.com/magedev/index.php/magentot-02/20-fields-x-text-and-ima
ge.html

Original comment by agur...@gmail.com on 11 May 2012 at 5:36

GoogleCodeExporter commented 8 years ago

The template is only 15 kilobytes, but we need more than 65K.

Please, add some dump text to the template such as default values, datasets.

Original comment by Anatoly....@gmail.com on 13 May 2012 at 6:25

GoogleCodeExporter commented 8 years ago

Ok now?
https://d1.zetaprints.com/magedev/index.php/magentot-02/20-fields-x-text-and-ima
ge.html

Original comment by agur...@gmail.com on 14 May 2012 at 12:58

Changed state: MoreWork

GoogleCodeExporter commented 8 years ago

Nope, it's only 18K now. You can check templates size at 
http://cname.zetaprints.com/?page=template-xml;TemplateID=F3CBEB75-1788-494E-8F4
3-A9BEEB2D4219

Open the link and click with right mouse button, choose View Page Info and find 
Size field. It should be more then 65 KB.

Add big amount of text to datasets.

Original comment by Anatoly....@gmail.com on 14 May 2012 at 1:51

Changed state: ToTest

GoogleCodeExporter commented 8 years ago

I don't see a "size" or "kb" word anywhere on the XML page nor its source code.
Where do I see the current size?

Original comment by agur...@gmail.com on 14 May 2012 at 2:25

GoogleCodeExporter commented 8 years ago

You should click on View Page Info menu item, but not on View Page Source one

Original comment by Anatoly....@gmail.com on 14 May 2012 at 6:40

GoogleCodeExporter commented 8 years ago

Try now? It should be 72 KB.

Original comment by agur...@gmail.com on 15 May 2012 at 7:41

Changed state: MoreWork

GoogleCodeExporter commented 8 years ago

Yep, it's OK!

Original comment by Anatoly....@gmail.com on 15 May 2012 at 10:00

Changed state: ToTest

GoogleCodeExporter commented 8 years ago

Not sure how to test. I Updated the preview without problems and placed the 
order without problems. Output PDF was also OK.
Test OK?

Original comment by agur...@gmail.com on 15 May 2012 at 10:31

GoogleCodeExporter commented 8 years ago

It it works then it's OK

Original comment by Anatoly....@gmail.com on 16 May 2012 at 10:31

GoogleCodeExporter commented 8 years ago

Original comment by agur...@gmail.com on 16 May 2012 at 11:31

Changed state: TestOK

GoogleCodeExporter commented 8 years ago

Original comment by ad...@zetaprints.com on 18 Jun 2012 at 4:41

Changed state: Done