• Site mis à jour le 17 juillet 2019

Problème pour installer une deuxième fois JCE

Plus d'informations
il y a 3 ans 9 mois - il y a 3 ans 9 mois #10856 par mihaly
Réponse de mihaly sur le sujet Problème pour installer une deuxième fois JCE
Hello,
Merci pour tes voeux de rétablissement, j'en ai normalement encore pour quelques mois, et devrai être réopéré en fin d'année ou début d'année prochaine.

Essaie de créer cette table manuellement en faisant une requête SQL avec le contenu suivant, cela avait fonctionné pour quelqu'un d'autre.
Note : remplace le #_ par le préfixe de tes tables, exemple : bobo_wf_profiles
INSERT INTO `#__wf_profiles` (`id`, `name`, `description`, `users`, `types`, `components`, `area`, `device`, `rows`, `plugins`, `published`, `ordering`, `checked_out`, `checked_out_time`, `params`) VALUES
(1, 'Default', 'Profil d''administration (défaut)', '', '6,7,3,4,5,8', '', 0, 'desktop,tablet,phone', 'help,newdocument,spacer,undo,redo,spacer,clipboard,spacer,bold,italic,underline,strikethrough,spacer,justifyfull,justifyleft,justifycenter,justifyright,spacer,lists,indent,outdent,spacer,blockquote,spacer,textcase;styleselect,formatselect,fontselect,fontsizeselect,forecolor,backcolor,spacer,removeformat,cleanup,spacer,sub,sup,spacer,charmap,spacer,hr;visualblocks,spacer,visualaid,spacer,table,spacer,article,anchor,link,imgmap,unlink,spacer,imgmanager;autosave,spacer,source,spacer,layer,spacer,xhtmlxtras,spacer,style,spacer,preview,print,fullscreen,spacer,visualchars,nonbreaking,spacer,searchreplace,spacer,spellchecker', 'clipboard,lists,textcase,cleanup,visualblocks,table,article,anchor,link,imgmap,imgmanager,autosave,source,layer,xhtmlxtras,style,preview,print,fullscreen,visualchars,nonbreaking,searchreplace,spellchecker,browser,contextmenu,inlinepopups,media', 1, 1, 0, '0000-00-00 00:00:00', '{"editor":{"width":"","height":"","toolbar_theme":"default","toolbar_align":"left","toolbar_location":"top","statusbar_location":"bottom","path":"1","resizing":"1","resize_horizontal":"1","resizing_use_cookie":"1","toggle":"1","toggle_label":"[Afficher\\/Masquer]","toggle_state":"1","relative_urls":"1","verify_html":"","schema":"","forced_root_block":"","profile_content_css":"2","profile_content_css_custom":"","theme_advanced_styles":"","theme_advanced_blockformats":["p","div","h1","h2","h3","h4","h5","h6","address","code","pre","samp","span","section","article","hgroup","aside","figure","dt","dd"],"theme_advanced_fonts_add":"","theme_advanced_fonts_remove":"","theme_advanced_font_sizes":"","custom_colors":"","dir":"","filesystem":{"name":"joomla","joomla":{"allow_root":"0","restrict_dir":"administrator,cache,components,includes,language,libraries,logs,media,modules,plugins,templates,xmlrpc"}},"max_size":"8192","upload_conflict":"overwrite","upload_runtimes":["html5","flash","silverlight"],"browser_position":"bottom","folder_tree":"1","list_limit":"all","validate_mimetype":"1","websafe_mode":"utf-8","websafe_allow_spaces":"0","upload_add_random":"0","invalid_elements":"","invalid_attributes":"dynsrc,lowsrc","invalid_attribute_values":"","extended_elements":"","allow_javascript":"0","allow_css":"0","allow_php":"0","cdata":"1"},"clipboard":{"paste_use_dialog":"0","paste_dialog_width":"450","paste_dialog_height":"400","paste_force_cleanup":"0","paste_strip_class_attributes":"all","paste_remove_spans":"0","paste_remove_styles":"0","paste_remove_attributes":"","paste_retain_style_properties":"","paste_remove_empty_paragraphs":"1","paste_remove_styles_if_webkit":"0","paste_html":"1","paste_text":"1","buttons":["cut","copy","paste"]},"lists":{"number_styles":["default","lower-alpha","lower-greek","lower-roman","upper-alpha","upper-roman"],"bullet_styles":["default","circle","disc","square"],"buttons":["numlist","bullist"]},"visualblocks":{"state":"1"},"table":{"width":"","height":"","border":"0","cols":"2","rows":"2","cellpadding":"","cellspacing":"","align":"","classes":"","buttons":["table_insert","delete_table","row_props","cell_props","row_before","row_after","delete_row","col_before","col_after","delete_col","split_cells","merge_cells"]},"article":{"hide_xtd_btns":"0","buttons":["readmore","pagebreak"]},"link":{"target":"","id":"","style":"","classes":"","dir":"","hreflang":"","lang":"","charset":"","type":"","rel":"","rev":"","tabindex":"","accesskey":"","file_browser":"1","tabs_advanced":"1","attributes_anchor":"1","attributes_target":"1","links":{"joomlalinks":{"enable":"1","content":"1","article_alias":"1","static":"1","contacts":"1","weblinks":"1","weblinks_alias":"1","menu":"1"}},"popups":{"default":"","jcemediabox":{"enable":"1"},"window":{"enable":"1"}},"search":{"link":{"enable":"1","plugins":["categories","contacts","content","newsfeeds","weblinks"]}}},"imgmanager":{"dir":"","max_size":"","extensions":"image=jpeg,jpg,png,gif","hide_xtd_btns":"0","filesystem":{"name":""},"alt":"","margin_top":"","margin_right":"","margin_bottom":"","margin_left":"","border":"0","border_width":"1","border_style":"solid","border_color":"#000000","align":"","always_include_dimensions":"1","style":"","classes":"","title":"","id":"","direction":"","usemap":"","longdesc":"","tabs_rollover":"1","tabs_advanced":"1","attributes_dimensions":"1","attributes_align":"1","attributes_margin":"1","attributes_border":"1","upload":"1","folder_new":"1","folder_delete":"1","folder_rename":"1","folder_move":"1","file_delete":"1","file_rename":"1","file_move":"1","dragdrop_upload":"1"},"source":{"highlight":"1","numbers":"1","wrap":"1","format":"1","tag_closing":"1","selection_match":"1","theme":"textmate"},"xhtmlxtras":{"buttons":["cite","abbr","acronym","del","ins","attribs"]},"spellchecker":{"engine":"browser","browser_state":"0","googlespell_languages":["French=fr"],"languages":"English=en","pspell_mode":"PSPELL_FAST","pspell_spelling":"","pspell_jargon":"","pspell_encoding":"","pspell_dictionary":"components\\/com_jce\\/editor\\/tiny_mce\\/plugins\\/spellchecker\\/dictionary.pws","pspellshell_aspell":"\\/usr\\/bin\\/aspell","pspellshell_tmp":"\\/tmp"},"browser":{"dir":"","max_size":"","extensions":"office=doc,docx,ppt,xls;image=gif,jpeg,jpg,png;acrobat=pdf;archive=zip,tar,gz,rar;flash=swf;quicktime=mov,mp4,qt;windowsmedia=wmv,asx,asf,avi;audio=wav,mp3,aiff;openoffice=odt,odg,odp,ods,odf","filesystem":{"name":""},"upload":"1","folder_new":"1","folder_delete":"1","folder_rename":"1","folder_move":"1","file_delete":"1","file_rename":"1","file_move":"1"},"media":{"strict":"1","iframes":"0","audio":"1","video":"1","object":"1","embed":"1","version_flash":"10,1,53,64","version_windowsmedia":"10,00,00,3646","version_quicktime":"7,3,0,0","version_java":"1,5,0,0","version_shockwave":"10,2,0,023"}}'),
(2, 'Frontal', 'Profil pour la rédaction en frontal.', '', '3,4,5', '', 1, 'desktop,tablet,phone', 'help,newdocument,spacer,undo,redo,spacer,clipboard,spacer,bold,italic,underline,strikethrough,justifyfull,justifycenter,justifyleft,justifyright,spacer,lists,indent,outdent,spacer,blockquote,spacer,textcase;formatselect,styleselect,fontselect,fontsizeselect,forecolor,backcolor,spacer,cleanup,removeformat,spacer,sub,sup,spacer,charmap,spacer,hr;visualblocks,spacer,visualaid,spacer,table,spacer,article,anchor,link,imgmap,unlink,spacer,imgmanager;autosave,spacer,source,spacer,layer,spacer,xhtmlxtras,spacer,style,spacer,preview,print,fullscreen,spacer,visualchars,nonbreaking,spacer,searchreplace,spacer,spellchecker', 'clipboard,lists,textcase,cleanup,visualblocks,table,article,anchor,link,imgmap,imgmanager,autosave,source,layer,xhtmlxtras,style,preview,print,fullscreen,visualchars,nonbreaking,searchreplace,spellchecker,browser,contextmenu,inlinepopups,media', 1, 2, 0, '0000-00-00 00:00:00', '{"editor":{"width":"","height":"","toolbar_theme":"default","toolbar_align":"left","toolbar_location":"top","statusbar_location":"bottom","path":"1","resizing":"1","resize_horizontal":"1","resizing_use_cookie":"1","toggle":"1","toggle_label":"[Toggle Editor]","toggle_state":"1","relative_urls":"1","verify_html":"","schema":"","forced_root_block":"","profile_content_css":"2","profile_content_css_custom":"","theme_advanced_styles":"","theme_advanced_blockformats":["p","div","h1","h2","h3","h4","h5","h6","address","code","pre","samp","span","section","article","hgroup","aside","figure","dt","dd"],"theme_advanced_fonts_add":"","theme_advanced_fonts_remove":"","theme_advanced_font_sizes":"","custom_colors":"","dir":"images\\/frontal","filesystem":{"name":"joomla","joomla":{"allow_root":"0","restrict_dir":"administrator,cache,components,includes,language,libraries,logs,media,modules,plugins,templates,xmlrpc"}},"max_size":"","upload_conflict":"overwrite","upload_runtimes":["html5","flash","silverlight"],"browser_position":"bottom","folder_tree":"1","list_limit":"all","validate_mimetype":"1","websafe_mode":"utf-8","websafe_allow_spaces":"0","upload_add_random":"0","invalid_elements":"","invalid_attributes":"dynsrc,lowsrc","invalid_attribute_values":"","extended_elements":"","allow_javascript":"0","allow_css":"0","allow_php":"0","cdata":"1"},"clipboard":{"paste_use_dialog":"0","paste_dialog_width":"450","paste_dialog_height":"400","paste_force_cleanup":"0","paste_strip_class_attributes":"all","paste_remove_spans":"0","paste_remove_styles":"0","paste_remove_attributes":"","paste_retain_style_properties":"","paste_remove_empty_paragraphs":"1","paste_remove_styles_if_webkit":"0","paste_html":"1","paste_text":"1","buttons":["cut","copy","paste"]},"lists":{"number_styles":["default","lower-alpha","lower-greek","lower-roman","upper-alpha","upper-roman"],"bullet_styles":["default","circle","disc","square"],"buttons":["numlist","bullist"]},"visualblocks":{"state":"1"},"table":{"width":"","height":"","border":"0","cols":"2","rows":"2","cellpadding":"","cellspacing":"","align":"","classes":"","buttons":["table_insert","delete_table","row_props","cell_props","row_before","row_after","delete_row","col_before","col_after","delete_col","split_cells","merge_cells"]},"article":{"hide_xtd_btns":"0","buttons":["readmore","pagebreak"]},"link":{"target":"","id":"","style":"","classes":"","dir":"","hreflang":"","lang":"","charset":"","type":"","rel":"","rev":"","tabindex":"","accesskey":"","file_browser":"1","tabs_advanced":"1","attributes_anchor":"1","attributes_target":"1","links":{"joomlalinks":{"enable":"1","content":"1","article_alias":"1","static":"1","contacts":"1","weblinks":"1","weblinks_alias":"1","menu":"1"}},"popups":{"default":"","jcemediabox":{"enable":"1"},"window":{"enable":"1"}},"search":{"link":{"enable":"1","plugins":["categories","contacts","content","newsfeeds","weblinks"]}}},"imgmanager":{"dir":"","max_size":"","extensions":"image=jpeg,jpg,png,gif","hide_xtd_btns":"0","filesystem":{"name":""},"alt":"","margin_top":"","margin_right":"","margin_bottom":"","margin_left":"","border":"0","border_width":"1","border_style":"solid","border_color":"#000000","align":"","always_include_dimensions":"1","style":"","classes":"","title":"","id":"","direction":"","usemap":"","longdesc":"","tabs_rollover":"1","tabs_advanced":"1","attributes_dimensions":"1","attributes_align":"1","attributes_margin":"1","attributes_border":"1","upload":"1","folder_new":"1","folder_delete":"1","folder_rename":"1","folder_move":"1","file_delete":"1","file_rename":"1","file_move":"1","dragdrop_upload":"1"},"source":{"highlight":"1","numbers":"1","wrap":"1","format":"1","tag_closing":"1","selection_match":"1","theme":"textmate"},"xhtmlxtras":{"buttons":["cite","abbr","acronym","del","ins","attribs"]},"spellchecker":{"engine":"browser","browser_state":"0","googlespell_languages":["French=fr"],"languages":"English=en","pspell_mode":"PSPELL_FAST","pspell_spelling":"","pspell_jargon":"","pspell_encoding":"","pspell_dictionary":"components\\/com_jce\\/editor\\/tiny_mce\\/plugins\\/spellchecker\\/dictionary.pws","pspellshell_aspell":"\\/usr\\/bin\\/aspell","pspellshell_tmp":"\\/tmp"},"browser":{"dir":"","max_size":"","extensions":"office=doc,docx,ppt,xls;image=gif,jpeg,jpg,png;acrobat=pdf;archive=zip,tar,gz,rar;flash=swf;quicktime=mov,mp4,qt;windowsmedia=wmv,asx,asf,avi;audio=wav,mp3,aiff;openoffice=odt,odg,odp,ods,odf","filesystem":{"name":""},"upload":"1","folder_new":"1","folder_delete":"1","folder_rename":"1","folder_move":"1","file_delete":"1","file_rename":"1","file_move":"1"},"media":{"strict":"1","iframes":"0","audio":"1","video":"1","object":"1","embed":"1","version_flash":"10,1,53,64","version_windowsmedia":"10,00,00,3646","version_quicktime":"7,3,0,0","version_java":"1,5,0,0","version_shockwave":"10,2,0,023"}}'),
(3, 'Public', 'Profil pour les simples enregistrés et visiteurs', '', '1,9,2,8', '', 0, 'desktop,tablet,phone', 'undo,redo,spacer,bold,italic,underline,strikethrough,spacer,justifyfull,justifyleft,justifycenter,justifyright,spacer,forecolor,lists,indent,outdent,removeformat,spacer,charmap,hr,spacer,link,unlink', 'lists,link,contextmenu,inlinepopups', 1, 3, 0, '0000-00-00 00:00:00', '{"editor":{"width":"","height":"","toolbar_theme":"default","toolbar_align":"left","toolbar_location":"top","statusbar_location":"bottom","path":"1","resizing":"1","resize_horizontal":"1","resizing_use_cookie":"1","toggle":"0","toggle_label":"[Toggle Editor]","toggle_state":"1","relative_urls":"1","verify_html":"","schema":"","forced_root_block":"","profile_content_css":"2","profile_content_css_custom":"","theme_advanced_styles":"","theme_advanced_blockformats":["p","div","h1","h2","h3","h4","h5","h6","address","code","pre","samp","span","section","article","hgroup","aside","figure","dt","dd"],"theme_advanced_fonts_add":"","theme_advanced_fonts_remove":"","theme_advanced_font_sizes":"","custom_colors":"","dir":"images\\/frontal\\/public\\/$username","filesystem":{"name":"joomla","joomla":{"allow_root":"0","restrict_dir":"administrator,cache,components,includes,language,libraries,logs,media,modules,plugins,templates,xmlrpc"}},"max_size":"","upload_conflict":"overwrite","upload_runtimes":["html5","flash","silverlight"],"browser_position":"bottom","folder_tree":"1","list_limit":"all","validate_mimetype":"1","websafe_mode":"utf-8","websafe_allow_spaces":"0","upload_add_random":"0","invalid_elements":"","invalid_attributes":"dynsrc,lowsrc","invalid_attribute_values":"","extended_elements":"","allow_javascript":"0","allow_css":"0","allow_php":"0","cdata":"1"},"lists":{"number_styles":["default","lower-alpha","lower-greek","lower-roman","upper-alpha","upper-roman"],"bullet_styles":["default","circle","disc","square"],"buttons":["numlist","bullist"]},"link":{"target":"","id":"","style":"","classes":"","dir":"","hreflang":"","lang":"","charset":"","type":"","rel":"","rev":"","tabindex":"","accesskey":"","file_browser":"1","tabs_advanced":"1","attributes_anchor":"1","attributes_target":"1","links":{"joomlalinks":{"enable":"1","content":"1","article_alias":"1","static":"1","contacts":"1","weblinks":"1","weblinks_alias":"1","menu":"1"}},"popups":{"default":"","jcemediabox":{"enable":"1"},"window":{"enable":"1"}},"search":{"link":{"enable":"1","plugins":["categories","contacts","content","newsfeeds","weblinks"]}}}}'),
(4, 'Mobile', 'Sample Mobile Profile', '', '3,4,5,6,7,8', '', 0, 'tablet,phone', 'undo,redo,spacer,bold,italic,underline,formatselect,spacer,justifyleft,justifycenter,justifyfull,justifyright,spacer,fullscreen,kitchensink;styleselect,lists,spellchecker,article,link,unlink', 'fullscreen,kitchensink,spellchecker,article,link,inlinepopups,lists', 0, 4, 0, '0000-00-00 00:00:00', '{"editor":{"toolbar_theme":"mobile","resizing":"0","resize_horizontal":"0","resizing_use_cookie":"0","toggle":"0","links":{"popups":{"default":"","jcemediabox":{"enable":"0"},"window":{"enable":"0"}}}}}');

Mihàly Marti alias Sarki
Dernière édition: il y a 3 ans 9 mois par mihaly.

Connexion ou Créer un compte pour participer à la conversation.

  • girafeprod
  • Auteur du sujet
  • Hors Ligne
  • Nouveau Rédacteur
  • Nouveau Rédacteur
Plus d'informations
il y a 3 ans 9 mois #10864 par girafeprod
Réponse de girafeprod sur le sujet Problème pour installer une deuxième fois JCE
Salut,
merci pour ta réponse.
J'ai essayé mais je n'y arrive pas. Quels préfixes je dois utiliser ? J'ai plusieurs tables comme bak_, u2wgo_, ua5zt_
J'ai cliqué sur sql et rempli la fenêtre avec ton texte mais j'ai reçu un message d'erreur. Voici le message :
MySQL a répondu: Documentation

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`u2wgo_wf_profiles` (`id`, `name`, `description`, `users`, `types`, `components`' at line 1

je suis très débutant. merci pour ton aide et ta patience.
a bientôt,
Alex

Connexion ou Créer un compte pour participer à la conversation.

Plus d'informations
il y a 3 ans 9 mois #10882 par mihaly
Réponse de mihaly sur le sujet Problème pour installer une deuxième fois JCE
Hello,
Es-tu parvenu à réinstaller JCE ?
Si non, tu peux me créer un compte admin provisoire que je puisse te l'installer.
Il n'est pas normal que tu aies une erreur SQL... ta base de données est bien en utf8_general_ci ?

Mihàly Marti alias Sarki

Connexion ou Créer un compte pour participer à la conversation.

Temps de génération de la page : 0.197 secondes
Propulsé par Kunena

Rechercher