Jump to content
Дизайн и модификация IPS Community IPBSkinsBETA
Search In
  • More options...
Find results that contain...
Find results in...
Sign in to follow this  
DroneUA

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

Recommended Posts

Зарание извините за возможные "тупизмы", я в 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               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

 

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

Share this post


Link to post
Share on other sites

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

 

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

ALTER TABLE forums ADD icon VARCHAR(255);

Share this post


Link to post
Share on other sites

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

 

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

ALTER TABLE forums ADD icon VARCHAR(255);

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...