announcement mod

[Jappie]

Code: Selecteer alles

Failed obtaining forum access control lists

DEBUG MODE

SQL Error : 1054 Unknown column 'a.auth_global_announce' in 'field list'

SELECT a.forum_id, a.auth_view, a.auth_read, a.auth_post, a.auth_reply, a.auth_edit, a.auth_delete, a.auth_sticky, a.auth_announce, a.auth_global_announce, a.auth_vote, a.auth_pollcreate FROM phpbb_forums a 

Line : 140
File : /home/customers/vrijeschool-leiden.nl/html/vrijeschool-leiden.nl/testsite/phpBB2/includes/auth.php

deze fout melding krijg ik nou weet ik dat is nog een SQL moet uitvoeren maar heb ik geen idee hoe omdat die file er niet bij zat



http://www.phpbbhacks.com/viewhack.php?id=1131

Code: Selecteer alles

#-----[ SQL ]-------------------------------------------------
#
ALTER TABLE phpbb_topics ADD topic_announce_duration MEDIUMINT(5) NOT NULL;
ALTER TABLE phpbb_auth_access ADD auth_global_announce TINYINT(1) NOT NULL AFTER auth_announce;
ALTER TABLE phpbb_forums ADD auth_global_announce TINYINT(2) NOT NULL AFTER auth_announce;
UPDATE phpbb_forums SET auth_global_announce=5;
#

Dit staat nog in de install file maar goed ik kan er dus niet veel mee :S

[WebSiteNet]

Je moet die sql query uitvoeren in phpmyadmin.