hm?! looks like you didn't define the GALLERY_USERS_TABLE in the includes/constants.phpsleevedbiker wrote:installed and now getting this error on every topic i try to view
General Error
SQL ERROR [ mysql4 ]
Table 'son0928406324873.GALLERY_USERS_TABLE' doesn't exist [1146]
SQL
SELECT u.*, z.friend, z.foe, p.*, gu.personal_album_id, gu.user_images FROM (phpbb_users u, phpbb_posts p) LEFT JOIN phpbb_zebra z ON (z.user_id = 2 AND z.zebra_id = p.poster_id) LEFT JOIN GALLERY_USERS_TABLE gu ON (gu.user_id = p.poster_id) WHERE p.post_id IN (24252, 24254, 24276, 24320) AND u.user_id = p.poster_id
BACKTRACE
FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()
FILE: viewtopic.php
LINE: 993
CALL: dbal_mysql->sql_query()
please help asap..... if anything how do i remove it from my sql
Code: Select all
// phpBB Gallery integration
define('GALLERY_ROOT_PATH', 'gallery/');
define('GALLERY_ALBUMS_TABLE', $table_prefix . 'gallery_albums');
define('GALLERY_ATRACK_TABLE', $table_prefix . 'gallery_albums_track');
define('GALLERY_COMMENTS_TABLE', $table_prefix . 'gallery_comments');
define('GALLERY_CONFIG_TABLE', $table_prefix . 'gallery_config');
define('GALLERY_CONTESTS_TABLE', $table_prefix . 'gallery_contests');
define('GALLERY_FAVORITES_TABLE', $table_prefix . 'gallery_favorites');
define('GALLERY_IMAGES_TABLE', $table_prefix . 'gallery_images');
define('GALLERY_MODSCACHE_TABLE', $table_prefix . 'gallery_modscache');
define('GALLERY_PERMISSIONS_TABLE', $table_prefix . 'gallery_permissions');
define('GALLERY_RATES_TABLE', $table_prefix . 'gallery_rates');
define('GALLERY_REPORTS_TABLE', $table_prefix . 'gallery_reports');
define('GALLERY_ROLES_TABLE', $table_prefix . 'gallery_roles');
define('GALLERY_USERS_TABLE', $table_prefix . 'gallery_users');
define('GALLERY_WATCH_TABLE', $table_prefix . 'gallery_watch');
Code: Select all
define('GALLERY_USERS_TABLE', $table_prefix . 'gallery_users');
Thanks Josh18657Josh18657 wrote:and here is the mod sql for anyone interested
Code: Select all
CREATE TABLE `phpbb_mypage` ( `mypage_id` int(10) NOT NULL auto_increment, `owner_id` int(10) NOT NULL, `allow_comments` int(1) NOT NULL default '0', `allow_ratings` int(1) NOT NULL default '0', `parse_bbcode` int(1) NOT NULL default '1', `parse_html` int(1) NOT NULL default '0', `parse_smiles` int(1) NOT NULL default '0', `parse_url` int(1) NOT NULL default '1', `bg_color` varchar(50) NOT NULL default 'White', `bg_img` varchar(255) NOT NULL default 'none', `bg_img_url` varchar(255) NOT NULL default 'none', `bg_style` varchar(20) NOT NULL default 'repeat', `bg_style_fix` varchar(10) NOT NULL default 'scroll', `fnt_size` varchar(20) NOT NULL default 'Medium', `fnt_color` varchar(20) NOT NULL default 'Black', `mypage_title` varchar(255) NOT NULL, `created` varchar(255) NOT NULL, `content` text NOT NULL, `bbcode_uid` varchar(255) NOT NULL, `bbcode_bitfield` varchar(255) NOT NULL, `bbcode_options` varchar(255) NOT NULL, `views` int(10) NOT NULL default '0', `mypage_order` int(10) NOT NULL default '0', PRIMARY KEY (`mypage_id`) ) TYPE=MyISAM ; CREATE TABLE `phpbb_mypage_comments` ( `comment_id` int(10) NOT NULL auto_increment, `user_id` int(10) NOT NULL default '0', `comment_username` varchar(255) NOT NULL default '0', `mypage_id` int(10) NOT NULL default '0', `comment` text NOT NULL, `comment_time` int(11) NOT NULL default '0', `page_owner_id` int(10) NOT NULL default '0', `comment_uid` varchar(255) NOT NULL default '0', `comment_bitfield` varchar(255) NOT NULL default '0', `comment_options` varchar(255) NOT NULL default '0', PRIMARY KEY (`comment_id`) ) TYPE=MyISAM ; CREATE TABLE `phpbb_mypage_ratings` ( `rating_id` int(10) NOT NULL auto_increment, `user_id` int(10) NOT NULL default '0', `mypage_id` int(10) NOT NULL default '0', `rating` int(10) NOT NULL default '0', `page_owner_id` int(10) NOT NULL default '0', PRIMARY KEY (`rating_id`) ) TYPE=MyISAM ; CREATE TABLE `phpbb_mypage_uploads` ( `upload_id` int(10) NOT NULL auto_increment, `owner_id` int(10) NOT NULL default '0', `upload_title` varchar(255) NOT NULL default '0', `save_name` varchar(255) NOT NULL default '0', `views` int(10) NOT NULL default '0', `extension` varchar(5) NOT NULL default '0', `size_string` varchar(255) NOT NULL default '0', `width` int(5) NOT NULL default '0', `height` int(5) NOT NULL default '0', `upload_time` int(11) NOT NULL default '0', `mime` varchar(100) NOT NULL default '0', PRIMARY KEY (`upload_id`) ) TYPE=MyISAM ; INSERT INTO `phpbb_config` (`config_name`, `config_value`, `is_dynamic`) VALUES ('mypage_rate_3', '3.gif', 0), ('mypage_rate_2', '2.gif', 0), ('mypage_rate_1', '1.gif', 0), ('mypage_rate_0', '0.gif', 0), ('mypage_default_content', 'page not yet available', 0), ('mypage_use_board_header', '1', 0), ('mypage_max_uploads_size', '100000', 0), ('mypage_custom_footer', '<center><a href="http://www.jtsenterprises.biz"><img src="http://www.jtsenterprises.biz/banners/remote_banner_1.png" /></a></center>', 0), ('mypage_rate_4', '4.gif', 0), ('mypage_rate_5', '5.gif', 0), ('mypage_rate_none', 'none.gif', 0), ('mypage_allowed_1', '1', 0), ('mypage_allowed_2', '5', 0), ('mypage_allowed_3', '10', 0), ('mypage_allowed_uploads_1', '2', 0), ('mypage_allowed_uploads_2', '10', 0), ('mypage_allowed_uploads_3', '15', 0); INSERT INTO `phpbb_acl_options` (`auth_option`, `is_global`, `is_local`, `founder_only`) VALUES (1, 'f_', 0, 1, 0), ('u_mp_comments', 1, 0, 0), ('u_mp_vote', 1, 0, 0), ('u_mp_ratings', 1, 0, 0), ('u_mp_own_ratings', 1, 0, 0), ('u_mp_own_comments', 1, 0, 0), ('u_mp_use_html', 1, 0, 0), ('u_mp_uploads_1', 1, 0, 0), (u_mp_uploads_2', 1, 0, 0), ('u_mp_uploads_3', 1, 0, 0), ('u_mp_allowed_1', 1, 0, 0), ('u_mp_allowed_2', 1, 0, 0), ('u_mp_allowed_3', 1, 0, 0), ('m_mp_edit', 1, 0, 0), ('a_mp_change', 1, 0, 0); -- add modules manually because these aren't correct for other phpbb3 installs INSERT INTO `phpbb_modules` (`module_id`, `module_enabled`, `module_display`, `module_basename`, `module_class`, `parent_id`, `left_id`, `right_id`, `module_langname`, `module_mode`, `module_auth`) VALUES (194, 1, 1, 'mypage', 'ucp', 0, 55, 64, 'UCP_MYPAGE', 'overview', 'acl_u_mp_allowed_1 || acl_u_mp_allowed_2 || acl_u_mp_allowed_3'), (195, 1, 1, 'mypage', 'ucp', 194, 56, 57, 'UCP_MP_MAIN', 'overview', 'acl_u_mp_allowed_1 || acl_u_mp_allowed_2 || acl_u_mp_allowed_3'), (196, 1, 1, 'mypage', 'ucp', 194, 58, 59, 'UCP_MP_UPLOADS', 'uploads', 'acl_u_mp_uploads_1 || acl_u_mp_uploads_2 || acl_u_mp_uploads_3'), (197, 1, 1, 'mypage', 'ucp', 194, 60, 61, 'UCP_MP_ADD', 'add', 'acl_u_mp_allowed_1 || acl_u_mp_allowed_2 || acl_u_mp_allowed_3'), (198, 1, 1, 'mypage', 'ucp', 194, 62, 63, 'UCP_MP_EDIT', 'edit', 'acl_u_mp_allowed_1 || acl_u_mp_allowed_2 || acl_u_mp_allowed_3'), (199, 1, 1, '', 'acp', 9, 102, 109, 'ACP_MP_MYPAGE', '', 'acl_a_mp_change'), (200, 1, 1, 'mypage', 'acp', 199, 103, 104, 'ACP_MP_MAIN', 'overview', 'acl_a_mp_change'), (201, 1, 1, 'mypage', 'acp', 199, 105, 106, 'ACP_MP_LIMITS', 'limits', 'acl_a_mp_change'), (202, 1, 1, 'mypage', 'acp', 199, 107, 108, 'ACP_MP_STYLE', 'style', 'acl_a_mp_change');
Please do that.Anyasha wrote:I have souped up this baby like crazy (avatar and colored usernames in comments, smilies and bbcode above comment text box, "last updated" feature, more colors, ability to select from premade templates, etc) and fixed a lot of errors. Am I allowed to make a zip and post it?
Lastpost wrote:Please do that.Anyasha wrote:I have souped up this baby like crazy (avatar and colored usernames in comments, smilies and bbcode above comment text box, "last updated" feature, more colors, ability to select from premade templates, etc) and fixed a lot of errors. Am I allowed to make a zip and post it?