[Fixed large files download] Problem with files download

More
11 years 9 months ago #39653 by bendeb
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. :)

Flexicontent 4.1.0b1
Joomla 3.9.18

Please Log in or Create an account to join the conversation.

More
11 years 9 months ago #39655 by ggppdk
Hello,

the files / filemanager feature is improved in later version,

please backup your site with e.g. akeeba and the install:
v2.1.0 r1742

and retest, just the zero octets file could be a server-specific issue ... we will see

Regards


-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

Please Log in or Create an account to join the conversation.

More
11 years 9 months ago #39661 by bendeb
Thank ggppdk for your answer.

I have already tested with the latest version, and the problem still persist. And because of multiple changes in the css of this new version, I reinstall an old version because I have no time now to change it completly. :?

Could it be a CHMOD configuration problem ? Or server (OVH) ?
What CHMOD I have to apply on my securized folder ?

And how about the big error message I listed above ?
What it means ?
Since I truncate the flexicontent_files table, this message disapear, but the problem still persist however. :(

Flexicontent 4.1.0b1
Joomla 3.9.18

Please Log in or Create an account to join the conversation.

More
11 years 9 months ago #39666 by ggppdk
hello,

about 0 bytes download
it is probably due to some PHP error or warning getting printed before the HTTP header,

you can send me a PM with admin access to the site

and a frontend url of a content item that has a file


-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

Please Log in or Create an account to join the conversation.

More
11 years 9 months ago #39694 by ggppdk
Hello,

if you installed r1742 then please update to 1742a, it fixes a saving problem with file field,

-1- about slow query
apply this fix (this is temporary workaround , is needed only for large sites !!):

www.flexicontent.org/forum/index ... pic#p39690

-2- about the download being zero bytes that is another thing (i have your PM, i will look at it soon, at a convenient time)

Regards


-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

Please Log in or Create an account to join the conversation.

More
11 years 9 months ago #39776 by bendeb
Thank you ggppdk.
The files download worked great before, on the ancient server (with FC r1680).
Since I migrated to a new server, there is a lot of 0 ko files when I download it.
Even if I put a new file, it doesn't work. :?
I don't understand anything.
I'm waiting for your intervention on the site to fix this issue. Thank in advance. :)

Flexicontent 4.1.0b1
Joomla 3.9.18

Please Log in or Create an account to join the conversation.

Moderators: vistamediajoomlacornerggppdk
Time to create page: 0.357 seconds
Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Essential
These cookies are needed to make the website work correctly. You can not disable them.
Display
Accept
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline
Save