Board watch

All new MODs released in our MOD Database will be announced in here. All support for released MODs needs to take place in the Customisations Database.
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

NOTICE: This forum is only for the announcement of new releases and/or updates of MODs. Any MOD support should be obtained through the Customisations Database in the support area designated for each MOD.

A direct link to support for each MOD is in the first post of the respective topic.
Locked
asinshesq
Registered User
Posts: 6266
Joined: Sun Feb 22, 2004 9:34 pm
Location: NYC
Name: Alan

Re: Board watch

Post by asinshesq » Fri Aug 14, 2009 8:04 pm

ac_forum wrote: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
Registered User
Posts: 3
Joined: Fri Aug 14, 2009 6:07 pm

Re: Board watch

Post by ac_forum » Sat Aug 15, 2009 3:32 pm

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
Attachments

[The extension zip has been deactivated and can no longer be displayed.]

090814_SQL_Error_dband.gif
Screenshot from the error message. The no in the message states my db-name
090814_SQL_Error_dband.gif (9.89 KiB) Viewed 1770 times

asinshesq
Registered User
Posts: 6266
Joined: Sun Feb 22, 2004 9:34 pm
Location: NYC
Name: Alan

Re: Board watch

Post by asinshesq » Sun Aug 16, 2009 1:47 am

ac_forum wrote: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
Registered User
Posts: 3
Joined: Fri Aug 14, 2009 6:07 pm

Re: Board watch

Post by ac_forum » Sun Aug 16, 2009 9:39 am

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 :D :D :D

asinshesq
Registered User
Posts: 6266
Joined: Sun Feb 22, 2004 9:34 pm
Location: NYC
Name: Alan

Re: Board watch

Post by asinshesq » Sun Aug 16, 2009 9:54 am

glad to hear it's working now. Enjoy.

brix11
Registered User
Posts: 14
Joined: Thu Apr 29, 2004 6:50 pm

Re: Board watch

Post by brix11 » Wed Aug 19, 2009 6:48 pm

Ha...looks like I spoke too soon. How would I modify notification so that posters DO receive notification of their own posts?
brix11 wrote:
asinshesq wrote: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
Registered User
Posts: 6266
Joined: Sun Feb 22, 2004 9:34 pm
Location: NYC
Name: Alan

Re: Board watch

Post by asinshesq » Wed Aug 19, 2009 8:25 pm

brix11 wrote:Ha...looks like I spoke too soon. How would I modify notification so that posters DO receive notification of their own posts?
brix11 wrote:
asinshesq wrote: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
Registered User
Posts: 1
Joined: Thu Aug 20, 2009 2:23 pm

Re: Board watch

Post by andy_drummond » Thu Aug 20, 2009 2:36 pm

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
Registered User
Posts: 6266
Joined: Sun Feb 22, 2004 9:34 pm
Location: NYC
Name: Alan

Re: Board watch

Post by asinshesq » Thu Aug 20, 2009 6:12 pm

andy_drummond wrote: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
Registered User
Posts: 18
Joined: Tue Jul 14, 2009 6:48 pm

Re: Board watch

Post by opconxps » Fri Aug 21, 2009 5:19 pm

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

Joe_Joe
Registered User
Posts: 52
Joined: Sun Apr 26, 2009 8:16 pm

Re: Board watch

Post by Joe_Joe » Sun Aug 23, 2009 9:05 pm

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. :lol:

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
Registered User
Posts: 6266
Joined: Sun Feb 22, 2004 9:34 pm
Location: NYC
Name: Alan

Re: Board watch

Post by asinshesq » Sun Aug 23, 2009 10:37 pm

Joe_Joe wrote: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. :lol:

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
Registered User
Posts: 52
Joined: Sun Apr 26, 2009 8:16 pm

Re: Board watch

Post by Joe_Joe » Mon Aug 24, 2009 4:36 pm

asinshesq wrote:
Joe_Joe wrote: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. :lol:

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
Registered User
Posts: 6266
Joined: Sun Feb 22, 2004 9:34 pm
Location: NYC
Name: Alan

Re: Board watch

Post by asinshesq » Mon Aug 24, 2009 5:07 pm

Joe_Joe wrote: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
Registered User
Posts: 52
Joined: Sun Apr 26, 2009 8:16 pm

Re: Board watch

Post by Joe_Joe » Tue Aug 25, 2009 2:12 pm

asinshesq wrote:
Joe_Joe wrote: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

Locked

Return to “[3.0.x] MOD Database Releases”