Jump to content

Recommended Posts

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)
);

Link to comment
https://forums.phpfreaks.com/topic/45071-adapting-a-phpbb-mod/
Share on other sites

  • 2 weeks later...
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.