Adapting a phpbb Mod

JakeTFG · March 31, 2007

The mod im adpating is The BLog Mod for phpbb and i thought if i changed any where it said blog, blogs, weblog, or weblogs it would work fine however I am running into a problem when users attempt to set up their tagbooks.

Error Message:

General Error

Error creating a tagbook.

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 'FF6600', 16, '0066CC', 10, 'FF6600', 14, 'F' at line 99

INSERT INTO phpbb_tagbooks ( tagbook_id, template_id, tagbook_name, tagbook_desc, tagbook_auth, replies_auth, entries_perpage, post_reply_text, replies_text, tagbook_create_date, mood_set, background_color, entry_bg_color, border_color, background_image, background_image_fixed, tile_bg, bg_ypos, bg_xpos, sb_face_color, sb_highlight_color, sb_shadow_color, sb_3dlight_color, sb_arrow_color, sb_track_color, sb_darkshadow_color, font, font_color, font_size, normal_link_color, normal_link_underline, active_link_color, active_link_underline, hover_link_color, hover_link_underline, visited_link_color, visited_link_underline, tagbook_title_color, tagbook_title_font_size, entry_title_color, entry_title_font_size, date_time_color, date_time_font_size, block_title_color, block_title_font_size, block_bg_color, block_border_color, custom_block_title, custom_block, cblock_bbcode_uid, show_profile_info, show_calendar, show_contact_info, show_tagbook_info, show_shoutbox, reply_in_popup, tagbook_shoutbox_desc) VALUES ( (+1), 1, 'MAXP0WER''s tagbook', 'Welcome to my tagbook', 0, 0, 5, '(Post your comment)', '%s Comments', 1175374117, 0, '5368C1', 'F9F9F9', 'CCCCCC', 'none', 1, 'repeat', 'center', 'center', 'DEDEDE', 'FFFFFF', 'DEDEDE', 'D7D7D7', '666666', 'EFEFEF', '989898', 0, '000000', 8, '2188E0', 0, '2188E0', 0, 'FF6600', 1, '0066CC', 0, '', , 'FF6600', 16, '0066CC', 10, 'FF6600', 14, 'F0F0F0', 'CCCCCC', '', '', '', 1, 1, 1, 1, 1, 1, 1)

Line : 528
File : tagbook_config.php

This is the code in the file that is spitting out that error code:

			// Everything else okay? Then create the tagbook

		$sql = "INSERT INTO " . tagbooks_TABLE . " (

			tagbook_id,

			template_id,

			tagbook_name,

			tagbook_desc,

			tagbook_auth,

			replies_auth,

			entries_perpage,

			post_reply_text,

			replies_text,

			tagbook_create_date,

			mood_set,

			background_color,

			entry_bg_color,

			border_color,

			background_image,

			background_image_fixed,

			tile_bg,

			bg_ypos,

			bg_xpos,

			sb_face_color,

			sb_highlight_color,

			sb_shadow_color,

			sb_3dlight_color,

			sb_arrow_color,

			sb_track_color,

			sb_darkshadow_color,

			font,

			font_color,

			font_size,

			normal_link_color,

			normal_link_underline,

			active_link_color,

			active_link_underline,

			hover_link_color,

			hover_link_underline,

			visited_link_color,

			visited_link_underline,

			tagbook_title_color,

			tagbook_title_font_size,

			entry_title_color,

			entry_title_font_size,

			date_time_color,

			date_time_font_size,

			block_title_color,

			block_title_font_size,

			block_bg_color,

			block_border_color,

			custom_block_title,

			custom_block,

			cblock_bbcode_uid,

			show_profile_info,

			show_calendar,

			show_contact_info,

			show_tagbook_info,

			show_shoutbox,

			reply_in_popup,

			tagbook_shoutbox_desc)



			VALUES (

			($maximum+1),

			$tagbook_template,

			'" . str_replace("\'", "''", $tagbook_name) . "',

			'" . str_replace("\'", "''", $tagbook_desc) . "',

			$tagbook_auth,

			$reply_auth,

			$num_entries,

			'" . str_replace("\'", "''", $post_reply_label) . "',

			'" . str_replace("\'", "''", $replies_label) . "',

			" . time() . ",

			$tagbook_mood_set,

			'" . str_replace("\'", "''", $background_color) . "',

			'" . str_replace("\'", "''", $entry_bg_color) . "',

			'" . str_replace("\'", "''", $border_color) . "',

			'" . str_replace("\'", "''", $background_image) . "',

			$background_image_fixed,

			'" . str_replace("\'", "''", $tile_bg) . "',

			'" . str_replace("\'", "''", $bg_ypos) . "',

			'" . str_replace("\'", "''", $bg_xpos) . "',

			'" . str_replace("\'", "''", $sb_face_color) . "',

			'" . str_replace("\'", "''", $sb_highlight_color) . "',

			'" . str_replace("\'", "''", $sb_shadow_color) . "',

			'" . str_replace("\'", "''", $sb_3dlight_color) . "',

			'" . str_replace("\'", "''", $sb_arrow_color) . "',

			'" . str_replace("\'", "''", $sb_track_color) . "',

			'" . str_replace("\'", "''", $sb_darkshadow_color) . "',

			$font,

			'" . str_replace("\'", "''", $font_color) . "',

			$font_size,

			'" . str_replace("\'", "''", $normal_link_color) . "',

			$normal_link_underline,

			'" . str_replace("\'", "''", $active_link_color) . "',

			$active_link_underline,

			'" . str_replace("\'", "''", $hover_link_color) . "',

			$hover_link_underline,

			'" . str_replace("\'", "''", $visited_link_color) . "',

			$visited_link_underline,

			'" . str_replace("\'", "''", $tagbook_title_color) . "',

			$tagbook_title_font_size,

			'" . str_replace("\'", "''", $entry_title_color) . "',

			$entry_title_font_size,

			'" . str_replace("\'", "''", $date_time_color) . "',

			$date_time_font_size,

			'" . str_replace("\'", "''", $block_title_color) . "',

			$block_title_font_size,

			'" . str_replace("\'", "''", $block_bg_color) . "',

			'" . str_replace("\'", "''", $block_border_color) . "',

			'" . str_replace("\'", "''", $custom_block_title) . "',

			'" . str_replace("\'", "''", $custom_block) . "',

			'$bbcode_uid',

			$show_profile_info,

			$show_calendar,

			$show_contact_info,

			$show_tagbook_info,

			$show_shoutbox,

			$reply_in_popup,

			$shoutbox_desc)";

		if ( !($result = $db->sql_query($sql, BEGIN_TRANSACTION)) )

		{

			message_die(GENERAL_ERROR, 'Error creating a tagbook.', '', __LINE__, __FILE__, $sql);

		}

This is the MYSQL Table setup:

CREATE TABLE phpbb_tagbooks (
tagbook_id MEDIUMINT( UNSIGNED NOT NULL DEFAULT '0',
template_id SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
tagbook_name VARCHAR(60) NOT NULL DEFAULT '',
tagbook_desc VARCHAR(255) NOT NULL DEFAULT '',
tagbook_auth TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
replies_auth TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
tagbook_entries MEDIUMINT( 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 '',
tagbook_create_date INT(11) NOT NULL DEFAULT '0',
tagbook_views MEDIUMINT( UNSIGNED NOT NULL DEFAULT '0',
tagbook_advanced TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
tagbook_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_tagbook_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',
tagbook_last_entry_id MEDIUMINT( UNSIGNED NOT NULL DEFAULT '0',
mood_set MEDIUMINT( 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 '',
tagbook_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',
tagbook_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 (tagbook_id),
KEY (template_id),
KEY (mood_set)
);

tippy_102 · April 1, 2007

Did you change the name of the database table?

JakeTFG · April 15, 2007

ypu the name of the table is correct phpbb_tagbooks

theres just something wrong with the mysql i think

Sign In

Adapting a phpbb Mod

Recommended Posts

JakeTFG

Link to comment

Share on other sites

tippy_102

Link to comment

Share on other sites

JakeTFG

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information