[3.1.4] Ошибка базы данных 1054

[DroneUA 0]

Зарание извините за возможные "тупизмы", я в IPBoard не мастак...

Проблема обнаружилась внезапно и сказать точно из-за чего я не в силах. Могу только предположить что повлиял хук "Отображение модераторов форумов" и "Дефолтный аватар".

Прочитав подобные темы, для себя решения не нашел.

Вот последний лог:

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Wed, 23 May 2012 06:32:13 +0000
Error: 1054 - Unknown column 'icon' in 'field list'
IP Address: 195.57.19.102 - /forum/admin/index.php?adsess=47938fd3cf1befe3fec7abb899e62ee8&app=forums&&module=forums&section=forums&&do=donew&f=0&name=%D0%9D%D0%BE%D0%B2%D1%8B%D0%B9+%D1%84%D0%BE%D1%80%D1%83%D0%BC
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: INSERT INTO forums (`name`,`name_seo`,`description`,`use_ibc`,`use_html`,`status`,`password`,`password_override`,`sort_key`,`sort_order`,`prune`,`topicfilter`,`preview_posts`,`allow_poll`,`allow_pollbump`,`forum_allow_rating`,`inc_postcount`,`parent_id`,`sub_can_post`,`quick_reply`,`redirect_on`,`redirect_hits`,`redirect_url`,`notify_modq_emails`,`permission_showtopic`,`min_posts_post`,`min_posts_view`,`can_view_others`,`hide_last_info`,`icon`,`disable_sharelinks`,`permission_custom_error`,`position`,`topics`,`posts`,`last_post`,`last_poster_id`,`last_poster_name`) VALUES('Piar','piar','',1,0,1,'','','last_post','Z-A',100,'all',0,1,0,0,1,8,1,1,0,0,'',0,0,0,0,1,0,0,0,'',56,0,0,0,0,'')
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File                                                                       | Function                                                                      | Line No.          |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/applications/forums/modules_admin/forums/forums.php                  | [db_main_mysql].insert                                                        | 1318              |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications/forums/modules_admin/forums/forums.php                  | [admin_forums_forums_forums].forumSave                                        | 88                |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php                                       | [admin_forums_forums_forums].doExecute                                        | 285               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Wed, 23 May 2012 06:33:17 +0000
Error: 1054 - Unknown column 'icon' in 'field list'
IP Address: 195.57.19.102 - /forum/admin/index.php?adsess=47938fd3cf1befe3fec7abb899e62ee8&app=forums&&module=forums&section=forums&&do=donew&f=0&name=%D0%9D%D0%BE%D0%B2%D1%8B%D0%B9+%D1%84%D0%BE%D1%80%D1%83%D0%BC
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: INSERT INTO forums (`name`,`name_seo`,`description`,`use_ibc`,`use_html`,`status`,`password`,`password_override`,`sort_key`,`sort_order`,`prune`,`topicfilter`,`preview_posts`,`allow_poll`,`allow_pollbump`,`forum_allow_rating`,`inc_postcount`,`parent_id`,`sub_can_post`,`quick_reply`,`redirect_on`,`redirect_hits`,`redirect_url`,`notify_modq_emails`,`permission_showtopic`,`min_posts_post`,`min_posts_view`,`can_view_others`,`hide_last_info`,`icon`,`disable_sharelinks`,`permission_custom_error`,`position`,`topics`,`posts`,`last_post`,`last_poster_id`,`last_poster_name`) VALUES('Piar','piar','',1,0,1,'','','last_post','Z-A',100,'all',0,1,0,0,1,10,1,1,0,0,'',0,0,0,0,1,0,0,0,'',56,0,0,0,0,'')
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File                                                                       | Function                                                                      | Line No.          |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/applications/forums/modules_admin/forums/forums.php                  | [db_main_mysql].insert                                                        | 1318              |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications/forums/modules_admin/forums/forums.php                  | [admin_forums_forums_forums].forumSave                                        | 88                |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php                                       | [admin_forums_forums_forums].doExecute                                        | 285               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Wed, 23 May 2012 13:03:05 +0000
Error: 1054 - Unknown column 'icon' in 'field list'
IP Address: 188.230.22.132 - /forum/admin/index.php?adsess=2f098bb7a9517d8e63b44dec0f6dd2b2&app=forums&&module=forums&section=forums&&do=donew&f=0&name=%D0%9D%D0%BE%D0%B2%D1%8B%D0%B9+%D1%84%D0%BE%D1%80%D1%83%D0%BC
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: INSERT INTO forums (`name`,`name_seo`,`description`,`use_ibc`,`use_html`,`status`,`password`,`password_override`,`sort_key`,`sort_order`,`prune`,`topicfilter`,`preview_posts`,`allow_poll`,`allow_pollbump`,`forum_allow_rating`,`inc_postcount`,`parent_id`,`sub_can_post`,`quick_reply`,`redirect_on`,`redirect_hits`,`redirect_url`,`notify_modq_emails`,`permission_showtopic`,`min_posts_post`,`min_posts_view`,`can_view_others`,`hide_last_info`,`icon`,`disable_sharelinks`,`permission_custom_error`,`position`,`topics`,`posts`,`last_post`,`last_poster_id`,`last_poster_name`) VALUES('Пиар агенство','%d0%bf%d0%b8%d0%b0%d1%80-%d0%b0%d0%b3%d0%b5%d0%bd%d1%81%d1%82%d0%b2%d0%be','',1,0,1,'','','last_post','Z-A',100,'all',0,1,0,0,1,8,1,1,0,0,'',0,0,0,0,1,0,0,0,'',56,0,0,0,0,'')
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File                                                                       | Function                                                                      | Line No.          |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/applications/forums/modules_admin/forums/forums.php                  | [db_main_mysql].insert                                                        | 1318              |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications/forums/modules_admin/forums/forums.php                  | [admin_forums_forums_forums].forumSave                                        | 88                |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php                                       | [admin_forums_forums_forums].doExecute                                        | 285               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Wed, 23 May 2012 13:19:50 +0000
Error: 1054 - Unknown column 'icon' in 'field list'
IP Address: 188.230.22.132 - /forum/admin/index.php?adsess=09edb1552624ed58b1539c0169743ec3&app=forums&&module=forums&section=forums&&do=donew&f=0&name=%D0%9D%D0%BE%D0%B2%D1%8B%D0%B9+%D1%84%D0%BE%D1%80%D1%83%D0%BC
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: INSERT INTO forums (`name`,`name_seo`,`description`,`use_ibc`,`use_html`,`status`,`password`,`password_override`,`sort_key`,`sort_order`,`prune`,`topicfilter`,`preview_posts`,`allow_poll`,`allow_pollbump`,`forum_allow_rating`,`inc_postcount`,`parent_id`,`sub_can_post`,`quick_reply`,`redirect_on`,`redirect_hits`,`redirect_url`,`notify_modq_emails`,`permission_showtopic`,`min_posts_post`,`min_posts_view`,`can_view_others`,`hide_last_info`,`icon`,`disable_sharelinks`,`permission_custom_error`,`position`,`topics`,`posts`,`last_post`,`last_poster_id`,`last_poster_name`) VALUES('Пиар агенство','%d0%bf%d0%b8%d0%b0%d1%80-%d0%b0%d0%b3%d0%b5%d0%bd%d1%81%d1%82%d0%b2%d0%be','',1,0,1,'','','last_post','Z-A',100,'all',0,1,0,0,1,8,1,1,0,0,'',0,0,0,0,1,0,'temaserv.png',0,'',56,0,0,0,0,'')
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File                                                                       | Function                                                                      | Line No.          |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/applications/forums/modules_admin/forums/forums.php                  | [db_main_mysql].insert                                                        | 1318              |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications/forums/modules_admin/forums/forums.php                  | [admin_forums_forums_forums].forumSave                                        | 88                |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php                                       | [admin_forums_forums_forums].doExecute                                        | 285               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Wed, 23 May 2012 13:56:16 +0000
Error: 1054 - Unknown column 'icon' in 'field list'
IP Address: 84.232.59.163 - /forum/admin/index.php?adsess=2c5db113367df4ea18d184a30aaca022&app=forums&&module=forums&section=forums&&do=donew&f=0&name=%D0%9D%D0%BE%D0%B2%D1%8B%D0%B9+%D1%84%D0%BE%D1%80%D1%83%D0%BC
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: INSERT INTO forums (`name`,`name_seo`,`description`,`use_ibc`,`use_html`,`status`,`password`,`password_override`,`sort_key`,`sort_order`,`prune`,`topicfilter`,`preview_posts`,`allow_poll`,`allow_pollbump`,`forum_allow_rating`,`inc_postcount`,`parent_id`,`sub_can_post`,`quick_reply`,`redirect_on`,`redirect_hits`,`redirect_url`,`notify_modq_emails`,`permission_showtopic`,`min_posts_post`,`min_posts_view`,`can_view_others`,`hide_last_info`,`icon`,`disable_sharelinks`,`permission_custom_error`,`position`,`topics`,`posts`,`last_post`,`last_poster_id`,`last_poster_name`) VALUES('Пиар Проекта','%d0%bf%d0%b8%d0%b0%d1%80-%d0%bf%d1%80%d0%be%d0%b5%d0%ba%d1%82%d0%b0','',1,0,1,'','','last_post','Z-A',100,'all',0,1,0,0,1,8,1,1,0,0,'',0,0,0,0,1,0,0,0,'',56,0,0,0,0,'')
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File                                                                       | Function                                                                      | Line No.          |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/applications/forums/modules_admin/forums/forums.php                  | [db_main_mysql].insert                                                        | 1318              |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications/forums/modules_admin/forums/forums.php                  | [admin_forums_forums_forums].forumSave                                        | 88                |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php                                       | [admin_forums_forums_forums].doExecute                                        | 285               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

[DroneUA 0]

Up!Нужна помощь. Никак немогу справиться.

[siv1987 2628]

 Error: 1054 - Unknown column 'icon' in 'field list'

 

Column 'icon' это из хука иконки форума (forum icons).

[Ritsuka 540]

Виновный хук называется "(DP30) Forum Icons".

 

Перейдите в АЦ в раздел "Support > SQL Management > SQL Toolbox" и выполните запрос:

ALTER TABLE forums ADD icon VARCHAR(255);

[DroneUA 0]

Виновный хук называется "(DP30) Forum Icons".

 

Перейдите в АЦ в раздел "Support > SQL Management > SQL Toolbox" и выполните запрос:

ALTER TABLE forums ADD icon VARCHAR(255);

Спасибо большое, помогло! ;)