There appears to be an error with the database.

[artrix]

Witam wyskakuje mi blad podczas jak chce zrobic nowy dzial "There appears to be an error with the database."

Oto plik z folderu /cache

 

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Sun, 06 Jan 2013 18:09:56 +0000
 Error: 1203 - User napierz_77 already has more than 'max_user_connections' active connections
 IP Address: 178.37.98.242 - /index.php?s=0bb56297344a6e66f428398aaa2ae0d5&&app=shoutbox&module=ajax&section=coreAjax&secure_key=6270497e295612325bde90d573c7c306&type=getShouts&lastid=5183&global=1
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Sun, 06 Jan 2013 18:22:11 +0000
 Error: 1054 - Unknown column 'icon' in 'field list'
 IP Address: 83.5.155.65 - /admin/index.php?adsess=f4d2e12c2f1385a86204cd80eb180954&app=forums&&module=forums&section=forums&&do=donew&f=0&name=Nowe+forum
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: INSERT INTO forums (`name`,`name_seo`,`description`,`use_ibc`,`use_html`,`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`,`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`,`tag_predefined`,`forums_bitoptions`,`permission_custom_error`,`position`,`topics`,`posts`,`last_post`,`last_poster_id`,`last_poster_name`) VALUES('xxxxxxx','xxxxxxx','xxxxxxxxxxxxx',1,0,'','','last_post','Z-A',100,'all',0,1,0,0,1,-1,1,0,0,'',0,1,0,0,1,0,0,0,'',0,'',75,0,0,0,0,'')
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/applications/forums/modules_admin/forums/forums.php                  | [db_main_mysql].insert                                                        | 1322              |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications/forums/modules_admin/forums/forums.php                  | [admin_forums_forums_forums].forumSave                                        | 86                |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/sources/base/ipsController.php                                       | [admin_forums_forums_forums].doExecute                                        | 306               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Sun, 06 Jan 2013 18:24:25 +0000
 Error: 1054 - Unknown column 'icon' in 'field list'
 IP Address: 83.5.155.65 - /admin/index.php?adsess=f4d2e12c2f1385a86204cd80eb180954&app=forums&&module=forums&section=forums&&do=donew&f=0&name=Nowe+forum
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: INSERT INTO forums (`name`,`name_seo`,`description`,`use_ibc`,`use_html`,`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`,`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`,`tag_predefined`,`forums_bitoptions`,`permission_custom_error`,`position`,`topics`,`posts`,`last_post`,`last_poster_id`,`last_poster_name`) VALUES('xxxxxxxxxxx','xxxxxxxxxxx','xxxxxxxxxxxxxxxxxx',1,0,'','','last_post','Z-A',100,'all',0,1,0,0,1,-1,1,0,0,'',0,1,0,0,1,0,0,0,'',0,'',75,0,0,0,0,'')
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/applications/forums/modules_admin/forums/forums.php                  | [db_main_mysql].insert                                                        | 1322              |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications/forums/modules_admin/forums/forums.php                  | [admin_forums_forums_forums].forumSave                                        | 86                |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/sources/base/ipsController.php                                       | [admin_forums_forums_forums].doExecute                                        | 306               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

Edytowane 6 Stycznia 2013 przez Jakub
Wycięto niepotrzebne logi.

[pawel7121]

Co robi moje forum w Twoim profilu to po 1, a po 2 

Error: 1203 - User napierz_77

Czyżby chciałbyś zrobić podróbkę mojego forum? 

[artrix]

literowka w profilu

[Macsch15]

Wina hostingu.

[artrix]

to da się coś zrobić czy tylko kontakt z hostigiem ?

[Macsch15]

Kontakt albo zmiana (2 polecane).

[artrix]

co mam inapisac wkleic to co tutaj na forum czy jak ?

[Jakub]

Oj, Maciuś. Nie popatrzyłeś na dół logów.

 

@artrix http://forum.invisionize.pl/topic/8282-rozwiazany-tworzenie-nowego-forum-subforum/#entry55124

[artrix]

Aha czyli rozumiem że mam to zrobić ?

 

No właśnie tego nie zrobiłeś.

Wykonaj takie zapytanie w PhpMyAdminie lub bezpośrednio w ACP:

ALTER TABLE `ibf_forums` ADD `icon` text NOT NULL;

Jeśli masz inny prefix ( lub żaden ) niż ibf_ to pamiętaj, by go zmienić w tym zapytaniu.

Edytowane 6 Stycznia 2013 przez artrix

[Jakub]

Tak.

[artrix]

#1146 - Table 'napieprz_77777.ibf_forums' doesn't exist

[Jakub]

Nie pomyślałeś o zmianie prefiksu tabeli ibf_ na swój własny? Akurat w tym przypadku nie będzie go w ogóle, czyli zapytanie będzie wyglądało tak:

ALTER TABLE `forums` ADD `icon` text NOT NULL;

[artrix]

oo wyskoczyło

#1060 - Duplicate column name 'icon'

#1060 - Duplicate column name 'icon'

[Jakub]

Czyli pole już jest. Spróbuj teraz dodać nowe forum i daj znać jak poszło.

[artrix]

Wszystko chula mozesz lock thx za pomoc