[ABD] The Blog Mod

A place for MOD Authors to post and receive feedback on MODs still in development. No MODs within this forum should be used within a live environment! No new topics are allowed in this forum.
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

IMPORTANT: MOD Development Forum rules

On February 1, 2009 this forum will be set to read only as part of retiring of phpBB2.
Locked
hyperion
Registered User
Posts: 268
Joined: Sun Jul 06, 2003 7:13 pm

Post by hyperion »

No major bugs in this version.

You can, as owner of the site, edit the .htm files in the template's directory. For others, there is an "Advanced Mode" which allows full html editing of the main page of their blog, plus the "face plate". You've got to grant the privileges for this yourself, as no checking is done on the HTML (which could let the owner hijack someone else's account).
The Blog Mod: ( Dev Topic | Demo )
The Blog Mod version 0.2.3 - Released May 18, 2005
Download

Forum Weblogs Mod: (discontinued)
User avatar
lozt
Registered User
Posts: 527
Joined: Thu Aug 15, 2002 5:11 am
Location: Paradise

Post by lozt »

Thank you
:)
cellpack
Registered User
Posts: 99
Joined: Sat Oct 04, 2003 9:54 am

Post by cellpack »

firstly great mod :)

for some reason i can not upload a picture when i click the upload button it just clears what i have selected when i clickd the browse button, also i ahve to click anyof he buttons atleast 3 times before it saves the changes?? any ideas?
webon100
Registered User
Posts: 3
Joined: Sun Jul 10, 2005 7:40 pm

Thanks for this MOD

Post by webon100 »

hyperion wrote: No major bugs in this version.

You can, as owner of the site, edit the .htm files in the template's directory. For others, there is an "Advanced Mode" which allows full html editing of the main page of their blog, plus the "face plate". You've got to grant the privileges for this yourself, as no checking is done on the HTML (which could let the owner hijack someone else's account).




I have installed everything on the server, but it dones't work.

the error msg as following:


phpBB : Critical Error

Could not query config information

DEBUG MODE

SQL Error : 1146 Table 'myname.WEBLOG_CONFIG_TABLE' doesn't exist

SELECT * FROM WEBLOG_CONFIG_TABLE

Line : 59
File : weblogs_common.php


So, is there server problem or anything i should do ?

Many thanks in advance
webon100
Registered User
Posts: 3
Joined: Sun Jul 10, 2005 7:40 pm

Re: [BETA] The Blog Mod - WEBLOG_CONFIG_TABLE doesn't exist

Post by webon100 »

hyperion wrote: If you get the error "Table WEBLOG_CONFIG_TABLE doesn't exist" or something similar, ensure that you made the changes to constants.php correctly. "WEBLOG_CONFIG_TABLE" is a constant referring to the actual table, plus your forum prefix.



Hello
Many thanks for this MOD. It is great.

I have upload all the files to my server. and when i go to the CP, it showing the Weblog section, but the thing i got silimar error message like this.

-----------------------------------+
SQL Error : 1146 Table 'prefix.WEBLOG_CONFIG_TABLE' doesn't exist

SELECT * FROM WEBLOG_CONFIG_TABLE

Line : 59
File : weblogs_common.php
-----------------------------------+

I have tried to edit weblogs_common.php and constants.php, and premission is 775 or 777 and still not working.

So, i am wondering if this MOD need some file like install.php which able to add new table on the mySQL


Please help to fix on this

thanks in advance
Homeskillet
Registered User
Posts: 231
Joined: Thu Oct 07, 2004 5:00 am
Contact:

Post by Homeskillet »

Did you do this part of the instructions? You can either do it manually, or just upload the db_update.php file included with the download into your main root directory. Then run it from your browser.

Code: Select all

#
#-----[ SQL ]------------------------------------------
# Replace "phpbb_" with the prefix of your forums, or use the included db_update.php to run the SQL
ALTER TABLE phpbb_groups ADD group_allow_weblogs TINYINT(1) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE phpbb_users ADD user_allowweblog TINYINT(1) UNSIGNED NOT NULL DEFAULT '1';
ALTER TABLE phpbb_users ADD user_allowadvweblog TINYINT(1) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE phpbb_users ADD user_showfriends TINYINT(1) UNSIGNED NOT NULL DEFAULT '1';
ALTER TABLE phpbb_users ADD user_weblog MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0';

CREATE TABLE phpbb_weblog_actions (
	action_id SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL,
	action_text VARCHAR(50) DEFAULT '',
	action_url VARCHAR(100) DEFAULT '',
	PRIMARY KEY (action_id)
);

CREATE TABLE phpbb_weblog_blocked (
	owner_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
	blocked_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
	PRIMARY KEY (owner_id, blocked_id)
);

CREATE TABLE phpbb_weblog_config (
	config_name VARCHAR(255) NOT NULL DEFAULT '',
	config_value VARCHAR(255) NOT NULL DEFAULT '',
	PRIMARY KEY (config_name)
);

CREATE TABLE phpbb_weblog_contributors (
	weblog_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
	user_id MEDIUMINT(8) NOT NULL DEFAULT '0',
	PRIMARY KEY (weblog_id, user_id)
);

CREATE TABLE phpbb_weblog_entries (
	entry_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
	weblog_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
	entry_access TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
	entry_subject VARCHAR(60) NOT NULL DEFAULT '',
	entry_text TEXT NOT NULL DEFAULT '',
	bbcode_uid VARCHAR(10) NOT NULL DEFAULT '',
	entry_mood SMALLINT(5) NOT NULL DEFAULT '0',
	entry_currently SMALLINT(5) NOT NULL DEFAULT '0',
	currently_text VARCHAR(60) NOT NULL DEFAULT '',
	entry_time INT(11) NOT NULL DEFAULT '0',
	entry_views MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
	enable_bbcode TINYINT(1) UNSIGNED NOT NULL DEFAULT '1',
	enable_smilies TINYINT(1) UNSIGNED NOT NULL DEFAULT '1',
	enable_html TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
	memorable TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
	no_replies TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
	entry_replies MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
	entry_last_post_userid MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT' 0',
	entry_last_post_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
	entry_poster_id MEDIUMINT(8) NOT NULL DEFAULT '0',
	entry_trackbacks SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
	entry_deleted TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
	PRIMARY KEY (entry_id),
	KEY (weblog_id),
	KEY (entry_last_post_userid),
	KEY (entry_last_post_id),
	KEY (entry_poster_id)
);

CREATE TABLE phpbb_weblog_friends (
	owner_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
	friend_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
	PRIMARY KEY (owner_id, friend_id)
);

CREATE TABLE phpbb_weblog_mood_sets (
	set_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
	set_name VARCHAR (255) NOT NULL DEFAULT '',
	PRIMARY KEY (set_id)
);

CREATE TABLE phpbb_weblog_moods (
	mood_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
	mood_text VARCHAR (255) NOT NULL DEFAULT '',
	mood_url VARCHAR (255) NOT NULL DEFAULT '',
	mood_set MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
	PRIMARY KEY (mood_id),
	KEY (mood_set)
);

CREATE TABLE phpbb_weblog_replies (
	reply_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
	entry_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
	poster_id MEDIUMINT(8) NOT NULL DEFAULT '0',
	post_time INT(11),
	post_username VARCHAR(25) NOT NULL DEFAULT '',
	post_subject VARCHAR (60) NOT NULL DEFAULT '',
	enable_bbcode TINYINT(1) UNSIGNED NOT NULL DEFAULT '1',
	enable_smilies TINYINT(1) UNSIGNED NOT NULL DEFAULT '1',
	enable_html TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
	enable_sig TINYINT(1) UNSIGNED NOT NULL DEFAULT '1',
	reply_text TEXT NOT NULL DEFAULT '',
	bbcode_uid VARCHAR(10) NOT NULL DEFAULT '',
	PRIMARY KEY (reply_id),
	KEY (entry_id),
	KEY (poster_id)
);

CREATE TABLE phpbb_weblog_shoutbox (
	shout_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
	shout_weblog MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
	shout_text TEXT NOT NULL DEFAULT '',
	shout_poster MEDIUMINT(8) NOT NULL DEFAULT '0',
	shout_username VARCHAR(25) NOT NULL DEFAULT '',
	bbcode_uid VARCHAR (10) NOT NULL DEFAULT '',
	shout_time INT(11) NOT NULL DEFAULT '0',
	shout_www VARCHAR (100) NOT NULL DEFAULT '',
	PRIMARY KEY (shout_id),
	KEY (shout_weblog),
	KEY (shout_poster)
);

CREATE TABLE phpbb_weblog_templates (
	template_id SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
	template_name VARCHAR(100) NOT NULL DEFAULT '',
	template_dir VARCHAR (100) NOT NULL DEFAULT '',
	template_private TINYINT(1) NOT NULL DEFAULT '0',
	PRIMARY KEY (template_id)
);

CREATE TABLE phpbb_weblog_trackbacks (
	tb_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
	tb_entry MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
	tb_blog VARCHAR (255) NOT NULL DEFAULT '',
	tb_time INT(11) NOT NULL DEFAULT '0',
	tb_excerpt VARCHAR(255) NOT NULL DEFAULT '',
	tb_url VARCHAR(255) NOT NULL DEFAULT '',
	tb_title VARCHAR(255) NOT NULL DEFAULT '',
	PRIMARY KEY (tb_id),
	KEY (tb_entry)
);

CREATE TABLE phpbb_weblogs (
	weblog_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
	template_id SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
	weblog_name VARCHAR(60) NOT NULL DEFAULT '',
	weblog_desc VARCHAR(255) NOT NULL DEFAULT '',
	weblog_auth TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
	replies_auth TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
	weblog_entries MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
	entries_perpage SMALLINT(5)  UNSIGNED NOT NULL DEFAULT '5',
	post_reply_text VARCHAR(60) NOT NULL DEFAULT '',
	replies_text VARCHAR(60) NOT NULL DEFAULT '',
	weblog_create_date INT(11) NOT NULL DEFAULT '0',
	weblog_views MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
	weblog_advanced TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
	weblog_shoutbox_desc TINYINT(1) UNSIGNED NOT NULL DEFAULT '1',
	show_profile_info TINYINT(1) UNSIGNED NOT NULL DEFAULT '1',
	show_calendar TINYINT(1) UNSIGNED NOT NULL DEFAULT '1',
	show_contact_info TINYINT(1) UNSIGNED NOT NULL DEFAULT '1',
	show_weblog_info TINYINT(1) UNSIGNED NOT NULL DEFAULT '1',
	show_shoutbox TINYINT(1) UNSIGNED NOT NULL DEFAULT '1',
	reply_in_popup TINYINT(1) UNSIGNED NOT NULL DEFAULT '1',
	deleted TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
	weblog_last_entry_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
	mood_set MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
	custom_block TEXT NOT NULL DEFAULT '',
	custom_block_title VARCHAR (64) NOT NULL DEFAULT '',
	background_color VARCHAR(6) NOT NULL DEFAULT '',
	entry_bg_color VARCHAR(6) NOT NULL DEFAULT '',
	border_color VARCHAR(6) NOT NULL DEFAULT '',
	background_image VARCHAR(255) NOT NULL DEFAULT '',
	background_image_fixed TINYINT(1) NOT NULL DEFAULT '0',
	tile_bg VARCHAR(9) NOT NULL DEFAULT '',
	sb_face_color VARCHAR(6) NOT NULL DEFAULT '',
	sb_highlight_color VARCHAR(6) NOT NULL DEFAULT '',
	sb_shadow_color VARCHAR(6) NOT NULL DEFAULT '',
	sb_3dlight_color VARCHAR(6) NOT NULL DEFAULT '',
	sb_arrow_color VARCHAR(6) NOT NULL DEFAULT '',
	sb_track_color VARCHAR(6) NOT NULL DEFAULT '',
	sb_darkshadow_color VARCHAR(6) NOT NULL DEFAULT '',
	font SMALLINT(5) NOT NULL DEFAULT '0',
	font_color VARCHAR(6) NOT NULL DEFAULT '000000',
	font_size TINYINT(2) NOT NULL DEFAULT '0',
	normal_link_color VARCHAR(6) NOT NULL DEFAULT '',
	active_link_color VARCHAR(6) NOT NULL DEFAULT '',
	hover_link_color VARCHAR(6) NOT NULL DEFAULT '',
	visited_link_color VARCHAR(6) NOT NULL DEFAULT '',
	weblog_title_color VARCHAR(6) NOT NULL DEFAULT '',
	entry_title_color VARCHAR(6) NOT NULL DEFAULT '',
	date_time_color VARCHAR(6) NOT NULL DEFAULT '',
	block_title_color VARCHAR(6) NOT NULL DEFAULT '',
	block_bg_color VARCHAR(6) NOT NULL DEFAULT '',
	block_border_color VARCHAR(6) NOT NULL DEFAULT '',
	bg_ypos VARCHAR(6) NOT NULL DEFAULT '',
	bg_xpos VARCHAR(6) NOT NULL DEFAULT '',
	normal_link_underline TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
	active_link_underline TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
	hover_link_underline TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
	visited_link_underline TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
	weblog_title_font_size TINYINT(2) UNSIGNED NOT NULL DEFAULT '16',
	entry_title_font_size TINYINT(2) UNSIGNED NOT NULL DEFAULT '12',
	date_time_font_size TINYINT(2) UNSIGNED NOT NULL DEFAULT '14',
	block_title_font_size TINYINT(2) UNSIGNED NOT NULL DEFAULT '14',
	cblock_bbcode_uid VARCHAR(10) NOT NULL DEFAULT '',
	PRIMARY KEY (weblog_id),
	KEY (template_id),
	KEY (mood_set)
);

INSERT INTO phpbb_weblog_actions (action_id, action_text, action_url) VALUES (1, 'Eating', 'action_eat.gif');
INSERT INTO phpbb_weblog_actions (action_id, action_text, action_url) VALUES (2, 'Listening to', 'action_listen.gif');
INSERT INTO phpbb_weblog_actions (action_id, action_text, action_url) VALUES (3, 'Playing', 'action_play.gif');
INSERT INTO phpbb_weblog_actions (action_id, action_text, action_url) VALUES (4, 'Reading', 'action_read.gif');
INSERT INTO phpbb_weblog_actions (action_id, action_text, action_url) VALUES (5, 'Watching', 'action_watch.gif');
INSERT INTO phpbb_weblog_actions (action_id, action_text, action_url) VALUES (6, 'Working', 'action_work.gif');

INSERT INTO phpbb_weblog_config (config_name, config_value) VALUES ('enable_mod', 1);
INSERT INTO phpbb_weblog_config (config_name, config_value) VALUES ('no_avatars_index', 0);
INSERT INTO phpbb_weblog_config (config_name, config_value) VALUES ('default_name', '%s\'s blog');
INSERT INTO phpbb_weblog_config (config_name, config_value) VALUES ('default_desc', 'Welcome to my Blog');
INSERT INTO phpbb_weblog_config (config_name, config_value) VALUES ('main_sorttype', 0);
INSERT INTO phpbb_weblog_config (config_name, config_value) VALUES ('main_sortorder', 'desc');
INSERT INTO phpbb_weblog_config (config_name, config_value) VALUES ('main_blogsperpage', 10);
INSERT INTO phpbb_weblog_config (config_name, config_value) VALUES ('use_default_faceplates', 1);
INSERT INTO phpbb_weblog_config (config_name, config_value) VALUES ('condense_index', 0);
INSERT INTO phpbb_weblog_config (config_name, config_value) VALUES ('censor_weblog', 0);
INSERT INTO phpbb_weblog_config (config_name, config_value) VALUES ('default_auth', 0);
INSERT INTO phpbb_weblog_config (config_name, config_value) VALUES ('default_reply_auth', 0);
INSERT INTO phpbb_weblog_config (config_name, config_value) VALUES ('default_entries_perpage', 5);
INSERT INTO phpbb_weblog_config (config_name, config_value) VALUES ('require_auth', 1);
INSERT INTO phpbb_weblog_config (config_name, config_value) VALUES ('default_post_reply_text', '(Post your comment)');
INSERT INTO phpbb_weblog_config (config_name, config_value) VALUES ('default_replies_text', '%s Comments');
INSERT INTO phpbb_weblog_config (config_name, config_value) VALUES ('index_list_by_username', 0);
INSERT INTO phpbb_weblog_config (config_name, config_value) VALUES ('shoutbox_flood_delay', 15);
INSERT INTO phpbb_weblog_config (config_name, config_value) VALUES ('max_pic_width', 500);
INSERT INTO phpbb_weblog_config (config_name, config_value) VALUES ('max_pic_height', 500);
INSERT INTO phpbb_weblog_config (config_name, config_value) VALUES ('max_pic_size', 131072);
INSERT INTO phpbb_weblog_config (config_name, config_value) VALUES ('pic_upload_enabled', 1);

INSERT INTO phpbb_weblog_mood_sets (set_id, set_name) VALUES (0, 'Default Set');

INSERT INTO phpbb_weblog_moods (mood_id, mood_text, mood_url, mood_set) VALUES (1, 'Angelic', 'mood_angelic.gif', 0);
INSERT INTO phpbb_weblog_moods (mood_id, mood_text, mood_url, mood_set) VALUES (2, 'Confused', 'mood_confused.gif', 0);
INSERT INTO phpbb_weblog_moods (mood_id, mood_text, mood_url, mood_set) VALUES (3, 'Cool', 'mood_cool.gif', 0);
INSERT INTO phpbb_weblog_moods (mood_id, mood_text, mood_url, mood_set) VALUES (4, 'Silly', 'mood_silly.gif', 0);
INSERT INTO phpbb_weblog_moods (mood_id, mood_text, mood_url, mood_set) VALUES (5, 'Very Sad', 'mood_verysad.gif', 0);
INSERT INTO phpbb_weblog_moods (mood_id, mood_text, mood_url, mood_set) VALUES (6, 'Shocked', 'mood_shocked.gif', 0);
INSERT INTO phpbb_weblog_moods (mood_id, mood_text, mood_url, mood_set) VALUES (7, 'Evil', 'mood_evil.gif', 0);
INSERT INTO phpbb_weblog_moods (mood_id, mood_text, mood_url, mood_set) VALUES (8, 'In Love', 'mood_love.gif', 0);
INSERT INTO phpbb_weblog_moods (mood_id, mood_text, mood_url, mood_set) VALUES (9, 'Amused', 'mood_amused.gif', 0);
INSERT INTO phpbb_weblog_moods (mood_id, mood_text, mood_url, mood_set) VALUES (10, 'Angry', 'mood_angry.gif', 0);
INSERT INTO phpbb_weblog_moods (mood_id, mood_text, mood_url, mood_set) VALUES (11, 'Neutral', 'mood_neutral.gif', 0);
INSERT INTO phpbb_weblog_moods (mood_id, mood_text, mood_url, mood_set) VALUES (12, 'Sick', 'mood_sick.gif', 0);
INSERT INTO phpbb_weblog_moods (mood_id, mood_text, mood_url, mood_set) VALUES (13, 'Scared', 'mood_scared.gif', 0);
INSERT INTO phpbb_weblog_moods (mood_id, mood_text, mood_url, mood_set) VALUES (14, 'Happy', 'mood_happy.gif', 0);
INSERT INTO phpbb_weblog_moods (mood_id, mood_text, mood_url, mood_set) VALUES (15, 'Fed Up WIth Life', 'mood_fedup.gif', 0);
INSERT INTO phpbb_weblog_moods (mood_id, mood_text, mood_url, mood_set) VALUES (16, 'Distorted', 'mood_distorted.gif', 0);
INSERT INTO phpbb_weblog_moods (mood_id, mood_text, mood_url, mood_set) VALUES (17, 'Hypnotized', 'mood_hypnotized.gif', 0);
INSERT INTO phpbb_weblog_moods (mood_id, mood_text, mood_url, mood_set) VALUES (18, 'Embarrased', 'mood_embarrased.gif', 0);
INSERT INTO phpbb_weblog_moods (mood_id, mood_text, mood_url, mood_set) VALUES (19, 'Sleepy', 'mood_sleepy.gif', 0);
INSERT INTO phpbb_weblog_templates (template_id, template_name, template_dir) VALUES (1, 'simpleGray', 'simpleGray');
...
webon100
Registered User
Posts: 3
Joined: Sun Jul 10, 2005 7:40 pm

Post by webon100 »

Homeskillet wrote: Did you do this part of the instructions? You can either do it manually, or just upload the db_update.php file included with the download into your main root directory. Then run it from your browser.


Hello

Thanks for the instruction. and i have run the "db_update.php", and script has installed the tables. but, however, when i go to the weblog CP, still the same.

-------------------------------------------------------+
SQL Error : 1146 Table 'dbname.prefix_WEBLOG_CONFIG' doesn't exist

SELECT * FROM phpbb_WEBLOG_CONFIG

Line : 59
File : weblogs_common.php
------------------------------------------------------------+

whenever, how can i change on weblogs_common.php

I have change the code
FROM " . WEBLOG_CONFIG_table;
if( !($result = $db->sql_query($sql)) )

to

FROM " . WEBLOG_CONFIG;
if( !($result = $db->sql_query($sql)) )

or this one

FROM " . phpbb_WEBLOG_CONFIG;
if( !($result = $db->sql_query($sql)) )


the wried thing is on CP, it always show the DB name in front of prefix

"dbname.prefix_WEBLOG_CONFIG' doesn't exist"

the real table name should be "prefix_WEBLOG_CONFIG"


Please advise it.

Many thanks in advance.
n00bstorm
Registered User
Posts: 481
Joined: Sun Jan 30, 2005 7:52 pm

Post by n00bstorm »

cool :wink:
hyperion
Registered User
Posts: 268
Joined: Sun Jul 06, 2003 7:13 pm

Re: [BETA] The Blog Mod - WEBLOG_CONFIG_TABLE doesn't exist

Post by hyperion »

webon100 wrote:
hyperion wrote:If you get the error "Table WEBLOG_CONFIG_TABLE doesn't exist" or something similar, ensure that you made the changes to constants.php correctly. "WEBLOG_CONFIG_TABLE" is a constant referring to the actual table, plus your forum prefix.



Hello
Many thanks for this MOD. It is great.

I have upload all the files to my server. and when i go to the CP, it showing the Weblog section, but the thing i got silimar error message like this.

-----------------------------------+
SQL Error : 1146 Table 'prefix.WEBLOG_CONFIG_TABLE' doesn't exist

SELECT * FROM WEBLOG_CONFIG_TABLE

Line : 59
File : weblogs_common.php
-----------------------------------+

I have tried to edit weblogs_common.php and constants.php, and premission is 775 or 777 and still not working.

So, i am wondering if this MOD need some file like install.php which able to add new table on the mySQL


Please help to fix on this

thanks in advance


Please make sure you did this part of the instructions:

Code: Select all

#
#-----[ OPEN ]------------------------------------------
# REQUIRED - Used throughout the mod. It WILL NOT work if you don't do these changes!
includes/constants.php

#
#-----[ FIND ]------------------------------------------
#
define('POST_POST_URL', 'p');
define('POST_GROUPS_URL', 'g');

#
#-----[ AFTER, ADD ]------------------------------------------
#
define('POST_WEBLOG_URL', 'w');
define('POST_ENTRY_URL', 'e');
define('POST_REPLY_URL', 'r');
define('POST_TRACKBACK_URL', 't');

#
#-----[ FIND ]------------------------------------------
#
define('VOTE_DESC_TABLE', $table_prefix.'vote_desc');
define('VOTE_RESULTS_TABLE', $table_prefix.'vote_results');
define('VOTE_USERS_TABLE', $table_prefix.'vote_voters');

#
#-----[ AFTER, ADD ]------------------------------------------
#
define('WEBLOG_BLOCKED_TABLE', $table_prefix.'weblog_blocked');
define('WEBLOG_CONFIG_TABLE',	$table_prefix.'weblog_config');
define('WEBLOG_ACTIONS_TABLE', $table_prefix.'weblog_actions');
define('WEBLOG_ENTRIES_TABLE', $table_prefix.'weblog_entries');
define('WEBLOG_FRIENDS_TABLE', $table_prefix.'weblog_friends');
define('WEBLOG_MOODS_TABLE', $table_prefix.'weblog_moods');
define('WEBLOG_MOOD_SETS_TABLE', $table_prefix.'weblog_mood_sets');
define('WEBLOG_CONTRIBUTORS_TABLE', $table_prefix.'weblog_contributors');
define('WEBLOG_REPLIES_TABLE', $table_prefix.'weblog_replies');
define('WEBLOG_SHOUTBOX_TABLE', $table_prefix.'weblog_shoutbox');
define('WEBLOG_TEMPLATES_TABLE', $table_prefix.'weblog_templates');
define('WEBLOG_TRACKBACKS_TABLE', $table_prefix.'weblog_trackbacks');
define('WEBLOGS_TABLE', $table_prefix.'weblogs');
The Blog Mod: ( Dev Topic | Demo )
The Blog Mod version 0.2.3 - Released May 18, 2005
Download

Forum Weblogs Mod: (discontinued)
User avatar
ArchY
Registered User
Posts: 42
Joined: Sat Nov 03, 2001 10:34 am
Location: Saint Germain en Laye

Post by ArchY »

hi

I have install with success this mod, but where can I find french language file ? is it already done ?

good job and Thx !
Mrs. Bell
Registered User
Posts: 31
Joined: Mon Mar 24, 2003 7:02 am

Post by Mrs. Bell »

hyperion wrote: For templates other than subSilver you'll have to extrapolate and figure out the HTML to put in to make it show up properly. You could also try asking the template's author. The code for subSilver should be a good reference.


So as a NEW newbie, should I stay away from this mod since I don't use subSilver? I can't imagine coding myself ;)
Homeskillet
Registered User
Posts: 231
Joined: Thu Oct 07, 2004 5:00 am
Contact:

Post by Homeskillet »

Which template do you use? I have four different templates on my board and the weblogs installed just fine...no problems.

I use charcoal 2, charcoal 3, subblack, and subsilver.
...
Mrs. Bell
Registered User
Posts: 31
Joined: Mon Mar 24, 2003 7:02 am

Post by Mrs. Bell »

I currently use subRed but was thinking of switching to ezSerenity.

Did you have to manually change anything to get it to work with those templates?
Homeskillet
Registered User
Posts: 231
Joined: Thu Oct 07, 2004 5:00 am
Contact:

Post by Homeskillet »

Nope...cuz believe me...I am as noob as they get. :lol:

You shouldn't have ANY problems with subRed...I don't know anything about the ezSerenity one to say one way or another.
...
gianni76
Registered User
Posts: 71
Joined: Sun Jul 03, 2005 11:04 am

Post by gianni76 »

Hi,
how do you use Web Blogs with multiple board templates?

I have Aqua and when I try to access the index I get the error:
Template->make_filename(): Error - file weblog_index_noweblog.tpl does not exist

The same blogs work regularly on the same board if looked in subsilver.

Assuming you need to install other files (please mention which and where), will I need to repeat this operation for each other template I install? (seems crazy!)
Locked

Return to “[2.0.x] MODs in Development”