ROZWIĄZANY: Tworzenie Nowego Forum & SubForum

[snoxd]

Jeszcze wczoraj wszystko działało znakomicie az do teraz.

Chcialem stworzyć subforum do 1 działu ale nie dalo rady , pozniej zouwazylem ze juz wogole nie moge zadnego działu ani forum ani subfora stworzyć

Wpisuje nazwe forum , ustawiam przywileje dla kazdego ( Permission Access Levels ) daj OK i dostaje komunikat :

IPS Driver Error

There appears to be an error with the database.

You can try to refresh the page by clicking here

Klikam Click here ..i pojawiam sie w ACP > Managment z komunikatem :

Admin CP Message

Security Mismatch - please go back and reload the form before attempting to submit the form / press the button again

mozna temu jakoś zaradzić? probowalem kilkanascie razy refreshowac strone bo myslalem ze zle sie wczytało, ale dalej nie działa.

/ Forum które aktualnie uzywam IP. Board 2.3.6

Edytowane 10 Marca 2010 przez snoxd

[DawPi]

Witamy na forum, podaj proszę kod błędu, więcej informacji, jak go uzyskać znajdziesz tutaj:

[snoxd]

===================================================

Date: Wed, 10 Mar 2010 06:02:49 -0500

Error Number: 1054

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

IP Address: 80.52.169.74

Page: /admin/index.php?adsess=0a49952b70c4921f2ba07bd7ce7f4238&section=content&act=forum&code=donew&f=0&name=New%20Forum

mySQL query error: INSERT INTO ibf_forums (name,icon,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,redirect_loc,notify_modq_emails,permission_showtopic,permission_custom_error,id,position,topics,posts,last_post,last_poster_id,last_poster_name,permission_array) VALUES('Muzyka','Gears','Forum po¶więcone muzyce, w każdej formie. ',1,0,1,'','','last_post','Z-A',100,'all',0,1,0,0,1,13,1,1,0,0,'','','',0,'',15,15,0,0,0,0,'','a:6:{s:11:\\\"start_perms\\\";s:1:\\\"*\\\";s:11:\\\"reply_perms\\\";s:1:\\\"*\\\";s:10:\\\"read_perms\\\";s:1:\\\"*\\\";s:12:\\\"upload_perms\\\";s:1:\\\"*\\\";s:14:\\\"download_perms\\\";s:1:\\\"*\\\";s:10:\\\"show_perms\\\";s:1:\\\"*\\\";}')

===================================================

Date: Wed, 10 Mar 2010 06:02:57 -0500

Error Number: 1054

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

IP Address: 80.52.169.74

Page: /admin/index.php?adsess=0a49952b70c4921f2ba07bd7ce7f4238&section=content&act=forum&code=donew&f=0&name=New%20Forum

mySQL query error: INSERT INTO ibf_forums (name,icon,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,redirect_loc,notify_modq_emails,permission_showtopic,permission_custom_error,id,position,topics,posts,last_post,last_poster_id,last_poster_name,permission_array) VALUES('Muzyka','Gears','Forum po¶więcone muzyce, w każdej formie. ',1,0,1,'','','last_post','Z-A',100,'all',0,1,0,0,1,13,1,1,0,0,'','','',0,'',15,15,0,0,0,0,'','a:6:{s:11:\\\"start_perms\\\";s:1:\\\"*\\\";s:11:\\\"reply_perms\\\";s:1:\\\"*\\\";s:10:\\\"read_perms\\\";s:1:\\\"*\\\";s:12:\\\"upload_perms\\\";s:1:\\\"*\\\";s:14:\\\"download_perms\\\";s:1:\\\"*\\\";s:10:\\\"show_perms\\\";s:1:\\\"*\\\";}')

===================================================

Date: Wed, 10 Mar 2010 06:03:59 -0500

Error Number: 1054

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

IP Address: 80.52.169.74

Page: /admin/index.php?adsess=0a49952b70c4921f2ba07bd7ce7f4238&section=content&act=forum&code=donew&f=0&name=New%20Forum

mySQL query error: INSERT INTO ibf_forums (name,icon,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,redirect_loc,notify_modq_emails,permission_showtopic,permission_custom_error,id,position,topics,posts,last_post,last_poster_id,last_poster_name,permission_array) VALUES('Muzyka','','Forum po¶więcone muzyce, w każdej formie. ',1,0,1,'','','last_post','Z-A',100,'all',0,1,0,0,1,13,1,1,0,0,'','','',0,'',15,15,0,0,0,0,'','a:6:{s:11:\\\"start_perms\\\";s:1:\\\"*\\\";s:11:\\\"reply_perms\\\";s:1:\\\"*\\\";s:10:\\\"read_perms\\\";s:1:\\\"*\\\";s:12:\\\"upload_perms\\\";s:1:\\\"*\\\";s:14:\\\"download_perms\\\";s:1:\\\"*\\\";s:10:\\\"show_perms\\\";s:1:\\\"*\\\";}')

===================================================

Date: Wed, 10 Mar 2010 06:07:23 -0500

Error Number: 1054

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

IP Address: 80.52.169.74

Page: /admin/index.php?adsess=0a49952b70c4921f2ba07bd7ce7f4238&section=content&act=forum&code=donew&f=0&name=New%20Forum

mySQL query error: INSERT INTO ibf_forums (name,icon,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,redirect_loc,notify_modq_emails,permission_showtopic,permission_custom_error,id,position,topics,posts,last_post,last_poster_id,last_poster_name,permission_array) VALUES('TEST','','',1,0,1,'','','last_post','Z-A',100,'all',0,1,0,0,1,1,1,1,0,0,'','','',0,'',15,15,0,0,0,0,'','a:6:{s:11:\\\"start_perms\\\";s:1:\\\"*\\\";s:11:\\\"reply_perms\\\";s:1:\\\"*\\\";s:10:\\\"read_perms\\\";s:1:\\\"*\\\";s:12:\\\"upload_perms\\\";s:1:\\\"*\\\";s:14:\\\"download_perms\\\";s:1:\\\"*\\\";s:10:\\\"show_perms\\\";s:1:\\\"*\\\";}')

===================================================

Date: Wed, 10 Mar 2010 06:14:51 -0500

Error Number: 1054

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

IP Address: 80.52.169.74

Page: /admin/index.php?adsess=0a49952b70c4921f2ba07bd7ce7f4238&section=content&act=forum&code=donew&f=0&name=New%20Forum

mySQL query error: INSERT INTO ibf_forums (name,icon,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,redirect_loc,notify_modq_emails,permission_showtopic,permission_custom_error,id,position,topics,posts,last_post,last_poster_id,last_poster_name,permission_array) VALUES('TEST','','',1,0,1,'','','last_post','Z-A',100,'all',0,1,0,0,1,1,1,1,0,0,'','','',0,'',15,15,0,0,0,0,'','a:6:{s:11:\\\"start_perms\\\";s:1:\\\"*\\\";s:11:\\\"reply_perms\\\";s:1:\\\"*\\\";s:10:\\\"read_perms\\\";s:1:\\\"*\\\";s:12:\\\"upload_perms\\\";s:1:\\\"*\\\";s:14:\\\"download_perms\\\";s:1:\\\"*\\\";s:10:\\\"show_perms\\\";s:1:\\\"*\\\";}')

===================================================

Date: Wed, 10 Mar 2010 06:17:00 -0500

Error Number: 1054

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

IP Address: 80.52.169.74

Page: /admin/index.php?adsess=09587b009c81afa755e13228a17223bc&section=content&act=forum&code=donew&f=0&name=New%20Forum

mySQL query error: INSERT INTO ibf_forums (name,icon,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,redirect_loc,notify_modq_emails,permission_showtopic,permission_custom_error,id,position,topics,posts,last_post,last_poster_id,last_poster_name,permission_array) VALUES('fora','','',1,0,1,'','','last_post','Z-A',100,'all',0,1,0,0,1,1,1,1,0,0,'','','',0,'',15,15,0,0,0,0,'','a:6:{s:11:\\\"start_perms\\\";s:1:\\\"*\\\";s:11:\\\"reply_perms\\\";s:1:\\\"*\\\";s:10:\\\"read_perms\\\";s:1:\\\"*\\\";s:12:\\\"upload_perms\\\";s:1:\\\"*\\\";s:14:\\\"download_perms\\\";s:1:\\\"*\\\";s:10:\\\"show_perms\\\";s:1:\\\"*\\\";}')

===================================================

Date: Wed, 10 Mar 2010 08:16:43 -0500

Error Number: 1054

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

IP Address: 80.52.169.74

Page: /admin/index.php?adsess=8667f3bb9dc2846dc2df07a09d65f098&section=content&act=forum&code=doedit&f=13&name=Spam

mySQL query error: UPDATE ibf_forums SET name='Spam',icon='Gamepad',description='My to Lubimy...',use_ibc=1,use_html=0,status=1,password='',password_override='',sort_key='last_post',sort_order='Z-A',prune=100,topicfilter='all',preview_posts=0,allow_poll=1,allow_pollbump=0,forum_allow_rating=0,inc_postcount=1,parent_id=12,sub_can_post=1,quick_reply=1,redirect_on=0,redirect_hits=0,redirect_url='',redirect_loc='',notify_modq_emails='',permission_showtopic=0,permission_custom_error='' WHERE id=13

jak by cos zle albo nie tak to tutaj jeszcze wrzucilem caly pliczek... http://wrzucacz.pl/file/3501268238551

[DawPi]

Icon - podejrzewam, że instalowałeś moją modyfikację do pokazywania ikon działów. Musisz wykonać to jeszcze raz, ponieważ nie zainstalowała się poprawnie.

[snoxd]

hmm wlasnie sobie przypomnialem ze wszystko prawie zrobilem oprocz jednej rzeczy ktorej nie zrozumialem dobrze a zupelnie co innego zrobilem pewnie

Run the following Mysql Query in the Mysql Manger in the IPB ACP or PHPMyAdmin Replace the "ibf_" With whatever Your Database Prefix is.

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

moze o wyjaśnienie co dokladnie mam zrobic ? ; )

[DawPi]

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.

[snoxd]

no własnie w tym problem ze nawet nie wiem co mam włączyc i gdzie kliknąć hehe ;d

jestem w phpmyAdmin i jest pelno ibf_ z roznymi koncowkami

czy mam edytowac ibf_forums ?

[DawPi]

Nie. Wykonać to, co napisałem - wykonać zapytanie SQL w zakładce SQL.

[snoxd]

aaa juz wiem troche googlowalem i wiem jak juz to zrobic ;p

widze ze ty jako głowny supporter 24/7

dzieki wielkie

/Temat mozna zamknac

[DawPi]

Problem ROZWIĄZANY. Jeśli są jakiekolwiek wątpliwości, pytania proszę o założenie nowego tematu.

Wszelkie uzasadnione reklamacje/pretensje/sugestie/rady przyjmuje ekipa forum.