Question: |
Hello. поддоменhttp://117.seocean.hipri unloading with stores information about the remaining goods, inscription goes: Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 10 bytes) in /home/seocean/public_html/117/system/database/mysql.php on line 30База data unloads the goods in the format sqlОднако unloading of goods need to edit in xml or excel for editing.Willing to incur additional costs - loading and unloading enough to do once. Further increase in memory is not required. |
Question: |
in the platform there is a script downloading in excel, but in this operation and an error occurs |
Answer: |
Hello. What value you need for the script to work? |
Question: |
The script given here are the notes:Estimated design data:XLS file Size: 9-10МБИспользование memory usage export: up to 13МВИспользование memory usage import: up to 355 Batory works fine with the following PHP settings:memory_limit 16M 512Mpost_max_size 16Mupload_max_filesize |
Answer: |
Parameters set to the following values: memory_limit 512M post_max_size 50M upload_max_filesize 50M please Check now.
|
Question: |
Was given this error:Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 19 bytes) in /home/seocean/public_html/117/system/PHPExcel/Classes/PHPExcel/Style/Supervisor.php on line 124 |
Answer: |
this MEA t that the script exceeds the limits of shared hosting |
Question: |
is there any solution? one unloading and one loading need only be done once. (In mysql is not possible to make a massive correction - we need to change the value of \",\" on value \".\")All other operations can be done through the format sqlЯ I repeat that we are ready to incur the cost if necessary |
Answer: |
you can split a file? |
Question: |
the script does not provide such vozmozhnostyakh unloading done entirely copied from mysql in xml format - uploads - fixed - back to download in xml format does not give - produces an error |
Answer: |
before uploading you can split a file? |
Question: |
if back to make loading into the database in xml format - then this too would be an option.and download in xml format in mysql is done with the default settings - of course, with the change of the format of the downloadable file may need something additional to configure? |
Answer: |
how to make zagorujko in xml ? |
Question: |
i.e. does it? I`m sorry - I`m not a programmer |
Question: |
I don`t even know how to split the table because I only single table upload not able and not all |
Answer: |
how often do you upload the file? |
Question: |
this store I have downloaded via the dump and the image of the site this week - to find bug in the module (I in sql -do not understand - but in opencart - versed) error in operation module not - there is an error in filling in the attributes of the product). Corrects errors in the attributes and turn in work. This is not my shop - and my host - I won`t have to load and unload the goods in the store.Maybe leave it for a demonstration - but only for demonstration. |
Answer: |
we`re going to make you more limits. please wait |
Question: |
OK I am waiting for |
Answer: |
please Check now.
|
Question: |
an error occurred with the display and the store and the admin - can`t login and check - limits because he could not influence - try to understand |
Question: |
you please wait, I now understand what conflict arose in the work shop and to unload |
Answer: |
ok
|
Question: |
here is what he writes now:Allowed memory size of 536870912 bytes exhausted (tried to allocate 79 bytes)See also `System > Error Logs` for more details. |
Answer: |
please Provide the link where you see the error. |
Question: |
Tried again upload:504 Gateway Time-out |
Question: |
http://117.seocean.ru/admin/index.php?route=tool/export/download&token=2e47ccdd381cf605f218991f5b32170f |
Question: |
And here is the latest data from the error log:2014-11-06 19:00:27 - PHP Fatal Error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 79 bytes) in /home/seocean/public_html/117/system/PHPExcel/Classes/PHPExcel/Style/Supervisor.php on line 1232014-11-06 19:17:46 - PHP Fatal Error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 19 bytes) in /home/seocean/public_html/117/system/PHPExcel/Classes/PHPExcel/Style/Supervisor.php on line 1242014-11-06 19:19:20 - PHP Fatal Error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 91 bytes) in /home/seocean/public_html/117/system/PHPExcel/Classes/PHPExcel/Style/Supervisor.php on line 123 |
Question: |
Page export to adminke:http://117.seocean.ru/admin/index.php?route=tool/export&token=28ca07fb6e0d2919e01dd21d49f61d3eлогин: adminпароль: 999rrrwww |
Answer: |
Provide the login credentials. |
Question: |
http://117.seocean.ru/adminлогин: adminпароль: 999rrrwww |
Answer: |
We have increased the limit up to 1024MB , but still viskakivaet error. In your system there is no limit? |
Question: |
about no limit in opencart I haven`t heard - speed - Yes - the speed drops |
Answer: |
please Check now.
|
Question: |
That`s what ended:504 Gateway Time-out |
Answer: |
this is an error of exceeding the time limit of the script. this option is global and only for you we can`t change it, but increase for the entire server as it is impossible |
Question: |
I knew you will forgive me and thank you for trying to help me than I really can blagodarnosti it is another question. I found a sql query to the database is образецUPDATE `var_contentvalues`SET value = REPLACE(value, `,`, `.`)WHERE `tmplvarid` = `10` AND ` value` LIKE `%,%`;it can be used to change the commas to points directly in the database annihilate this is a complete expression or not, and what tags it opens and closes? |
Answer: |
Check what is this for? LIKE `%,%`; |
Question: |
You only need this applied to my tables:UPDATE `oc_product_attribute`SET value = REPLACE(value, `,`, `.`)not needed:LIKE `%,%`; - as I understand - an exception |
Question: |
I.e. the full and desired expression is the following:UPDATE `oc_product_attribute`SET text = REPLACE(text, `,`, `.`)Don`t know - is it necessary in the end to put a semicolon |
Answer: |
please wait, your request has been sent to our programmer |
Question: |
OK thanks I`m waiting |
Answer: |
In what database you run this query? |
Question: |
in php Myadminбд: seocean_t1 |
Question: |
http://46.29.2.45:2082/cpsess1164080617/3rdparty/phpMyAdmin/index.php#PMAURL-14:sql.php?db=seocean_t1&table=oc_product_attribute&server=1&target=&token=192a2217f6cfc084de891e416885cd8a |
Answer: |
the search query is: SELECT `text` FROM `oc_product_attribute` WHERE `text` LIKE `%,%` ie for updates, you need to specify the first part of your query: UPDATE `oc_product_attribute` SET `text` = REPLACE(`text`, `,`, `.`) WHERE `text` LIKE `%,%` |
Question: |
Thank you very much! |
Answer: |
thank you for contacting tech support |