Page 1 of 1

Install help, subsilver2...

Posted: 16. July 2008 07:49
by Sharky
Hi,

I'm just in the process of installing this portal on my 3.0.1 board that is currently running Subsilver2 - my first question is;

Am I correct in assuming that I have to complete the install instructions for ProSilver as well as SS2 in order for the MOD to function correctly before completing the SS2 edits? (I have copied all the directories/files to their appropriate destinations on my site, as instructed by the install.xml file by not advanced to the subsilver2.xml instructions as yet).

My second question is in regards to the following;

.htaccess edit

Code: Select all

<Files "common.php">
Order Allow,Deny
Deny from All
</Files>
The problem is, my .htaccess file does not contain the above code. Mine looks like this...

Code: Select all

# -FrontPage-

IndexIgnore .htaccess */.??* *~ *# */HEADER* */README* */_vti*

<Limit GET POST>
order deny,allow
deny from all
allow from all
</Limit>
<Limit PUT DELETE>
order deny,allow
deny from all
</Limit>
AuthName *****************
AuthUserFile /home/*******/public_html/_vti_pvt/service.pwd
AuthGroupFile /home/********/public_html/_vti_pvt/service.grp
Am I opening the correct file? - .htaccess in my forums root dir?.

All the other edits looks pretty straight forward. Should I run the install_portal/install.php before or after editing the SubSilver2 files, or does it make no difference?.

Thanks for your help, I look forward to the implementation of this portal to my forums.

Re: Install help, subsilver2...

Posted: 16. July 2008 12:11
by Sharky
WOW, what a mess - so I edited all the files and ran the installer, came up with all this;

Code: Select all

session_begin(); $auth->acl($user->data); $user->setup('mods/portal_install'); $mode = request_var('mode', ''); $page_title = 'Board3portal v' . $current_version; if( $user->data['is_registered'] && $auth->acl_get('a_board') ) { $version_array = array('0.1.0', '0.2.0', '0.2.1', '0.2.2', '0.3.0', 'p3p1.2.2', 'p3p1.2.1', 'p3p1.2.0', 'p3p1.1.0b'); $old_version = 0; $phpbb3portal = false; $installed = $updated = $uninstalled =false; $sql = 'SELECT config_value as version FROM ' . PORTAL_CONFIG_TABLE . " WHERE config_name = 'portal_version'"; $result = @$db->sql_query_limit( $sql, 1 ); if( $db->sql_affectedrows($result) > 0 ) { $version = $db->sql_fetchrow( $result ); $old_version = strtolower($version['version']); } else { $db->sql_freeresult( $result ); $sql = 'SELECT config_value as version FROM ' . CONFIG_TABLE . " WHERE config_name = 'portal_version'"; $result = @$db->sql_query_limit( $sql, 1 ); if( $db->sql_affectedrows($result) > 0 ) { $version = $db->sql_fetchrow( $result ); $phpbb3portal = true; $old_version = ( strtolower($version['version']) == '1.1.0.b' ) ? '1.1.0b' : strtolower($version['version']) ; } } $db->sql_freeresult( $result ); $check_mode = 'none'; if( $old_version == 0 ) { $check_mode = 'install'; } elseif( $phpbb3portal === TRUE || version_compare( $old_version, $current_version, "<" ) === TRUE ) { $check_mode = 'update'; } $confirm = request_var('confirm', 0); $error_array = array(); function split_sql_file($sql, $delimiter) { $sql = str_replace("\r" , '', $sql); $data = preg_split('/' . preg_quote($delimiter, '/') . '$/m', $sql); $data = array_map('trim', $data); // The empty case $end_data = end($data); if (empty($end_data)) { unset($data[key($data)]); } return $data; } function db_error( $error, $sql, $line, $file, $skip = false ) { global $error, $lang, $db; if( $skip ) { $error_array[] = '' . $user->lang['GENERAL_ERROR'] . ': ' . basename($file) . ' [ ' . $line . ' ]
' . $error . '
» SQL:' . $sql; return; } else { include $phpbb_root_path . 'install_portal/style/layout_header.php'; echo '
'. $user->lang['GENERAL_ERROR'] .'

' . $error . '
» SQL:' . $sql . '
' . basename($file) . ' [ ' . $line . ' ]
'; include $phpbb_root_path . 'install_portal/style/layout_footer.php'; exit; } } function remove_comments(&$output) { $lines = explode("\n", $output); $output = ''; // try to keep mem. use down $linecount = sizeof($lines); $in_comment = false; for ($i = 0; $i < $linecount; $i++) { if (trim($lines[$i]) == '/*') { $in_comment = true; } if (!$in_comment) { $output .= $lines[$i] . "\n"; } if (trim($lines[$i]) == '*/') { $in_comment = false; } } unset($lines); return $output; } function remove_remarks(&$sql) { $sql = preg_replace('/\n{2,}/', "\n", preg_replace('/^#.*$/m', "\n", $sql)); } // What sql_layer should we use? switch ($db->sql_layer) { case 'mysql': $db_schema = 'mysql_40'; $delimiter = ';'; $comments = 'remove_remarks'; break; case 'mysql4': if (version_compare($db->mysql_version, '4.1.3', '>=')) { $db_schema = 'mysql_41'; } else { $db_schema = 'mysql_40'; } $delimiter = ';'; $comments = 'remove_remarks'; break; case 'mysqli': $db_schema = 'mysql_41'; $delimiter = ';'; $comments = 'remove_remarks'; break; case 'mssql': case 'mssql_odbc': $db_schema = 'mssql'; $delimiter = 'GO'; $comments = 'remove_comments'; break; case 'postgres': $db_schema = 'postgres'; $delimiter = ';'; $comments = 'remove_comments'; break; case 'sqlite': $db_schema = 'sqlite'; $delimiter = ';'; $comments = 'remove_remarks'; break; case 'firebird': $db_schema = 'firebird'; $delimiter = ';;'; $comments = 'remove_remarks'; break; case 'oracle': $db_schema = 'oracle'; $delimiter = '/'; $comments = 'remove_comments'; break; default: trigger_error('Sorry, unsupported DBMS found: ' . $db->sql_layer); break; } // Get old version if it is installed. switch ($mode) { // Installing from scratch case 'install': if( $check_mode == 'install' ) { if( $confirm == 1) { // Drop thes tables if existing switch( $db->sql_layer ) { case 'mysql4': case 'mysqli': case 'oracle': case 'firebird': case 'sqlite': case 'mysql': $sql = 'DROP TABLE IF EXISTS ' . $table_prefix . 'portal_config'; $result = $db->sql_query($sql); $db->sql_freeresult($result); break; case '': $sql = 'SELECT version() as version'; $result = $db->sql_query($sql); $data = $db->sql_fetchrow($result); if( version_compare($data['version'], '8.1.11', '>') === TRUE ) { $sql = 'DROP TABLE IF EXISTS ' . $table_prefix . 'portal_config'; $result = $db->sql_query($sql); $db->sql_freeresult($result); } else { $sql = 'DROP TABLE ' . $table_prefix . 'portal_config'; $result = @$db->sql_query($sql); $db->sql_freeresult($result); } break; case 'mssql': $sql = 'if exists (select * from sysobjects where name = ' . $table_prefix . 'portal_config) drop table ' . $table_prefix . 'portal_config'; $result = $db->sql_query($sql); $db->sql_freeresult($result); break; } // locate the schema files $dbms_schema = 'schemas/_' . $db_schema . '_schema.sql'; $sql_query = @file_get_contents($dbms_schema); $sql_query = preg_replace('#phpbb_#i', $table_prefix, $sql_query); $comments($sql_query); $sql_query = split_sql_file($sql_query, $delimiter); // Make tables foreach ($sql_query as $sql) { if (!$db->sql_query($sql)) { $error = $db->sql_error(); db_error($error['message'], $sql, __LINE__, __FILE__); } } unset($sql_query); // Now for the data $sql_query = @file_get_contents('schemas/_schema_data.sql'); switch ($db->sql_layer) { case 'mssql': case 'mssql_odbc': $sql_query = preg_replace('#\# MSSQL IDENTITY (phpbb_[a-z_]+) (ON|OFF) \##s', 'SET IDENTITY_INSERT \1 \2;', $sql_query); break; case 'postgres': $sql_query = preg_replace('#\# POSTGRES (BEGIN|COMMIT) \##s', '\1; ', $sql_query); break; } $sql_query = preg_replace('#phpbb_#i', $table_prefix, $sql_query); $sql_query = preg_replace('/\n{2,}/', "\n", preg_replace('/^#.*$/m', "\n", $sql_query)); $sql_query = split_sql_file($sql_query, ';'); $sql_query[] = "INSERT INTO {$table_prefix}portal_config (config_name, config_value) VALUES ('portal_version', '{$current_version}')"; foreach ($sql_query as $sql) { if (!$db->sql_query($sql)) { $error = $db->sql_error(); db_error($error['message'], $sql, __LINE__, __FILE__); } } unset($sql_query); // create the acp modules - Nickvergessen's code $modules = new acp_modules(); $portal = array( 'module_basename' => '', 'module_enabled' => 1, 'module_display' => 1, 'parent_id' => 31, 'module_class' => 'acp', 'module_langname' => 'ACP_PORTAL_INFO', 'module_mode' => '', 'module_auth' => '' ); $modules->update_module_data($portal); $general = array( 'module_basename' => 'portal', 'module_enabled' => 1, 'module_display' => 1, 'parent_id' => $portal['module_id'], 'module_class' => 'acp', 'module_langname' => 'ACP_PORTAL_GENERAL_INFO', 'module_mode' => 'general', 'module_auth' => '' ); $modules->update_module_data($general); $news = array( 'module_basename' => 'portal', 'module_enabled' => 1, 'module_display' => 1, 'parent_id' => $portal['module_id'], 'module_class' => 'acp', 'module_langname' => 'ACP_PORTAL_NEWS_INFO', 'module_mode' => 'news', 'module_auth' => '' ); $modules->update_module_data($news); $announcements = array( 'module_basename' => 'portal', 'module_enabled' => 1, 'module_display' => 1, 'parent_id' => $portal['module_id'], 'module_class' => 'acp', 'module_langname' => 'ACP_PORTAL_ANNOUNCE_INFO', 'module_mode' => 'announcements', 'module_auth' => '' ); $modules->update_module_data($announcements); $welcome = array( 'module_basename' => 'portal', 'module_enabled' => 1, 'module_display' => 1, 'parent_id' => $portal['module_id'], 'module_class' => 'acp', 'module_langname' => 'ACP_PORTAL_WELCOME_INFO', 'module_mode' => 'welcome', 'module_auth' => '' ); $modules->update_module_data($welcome); $recent = array( 'module_basename' => 'portal', 'module_enabled' => 1, 'module_display' => 1, 'parent_id' => $portal['module_id'], 'module_class' => 'acp', 'module_langname' => 'ACP_PORTAL_RECENT_INFO', 'module_mode' => 'recent', 'module_auth' => '' ); $modules->update_module_data($recent); $wordgraph = array( 'module_basename' => 'portal', 'module_enabled' => 1, 'module_display' => 1, 'parent_id' => $portal['module_id'], 'module_class' => 'acp', 'module_langname' => 'ACP_PORTAL_WORDGRAPH_INFO', 'module_mode' => 'wordgraph', 'module_auth' => '' ); $modules->update_module_data($wordgraph); $paypal = array( 'module_basename' => 'portal', 'module_enabled' => 1, 'module_display' => 1, 'parent_id' => $portal['module_id'], 'module_class' => 'acp', 'module_langname' => 'ACP_PORTAL_PAYPAL_INFO', 'module_mode' => 'paypal', 'module_auth' => '' ); $modules->update_module_data($paypal); $attachments = array( 'module_basename' => 'portal', 'module_enabled' => 1, 'module_display' => 1, 'parent_id' => $portal['module_id'], 'module_class' => 'acp', 'module_langname' => 'ACP_PORTAL_ATTACHMENTS_NUMBER_INFO', 'module_mode' => 'attachments', 'module_auth' => '' ); $modules->update_module_data($attachments); $members = array( 'module_basename' => 'portal', 'module_enabled' => 1, 'module_display' => 1, 'parent_id' => $portal['module_id'], 'module_class' => 'acp', 'module_langname' => 'ACP_PORTAL_MEMBERS_INFO', 'module_mode' => 'members', 'module_auth' => '' ); $modules->update_module_data($members); $polls = array( 'module_basename' => 'portal', 'module_enabled' => 1, 'module_display' => 1, 'parent_id' => $portal['module_id'], 'module_class' => 'acp', 'module_langname' => 'ACP_PORTAL_POLLS_INFO', 'module_mode' => 'polls', 'module_auth' => '' ); $modules->update_module_data($polls); $bots = array( 'module_basename' => 'portal', 'module_enabled' => 1, 'module_display' => 1, 'parent_id' => $portal['module_id'], 'module_class' => 'acp', 'module_langname' => 'ACP_PORTAL_BOTS_INFO', 'module_mode' => 'bots', 'module_auth' => '' ); $modules->update_module_data($bots); $poster = array( 'module_basename' => 'portal', 'module_enabled' => 1, 'module_display' => 1, 'parent_id' => $portal['module_id'], 'module_class' => 'acp', 'module_langname' => 'ACP_PORTAL_MOST_POSTER_INFO', 'module_mode' => 'poster', 'module_auth' => '' ); $modules->update_module_data($poster); $minicalendar = array( 'module_basename' => 'portal', 'module_enabled' => 1, 'module_display' => 1, 'parent_id' => $portal['module_id'], 'module_class' => 'acp', 'module_langname' => 'ACP_PORTAL_MINICALENDAR_INFO', 'module_mode' => 'minicalendar', 'module_auth' => '' ); $modules->update_module_data($minicalendar); $customblock = array( 'module_basename' => 'portal', 'module_enabled' => 1, 'module_display' => 1, 'parent_id' => $portal['module_id'], 'module_class' => 'acp', 'module_langname' => 'ACP_PORTAL_CUSTOM_INFO', 'module_mode' => 'customblock', 'module_auth' => '' ); $modules->update_module_data($customblock); $linkblock = array( 'module_basename' => 'portal', 'module_enabled' => 1, 'module_display' => 1, 'parent_id' => $portal['module_id'], 'module_class' => 'acp', 'module_langname' => 'ACP_PORTAL_LINKS_INFO', 'module_mode' => 'links', 'module_auth' => '' ); $modules->update_module_data($linkblock); // clear cache and log what we did $cache->purge(); add_log('admin', $page_title . ' installed'); $installed = true; } include($phpbb_root_path . 'install_portal/style/layout_install.'.$phpEx); } else { include($phpbb_root_path . 'install_portal/style/layout_menu.'.$phpEx); } break; // Updating case 'update': if( $check_mode == 'update' ) { $confirm = request_var('confirm', ''); if( $confirm == 1 ) { if( $phpbb3portal === TRUE ) { // Drop thes tables if existing switch( $db->sql_layer ) { case 'mysql4': case 'mysqli': case 'oracle': case 'firebird': case 'sqlite': case 'mysql': $sql = 'DROP TABLE IF EXISTS ' . $table_prefix . 'portal_config'; $result = $db->sql_query($sql); $db->sql_freeresult($result); break; case '': $sql = 'SELECT version() as version'; $result = $db->sql_query($sql); $data = $db->sql_fetchrow($result); if( version_compare($data['version'], '8.1.11', '>') === TRUE ) { $sql = 'DROP TABLE IF EXISTS ' . $table_prefix . 'portal_config'; $result = $db->sql_query($sql); $db->sql_freeresult($result); } else { $sql = 'DROP TABLE ' . $table_prefix . 'portal_config'; $result = @$db->sql_query($sql); $db->sql_freeresult($result); } break; case 'mssql': $sql = 'if exists (select * from sysobjects where name = ' . $table_prefix . 'portal_config) drop table ' . $table_prefix . 'portal_config'; $result = $db->sql_query($sql); $db->sql_freeresult($result); break; } // locate the schema files $dbms_schema = 'schemas/_' . $db_schema . '_schema.sql'; $sql_query = @file_get_contents($dbms_schema); $sql_query = preg_replace('#phpbb_#i', $table_prefix, $sql_query); $comments($sql_query); $sql_query = split_sql_file($sql_query, $delimiter); // Make tables foreach ($sql_query as $sql) { if (!$db->sql_query($sql)) { $error = $db->sql_error(); db_error($error['message'], $sql, __LINE__, __FILE__); } } unset($sql_query); // Start by inserting default data $sql_query = @file_get_contents('schemas/_schema_data.sql'); switch ($db->sql_layer) { case 'mssql': case 'mssql_odbc': $sql_query = preg_replace('#\# MSSQL IDENTITY (phpbb_[a-z_]+) (ON|OFF) \##s', 'SET IDENTITY_INSERT \1 \2;', $sql_query); break; case 'postgres': $sql_query = preg_replace('#\# POSTGRES (BEGIN|COMMIT) \##s', '\1; ', $sql_query); break; } $sql_query = preg_replace('#phpbb_#i', $table_prefix, $sql_query); $sql_query = preg_replace('/\n{2,}/', "\n", preg_replace('/^#.*$/m', "\n", $sql_query)); $sql_query = split_sql_file($sql_query, ';'); $sql_query[] = "INSERT INTO {$table_prefix}portal_config (config_name, config_value) VALUES ('portal_version', '{$current_version}')"; foreach ($sql_query as $sql) { if (!$db->sql_query($sql)) { $error = $db->sql_error(); db_error($error['message'], $sql, __LINE__, __FILE__); } } unset($sql_query); // Set old settings. $sql = 'SELECT * FROM ' . PORTAL_CONFIG_TABLE; $result = $db->sql_query($sql); while ($row = $db->sql_fetchrow($result)) { if (isset($config[$row['config_name']])) { $sql2 = 'UPDATE ' . PORTAL_CONFIG_TABLE . " SET config_value = '" . $config[$row['config_name']] . "' WHERE config_name = '" . $row['config_name'] . "' LIMIT 1"; $db->sql_query($sql2); $sql3 = 'DELETE FROM ' . CONFIG_TABLE . " WHERE config_name = '" . $row['config_name'] . "' LIMIT 1"; $db->sql_query($sql3); } } $db->sql_freeresult($result); $sql = 'UPDATE ' . PORTAL_CONFIG_TABLE . " SET config_value = '{$current_version}' where config_name = 'portal_version'"; $db->sql_query($sql); // Delete old portal stuff $sql = "ALTER TABLE {$table_prefix}config CHANGE config_value config_value varchar(255) NOT NULL"; $db->sql_query($sql); $sql = 'SELECT right_id, module_id FROM ' . MODULES_TABLE . " WHERE module_langname = 'ACP_PORTAL_GENERAL_INFO' OR module_langname = 'ACP_PORTAL_NEWS_INFO' OR module_langname = 'ACP_PORTAL_ANNOUNCE_INFO' OR module_langname = 'ACP_PORTAL_WELCOME_INFO' OR module_langname = 'ACP_PORTAL_RECENT_INFO' OR module_langname = 'ACP_PORTAL_WORDGRAPH_INFO' OR module_langname = 'ACP_PORTAL_PAYPAL_INFO' OR module_langname = 'ACP_PORTAL_ADS_INFO' OR module_langname = 'ACP_PORTAL_ATTACHMENTS_NUMBER_INFO' OR module_langname = 'ACP_PORTAL_MEMBERS_INFO' OR module_langname = 'ACP_PORTAL_POLLS_INFO' OR module_langname = 'ACP_PORTAL_BOTS_INFO' OR module_langname = 'ACP_PORTAL_MOST_POSTER_INFO' OR module_langname = 'ACP_PORTAL_MINICALENDAR_INFO' OR module_langname = 'ACP_PORTAL_CUSTOM_INFO' OR module_langname = 'ACP_PORTAL_LINKS_INFO'"; $result = $db->sql_query($sql); while ($row = $db->sql_fetchrow($result)) { $sql = 'DELETE FROM ' . MODULES_TABLE . " WHERE module_id = '{$row['module_id']}'"; $db->sql_query($sql); $sql = 'UPDATE ' . MODULES_TABLE . " SET left_id = left_id - 2 WHERE module_class = 'acp' AND left_id > {$row['right_id']}"; $db->sql_query($sql); $sql = 'UPDATE ' . MODULES_TABLE . " SET right_id = right_id - 2 WHERE module_class = 'acp' AND right_id > {$row['right_id']}"; $db->sql_query($sql); } $db->sql_freeresult($result); $sql = 'SELECT right_id, module_id FROM ' . MODULES_TABLE . " WHERE module_langname = 'ACP_PORTAL_INFO'"; $result = $db->sql_query($sql); while ($row = $db->sql_fetchrow($result)) { $sql = 'DELETE FROM ' . MODULES_TABLE . " WHERE module_id = '{$row['module_id']}'"; $db->sql_query($sql); $sql = 'UPDATE ' . MODULES_TABLE . " SET left_id = left_id - 2 WHERE module_class = 'acp' AND left_id > {$row['right_id']}"; $db->sql_query($sql); $sql = 'UPDATE ' . MODULES_TABLE . " SET right_id = right_id - 2 WHERE module_class = 'acp' AND right_id > {$row['right_id']}"; $db->sql_query($sql); } $db->sql_freeresult($result); // create the acp modules $modules = new acp_modules(); $portal = array( 'module_basename' => '', 'module_enabled' => 1, 'module_display' => 1, 'parent_id' => 31, 'module_class' => 'acp', 'module_langname' => 'ACP_PORTAL_INFO', 'module_mode' => '', 'module_auth' => '' ); $modules->update_module_data($portal); $general = array( 'module_basename' => 'portal', 'module_enabled' => 1, 'module_display' => 1, 'parent_id' => $portal['module_id'], 'module_class' => 'acp', 'module_langname' => 'ACP_PORTAL_GENERAL_INFO', 'module_mode' => 'general', 'module_auth' => '' ); $modules->update_module_data($general); $news = array( 'module_basename' => 'portal', 'module_enabled' => 1, 'module_display' => 1, 'parent_id' => $portal['module_id'], 'module_class' => 'acp', 'module_langname' => 'ACP_PORTAL_NEWS_INFO', 'module_mode' => 'news', 'module_auth' => '' ); $modules->update_module_data($news); $announcements = array( 'module_basename' => 'portal', 'module_enabled' => 1, 'module_display' => 1, 'parent_id' => $portal['module_id'], 'module_class' => 'acp', 'module_langname' => 'ACP_PORTAL_ANNOUNCE_INFO', 'module_mode' => 'announcements', 'module_auth' => '' ); $modules->update_module_data($announcements); $welcome = array( 'module_basename' => 'portal', 'module_enabled' => 1, 'module_display' => 1, 'parent_id' => $portal['module_id'], 'module_class' => 'acp', 'module_langname' => 'ACP_PORTAL_WELCOME_INFO', 'module_mode' => 'welcome', 'module_auth' => '' ); $modules->update_module_data($welcome); $recent = array( 'module_basename' => 'portal', 'module_enabled' => 1, 'module_display' => 1, 'parent_id' => $portal['module_id'], 'module_class' => 'acp', 'module_langname' => 'ACP_PORTAL_RECENT_INFO', 'module_mode' => 'recent', 'module_auth' => '' ); $modules->update_module_data($recent); $wordgraph = array( 'module_basename' => 'portal', 'module_enabled' => 1, 'module_display' => 1, 'parent_id' => $portal['module_id'], 'module_class' => 'acp', 'module_langname' => 'ACP_PORTAL_WORDGRAPH_INFO', 'module_mode' => 'wordgraph', 'module_auth' => '' ); $modules->update_module_data($wordgraph); $paypal = array( 'module_basename' => 'portal', 'module_enabled' => 1, 'module_display' => 1, 'parent_id' => $portal['module_id'], 'module_class' => 'acp', 'module_langname' => 'ACP_PORTAL_PAYPAL_INFO', 'module_mode' => 'paypal', 'module_auth' => '' ); $modules->update_module_data($paypal); $attachments = array( 'module_basename' => 'portal', 'module_enabled' => 1, 'module_display' => 1, 'parent_id' => $portal['module_id'], 'module_class' => 'acp', 'module_langname' => 'ACP_PORTAL_ATTACHMENTS_NUMBER_INFO', 'module_mode' => 'attachments', 'module_auth' => '' ); $modules->update_module_data($attachments); $members = array( 'module_basename' => 'portal', 'module_enabled' => 1, 'module_display' => 1, 'parent_id' => $portal['module_id'], 'module_class' => 'acp', 'module_langname' => 'ACP_PORTAL_MEMBERS_INFO', 'module_mode' => 'members', 'module_auth' => '' ); $modules->update_module_data($members); $polls = array( 'module_basename' => 'portal', 'module_enabled' => 1, 'module_display' => 1, 'parent_id' => $portal['module_id'], 'module_class' => 'acp', 'module_langname' => 'ACP_PORTAL_POLLS_INFO', 'module_mode' => 'polls', 'module_auth' => '' ); $modules->update_module_data($polls); $bots = array( 'module_basename' => 'portal', 'module_enabled' => 1, 'module_display' => 1, 'parent_id' => $portal['module_id'], 'module_class' => 'acp', 'module_langname' => 'ACP_PORTAL_BOTS_INFO', 'module_mode' => 'bots', 'module_auth' => '' ); $modules->update_module_data($bots); $poster = array( 'module_basename' => 'portal', 'module_enabled' => 1, 'module_display' => 1, 'parent_id' => $portal['module_id'], 'module_class' => 'acp', 'module_langname' => 'ACP_PORTAL_MOST_POSTER_INFO', 'module_mode' => 'poster', 'module_auth' => '' ); $modules->update_module_data($poster); $minicalendar = array( 'module_basename' => 'portal', 'module_enabled' => 1, 'module_display' => 1, 'parent_id' => $portal['module_id'], 'module_class' => 'acp', 'module_langname' => 'ACP_PORTAL_MINICALENDAR_INFO', 'module_mode' => 'minicalendar', 'module_auth' => '' ); $modules->update_module_data($minicalendar); $customblock = array( 'module_basename' => 'portal', 'module_enabled' => 1, 'module_display' => 1, 'parent_id' => $portal['module_id'], 'module_class' => 'acp', 'module_langname' => 'ACP_PORTAL_CUSTOM_INFO', 'module_mode' => 'customblock', 'module_auth' => '' ); $modules->update_module_data($customblock); $linkblock = array( 'module_basename' => 'portal', 'module_enabled' => 1, 'module_display' => 1, 'parent_id' => $portal['module_id'], 'module_class' => 'acp', 'module_langname' => 'ACP_PORTAL_LINKS_INFO', 'module_mode' => 'links', 'module_auth' => '' ); $modules->update_module_data($linkblock); // clear cache and log what we did $cache->purge(); add_log('admin', $page_title . ' updated'); $updated = true; } else { $portal_update_array = array(); include 'schemas/update_schema.php'; foreach( $sql_update as $sql_ver => $sql_data ) { if( version_compare($old_version, $sql_ver, ">=") === TRUE ) { continue; } else { $portal_update_array = array_merge($portal_update_array, $sql_data); } } $portal_update_array[] = 'UPDATE ' . PORTAL_CONFIG_TABLE . " SET config_value='{$current_version}' WHERE config_name = 'portal_version'"; foreach($portal_update_array as $sql) { $sql = preg_replace('#phpbb_#i', $table_prefix, $sql); if (!$db->sql_query($sql)) { $error = $db->sql_error(); db_error($error['message'], $sql, __LINE__, __FILE__); } } unset($portal_update_array, $sql_update); // create new acp modules $modules = new acp_modules(); $sql = 'SELECT module_id FROM ' . MODULES_TABLE . " WHERE module_langname = 'ACP_PORTAL_INFO' LIMIT 1"; $result = $db->sql_query($sql); $portal = $db->sql_fetchrow($result); foreach( $mod_update as $mod_ver => $mod_data ) { if( version_compare($old_version, $mod_ver, ">=") === TRUE ) { continue; } else { foreach( $mod_data as $mod_config) { $mod_config['parent_id'] = $portal['module_id']; $modules->update_module_data($mod_config); } } } $updated = true; } } include($phpbb_root_path . 'install_portal/style/layout_update.'.$phpEx); } else { include($phpbb_root_path . 'install_portal/style/layout_menu.'.$phpEx); } break; // Uninstalling case 'uninstall': if( $old_version != 0 ) { if( $confirm == 1) { if( $phpbb3portal === FALSE ) { // Drop thes tables if existing switch( $db->sql_layer ) { case 'mysql4': case 'mysqli': case 'oracle': case 'firebird': case 'sqlite': case 'mysql': $sql = 'DROP TABLE IF EXISTS ' . $table_prefix . 'portal_config'; $result = $db->sql_query($sql); $db->sql_freeresult($result); break; case '': $sql = 'SELECT version() as version'; $result = $db->sql_query($sql); $data = $db->sql_fetchrow($result); if( version_compare($data['version'], '8.1.11', '>') === TRUE ) { $sql = 'DROP TABLE IF EXISTS ' . $table_prefix . 'portal_config'; $result = $db->sql_query($sql); $db->sql_freeresult($result); } else { $sql = 'DROP TABLE ' . $table_prefix . 'portal_config'; $result = @$db->sql_query($sql); $db->sql_freeresult($result); } break; case 'mssql': $sql = 'if exists (select * from sysobjects where name = ' . $table_prefix . 'portal_config) drop table ' . $table_prefix . 'portal_config'; $result = $db->sql_query($sql); $db->sql_freeresult($result); break; } $sql = 'SELECT right_id, module_id FROM ' . MODULES_TABLE . " WHERE module_langname = 'ACP_PORTAL_GENERAL_INFO' OR module_langname = 'ACP_PORTAL_NEWS_INFO' OR module_langname = 'ACP_PORTAL_ANNOUNCE_INFO' OR module_langname = 'ACP_PORTAL_WELCOME_INFO' OR module_langname = 'ACP_PORTAL_RECENT_INFO' OR module_langname = 'ACP_PORTAL_WORDGRAPH_INFO' OR module_langname = 'ACP_PORTAL_PAYPAL_INFO' OR module_langname = 'ACP_PORTAL_ADS_INFO' OR module_langname = 'ACP_PORTAL_ATTACHMENTS_NUMBER_INFO' OR module_langname = 'ACP_PORTAL_MEMBERS_INFO' OR module_langname = 'ACP_PORTAL_POLLS_INFO' OR module_langname = 'ACP_PORTAL_BOTS_INFO' OR module_langname = 'ACP_PORTAL_MOST_POSTER_INFO' OR module_langname = 'ACP_PORTAL_MINICALENDAR_INFO' OR module_langname = 'ACP_PORTAL_CUSTOM_INFO' OR module_langname = 'ACP_PORTAL_LINKS_INFO' "; $result = $db->sql_query($sql); while ($row = $db->sql_fetchrow($result)) { $sql = 'DELETE FROM ' . MODULES_TABLE . " WHERE module_id = '{$row['module_id']}'"; $db->sql_query($sql); $sql = 'UPDATE ' . MODULES_TABLE . " SET left_id = left_id - 2 WHERE module_class = 'acp' AND left_id > {$row['right_id']}"; $db->sql_query($sql); $sql = 'UPDATE ' . MODULES_TABLE . " SET right_id = right_id - 2 WHERE module_class = 'acp' AND right_id > {$row['right_id']}"; $db->sql_query($sql); } $db->sql_freeresult($result); $sql = 'SELECT right_id, module_id FROM ' . MODULES_TABLE . " WHERE module_langname = 'ACP_PORTAL_INFO'"; $result = $db->sql_query($sql); while ($row = $db->sql_fetchrow($result)) { $sql = 'DELETE FROM ' . MODULES_TABLE . " WHERE module_id = '{$row['module_id']}'"; $db->sql_query($sql); $sql = 'UPDATE ' . MODULES_TABLE . " SET left_id = left_id - 2 WHERE module_class = 'acp' AND left_id > {$row['right_id']}"; $db->sql_query($sql); $sql = 'UPDATE ' . MODULES_TABLE . " SET right_id = right_id - 2 WHERE module_class = 'acp' AND right_id > {$row['right_id']}"; $db->sql_query($sql); } $db->sql_freeresult($result); $installed = true; } else { include($phpbb_root_path . 'install_portal/style/layout_header.'.$phpEx); echo '
' . $user->lang['INSTALLER_ERROR'] . '
'; echo '

' . $user->lang['INSTALLER_UNINSTALL_OLDVERSION'] . '
'; include($phpbb_root_path . 'install_portal/style/layout_footer.'.$phpEx); } } include($phpbb_root_path . 'install_portal/style/layout_uninstall.'.$phpEx); } else { include($phpbb_root_path . 'install_portal/style/layout_menu.'.$phpEx); } break; // Welcome page! default: include($phpbb_root_path . 'install_portal/style/layout_menu.'.$phpEx); break; } } else { include($phpbb_root_path . 'install_portal/style/layout_header.'.$phpEx); echo '
' . $user->lang['INSTALLER_ERROR'] . '
'; echo '

' . $user->lang['INSTALLER_NEEDS_ADMIN'] . '
'; include($phpbb_root_path . 'install_portal/style/layout_footer.'.$phpEx); } ?>
What went wrong, and what needs to be done to get this working?.

Re: Install help, subsilver2...

Posted: 16. July 2008 12:26
by Kevin
Modified anything on the installer?
Uploaded the files via FTP in the correct modus?

Re: Install help, subsilver2...

Posted: 16. July 2008 12:57
by Sharky
Kevin wrote:Modified anything on the installer?
Nope.
Uploaded the files via FTP in the correct modus?
I assume so, does it matter if you run the installer before or after the edited files have been uploaded?.

Re: Install help, subsilver2...

Posted: 17. July 2008 16:36
by clyde4210
well to see it properly you would need to have the edited files already loaded prior to installing. exspecially the ss2 files if that's the style you're using.

Re: Install help, subsilver2...

Posted: 18. July 2008 02:09
by Bible Poet
Don't know if you got a answer to your second question. but you place this line
DirectoryIndex portal.php index.php index.html index.htm

under this code in .htaccess
AuthGroupFile /home/********/public_html/_vti_pvt/service.grp

I have front Page on my site and that is where I put it and it works fine.
But be aware that front Page is funny and most of my problems that I had in the past was fp fault.

If that dose not work put it above this
AuthName *****************

also the root folder is \http://www.what ever.com
not \http://www.what ever.com/forum
.
Hope that this answers your no2 question.

Re: Install help, subsilver2...

Posted: 18. July 2008 04:51
by Sharky
Done everything suggested, but still no go.

Looking at the bottom of the error code, I feel like it wants to uninstall the bad original install before proceeding. I read the only way to uninstall it is by running the installer though... :?

Code: Select all

' . $user->lang['INSTALLER_UNINSTALL_OLDVERSION'] . '
'; include($phpbb_root_path . 'install_portal/style/layout_footer.'.$phpEx); } } include($phpbb_root_path . 'install_portal/style/layout_uninstall.'.$phpEx); } else { include($phpbb_root_path . 'install_portal/style/layout_menu.'.$phpEx); } break; // Welcome page! default: include($phpbb_root_path . 'install_portal/style/layout_menu.'.$phpEx); break; } } else { include($phpbb_root_path . 'install_portal/style/layout_header.'.$phpEx); echo '
' . $user->lang['INSTALLER_ERROR'] . '
'; echo '

' . $user->lang['INSTALLER_NEEDS_ADMIN'] . '
'; include($phpbb_root_path . 'install_portal/style/layout_footer.'.$phpEx); } ?>
If I try and go to www.mywebsite.com/portal.php I get this message;

General Error
SQL ERROR [ mysql4 ]

Table '*********_forum.phpbb_portal_config' doesn't exist [1146]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.

Please notify the board administrator or webmaster: admin@***************.com
When I go to mySQL DataBases in cPanel, there is obviously no DB for the above mentioned.

Any other suggestions? Really would like to get this going, but it's a pain at the moment...

Thanks.

Re: Install help, subsilver2...

Posted: 18. July 2008 06:10
by Sharky
Okay, so I got the install working. I'm a n00b, I was running the install.php file from the ftp client, not from my web browser! :oops: Thanks to those that offered their time in trying to help... No doubt I'll be back with more questions when setting things up.

Sharky.

Re: Install help, subsilver2...

Posted: 18. July 2008 11:41
by Sharky
Nevermind...