Hello,
I encounter a big problem with file download since I have change of server.
My new server is among OVH, mutualized.
Flexicontent version : 2.0.2 r1680 (I tested with the new version, but the problem is still here).
Joomla version : 2.5.10
I transfer all data of the ancient server toward the new server, and now, some files of my items are corrupt (0 ko).
The files are already on the FTP, I can download it without problem via FTP. But within my items, the download link give me a corrupt file of 0 kilo octets.
That don't apply to all items, juste a few but still a lot.
In the admin control panel, when I go to Flexicontent/files, I have a big error message that appear.
Code:
"getItemsMultiprop(): SQL QUERY ERROR:
Query execution was interrupted SQL=SELECT i.id as id, i.title FROM ddd_content AS i JOIN ddd_flexicontent_fields_item_relations AS rel ON rel.item_id = i.id JOIN ddd_flexicontent_fields AS fi ON fi.id = rel.field_id AND fi.field_type IN ('image') JOIN ddd_flexicontent_files AS f ON rel.value LIKE CONCAT("%","\"originalname\";s:%:%\"",f.filename,"\"%") GROUP BY i.id ORDER BY i.title ASC
userlevel(): SQL QUERY ERROR:
MySQL server has gone away SQL=SELECT a.id AS value, a.title AS text
FROM ddd_viewlevels AS a
GROUP BY a.id
ORDER BY a.ordering ASC,`title` ASC
userlevel(): SQL QUERY ERROR:
MySQL server has gone away SQL=SELECT a.id AS value, a.title AS text
FROM ddd_viewlevels AS a
GROUP BY a.id
ORDER BY a.ordering ASC,`title` ASC
userlevel(): SQL QUERY ERROR:
MySQL server has gone away SQL=SELECT a.id AS value, a.title AS text
FROM ddd_viewlevels AS a
GROUP BY a.id
ORDER BY a.ordering ASC,`title` ASC
userlevel(): SQL QUERY ERROR:
MySQL server has gone away SQL=SELECT a.id AS value, a.title AS text
FROM ddd_viewlevels AS a
GROUP BY a.id
ORDER BY a.ordering ASC,`title` ASC
userlevel(): SQL QUERY ERROR:
MySQL server has gone away SQL=SELECT a.id AS value, a.title AS text
FROM ddd_viewlevels AS a
GROUP BY a.id
ORDER BY a.ordering ASC,`title` ASC
userlevel(): SQL QUERY ERROR:
MySQL server has gone away SQL=SELECT a.id AS value, a.title AS text
FROM ddd_viewlevels AS a
GROUP BY a.id
ORDER BY a.ordering ASC,`title` ASC
userlevel(): SQL QUERY ERROR:
MySQL server has gone away SQL=SELECT a.id AS value, a.title AS text
FROM ddd_viewlevels AS a
GROUP BY a.id
ORDER BY a.ordering ASC,`title` ASC
userlevel(): SQL QUERY ERROR:
MySQL server has gone away SQL=SELECT a.id AS value, a.title AS text
FROM ddd_viewlevels AS a
GROUP BY a.id
ORDER BY a.ordering ASC,`title` ASC
userlevel(): SQL QUERY ERROR:
MySQL server has gone away SQL=SELECT a.id AS value, a.title AS text
FROM ddd_viewlevels AS a
GROUP BY a.id
ORDER BY a.ordering ASC,`title` ASC
userlevel(): SQL QUERY ERROR:
MySQL server has gone away SQL=SELECT a.id AS value, a.title AS text
FROM ddd_viewlevels AS a
GROUP BY a.id
ORDER BY a.ordering ASC,`title` ASC
userlevel(): SQL QUERY ERROR:
MySQL server has gone away SQL=SELECT a.id AS value, a.title AS text
FROM ddd_viewlevels AS a
GROUP BY a.id
ORDER BY a.ordering ASC,`title` ASC
userlevel(): SQL QUERY ERROR:
MySQL server has gone away SQL=SELECT a.id AS value, a.title AS text
FROM ddd_viewlevels AS a
GROUP BY a.id
ORDER BY a.ordering ASC,`title` ASC
userlevel(): SQL QUERY ERROR:
MySQL server has gone away SQL=SELECT a.id AS value, a.title AS text
FROM ddd_viewlevels AS a
GROUP BY a.id
ORDER BY a.ordering ASC,`title` ASC
userlevel(): SQL QUERY ERROR:
MySQL server has gone away SQL=SELECT a.id AS value, a.title AS text
FROM ddd_viewlevels AS a
GROUP BY a.id
ORDER BY a.ordering ASC,`title` ASC
userlevel(): SQL QUERY ERROR:
MySQL server has gone away SQL=SELECT a.id AS value, a.title AS text
FROM ddd_viewlevels AS a
GROUP BY a.id
ORDER BY a.ordering ASC,`title` ASC
userlevel(): SQL QUERY ERROR:
MySQL server has gone away SQL=SELECT a.id AS value, a.title AS text
FROM ddd_viewlevels AS a
GROUP BY a.id
ORDER BY a.ordering ASC,`title` ASC
userlevel(): SQL QUERY ERROR:
MySQL server has gone away SQL=SELECT a.id AS value, a.title AS text
FROM ddd_viewlevels AS a
GROUP BY a.id
ORDER BY a.ordering ASC,`title` ASC
userlevel(): SQL QUERY ERROR:
MySQL server has gone away SQL=SELECT a.id AS value, a.title AS text
FROM ddd_viewlevels AS a
GROUP BY a.id
ORDER BY a.ordering ASC,`title` ASC
userlevel(): SQL QUERY ERROR:
MySQL server has gone away SQL=SELECT a.id AS value, a.title AS text
FROM ddd_viewlevels AS a
GROUP BY a.id
ORDER BY a.ordering ASC,`title` ASC
userlevel(): SQL QUERY ERROR:
MySQL server has gone away SQL=SELECT a.id AS value, a.title AS text
FROM ddd_viewlevels AS a
GROUP BY a.id
ORDER BY a.ordering ASC,`title` ASC
userlevel(): SQL QUERY ERROR:
MySQL server has gone away SQL=SELECT a.id AS value, a.title AS text
FROM ddd_viewlevels AS a
GROUP BY a.id
ORDER BY a.ordering ASC,`title` ASC
userlevel(): SQL QUERY ERROR:
MySQL server has gone away SQL=SELECT a.id AS value, a.title AS text
FROM ddd_viewlevels AS a
GROUP BY a.id
ORDER BY a.ordering ASC,`title` ASC
userlevel(): SQL QUERY ERROR:
MySQL server has gone away SQL=SELECT a.id AS value, a.title AS text
FROM ddd_viewlevels AS a
GROUP BY a.id
ORDER BY a.ordering ASC,`title` ASC
userlevel(): SQL QUERY ERROR:
MySQL server has gone away SQL=SELECT a.id AS value, a.title AS text
FROM ddd_viewlevels AS a
GROUP BY a.id
ORDER BY a.ordering ASC,`title` ASC
userlevel(): SQL QUERY ERROR:
MySQL server has gone away SQL=SELECT a.id AS value, a.title AS text
FROM ddd_viewlevels AS a
GROUP BY a.id
ORDER BY a.ordering ASC,`title` ASC
userlevel(): SQL QUERY ERROR:
MySQL server has gone away SQL=SELECT a.id AS value, a.title AS text
FROM ddd_viewlevels AS a
GROUP BY a.id
ORDER BY a.ordering ASC,`title` ASC
userlevel(): SQL QUERY ERROR:
MySQL server has gone away SQL=SELECT a.id AS value, a.title AS text
FROM ddd_viewlevels AS a
GROUP BY a.id
ORDER BY a.ordering ASC,`title` ASC
userlevel(): SQL QUERY ERROR:
MySQL server has gone away SQL=SELECT a.id AS value, a.title AS text
FROM ddd_viewlevels AS a
GROUP BY a.id
ORDER BY a.ordering ASC,`title` ASC
userlevel(): SQL QUERY ERROR:
MySQL server has gone away SQL=SELECT a.id AS value, a.title AS text
FROM ddd_viewlevels AS a
GROUP BY a.id
ORDER BY a.ordering ASC,`title` ASC
userlevel(): SQL QUERY ERROR:
MySQL server has gone away SQL=SELECT a.id AS value, a.title AS text
FROM ddd_viewlevels AS a
GROUP BY a.id
ORDER BY a.ordering ASC,`title` ASC
Erreur de chargement du module MySQL server has gone away SQL=SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM ddd_modules AS m LEFT JOIN ddd_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN ddd_extensions AS e ON e.element = m.module AND e.client_id = m.client_id WHERE m.published = 1 AND e.enabled = 1 AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2013-09-01 12:33:24') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2013-09-01 12:33:24') AND m.access IN (1,1,2,3,4,5,6,7,10,9) AND m.client_id = 1 AND (mm.menuid = 0 OR mm.menuid <= 0) ORDER BY m.position, m.ordering"
- So I have removed all the files in my securised folder (I named it "site/pdf")
- I truncate the flexicontent_files table in the BDD (the big error message disapear, great).
- I upload some files (pdf) via the Flexicontent files manager.
- This some files appears correctly in site/pdf
- On my item, I erase the ancient files, and I put the new, I save and...
- ... it doesn't work either.
When I download it, it is a 0 kilo octets files.
How can I solve this problem ?
To date, I have to edit all my item (a lot) to put a correct file again on each of them, but if it doesn't work, it's useless.
Thank you in advance for your help.