Problème avec onglet fichier

More
11 years 2 months ago #39757 by juansolos
Bonjour,
je rencontre un problème lorque dans l'administration de flexicontent je clique sur "fichier".

Reponse :
Code:
getData(): SQL QUERY ERROR: Query execution was interrupted SQL=SELECT SQL_CALC_FOUND_ROWS f.*, u.name AS uploader, (SELECT COUNT(value) FROM xxxx_flexicontent_fields_item_relations AS rel JOIN xxxx_flexicontent_fields AS fi ON fi.id = rel.field_id WHERE fi.field_type = 'file' AND value = f.id) AS assigned_file, (SELECT COUNT(value) FROM xxxx_flexicontent_fields_item_relations AS rel JOIN xxxx_flexicontent_fields AS fi ON fi.id = rel.field_id WHERE fi.field_type = 'minigallery' AND value = f.id) AS assigned_minigallery, level.title as access_level, g.title AS groupname FROM xxxx_flexicontent_files AS f JOIN xxxx_users AS u ON u.id = f.uploaded_by LEFT JOIN xxxx_viewlevels as level ON level.id=f.access LEFT JOIN xxxx_usergroups AS g ON g.id = f.access ORDER BY f.filename , f.filename getItemsSingleprop(): SQL QUERY ERROR: MySQL server has gone away SQL=SELECT i.id as id, i.title FROM xxxx_content AS i JOIN xxxx_flexicontent_fields_item_relations AS rel ON rel.item_id = i.id JOIN xxxx_flexicontent_fields AS fi ON fi.id = rel.field_id AND fi.field_type IN ('file','minigallery') JOIN xxxx_flexicontent_files AS f ON f.id=rel.value GROUP BY i.id ORDER BY i.title ASC getItemsMultiprop(): SQL QUERY ERROR: MySQL server has gone away SQL=SELECT i.id as id, i.title FROM xxxx_content AS i JOIN xxxx_flexicontent_fields_item_relations AS rel ON rel.item_id = i.id JOIN xxxx_flexicontent_fields AS fi ON fi.id = rel.field_id AND fi.field_type IN ('image') JOIN xxxx_flexicontent_files AS f ON rel.value LIKE CONCAT("%","\"originalname\";s:%:%\"",f.filename,"\"%") GROUP BY i.id ORDER BY i.title ASC

Regards

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

More
11 years 2 months ago #39758 by ggppdk
Hello

can you try applying this fix (fix is for r1742a):

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


-- 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 2 months ago #39760 by juansolos
Thanks.

No change.

Regards

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

More
11 years 2 months ago #39763 by ggppdk
Hello,

how much time does it pass before you get this error?

did you change the correct file?

is it the same as original error or you get less errors with the patch applied ?

How many files and how many items does your site have?


-- 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 2 months ago #39765 by juansolos
Hello,
around 2 minutes before get this error. ("FLEXIcontent page creation is 124.35 secs (VIEW: filemanager)")

Yes i change the file.

The are the same errors.

I have around 3000 items and around 10000 files (images and pdf).

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

More
11 years 2 months ago #39768 by ggppdk
Hello,

the above patch, should have prevented this code from being executed

please send me a PM with admin login
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.

Moderators: vistamediajoomlacornerggppdk
Time to create page: 0.368 seconds
Save
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