phpBB.nl

Code: Selecteer alles

SQL Error : 1146 Table 'scoutingforum_nl_db.phpbb_forums_watch' doesn't exist

SELECT notify_status FROM phpbb_forums_watch WHERE forum_id = 1 AND user_id = 2

Line : 246
File : viewforum.php

Code: Selecteer alles

Could not obtain list of topic watchers

DEBUG MODE

SQL Error : 1146 Table 'scoutingforum_nl_db.phpbb_forums_watch' doesn't exist

SELECT u.user_id, u.user_email, u.user_lang, f.forum_name FROM phpbb_users u, phpbb_forums_watch fw, phpbb_forums f WHERE fw.forum_id = 1 AND fw.user_id NOT IN (2, -1 ) AND f.forum_id = 1 AND f.forum_notify = '1' AND u.user_id = fw.user_id

Line : 746
File : functions_post.php

Code: Selecteer alles

################################################################# 
## Mod Title: Forum notification mod 
## Mod Version: 1.4
## Date: 2004-02-22
## Author: David Herrmann < david.herrmann@gmx.net >
## Description: adds forum notification functionality to phpBB 2.0.6c,
## also adds some enhancements to the email bodies
## 
## Installation Level: intermediate
## Installation Time: 20 Minutes 
## Files To Edit: 
##                posting.php
##                viewforum.php
##		  admin/admin_forums.php
##                includes/constants.php
##                includes/functions_post.php 
##                language/lang_english/lang_main.php
##                language/lang_english/lang_admin.php
##                language/lang_english/email/topic_notify.tpl
##                templates/subSilver/viewforum_body.tpl
##                templates/subSilver/admin/forum_edit_body.tpl
##
##
## Files to Create:
##                language/lang_english/email/newtopic_notify.tpl
##                language/lang_english/email/forum_notify.tpl
##
##                language/lang_german/email/newtopic_notify.tpl
##                language/lang_german/email/forum_notify.tpl
##
## Included Files:
##                posting.php
##                viewforum.php
##		  admin/admin_forums.php
##                includes/constants.php
##                includes/functions_post.php 
##                language/lang_english/lang_main.php
##                language/lang_english/lang_admin.php
##                language/lang_english/email/topic_notify.tpl
##                language/lang_english/email/newtopic_notify.tpl
##                language/lang_english/email/forum_notify.tpl
##                language/lang_german/lang_main.php
##                language/lang_german/lang_admin.php
##                language/lang_german/email/topic_notify.tpl
##                language/lang_german/email/newtopic_notify.tpl
##                language/lang_german/email/forum_notify.tpl
##                templates/subSilver/viewforum_body.tpl
##                templates/subSilver/admin/forum_edit_body.tpl
## 
################################################################# 

Code: Selecteer alles

## Author Note: 
##
## This mod adds a "watch this forum" link to the viewforum page, similar to the 
## "watch this topic" link on viewtopic. Further on, this mod changes the structure 
## of email bodies, now including the post text, the name of the poster etc. in the
## email text.
## There are different email texts for watched topic (reply), watched forum (newtopic) and 
## watched forum (reply).
## The texts are available both in English and German.
##
## Security should be ok, you are not able to receive a notification email if the forum is private
## and you are not allowed to read!
##
## Do not forget to run the following commands on your sql database (replace phpbb2_ with your db prefix):
##
##CREATE TABLE phpbb2_forums_watch (
##    forum_id smallint(5) unsigned NOT NULL default '0',
##    user_id mediumint(8) NOT NULL default '0',
##    notify_status tinyint(1) NOT NULL default '0',
##    KEY forum_id (forum_id),
##    KEY user_id (user_id),
##    KEY notify_status (notify_status)
## )
##
##ALTER TABLE phpbb2_forums 
##    ADD forum_notify TINYINT(1) UNSIGNED DEFAULT '1' NOT NULL
##    AFTER forum_last_post_id
##
## the description is for subsilver theme users, it should work with every theme
## if you are using the files from the package you only have to run the sql command
## 
## this mod was tested on phpBB 2.0.6c
##
## Should be no problem for any user who knows what they are doing ;-)

Code: Selecteer alles

##CREATE TABLE phpbb2_forums_watch (
##    forum_id smallint(5) unsigned NOT NULL default '0',
##    user_id mediumint(8) NOT NULL default '0',
##    notify_status tinyint(1) NOT NULL default '0',
##    KEY forum_id (forum_id),
##    KEY user_id (user_id),
##    KEY notify_status (notify_status)
## )
##
##ALTER TABLE phpbb2_forums
##    ADD forum_notify TINYINT(1) UNSIGNED DEFAULT '1' NOT NULL
##    AFTER forum_last_post_id 

Code: Selecteer alles

SQL Error : 1146 Table 'scoutingforum_nl_db.phpbb_forums_watch' doesn't exist

SELECT notify_status FROM phpbb_forums_watch WHERE forum_id = 2 AND user_id = 2

Line : 246
File : viewforum.php

Code: Selecteer alles

CREATE TABLE phpbb_forums_watch ( 
    forum_id smallint(5) unsigned NOT NULL default '0', 
    user_id mediumint(8) NOT NULL default '0', 
    notify_status tinyint(1) NOT NULL default '0', 
    KEY forum_id (forum_id), 
    KEY user_id (user_id), 
    KEY notify_status (notify_status) 
 ) 
 
ALTER TABLE phpbb_forums 
    ADD forum_notify TINYINT(1) UNSIGNED DEFAULT '1' NOT NULL 
    AFTER forum_last_post_id 

Code: Selecteer alles

## Do not forget to run the following commands on your sql database (replace phpbb2_ with your db prefix):