Error on DB Update 3.0.5 > 3.0.6

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Scam Warning
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
NazTheEternal
Registered User
Posts: 55
Joined: Mon Apr 28, 2008 6:06 am

Error on DB Update 3.0.5 > 3.0.6

Post by NazTheEternal »

Code: Select all

Notice: Constant LOG_CONNECTIONS already defined in /home/content/.../forum/includes/constants.php on line 359

Notice: Constant LOG_LC_EXCLUDE_IP_TABLE already defined in /home/content/.../forum/includes/constants.php on line 360

Warning: Cannot modify header information - headers already sent by (output started at /home/content/.../forum/includes/constants.php:359) in /home/content/.../forum/install/database_update.php on line 171
When I click on the automated "Update" button it gives me this error here above, and I haven't a clue how to solve it...
ameeck
Former Team Member
Posts: 6559
Joined: Mon Mar 21, 2005 6:57 pm

Re: Error on DB Update 3.0.5 > 3.0.6

Post by ameeck »

Can you attach your constants.php file?
NazTheEternal
Registered User
Posts: 55
Joined: Mon Apr 28, 2008 6:06 am

Re: Error on DB Update 3.0.5 > 3.0.6

Post by NazTheEternal »

Sure thing...Heres the code as well as the attached file

Code: Select all

<?php
/**
*
* @package phpBB3
* @version $Id: constants.php,v 1.2 2009/06/03 22:05:58 damysterious Exp $
* @copyright (c) 2005 phpBB Group
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
*/

/**
* @ignore
*/
if (!defined('IN_PHPBB'))
{
	exit;
}

/**
* valid external constants:
* PHPBB_MSG_HANDLER
* PHPBB_DB_NEW_LINK
* PHPBB_ROOT_PATH
* PHPBB_ADMIN_PATH
*/

// phpBB Version
define('PHPBB_VERSION', '3.0.5');

// QA-related
// define('PHPBB_QA', 1);

// User related
define('ANONYMOUS', 1);

define('USER_ACTIVATION_NONE', 0);
define('USER_ACTIVATION_SELF', 1);
define('USER_ACTIVATION_ADMIN', 2);
define('USER_ACTIVATION_DISABLE', 3);

define('AVATAR_UPLOAD', 1);
define('AVATAR_REMOTE', 2);
define('AVATAR_GALLERY', 3);

define('USER_NORMAL', 0);
define('USER_INACTIVE', 1);
define('USER_IGNORE', 2);
define('USER_FOUNDER', 3);

define('INACTIVE_REGISTER', 1);
define('INACTIVE_PROFILE', 2);
define('INACTIVE_MANUAL', 3);
define('INACTIVE_REMIND', 4);

// ACL
define('ACL_NEVER', 0);
define('ACL_YES', 1);
define('ACL_NO', -1);

// Login error codes
define('LOGIN_CONTINUE', 1);
define('LOGIN_BREAK', 2);
define('LOGIN_SUCCESS', 3);
define('LOGIN_SUCCESS_CREATE_PROFILE', 20);
define('LOGIN_ERROR_USERNAME', 10);
define('LOGIN_ERROR_PASSWORD', 11);
define('LOGIN_ERROR_ACTIVE', 12);
define('LOGIN_ERROR_ATTEMPTS', 13);
define('LOGIN_ERROR_EXTERNAL_AUTH', 14);
define('LOGIN_ERROR_PASSWORD_CONVERT', 15);

// Group settings
define('GROUP_OPEN', 0);
define('GROUP_CLOSED', 1);
define('GROUP_HIDDEN', 2);
define('GROUP_SPECIAL', 3);
define('GROUP_FREE', 4);

// Forum/Topic states
define('FORUM_CAT', 0);
define('FORUM_POST', 1);
define('FORUM_LINK', 2);
define('ITEM_UNLOCKED', 0);
define('ITEM_LOCKED', 1);
define('ITEM_MOVED', 2);

// Forum Flags
define('FORUM_FLAG_LINK_TRACK', 1);
define('FORUM_FLAG_PRUNE_POLL', 2);
define('FORUM_FLAG_PRUNE_ANNOUNCE', 4);
define('FORUM_FLAG_PRUNE_STICKY', 8);
define('FORUM_FLAG_ACTIVE_TOPICS', 16);
define('FORUM_FLAG_POST_REVIEW', 32);

// Optional text flags
define('OPTION_FLAG_BBCODE', 1);
define('OPTION_FLAG_SMILIES', 2);
define('OPTION_FLAG_LINKS', 4);

// Topic types
define('POST_NORMAL', 0);
define('POST_STICKY', 1);
define('POST_ANNOUNCE', 2);
define('POST_GLOBAL', 3);

// Lastread types
define('TRACK_NORMAL', 0);
define('TRACK_POSTED', 1);

// Notify methods
define('NOTIFY_EMAIL', 0);
define('NOTIFY_IM', 1);
define('NOTIFY_BOTH', 2);

// Email Priority Settings
define('MAIL_LOW_PRIORITY', 4);
define('MAIL_NORMAL_PRIORITY', 3);
define('MAIL_HIGH_PRIORITY', 2);

// Log types
define('LOG_ADMIN', 0);
define('LOG_MOD', 1);
define('LOG_CRITICAL', 2);
define('LOG_USERS', 3);

// phpBB Gallery integration
define('LOG_GALLERY', 4);
// phpBB Gallery integration

// phpBB log connections integration
define('LOG_CONNECTIONS', 4);
// phpBB log connections integration

// Private messaging - Do NOT change these values
// start mod view or mark unread posts (and end mod too)...added the next line
define('PRIVMSGS_UNREADBOX', -5);
define('PRIVMSGS_HOLD_BOX', -4);
define('PRIVMSGS_NO_BOX', -3);
define('PRIVMSGS_OUTBOX', -2);
define('PRIVMSGS_SENTBOX', -1);
define('PRIVMSGS_INBOX', 0);

// Full Folder Actions
define('FULL_FOLDER_NONE', -3);
define('FULL_FOLDER_DELETE', -2);
define('FULL_FOLDER_HOLD', -1);

// Download Modes - Attachments
define('INLINE_LINK', 1);
// This mode is only used internally to allow modders extending the attachment functionality
define('PHYSICAL_LINK', 2);

// Confirm types
define('CONFIRM_REG', 1);
define('CONFIRM_LOGIN', 2);
define('CONFIRM_POST', 3);

// Categories - Attachments
define('ATTACHMENT_CATEGORY_NONE', 0);
define('ATTACHMENT_CATEGORY_IMAGE', 1); // Inline Images
define('ATTACHMENT_CATEGORY_WM', 2); // Windows Media Files - Streaming
define('ATTACHMENT_CATEGORY_RM', 3); // Real Media Files - Streaming
define('ATTACHMENT_CATEGORY_THUMB', 4); // Not used within the database, only while displaying posts
define('ATTACHMENT_CATEGORY_FLASH', 5); // Flash/SWF files
define('ATTACHMENT_CATEGORY_QUICKTIME', 6); // Quicktime/Mov files

// BBCode UID length
define('BBCODE_UID_LEN', 8);

// Number of core BBCodes
define('NUM_CORE_BBCODES', 12);

// Magic url types
define('MAGIC_URL_EMAIL', 1);
define('MAGIC_URL_FULL', 2);
define('MAGIC_URL_LOCAL', 3);
define('MAGIC_URL_WWW', 4);

// Profile Field Types
define('FIELD_INT', 1);
define('FIELD_STRING', 2);
define('FIELD_TEXT', 3);
define('FIELD_BOOL', 4);
define('FIELD_DROPDOWN', 5);
define('FIELD_DATE', 6);

// referer validation
define('REFERER_VALIDATE_NONE', 0);
define('REFERER_VALIDATE_HOST', 1);
define('REFERER_VALIDATE_PATH', 2);

// phpbb_chmod() permissions
@define('CHMOD_ALL', 7);
@define('CHMOD_READ', 4);
@define('CHMOD_WRITE', 2);
@define('CHMOD_EXECUTE', 1);

// Captcha code length
define('CAPTCHA_MIN_CHARS', 4);
define('CAPTCHA_MAX_CHARS', 7);

// Additional constants
define('VOTE_CONVERTED', 127);

// Table names
define('ACL_GROUPS_TABLE',			$table_prefix . 'acl_groups');
define('ACL_OPTIONS_TABLE',			$table_prefix . 'acl_options');
define('ACL_ROLES_DATA_TABLE',		$table_prefix . 'acl_roles_data');
define('ACL_ROLES_TABLE',			$table_prefix . 'acl_roles');
define('ACL_USERS_TABLE',			$table_prefix . 'acl_users');
define('ATTACHMENTS_TABLE',			$table_prefix . 'attachments');
define('BANLIST_TABLE',				$table_prefix . 'banlist');
define('BBCODES_TABLE',				$table_prefix . 'bbcodes');
define('BOOKMARKS_TABLE',			$table_prefix . 'bookmarks');
define('BOTS_TABLE',				$table_prefix . 'bots');
define('CONFIG_TABLE',				$table_prefix . 'config');
define('CONFIRM_TABLE',				$table_prefix . 'confirm');
define('DISALLOW_TABLE',			$table_prefix . 'disallow');
define('DRAFTS_TABLE',				$table_prefix . 'drafts');
define('EXTENSIONS_TABLE',			$table_prefix . 'extensions');
define('EXTENSION_GROUPS_TABLE',	$table_prefix . 'extension_groups');
define('FORUMS_TABLE',				$table_prefix . 'forums');
define('FORUMS_ACCESS_TABLE',		$table_prefix . 'forums_access');
define('FORUMS_TRACK_TABLE',		$table_prefix . 'forums_track');
define('FORUMS_WATCH_TABLE',		$table_prefix . 'forums_watch');
define('GROUPS_TABLE',				$table_prefix . 'groups');
define('ICONS_TABLE',				$table_prefix . 'icons');
define('LANG_TABLE',				$table_prefix . 'lang');
define('LOG_TABLE',					$table_prefix . 'log');
//-- mod : log connections --------------------------------------------------------
//-- add
define('LOG_LC_EXCLUDE_IP_TABLE',	$table_prefix . 'log_lc_exclude_ip');
//-- end : log connections --------------------------------------------------------
define('MODERATOR_CACHE_TABLE',		$table_prefix . 'moderator_cache');
define('MODULES_TABLE',				$table_prefix . 'modules');
define('POLL_OPTIONS_TABLE',		$table_prefix . 'poll_options');
define('POLL_VOTES_TABLE',			$table_prefix . 'poll_votes');
define('POSTS_TABLE',				$table_prefix . 'posts');
define('PRIVMSGS_TABLE',			$table_prefix . 'privmsgs');
define('PRIVMSGS_FOLDER_TABLE',		$table_prefix . 'privmsgs_folder');
define('PRIVMSGS_RULES_TABLE',		$table_prefix . 'privmsgs_rules');
define('PRIVMSGS_TO_TABLE',			$table_prefix . 'privmsgs_to');
define('PROFILE_FIELDS_TABLE',		$table_prefix . 'profile_fields');
define('PROFILE_FIELDS_DATA_TABLE',	$table_prefix . 'profile_fields_data');
define('PROFILE_FIELDS_LANG_TABLE',	$table_prefix . 'profile_fields_lang');
define('PROFILE_LANG_TABLE',		$table_prefix . 'profile_lang');
define('RANKS_TABLE',				$table_prefix . 'ranks');
define('REPORTS_TABLE',				$table_prefix . 'reports');
define('REPORTS_REASONS_TABLE',		$table_prefix . 'reports_reasons');
define('SEARCH_RESULTS_TABLE',		$table_prefix . 'search_results');
define('SEARCH_WORDLIST_TABLE',		$table_prefix . 'search_wordlist');
define('SEARCH_WORDMATCH_TABLE',	$table_prefix . 'search_wordmatch');
define('SESSIONS_TABLE',			$table_prefix . 'sessions');
define('SESSIONS_KEYS_TABLE',		$table_prefix . 'sessions_keys');
define('SITELIST_TABLE',			$table_prefix . 'sitelist');
define('SMILIES_TABLE',				$table_prefix . 'smilies');
define('STYLES_TABLE',				$table_prefix . 'styles');
define('STYLES_TEMPLATE_TABLE',		$table_prefix . 'styles_template');
define('STYLES_TEMPLATE_DATA_TABLE',$table_prefix . 'styles_template_data');
define('STYLES_THEME_TABLE',		$table_prefix . 'styles_theme');
define('STYLES_IMAGESET_TABLE',		$table_prefix . 'styles_imageset');
define('STYLES_IMAGESET_DATA_TABLE',$table_prefix . 'styles_imageset_data');
define('TOPICS_TABLE',				$table_prefix . 'topics');
define('TOPICS_POSTED_TABLE',		$table_prefix . 'topics_posted');
define('TOPICS_TRACK_TABLE',		$table_prefix . 'topics_track');
define('TOPICS_WATCH_TABLE',		$table_prefix . 'topics_watch');
define('USER_GROUP_TABLE',			$table_prefix . 'user_group');
define('USERS_TABLE',				$table_prefix . 'users');
define('WARNINGS_TABLE',			$table_prefix . 'warnings');
define('WORDS_TABLE',				$table_prefix . 'words');
define('ZEBRA_TABLE',				$table_prefix . 'zebra');

// Additional tables

/*
*
* @package define database tables for phpBB3 Portal XL 5.0
* @copyright (c) 2007 Portal XL 5.0 Group
* @license http://opensource.org/licenses/gpl-license.php GNU Public License 
*
*/
define('PORTAL_CONFIG_TABLE',			$table_prefix . 'portal_config');
define('PORTAL_BLOCK_TABLE',			$table_prefix . 'portal_block');
define('PORTAL_BLOCK_INDEX_TABLE',		$table_prefix . 'portal_block_index');
define('PORTAL_MENU_TABLE',         	$table_prefix . 'portal_menu');
define('PORTAL_QUOTE_TABLE',        	$table_prefix . 'portal_quote');
define('PORTAL_PARTNERS_TABLE',     	$table_prefix . 'portal_partners');
define('PORTAL_BANNER_HO_TABLE',    	$table_prefix . 'portal_banners_ho');
define('PORTAL_BANNER_VE_TABLE',    	$table_prefix . 'portal_banners_ve');
define('PORTAL_LINKS_TABLE',    		$table_prefix . 'portal_links');
define('PORTAL_MODS_TABLE',				$table_prefix . 'portal_mods');
define('PORTAL_FORUMADDS_TABLE',		$table_prefix . 'portal_forumadds');
define('PORTAL_PAGES_TABLE', 	        $table_prefix .	'portal_pages');
define('PORTAL_NEWSFEEDS_TABLE',  		$table_prefix . 'portal_newsfeeds');
define('PORTAL_ACRONYMS_TABLE',  		$table_prefix . 'portal_acronyms');
define('PORTAL_THANKS_TABLE', 			$table_prefix . 'portal_thanks');
define('PORTAL_USER_SETTINGS_TABLE', 	$table_prefix . 'portal_user_settings');
define('PORTAL_PAGE', true);
define('PORTAL_PAGES', true);
define('PORTAL_PAGES_PAGE', true);
define('PORTAL_INDEX', true);

// Animate Digits IP Tracking Counter
define('COUNTER_NONE', 0);
define('COUNTER_IMAGE', 1);
define('COUNTER_TEXT', 2);

// Download MOD 6
define('DL_INSTALLED', true);
define('DL_AUTH_TABLE', 				$table_prefix . 'dl_auth');
define('DL_CAT_TABLE', 					$table_prefix . 'downloads_cat');
define('DL_CONFIG_TABLE', 				$table_prefix . 'dl_config');
define('DL_EXT_BLACKLIST', 				$table_prefix . 'dl_ext_blacklist');
define('DL_RATING_TABLE', 				$table_prefix . 'dl_ratings');
define('DOWNLOADS_TABLE', 				$table_prefix . 'downloads');
define('DL_STATS_TABLE', 				$table_prefix . 'dl_stats');
define('DL_COMMENTS_TABLE', 			$table_prefix . 'dl_comments');
define('DL_BANLIST_TABLE', 				$table_prefix . 'dl_banlist');
define('DL_FAVORITES_TABLE', 			$table_prefix . 'dl_favorites');
define('DL_NOTRAF_TABLE', 				$table_prefix . 'dl_notraf');
define('DL_HOTLINK_TABLE', 				$table_prefix . 'dl_hotlink');
define('DL_BUGS_TABLE', 				$table_prefix . 'dl_bug_tracker');
define('DL_BUG_HISTORY_TABLE', 			$table_prefix . 'dl_bug_history');

define('KB_ARTICLE_TABLE',				$table_prefix . 'kb_article');
define('KB_CATEGORIE_TABLE',			$table_prefix . 'kb_categorie');
define('KB_CONFIG_TABLE',				$table_prefix . 'kb_config');
define('KB_LOG_TABLE',					$table_prefix . 'kb_changelog');
define('KB_TYPES_TABLE',				$table_prefix . 'kb_types');
define('KB_REPORTS_TABLE',				$table_prefix . 'kb_reports');
define('KB_FOLDER',						'knowledge');

// phpBB Calendar
define('CALENDAR_CONFIG_TABLE',			$table_prefix . 'calendar_config');
define('CALENDAR_EVENTS_TABLE',			$table_prefix . 'calendar_events');
define('CALENDAR_EVENT_TYPES_TABLE',	$table_prefix . 'calendar_event_types');

// Ajax ShoutBox Version 1.2 RC1
define('SHOUTBOX_TABLE', 				$table_prefix . 'shoutbox');

// Prime Post Revisions
define('POST_REVISIONS_TABLE',			$table_prefix . 'post_revisions');

// lefty74 Announcement Centre
define('ANNOUNCEMENTS_CENTRE_TABLE',	$table_prefix . 'announcement_centre');
define('GROUPS_ONLY', 0);
define('EVERYONE', 1);
define('GUESTS_ONLY', 2);

// Imprint 0.1.6
define('IMPRESSUM_TABLE',				$table_prefix . 'impressum');

// Automatic DST 1.0.6
define('DST_OFF', 0);
define('DST_ON', 1);
define('DST_AUTO', 2);

// log connections
define('LOG_CONNECTIONS', 4);
define('LOG_LC_EXCLUDE_IP_TABLE',	$table_prefix . 'log_lc_exclude_ip');

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

?>
Attachments
constants.php
(13.81 KiB) Downloaded 19 times
NazTheEternal
Registered User
Posts: 55
Joined: Mon Apr 28, 2008 6:06 am

Re: Error on DB Update 3.0.5 > 3.0.6

Post by NazTheEternal »

Anybody have a similar issue or any ideas on a fix? I'm totally lost and can not update my forums and thus have to deal with spam bots galore...
User avatar
HGN
Former Team Member
Posts: 4706
Joined: Wed Dec 03, 2008 1:53 pm
Location: The Netherlands
Name: Alfred
Contact:

Re: Error on DB Update 3.0.5 > 3.0.6

Post by HGN »

LOG_CONNECTIONS is defined twice in your constants.php, on line 131 and on line 359
LOG_LC_EXCLUDE_IP_TABLE is defined twice in your constants.php, on line 232 and on line 360

Both constants are not in the fresh constants.php, so you must have modified the file having created these constants twice. You should find for which mod(s) these modifications were made.
NazTheEternal
Registered User
Posts: 55
Joined: Mon Apr 28, 2008 6:06 am

Re: Error on DB Update 3.0.5 > 3.0.6

Post by NazTheEternal »

Right fixed that and managed to start the update and then i got this message while is was checking the files

Code: Select all

Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, support@supportwebsite.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.
Not exactly sure where to find this error log...
NazTheEternal
Registered User
Posts: 55
Joined: Mon Apr 28, 2008 6:06 am

Re: Error on DB Update 3.0.5 > 3.0.6

Post by NazTheEternal »

Well I checked through every possible error log I have, on the forums and on the SQL and they are all empty
User avatar
HGN
Former Team Member
Posts: 4706
Joined: Wed Dec 03, 2008 1:53 pm
Location: The Netherlands
Name: Alfred
Contact:

Re: Error on DB Update 3.0.5 > 3.0.6

Post by HGN »

Then you should ask your provider to verify the server error log.
NazTheEternal
Registered User
Posts: 55
Joined: Mon Apr 28, 2008 6:06 am

Re: Error on DB Update 3.0.5 > 3.0.6

Post by NazTheEternal »

Ok so I figured out the issue with the logs, I had to enable them myself for a week...

Here is the error that came up when the update bugged out...

Code: Select all

[Sun Feb  7 12:13:53 2010] [error] Premature end of script headers: /var/chroot/home/content/.../forum/install/index.php
NazTheEternal
Registered User
Posts: 55
Joined: Mon Apr 28, 2008 6:06 am

Re: Error on DB Update 3.0.5 > 3.0.6

Post by NazTheEternal »

I've tried redownloading the update in the event that it might have been a corrupt download but I still get the same error... I'm drawing blanks on this
NazTheEternal
Registered User
Posts: 55
Joined: Mon Apr 28, 2008 6:06 am

Re: Error on DB Update 3.0.5 > 3.0.6

Post by NazTheEternal »

I hate to keep bumping this but does anybody have any clue what the issue could be? I really need to update as I am getting spammed with bots hardcore...
NazTheEternal
Registered User
Posts: 55
Joined: Mon Apr 28, 2008 6:06 am

Re: Error on DB Update 3.0.5 > 3.0.6

Post by NazTheEternal »

So i looked up the error and a post mentioned that it could have something to do with lack of memory from my providers side...

Is that possible?
User avatar
Lumpy Burgertushie
Registered User
Posts: 68169
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Error on DB Update 3.0.5 > 3.0.6

Post by Lumpy Burgertushie »

updating is not going to stop the spammers.

yes, there are new spam protections in 3.0.6 but you already have all you need in your version to stop them.

read the spam sticky at the top of this forum.

also, unless you have a lot of MODs installed, just replace all the files with new ones from the full package download from here. except for the config.php file. then, in your browser, go to:
yourdomain.com/yourphpbb/install/database_update.php
then delete the install folder
you are now updated

robert
I'm baaaaaccckkkk. still doing work on donation basis. PM your needs.

Premium phpBB 3.3 Styles by PlanetStyles.net

If nobody is in the forest, does a tree really fall?
NazTheEternal
Registered User
Posts: 55
Joined: Mon Apr 28, 2008 6:06 am

Re: Error on DB Update 3.0.5 > 3.0.6

Post by NazTheEternal »

Thats the problem I have quite a bit of MOD-ing done, such as the Portal and other smaller mods.... Sigh...I have a feeling there is no easy way out of this...

Could it be a folder permissions setting causing this?
Locked

Return to “[3.0.x] Support Forum”