[SOLVED] Force Topic Read - Does it Work?

[Dr. Bantham]

I wanted to bring a post to the attention of all of my site members, therefore I thought I would utilize the Force to Read mod which comes with IM.

My first problem was not being able how to discern how to change the post to be set as FTR. That seemed not to be an option under ACP-->FTR Management-->FTR Configuration.

My second problem occurred when I attempted to view ACP-->FTR Management-->FTR Users. I received the following error message:

General Error
Error Getting Total Users.

DEBUG MODE

SQL Error : 1146 Table 'xxxxx.phpbb_force_read_users' doesn't exist

SELECT COUNT(user) AS total FROM phpbb_force_read_users

Line : 91
File : admin_force_read.php

The "xxxxx" was a type-over to maintain security.

While attempting a search here at IM2, I found two problems which were fixed by moderators here by advising that FTR be deactivated in ACP. Is this a feature which does not work? If so, will it be either removed or repaired in the next release? The problems created were major, such as locking members out of the site.

[IntegraTeam]

have you tried looking at this in fisubice?

[Dr. Bantham]

I just did so, and it looks the same as with other styles. The error message is identical.

[Simon N]

Works fine for me and I have been forcing my members (against their will) to read important topics and such for some months now.

[Helter]

the install.php, seldome omits to make a table, and when it does, it usually shows you an error. More likely, you have a corupted file that is not allowing your forum to find the table.
I would first check that the table is there, then try replacing the files the ftr mod uses, such as forum root/admin/admin_force_read.php etc...

[Dr. Bantham]

The table phpbb_force_read exists. However, phpbb_force_read_users does not. How can I create this and any other missing tables without affecting existing data? I should point out that I am running an IM installation which was upgraded from 1.32d to 1.40 when it was first released, and the transition experience was horrid, therefore I would not be surprised that tables are missing. Also, I ported over to a new server host a couple of months back and the table may have been dropped when restoring the SQL backup.

[IntegraMOD]

Code: Select all

## Table structure for table `phpbb_force_read_users`#  CREATE TABLE `phpbb_force_read_users` (   `user` varchar(255) NOT NULL default '',   `read` int(1) NOT NULL default '0',   `time` int(10) NOT NULL default '0') TYPE=MyISAM;  # --------------------------------------------------------  ## Table structure for table `phpbb_force_read_users`#

This query will add the table

[Dr. Bantham]

This query will add the table

That fixed it - many thanks!