Announcement problem

[D3luxe]

Your phpBB Version: 2.0.
phpBB Type: Integramod 141
MODs: Yes
Your knowledge: Advanced Knowledge
Board URL: http://www.RealmOfElonia.com

PHP Version:
MySQL Version:


What was done before the problem appeared?
Upgraded from PHPBB to IM141


What was done to try to solve the problem?
Nothing so far, I dont want to mess anything up



De.scription and Message

When I try to set up an Announcements block for the portal page, I get this error:

[code]Could not query announcements information  DEBUG MODE  SQL Error ]

I replaced fetchposts.php with the newest version from IM141 as well, I'm not sure whats going on. Anyone have any idea?

[Teelk]

Did you have the Announces Suite intalled on your board before updating? Can you post a global announcement?

[D3luxe]

Global announcements work fine, and I didnt have an announces suite installed before I updated. The only thing I had was IM Portal for PHPBB, instead of the whole IMmod.

EDIT: I ran into another problem. I installed the Group Color mod from this website, and now the groups that were set as moderators aren't showing up right. Instead of saying Moderator: Forum Mods, it says Moderator: username_color_

[D3luxe]

EDIT2: Forget the above edit. I removed the Group Color mod, it wasn't necessary anyway. Still having trouble with the announcements though. Help!

Woops, meant to edit the above post. Sorry!

[Teelk]

Can you set forum permission in the ACP without any problems?

[Leadfoot]

Thought I would try to set up an announcement block after reading this post to see if it would work for me. I was never able to get it ot work in 140 and it wont work for me either. All I get is the titlebar and no announcements. I am able to set forum permissions with no problem. I set it up on my testing page if you want to see how it looks Teelk

http://www.csasylum.com/forum/portal.php?page=17

Do you maybe have to resync for the announcements to show up or will it only look for announcements made after the block was added.

[D3luxe]

When I enable the announcements block, I dont just not get the announcements, I cant even access the portal page. Teelk is checking into my database values to make sure they are correct, he hasn't gotten back to me about it yet though.

[D3luxe]

So...any work Teelk? Its been a while since I sent you my DB backup, and still no word back from you.

[D3luxe]

.....Well...?

It's been a long time since I emailed you my DB...Any word yet..?

[thatjoeguy]

i also am having a problem with announcements in that I have the announcements block in the portal page, and created a post as an announcement, but it does not appear in the Announcements block at all.

I don't see any errors...anyone have any ideas?

[Leadfoot]

yes this is one issue i would like to see addressed. I would love to have the announcement block working on my portal page.

[Teelk]

i also am having a problem with announcements in that I have the announcements block in the portal page, and created a post as an announcement, but it does not appear in the Announcements block at all.

I don't see any errors...anyone have any ideas?

Go to ACP>IM Portal>Portal Configuration, set the appropriate forum id's to pull the announcements from, "Announcements Forum ID(s)".

Everyone else, check that this field has information in it as well please. This field being empty or incorrect will return that sql error.

[D3luxe]

Still doesn't work, after I checked that info. The Forum ID for where it was pulling the announcements was 1 (my News section) and I checked in the database too and it said the forum id for "News" was 1, so that is set right..

[Leadfoot]

God now for my stupid questoin of the day. ok I checked my forum id's and it currently has only a "0". So if I wanted to add a forum I enter the forum id. Now when I hover over a forum I see forum id as "f40" should I enter the f also and should multiple forums be seperated by commas

[Teelk]

Nope, just the number.

Still doesn't work, after I checked that info. The Forum ID for where it was pulling the announcements was 1 (my News section) and I checked in the database too and it said the forum id for "News" was 1, so that is set right..

See if any other announcement field is blank. It should be the forum id though, that's what the sql error you posted is telling me. It's the query before t.topic_time which is the forum_id.

[thatjoeguy]

Go to ACP>IM Portal>Portal Configuration, set the appropriate forum id's to pull the announcements from, "Announcements Forum ID(s)".

Done that. Entering 0 for all doesn't work, BTW.

[D3luxe]

Still doesnt work, I double and triple checked everything.

[Teelk]

Compare the contents of the portal_config table with the following SQL statements. If there are any missing, then run them in phpmyadmin, changing the phpbb_ to your db's table prefix.

Code: Select all

INSERT INTO phpbb_portal_config VALUES (1, 'md_cat_id', '0');INSERT INTO phpbb_portal_config VALUES (2, 'md_pics_number', '2');INSERT INTO phpbb_portal_config VALUES (3, 'md_pics_sort', '0');INSERT INTO phpbb_portal_config VALUES (4, 'md_pics_all', '1');INSERT INTO phpbb_portal_config VALUES (5, 'md_cat_id2', '0');INSERT INTO phpbb_portal_config VALUES (6, 'md_pics_number2', '2');INSERT INTO phpbb_portal_config VALUES (7, 'md_pics_sort2', '0');INSERT INTO phpbb_portal_config VALUES (8, 'md_pics_all2', '0');INSERT INTO phpbb_portal_config VALUES (9, 'md_num_announcements', '5');INSERT INTO phpbb_portal_config VALUES (10, 'md_announcements_length', '250');INSERT INTO phpbb_portal_config VALUES (11, 'md_announcements_forum_id', '1');INSERT INTO phpbb_portal_config VALUES (12, 'md_num_top_downloads', '10');INSERT INTO phpbb_portal_config VALUES (13, 'md_num_new_downloads', '10');INSERT INTO phpbb_portal_config VALUES (14, 'md_num_new_donations', '10');INSERT INTO phpbb_portal_config VALUES (15, 'md_links_style', '1');INSERT INTO phpbb_portal_config VALUES (16, 'md_links_own1', '1');INSERT INTO phpbb_portal_config VALUES (17, 'md_links_own2', '1');INSERT INTO phpbb_portal_config VALUES (18, 'md_links_code', '1');INSERT INTO phpbb_portal_config VALUES (19, 'md_poll_forum_id', '1');INSERT INTO phpbb_portal_config VALUES (20, 'md_poll_bar_length', '75');INSERT INTO phpbb_portal_config VALUES (21, 'md_ran_att_height', '200');INSERT INTO phpbb_portal_config VALUES (22, 'md_ran_att_width', '200');INSERT INTO phpbb_portal_config VALUES (23, 'md_ran_att_max', '3');INSERT INTO phpbb_portal_config VALUES (24, 'md_ran_att_forums_incl', '');INSERT INTO phpbb_portal_config VALUES (25, 'md_ran_att_forums_excl', '');INSERT INTO phpbb_portal_config VALUES (26, 'md_except_forum_id', '');INSERT INTO phpbb_portal_config VALUES (27, 'md_num_recent_topics', '10');INSERT INTO phpbb_portal_config VALUES (28, 'md_approve_mod_installed', '1');INSERT INTO phpbb_portal_config VALUES (29, 'md_recent_topics_style', '0');INSERT INTO phpbb_portal_config VALUES (30, 'md_num_referers', '10');INSERT INTO phpbb_portal_config VALUES (31, 'md_sort_referers', 'referer_hits DESC');INSERT INTO phpbb_portal_config VALUES (32, 'md_search_option_text', 'IntegraMOD');INSERT INTO phpbb_portal_config VALUES (33, 'md_display_not_visit', '1');INSERT INTO phpbb_portal_config VALUES (34, 'md_hours_track_users', '24');INSERT INTO phpbb_portal_config VALUES (35, 'md_scroll_delay', '100');INSERT INTO phpbb_portal_config VALUES (36, 'header_width', '140');INSERT INTO phpbb_portal_config VALUES (37, 'footer_width', '140');INSERT INTO phpbb_portal_config VALUES (38, 'md_cache_file_locking', '1');INSERT INTO phpbb_portal_config VALUES (39, 'md_cache_write_control', '1');INSERT INTO phpbb_portal_config VALUES (40, 'md_cache_read_control', '1');INSERT INTO phpbb_portal_config VALUES (41, 'md_cache_read_type', 'md5');INSERT INTO phpbb_portal_config VALUES (42, 'md_cache_filename_protect', '0');INSERT INTO phpbb_portal_config VALUES (43, 'md_cache_serialize', '1');INSERT INTO phpbb_portal_config VALUES (44, 'default_portal', '1');INSERT INTO phpbb_portal_config VALUES (45, 'cache_enabled', '1');INSERT INTO phpbb_portal_config VALUES (46, 'portal_header', '1');INSERT INTO phpbb_portal_config VALUES (47, 'portal_tail', '0');  

[D3luxe]

It looked NOTHING like that, so I completely dropped the table and recreated it with those values, but it still didnt fix it. No more error, its just that the entire announcement block is blank.

[gumbee]

The Announement block is not working for me either. I can edit permissions of the forums, and have correctly entered the id of the forum to poll from (tried '0' as well)... nothing.