Forum CMS Made Simple FR
[Résolu] Company Directory - Problème version from cms_version - Version imprimable

+- Forum CMS Made Simple FR (https://forum.cmsmadesimple.fr)
+-- Forum : Général (https://forum.cmsmadesimple.fr/forum-3.html)
+--- Forum : Modules, Tags (https://forum.cmsmadesimple.fr/forum-14.html)
+--- Sujet : [Résolu] Company Directory - Problème version from cms_version (/thread-832.html)


[Résolu] Company Directory - Problème version from cms_version - Kler - 24/11/2010

Citation :#~ Version du CMS: 1.8.2
#~ Nom de l'hébergeur : Netensia
#~ Informations Système :
#~ ----------------------------------------------
#~ Cms Version: 1.8.2
#~ Installed Modules:
#~ * CMSMailer: 2.0
#~ * FileManager: 1.0.2
#~ * MenuManager: 1.6.5
#~ * ModuleManager: 1.4
#~ * News: 2.10.6
#~ * nuSOAP: 1.0.2
#~ * Printing: 1.1.0
#~ * Search: 1.6.5
#~ * ThemeManager: 1.1.1
#~ * TinyMCE: 2.7.2
#~ * CGExtensions: 1.21.3
#~ * FormBuilder: 0.6.4
#~ * SiteMapMadeSimple: 1.2.1
#~ * CGSimpleSmarty: 1.4.5
#~ * CGFeedMaker: 1.0.11
#~ * CGExtensions: 1.21.3
#~ * CGFeedMaker: 1.0.11
#~ * JQueryTools: 1.0.10
#~ * CGSimpleSmarty: 1.4.5
#~ * CompanyDirectory: 1.5.2
#~ * FormBuilder: 0.6.4
#~ * Showtime: 1.0.5
#~ Config Information:
#~ * php_memory_limit:
#~ * process_whole_template: false
#~ * output_compression: false
#~ * max_upload_size: 64000000
#~ * default_upload_permission: 664
#~ * url_rewriting: none
#~ * page_extension:
#~ * query_var: page
#~ * use_hierarchy: true
#~ * image_manipulation_prog: GD
#~ * auto_alias_content: true
#~ * locale: fr_FR.utf-8
#~ * default_encoding: utf-8
#~ * admin_encoding: utf-8
#~ * set_names: true
#~ Php Information:
#~ * phpversion: 5.2.14
#~ * md5_function: On (Vrai)
#~ * gd_version: 2
#~ * tempnam_function: On (Vrai)
#~ * magic_quotes_runtime: Off (Faux)
#~ * E_STRICT: 0
#~ * memory_limit: 128M
#~ * max_execution_time: 30
#~ * output_buffering: On
#~ * safe_mode: Off (Faux)
#~ * file_uploads: On (Vrai)
#~ * post_max_size: 64M
#~ * upload_max_filesize: 64M
#~ * session_save_path: /tmp (1777)
#~ * session_use_cookies: On (Vrai)
#~ * xml_function: On (Vrai)
#~ Server Information:
#~ * Server Api: cgi
#~ * Server Db Type: MySQL (mysql)
#~ * Server Db Version: 5.0.90
#~ ----------------------------------------------

Bonsoir,

Je rencontre un sérieux problème sur mon module Company Directory. En effet après upgrade du système vers la version 1.8.2, je ne parviens plus à utiliser Company Dir correctment.
À l'insertion d'une nouvelle valeur dans le module, celui-ci me renvoie cette obscure erreur :

Code :
QUERY: SELECT version from cms_version
ERROR:

Et, justement, après ERROR... Il n'y a rien.
J'ai alors fait un debug. Mais là encore je ne comprends pas grand chose :-( La liste est longue et je m'excuse de devoir pourrir ce post mais...

Citation :Generé en 0,543308 secondes par CMS Made Simple utilisant 42 SQL queries et 8995756 bytes de mémoire (Sommet utilisation de la mémoire 9399884
Debug: (0.022516) - (629640)

loading smarty

Debug: (0.029582) - (902624)

loading adodb

Debug: (0.034912) - (988512)

loading page functions

Debug: (0.040041) - (1195108)

loading content functions

Debug: (0.044622) - (1399172)

loading pageinfo functions

Debug: (0.046823) - (1431904)

loading translation functions

Debug: (0.049436) - (1492872)

loading events functions

Debug: (0.052456) - (1576792)

loading php4 entity decode functions

Debug: (0.057416) - (1787884)

done loading files

Debug: (0.082226) - (2461396)

(mysql): SET NAMES 'utf8'

Debug: (0.085688) - (2480240)

(mysql): SELECT sitepref_name, sitepref_value from cms_siteprefs

Debug: (0.101297) - (2573820)

(mysql): SELECT * FROM cms_userplugins

Debug: (0,11295) - (2994564)

(mysql): SELECT * FROM cms_modules WHERE admin_only = 0 AND active = 1 ORDER by module_name

Debug display of 'End of include'Sad0,241348) - (6766252)
Debug display of 'Load Content Operations'Sad0,24347) - (6776960)
Debug display of 'End Load Content Operations'Sad0,255064) - (7341284)
Debug: (0,255949) - (7343548)

(mysql): SELECT content_id FROM cms_content WHERE default_content = 1

Debug: (0,256842) - (7344360)

(mysql): SELECT c.content_id, c.content_name, c.content_alias, c.menu_text, c.titleattribute, c.hierarchy, c.metadata, c.id_hierarchy, c.prop_names, c.create_date AS c_create_date, c.modified_date AS c_date, c.cachable, c.last_modified_by, t.template_id, t.encoding, t.modified_date AS t_date FROM cms_templates t INNER JOIN cms_content c ON c.template_id = t.template_id WHERE (c.content_alias = '15' OR c.content_id = '15') AND c.active = 1

Debug: (0,257329) - (7346192)

(mysql): SELECT MAX(modified_date) AS thedate FROM cms_content c

Debug display of 'Start Loading Hierarchy Manager'Sad0,257687) - (7343360)
Debug display of 'starting tree'Sad0,257726) - (7343904)
Debug: (0,263183) - (7483364)

file needs loading

Debug display of 'ending tree'Sad0,264311) - (7506228)
Debug display of 'End Loading Hierarchy Manager'Sad0,264352) - (7501532)
Debug: (0,264387) - (7501816)

start findNodeByTag

Debug: (0,264433) - (7502044)

end findNodeByTag

Debug: (0,265251) - (7505456)

(mysql): SELECT * FROM cms_content WHERE content_id = '15'

Debug: (0,269206) - (7683684)

load from data is loading properties

Debug: (0,270116) - (7686756)

(mysql): SELECT * FROM cms_content_props WHERE content_id = '15'

Debug: (0,277427) - (7814292)

(mysql): SELECT template_id, template_name, template_content, stylesheet, encoding, active, default_template, modified_date FROM cms_templates WHERE template_id = '20'

Debug: (0,291627) - (8494784)

(mysql): SELECT eh.tag_name, eh.module_name, e.originator, e.event_name, eh.handler_order, eh.handler_id, eh.removable FROM cms_event_handlers eh
INNER JOIN cms_events e ON e.event_id = eh.event_id
ORDER BY eh.handler_order ASC

Debug: (0,346797) - (8587740)

start findNodeByTag

Debug: (0,346868) - (8587944)

end findNodeByTag

Debug display of 'Start of Menu Manager Display'Sad0,34945) - (8669880)
Debug: (0,350533) - (8678212)

(mysql): SELECT * FROM cms_content WHERE content_id = '52'

Debug: (0,350871) - (8695656)

load from data is loading properties

Debug: (0,351507) - (8698756)

(mysql): SELECT * FROM cms_content_props WHERE content_id = '52'

Debug: (0,352876) - (8698276)

(mysql): SELECT * FROM cms_content WHERE content_id = '62'

Debug: (0,353184) - (8715576)

load from data is loading properties

Debug: (0,353825) - (8718556)

(mysql): SELECT * FROM cms_content_props WHERE content_id = '62'

Debug: (0,354926) - (8718164)

(mysql): SELECT * FROM cms_content WHERE content_id = '63'

Debug: (0,355226) - (8735472)

load from data is loading properties

Debug: (0,355972) - (8738452)

(mysql): SELECT * FROM cms_content_props WHERE content_id = '63'

Debug: (0,357134) - (8737968)

(mysql): SELECT * FROM cms_content WHERE content_id = '64'

Debug: (0,357454) - (8755224)

load from data is loading properties

Debug: (0,358157) - (8758204)

(mysql): SELECT * FROM cms_content_props WHERE content_id = '64'

Debug: (0,359264) - (8757736)

(mysql): SELECT * FROM cms_content WHERE content_id = '55'

Debug: (0,359583) - (8775032)

load from data is loading properties

Debug: (0,360248) - (8778012)

(mysql): SELECT * FROM cms_content_props WHERE content_id = '55'

Debug: (0,361391) - (8777484)

(mysql): SELECT * FROM cms_content WHERE content_id = '65'

Debug: (0,361708) - (8794828)

load from data is loading properties

Debug: (0,362353) - (8797808)

(mysql): SELECT * FROM cms_content_props WHERE content_id = '65'

Debug: (0,363459) - (8797352)

(mysql): SELECT * FROM cms_content WHERE content_id = '66'

Debug: (0,363766) - (8814688)

load from data is loading properties

Debug: (0,364506) - (8817668)

(mysql): SELECT * FROM cms_content_props WHERE content_id = '66'

Debug: (0,36559) - (8817184)

(mysql): SELECT * FROM cms_content WHERE content_id = '67'

Debug: (0,365908) - (8834476)

load from data is loading properties

Debug: (0,366573) - (8837456)

(mysql): SELECT * FROM cms_content_props WHERE content_id = '67'

Debug: (0,367632) - (8836996)

(mysql): SELECT * FROM cms_content WHERE content_id = '51'

Debug: (0,369773) - (8899636)

load from data is loading properties

Debug: (0,370509) - (8902616)

(mysql): SELECT * FROM cms_content_props WHERE content_id = '51'

Debug: (0,371691) - (8902912)

(mysql): SELECT * FROM cms_content WHERE content_id = '53'

Debug: (0,372018) - (8920188)

load from data is loading properties

Debug: (0,372687) - (8923168)

(mysql): SELECT * FROM cms_content_props WHERE content_id = '53'

Debug: (0,373798) - (8922716)

(mysql): SELECT * FROM cms_content WHERE content_id = '56'

Debug: (0,374124) - (8940288)

load from data is loading properties

Debug: (0,374864) - (8943268)

(mysql): SELECT * FROM cms_content_props WHERE content_id = '56'

Debug: (0,375716) - (8941920)

(mysql): SELECT * FROM cms_content WHERE content_id = '68'

Debug: (0,379037) - (9013596)

load from data is loading properties

Debug: (0,379772) - (9016576)

(mysql): SELECT * FROM cms_content_props WHERE content_id = '68'

Debug display of 'End of Menu Manager Display'Sad0,420017) - (9066904)
Debug: (0,420254) - (9029320)

start global_content_get_template

Debug: (0,424889) - (9117436)

(mysql): SELECT htmlblob_id, htmlblob_name, html, owner, modified_date FROM cms_htmlblobs WHERE htmlblob_name = 'publi'

Debug: (0,425116) - (9115424)

end global_content_get_template

Debug: (0,425173) - (9115524)

start global_content_get_timestamp

Debug: (0,42522) - (9115848)

end global_content_get_timestamp

Debug: (0,442297) - (9197888)

(mysql): SELECT * FROM cms_module_showtime_name WHERE show_id = 4

Debug: (0,44293) - (9203336)

(mysql): SELECT picture_id, picture_name, picture_url, picture_path, comment FROM cms_module_showtime WHERE active AND show_id = '4' ORDER BY picture_number

Debug: (0,468451) - (9127004)

start global_content_get_template

Debug: (0,469125) - (9130480)

(mysql): SELECT htmlblob_id, htmlblob_name, html, owner, modified_date FROM cms_htmlblobs WHERE htmlblob_name = 'Partenaires'

Debug: (0,469316) - (9128468)

end global_content_get_template

Debug: (0,469367) - (9128568)

start global_content_get_timestamp

Debug: (0,469413) - (9128892)

end global_content_get_timestamp

Debug: (0,479065) - (9130128)

start findNodeByTag

Debug: (0,479154) - (9130332)

end findNodeByTag

Debug: (0,488091) - (9131224)

start global_content_get_template

Debug: (0,48874) - (9134732)

(mysql): SELECT htmlblob_id, htmlblob_name, html, owner, modified_date FROM cms_htmlblobs WHERE htmlblob_name = 'footer'

Debug: (0,488954) - (9132848)

end global_content_get_template

Debug: (0,489001) - (9132948)

start global_content_get_timestamp

Debug: (0,489047) - (9133272)

end global_content_get_timestamp

Debug: (0,500812) - (9134092)

start global_content_get_template

Debug: (0,501499) - (9137640)

(mysql): SELECT htmlblob_id, htmlblob_name, html, owner, modified_date FROM cms_htmlblobs WHERE htmlblob_name = 'GAsynchrone'

Debug: (0,501694) - (9136616)

end global_content_get_template

Debug: (0,501745) - (9136716)

start global_content_get_timestamp

Debug: (0,501791) - (9137040)

end global_content_get_timestamp

Debug: (0,538062) - (9141008)

(mysql): SELECT DISTINCT A.css_id,A.media_type,B.assoc_order
FROM cms_css A, cms_css_assoc B
WHERE A.css_id = B.assoc_css_id
AND B.assoc_type = 'template'
AND B.assoc_to_id = '20'
ORDER BY B.assoc_order

Debug: (0,538297) - (9095560)

calling module TinyMCE from event ContentPostRender

Debug: (0,539813) - (9096380)

calling module CGExtensions from event ContentPostRender

Debug: (0,54306) - (9103184)

calling module Showtime from event ContentPostRender

Je sais par expérience que ce module est une vrai ch..... D'une part parce que les versions récentes sont catastrophiquement bugguées (je travaille donc avec la 1.5.2) et puis l'export en CSV ne génère qu'un malheureux fichier CSV de 300 octets, vierge de chez vierge.

Alors avant de me taper la réinsertion des quelques 458 entrées que contient cet annuaire d'entreprises... Je préfère demander. L'un de vous a peut-être déjà rencontré un problème de ce genre ?

Merci de votre aide.
K

[Résolu] Company Directory - Problème version from cms_version - jce76350 - 25/11/2010

y a t-il quelques chose sur le Bug Tracker ?
http://dev.cmsmadesimple.org/bug/list/250
Ou voir sur le forum EN

en général il vaut mieux utiliser les dernières version aussi bine des modules que du CMSms

[Résolu] Company Directory - Problème version from cms_version - Kler - 25/11/2010

Pour les versions c'est clair, d'habitude j'utilise toujours les dernières versions. Mais là vois-tu, lorsque j'ai installé Company Directory, on en était à la 1.5.2
Depuis j'ai essayé d'installer des versions plus récentes et j'ai souvent eu des problèmes. Du genre les onglets gabarits qui disparaissaient, et souvent des incompatibilités entre le module et CGExtensions.

J'ai laissé un message sur la Buglist. Je vais regarder sur le forum EN.