Board watch

[asinshesq]

But when I activate the boardwatchf option (the whole board) and add a reply, I receive an Error Message:

SQL ERROR [ mysql4 ]

FUNCTION db294537882.0AND does not exist [1305]

That's probably not the full error message. What is the full error message (everything you see on your screen)?

And wehn you tell me that, pm me your includes/functions_posting.php and I'll take a look.

[ac_forum]

Hi Alan,

thank you very much! The board rules do not permit new users (less than 5 posts) to send an pm (only to team members). So I cannot pm you anything. For this reason you find everything in this post. Hope that´s ok.

For security reasons:
The forum is empty, I am still developing. For this reason I think, it is ok to post the data for everybody.

Here´s the full error message and my functions_posting.php

The error is written in german (the 3rd line). It says:

"While loading the page, an SQL Error occured. Please contact your board-Administrator, if this error reoccurs frequently."

Kind regards,

Dirk from Germany

[asinshesq]

when I activate the boardwatchf option (the whole board) and add a reply, I receive an Error Message:

SQL ERROR [ mysql4 ]

FUNCTION db294537882.0AND does not exist [1305]

I followed everything.

You didn't follow everything exactly

You messed up a line big time. Here's what you need to do with that file you attached:

Code: Select all

OPEN
includes/functions_posting.php

FIND
				AND fw.notify_status = 0AND (fw.notify_status = 0 OR u.user_boardwatchf = " . BOARDWATCH_YES . ")

REPLACE WITH
				AND (fw.notify_status = 0 OR u.user_boardwatchf = " . BOARDWATCH_YES . ")

[ac_forum]

Hi Alan,

thank you very much for helping me and finding my mistake!

Now it´s working fine and I can tell you the MOD is really great and useful!

Best wishes,

Dirk from Germany

[asinshesq]

glad to hear it's working now. Enjoy.

[brix11]

Ha...looks like I spoke too soon. How would I modify notification so that posters DO receive notification of their own posts?

No, the mod follows the regular phpbb3 convention that the poster does not get notified of his or hew own posts. That would be easy to change, of course.

Ha...I'm done making changes. For now. Thanks, as I was unaware of the convention.

[asinshesq]

Ha...looks like I spoke too soon. How would I modify notification so that posters DO receive notification of their own posts?

No, the mod follows the regular phpbb3 convention that the poster does not get notified of his or hew own posts. That would be easy to change, of course.

Ha...I'm done making changes. For now. Thanks, as I was unaware of the convention.

Try this if you want users to get notifications of their own posts:

Code: Select all

OPEN
includes/functions_posting.php

FIND
$sql_ignore_users = ANONYMOUS . ', ' . $user->data['user_id'];

REPLACE WITH
$sql_ignore_users = ANONYMOUS;

Let me know if that does it.

[andy_drummond]

I'm probably being really thick here, but I can't find the code (<fieldset class="quick">) in adm/style/acp_users_prefs.html that I'm supposed to edit, or anything remotely like it.

Can anyone help, & will it matter (& will boardwatch work) if I don't edit it?

Thanks

Andy

[asinshesq]

I'm probably being really thick here, but I can't find the code (<fieldset class="quick">) in adm/style/acp_users_prefs.html that I'm supposed to edit, or anything remotely like it.

Can anyone help, & will it matter (& will boardwatch work) if I don't edit it?

Thanks

Andy

You reallly should make that edit. That line is very close to the bottom of a clean adm/style/acp_users_prefs.html file (at line 153). Perhaps you installed another mod that changed that line? If you want to pm me your adm/style/acp_users_prefs.html file I'll take a look.

[opconxps]

Thanks Mod poster. I was able to get it working on my test system 3.0.5.

[Joe_Joe]

I seem to have had the opposite problem of eberyone else.

First thank you for your hard work. Great mod, worked the first time out. So what's the problem? No place ti turn it on or off. Not in the acp, not in profile, not a module to be found, but it sent post out just like it should.

I uninstalled it and tried it on a test board and everything was there. Here's my conclusion. My forum is heavily modded and something is keeping the modules from showing up.

Thank you anyway.
JJ

[asinshesq]

So what's the problem? No place ti turn it on or off. Not in the acp, not in profile, not a module to be found, but it sent post out just like it should.

I uninstalled it and tried it on a test board and everything was there. Here's my conclusion. My forum is heavily modded and something is keeping the modules from showing up..

No, your problem is likely that you ignored or didn't notice the big bright red message that install_boardwatch displays when it finishes making the db changes and installing the modules. That message reads:

Warning

New permission settings have been added. Be sure to check your permission settings and see that they are as you would like them.

That tells you that you have to give people permissions allowing them to change their boardwatch settings. If you forget to do that, no one will have permission to see the boardwatch module that allows them to change their settings so they all get stuck with whatever default you provided.

[Joe_Joe]

So what's the problem? No place ti turn it on or off. Not in the acp, not in profile, not a module to be found, but it sent post out just like it should.

I uninstalled it and tried it on a test board and everything was there. Here's my conclusion. My forum is heavily modded and something is keeping the modules from showing up..

No, your problem is likely that you ignored or didn't notice the big bright red message that install_boardwatch displays when it finishes making the db changes and installing the modules. That message reads:

Warning

New permission settings have been added. Be sure to check your permission settings and see that they are as you would like them.

That tells you that you have to give people permissions allowing them to change their boardwatch settings. If you forget to do that, no one will have permission to see the boardwatch module that allows them to change their settings so they all get stuck with whatever default you provided.

Very interesting. You see I did read that. What I didn't see was where? Not all of us know where to look to find these things. So please if you will. Post what has to be done and where to find it. We are not all versed in how this works.

JJ

[asinshesq]

Very interesting. You see I did read that. What I didn't see was where? Not all of us know where to look to find these things. So please if you will. Post what has to be done and where to find it. We are not all versed in how this works.

I'm not sure what you are asking. You would need to grant permissions just like you granted permissions for other things (permission to post, permission to attach files, etc.). In this case, you would:

- go to the ACP

- click the permissions tab

- click on one of the global permissions links (e.g. for groups or users)

- pick a user or group you want to set the permissions for

- click advanced permissions

- set the permissions for boardwatch in whatever way you want.

[Joe_Joe]

Very interesting. You see I did read that. What I didn't see was where? Not all of us know where to look to find these things. So please if you will. Post what has to be done and where to find it. We are not all versed in how this works.

I'm not sure what you are asking. You would need to grant permissions just like you granted permissions for other things (permission to post, permission to attach files, etc.). In this case, you would:

- go to the ACP

- click the permissions tab

- click on one of the global permissions links (e.g. for groups or users)

- pick a user or group you want to set the permissions for

- click advanced permissions

- set the permissions for boardwatch in whatever way you want.

The problem was that there was no place to grant permission, naya, nothing yet it worked. I uninstalled the mod, re-installed it and all the permission modules were there.

That brings up an other question. Can the DB be reset to default to no unless a member wants it.

Your explantion in contrib is to change:

Code: Select all

array('phpbb_users', 'user_boardwatchb', array('TINYINT', 0)),
array('phpbb_users', 'user_boardwatchf', array('TINYINT', 0)),
array('phpbb_users', 'user_boardwatcht', array('TINYINT', 0)),

In your install file this is the closest to what it looks like and there are 4:

Code: Select all

'table_column_add' => array(
        array('phpbb_users', 'user_boardwatchb', array('TINT:1', 0)),
        array('phpbb_users', 'user_boardwatchf', array('TINT:1', 0)),
        array('phpbb_users', 'user_boardwatcht', array('TINT:1', 0)),
       array('phpbb_users', 'user_notify_status', array('TINT:1', 0)),

Can they be changed in the data base since on the second install the latter was run. I want this to default to no unless the Member wants it.

Sorry for being such a pain in the butt, I just want it right. My Members didn't like the 70 notifications they got yesterday. Picky, Picky!

Thanks for your help.
JJ