4.1 Message d'erreur EX1615

[Soundamental]

Quelqu'un a-t'il déjà eu ce message d'erreur ?
 

Désolé, il y a un problème

Quelque chose s’est mal passé.Veuillez réessayer.

Code d’erreur  EX1615

 

 

Cela survient de façon aléatoire (a priori) et c'est temporaire : si on recommence l'action, ça ne se reproduit pas (en tout cas ça ne m'est jamais arrivé).

C'est juste pénible

 

A noter que ça provoque généralement un double post quand ça se produit au moment de valider un message.

[Youp3]

Bonsoir,

 

je ne crois pas avoir déjà rencontré ce code d’erreur. Et dans les journaux, tu n’as rien trouvé ?

[Soundamental]

Bonsoir,

 

je ne crois pas avoir déjà rencontré ce code d’erreur. Et dans les journaux, tu n’as rien trouvé ?

 

Le code d'erreur serait repris dans la ligne correspondante du journal ? Si c'est le cas je n'ai rien trouvé...

A noter que le journal des erreurs est vide, mais pas le journal système. Je ne comprends pas vraiment la différence entre les 2.

[Youp3]

Si la base de données est indisponible au moment d’écrire une erreur, les erreurs sont stockées dans des fichiers dans uploads/logs.

 

Je ne saurais pas t’expliquer la différence entre les deux journaux, vu que je n’ai moi aussi que des entrées dans le journal système. Pour trouver l’entrée adéquate, c’est plus sur l’heure à laquelle elle s’est produite qu’il faut que tu te bases.

[Soundamental]

OK merci !

Je vais devoir attendre que le problème se reproduise car personne n'avait noté d'heure...

[bouckie]

Bonsoir,

 

Nous avons hélas très souvent cette erreur, voila le journal et ce qu'il en ressort (c'est du chinois pour moi)

 

Le support US a fait comprendre qu'il pouvait rien faire... et nous avons ce genre d'erreurs parfois plus de 10 fois par minutes... l'erreur 500 venant elle aussi faire concurrence !

 

Bref, pour tout vous dire j'ai 1580 pages dans le Journal du système (depuis le 26/05/2016), la table Core_log fait plus de 425 Mo... Je me demandais même si je pouvais pas la vider ?

 

 

Si jamais ca vous parle... N'hésitez pas, de l'aide ne sera jamais de refus ;-) 

 

 

 

Ici il s'agit d'un probleme avec la galerie d'image. Elle a souffert avec la migration

 

The URL of page the error occurred on was http://luniversims.com/gallery/image/15257-image/

SELECT gallery_images.*, author.*, core_tags_cache.tag_cache_text FROM `gallery_images` LEFT JOIN `core_tags_cache` ON tag_cache_key=MD5(CONCAT('gallery;gallery;',gallery_images.image_id)) LEFT JOIN `core_members` AS `author` ON author.member_id = gallery_images.image_member_id LEFT JOIN `gallery_albums` ON gallery_albums.album_id=gallery_images.image_album_id WHERE image_album_id=104 AND image_id<>15257 AND image_updated <= 1457901359 AND ( gallery_albums.album_id IS NULL OR gallery_albums.album_type IN(1,2) OR ( gallery_albums.album_type=3 AND ( gallery_albums.album_owner_id=1 OR gallery_albums.album_allowed_access IN (0) ) ) ) AND gallery_images.image_approved < 2 AND gallery_images.image_category_id IN(2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,102,103,104,105,106,107,108) ORDER BY image_updated DESC, image_id DESC LIMIT 1
IPS\Db\Exception: Prepared statement needs to be re-prepared (1615)
#0 /home/lunivers/public_html/system/Db/Select.php(346): IPS\_Db->preparedQuery('SELECT gallery_...', Array)
#1 /home/lunivers/public_html/system/Db/Select.php(408): IPS\Db\_Select->runQuery()
#2 [internal function]: IPS\Db\_Select->rewind()
#3 [internal function]: IteratorIterator->rewind()
#4 /home/lunivers/public_html/applications/gallery/sources/Image/Image.php(928): iterator_to_array(Object(IPS\Patterns\ActiveRecordIterator))
#5 /home/lunivers/public_html/applications/gallery/sources/Image/Image.php(990): IPS\gallery\_Image->previousImages(1)
#6 /home/lunivers/public_html/applications/gallery/modules/front/gallery/view.php(246): IPS\gallery\_Image->prevItem()
#7 /home/lunivers/public_html/system/Dispatcher/Controller.php(96): IPS\gallery\modules\front\gallery\_view->manage()
#8 /home/lunivers/public_html/system/Content/Controller.php(46): IPS\Dispatcher\_Controller->execute()
#9 /home/lunivers/public_html/applications/gallery/modules/front/gallery/view.php(56): IPS\Content\_Controller->execute()
#10 /home/lunivers/public_html/system/Dispatcher/Dispatcher.php(129): IPS\gallery\modules\front\gallery\_view->execute()
#11 /home/lunivers/public_html/index.php(13): IPS\_Dispatcher->run()
#12 {main}

BACKTRACE

#0 /home/lunivers/public_html/init.php(498): IPS\_Log::log('SELECT gallery_...', 'uncaught_except...')
#1 [internal function]: IPS\IPS::exceptionHandler(Object(IPS\Db\Exception))
#2 {main}

et j'ai eu ca aussi :

Prepared statement needs to be re-prepared
SELECT gallery_images.*, author.*, core_tags_cache.tag_cache_text FROM `gallery_images` LEFT JOIN `core_tags_cache` ON tag_cache_key=MD5(CONCAT(?,gallery_images.image_id)) LEFT JOIN `core_members` AS `author` ON author.member_id = gallery_images.image_member_id LEFT JOIN `gallery_albums` ON gallery_albums.album_id=gallery_images.image_album_id WHERE image_album_id=? AND image_id<>? AND image_updated <= ? AND ( gallery_albums.album_id IS NULL OR gallery_albums.album_type IN(1,2) OR ( gallery_albums.album_type=3 AND ( gallery_albums.album_owner_id=? OR gallery_albums.album_allowed_access IN (0) ) ) ) AND gallery_images.image_approved < 2 AND gallery_images.image_category_id IN(2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,102,103,104,105,106,107,108) ORDER BY image_updated DESC, image_id DESC LIMIT 1
Array
(
    [0] => gallery;gallery;
    [1] => 104
    [2] => 15257
    [3] => 1457901359
    [4] => 1
)

 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | /system/Db/Db.php                                                          | [IPS\Db\_Exception].__construct                                               | 427               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | /system/Db/Select.php                                                      | [IPS\_Db].preparedQuery                                                       | 346               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | /system/Db/Select.php                                                      | [IPS\Db\_Select].runQuery                                                     | 408               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 |                                                                            | [IPS\Db\_Select].rewind                                                       |                   |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 |                                                                            | [IteratorIterator].rewind                                                     |                   |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | /applications/gallery/sources/Image/Image.php                              | [].iterator_to_array                                                          | 928               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | /applications/gallery/sources/Image/Image.php                              | [IPS\gallery\_Image].previousImages                                           | 990               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | /applications/gallery/modules/front/gallery/view.php                       | [IPS\gallery\_Image].prevItem                                                 | 246               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | /system/Dispatcher/Controller.php                                          | [IPS\gallery\modules\front\gallery\_view].manage                              | 96                |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | /system/Content/Controller.php                                             | [IPS\Dispatcher\_Controller].execute                                          | 46                |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | /applications/gallery/modules/front/gallery/view.php                       | [IPS\Content\_Controller].execute                                             | 56                |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | /system/Dispatcher/Dispatcher.php                                          | [IPS\gallery\modules\front\gallery\_view].execute                             | 129               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | /index.php                                                                 | [IPS\_Dispatcher].run                                                         | 13                |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

BACKTRACE

#0 /home/lunivers/public_html/system/Db/Exception.php(109): IPS\_Log::log('Prepared statem...', 'sql')
#1 /home/lunivers/public_html/system/Db/Db.php(427): IPS\Db\_Exception->__construct('Prepared statem...', 1615, NULL, 'SELECT gallery_...', Array)
#2 /home/lunivers/public_html/system/Db/Select.php(346): IPS\_Db->preparedQuery('SELECT gallery_...', Array)
#3 /home/lunivers/public_html/system/Db/Select.php(408): IPS\Db\_Select->runQuery()
#4 [internal function]: IPS\Db\_Select->rewind()
#5 [internal function]: IteratorIterator->rewind()
#6 /home/lunivers/public_html/applications/gallery/sources/Image/Image.php(928): iterator_to_array(Object(IPS\Patterns\ActiveRecordIterator))
#7 /home/lunivers/public_html/applications/gallery/sources/Image/Image.php(990): IPS\gallery\_Image->previousImages(1)
#8 /home/lunivers/public_html/applications/gallery/modules/front/gallery/view.php(246): IPS\gallery\_Image->prevItem()
#9 /home/lunivers/public_html/system/Dispatcher/Controller.php(96): IPS\gallery\modules\front\gallery\_view->manage()
#10 /home/lunivers/public_html/system/Content/Controller.php(46): IPS\Dispatcher\_Controller->execute()
#11 /home/lunivers/public_html/applications/gallery/modules/front/gallery/view.php(56): IPS\Content\_Controller->execute()
#12 /home/lunivers/public_html/system/Dispatcher/Dispatcher.php(129): IPS\gallery\modules\front\gallery\_view->execute()
#13 /home/lunivers/public_html/index.php(13): IPS\_Dispatcher->run()
#14 {main}

exemple d'une page Article : 

 

Désolé, il y a un problème

Quelque chose s’est mal passé.Veuillez réessayer.

Code d’erreur  EX1615

SELECT word_key, word_default, word_custom FROM `core_sys_lang_words` WHERE lang_id=2 AND word_key IN('__indefart_content_record_comments_title','__indefart_content_record_reviews_title','content_db_lang_ia_1','content_db_lang_su_1','content_record_comment_title','content_record_review_title','content_record_comments_title','content_record_reviews_title','content_db_lang_pu_1','content_db_lang_pl_1','content_db_lang_ia_2','content_db_lang_su_2','content_record_comment_title','content_record_review_title','content_record_comments_title','content_record_reviews_title','content_db_lang_pu_2','content_db_lang_pl_2','content_field_10','content_field_11','content_field_12','content_field_13','content_field_14','cms_page_3','content_cat_name_27','content_cat_name_32','content_cat_name_32','search_contextual_item','r__categories_sg','search_contextual_item','first_page','prev_page','prev','next_page','next','last_page','pagination','page_number','go','view_user_profile','view_user_profile','view_user_profile','view_user_profile','view_user_profile','view_user_profile','view_user_profile','view_user_profile','view_user_profile','view_user_profile','view_user_profile','like_blurb_others','like_log_title','see_who_liked','like_blurb','like_blurb','like_blurb_others','like_blurb','like_blurb','like_blurb','like_blurb','like_blurb','like_blurb','like_blurb','view_user_profile','share_this_comment','reputation_badge_tooltip','f_years_short','_date_last_year_long','date_replied','report_submit_success','report','report_content','like','multiquote','quote','edit','options','hide','delete','link_to_comment','share_externally','twitter_text','facebook_text','googleplus_text','digg_text','delicious_text','reddit_text','stumble_text','send_email_form','email_sent','email_text','date_replied','date_replied','date_replied','view_user_profile','date_replied','view_user_profile','_date_last_year_long','date_replied','date_replied','view_user_profile','_date_last_year_long','date_replied','date_replied','date_replied','view_user_profile','_date_last_year_long','date_replied','date_replied','date_replied','view_user_profile','_date_last_year_long','date_replied','view_user_profile','_date_last_year_long','date_replied','view_user_profile','date_replied','view_user_profile','_date_last_year_long','date_replied','view_user_profile','date_replied','date_replied','date_replied','date_replied','date_replied','view_user_profile','_date_last_year_long','date_replied','date_replied','date_replied','split','merge','unhide','submit','content_record_form_submit_comment','content_record_form_comment_412','loading','content_record_form__comment_placeholder','editor_keep_formatting','editor_pasted_with_formatting','editor_remove_formatting','editor_keep_embed','editor_pasted_embed_link','editor_remove_embed','editor_close_preview','device_desktop_preview','device_desktop','device_tablet_preview','device_tablet','device_phone_preview','device_phone','content_record_form_comment_412_desc','content_record_form_comment_412_warning','required','content_record_form_auto_follow','content_record_form_auto_follow_suffix','content_record_form_auto_follow_desc','content_record_form_auto_follow_warning','view_user_profile','content_db_lang_sl_1','cms_locked_can_comment','follow_this_content','follow','followers_tooltip','who_follows_this','content_record_started_by','_date_this_year_short','_date_this_year_long','date_edited','edited_lc','_date_last_year_long','view_user_profile','view_user_profile','like_blurb_others','like_blurb','content_record_actions','feature_title_record','feature','pin_title_record','pin','hide_title_record','unlock_title_record','unlock','move','move_title_record','delete_title_record','moderation_history','content_record_report','content_view_revisions','cms_back_to_category_with_title','cms_back_to_category','user_feedback','jump_to_content_desc','jump_to_content','menu_item_80','menu_item_37','menu_item_108','menu_item_91','menu_item_93','menu_item_90','menu_item_88','menu_item_86','menu_item_87','menu_item_89','menu_item_128','menu_item_92','menu_item_81','menu_item_97','menu_item_98','menu_item_101','menu_item_104','menu_item_106','menu_item_105','menu_item_99','menu_item_100','menu_item_102','menu_item_103','menu_item_107','frontnavigation_forums','frontnavigation_downloads','menu_item_1','menu_item_119','stream_title_1','stream_title_2','stream_title_3','stream_title_4','stream_title_5','menu_item_126','menu_item_127','menu_item_110','frontnavigation_blogs','menu_item_113','menu_item_114','menu_item_112','menu_item_117','menu_item_115','menu_item_116','all_activity','your_activity_streams','default_streams','create_new_stream','search','more','menu_item_34','menu_item_35','menu_item_36','menu_item_45','menu_item_54','menu_item_78','menu_content','view_my_profile','menu_profile','my_attachments','menu_settings_title','menu_followed_content','edit_account_settings','menu_settings','menu_manage_ignore','menu_modcp','menu_admincp','sign_out','create_menu_title','create_menu','add_announcement','announcement','status_update','saved','member_status','select_forum','topic','select_category','file_download','gallery_image','event','cms_select_category','cms_create_menu_records_1','cms_create_menu_records_2','select_blog','blog_entry','userbar_notifications','notification_options','notifications','see_all_notifications','userbar_messages','compose_new','message_sent','inbox','go_to_inbox','userbar_reports','report_center_header','report_center_link','cms_records1_pl','search_everything','advanced_search','search_placeholder','home','downloads_file_pl','view_this_file','view_user_profile','byline_nodate','downloads','view_this_file','view_user_profile','byline_nodate','view_this_file','view_this_file') and word_js=0
IPS\Db\Exception: Prepared statement needs to be re-prepared (1615)
#0 /home/lunivers/public_html/system/Db/Select.php(346): IPS\_Db->preparedQuery('SELECT word_key...', Array)
#1 /home/lunivers/public_html/system/Db/Select.php(408): IPS\Db\_Select->runQuery()
#2 /home/lunivers/public_html/system/Lang/Lang.php(1412): IPS\Db\_Select->rewind()
#3 /home/lunivers/public_html/system/Widget/Widget.php(753): IPS\_Lang->parseOutputForDisplay('\n<h3 class='ips...')
#4 /home/lunivers/public_html/system/Theme/Theme.php(718) : eval()'d code(12995): IPS\_Widget->__toString()
#5 [internal function]: IPS\Theme\class_core_front_global->widgetContainer('footer', 'horizontal')
#6 /home/lunivers/public_html/system/Theme/SandboxedTemplate.php(57): call_user_func_array(Array, Array)
#7 /home/lunivers/public_html/system/Theme/Theme.php(718) : eval()'d code(4898): IPS\Theme\_SandboxedTemplate->__call('widgetContainer', Array)
#8 /home/lunivers/public_html/system/Theme/Theme.php(718) : eval()'d code(4898): IPS\Theme\SandboxedTemplate->widgetContainer('footer', 'horizontal')
#9 [internal function]: IPS\Theme\class_core_front_global->globalTemplate('SFP : liste de ...', '\n<div id="elCms...', Array)
#10 /home/lunivers/public_html/system/Theme/SandboxedTemplate.php(57): call_user_func_array(Array, Array)
#11 /home/lunivers/public_html/system/Dispatcher/Dispatcher.php(149): IPS\Theme\_SandboxedTemplate->__call('globalTemplate', Array)
#12 /home/lunivers/public_html/system/Dispatcher/Dispatcher.php(149): IPS\Theme\SandboxedTemplate->globalTemplate('SFP : liste de ...', '\n<div id="elCms...', Array)
#13 /home/lunivers/public_html/system/Dispatcher/Standard.php(101): IPS\_Dispatcher->finish()
#14 /home/lunivers/public_html/system/Dispatcher/Front.php(499): IPS\Dispatcher\_Standard->finish()
#15 /home/lunivers/public_html/system/Dispatcher/Dispatcher.php(131): IPS\Dispatcher\_Front->finish()
#16 /home/lunivers/public_html/index.php(13): IPS\_Dispatcher->run()
#17 {main}

Modifié le 5 août 2016 par bouckie

[Youp3]

Si le support officiel dit qu’il ne peut rien faire, sans explication, ce n’est pas très normal.

 

Pour moi oui, tu peux vider ta table core log, voir vider aussi le journal. Au point où tu en es.

[Erwin]

Bonsoir,

 

Par curiosité j'ai cherché un peu, et je pense que cela vaut le coup de se rapprocher de l'hébergeur, car le problème peut être lié au serveur MySQL.

 

Quelques pistes :

• la valeur de table_definition_cache est trop faible ;
• un problème de concurrence entre le service mysql et mysqldump ;

Le code d'erreur renvoyé est juste le code d'erreur de MySQL si on enlève le 'EX'.