Problème pour installer une deuxième fois JCE
- mihaly
- Hors Ligne
- Administrateur
Réduire
Informations
il y a 8 ans 6 mois - il y a 8 ans 6 mois #10856
par mihaly
Mihàly Marti alias Sarki
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
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 8 ans 6 mois par mihaly.
Connexion ou Créer un compte pour participer à la conversation.
- girafeprod
- Auteur du sujet
- Hors Ligne
- Nouveau membre
Réduire
Informations
- Messages : 8
- Remerciements 0
il y a 8 ans 6 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
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.
- mihaly
- Hors Ligne
- Administrateur
il y a 8 ans 6 mois #10882
par mihaly
Mihàly Marti alias Sarki
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 ?
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.151 secondes