thanks for the info! I was able to upgrade with no problems.

I currently have XOOPS 2.0.18.1 installed and would like to upgrade to the latest, 2.3.3

Where can I find all the upgrade patches I need? I've looked in the downloads sections but can't seem to find all the necessary patches.

Never mind, it was a file permission issue. I just noticed that it was not letting me update the file with the changes on my remote server. All is good :)

ok, I am having issues installing Protector 3.2 and defining my trusted path

here is a snippet from my mainfile.php

// XOOPS Physical Path // Physical path to your main XOOPS directory WITHOUT trailing slash // Example: define('XOOPS_ROOT_PATH', '/XXX/XXX/XXX/XXX/family');
define('XOOPS_ROOT_PATH', '/XXX/XXX/XXX/XXX/family');
define('XOOPS_TRUST_PATH', '/XXX/XXX/XXX/XXX/family/xoops_trust_path');

I know it is listed in the same directory as my Xoops_Root, but I want to get it to work first, and then I will move and rename it

Each time I go to install the module, I see this: set XOOPS_TRUST_PATH into mainfile.php
on the module Admin screen and the module is not listed to install.

I have uploaded both folders to the appropriate directories, but can't seem to get the trusted path to be recognized or working. I have also edited the mainfile.php for the pre & post check.

My XOOPS version is 2.0 (will uprade once I get my modules installed) or should I be upgrading the core first?

Thanks for any help!

Quote:
Yes

Quote:

That's just it, in the XOOPS 2.3.3 install, I do not get the option of telling it which database to use. All I get is MySQL for an option in the dropdown. I can input the hostname, username and password, but I never get the option for the database.

At this point, I may just go the upgrade route since this is working, but I'll keep at it so this issue can get resolved for all who experience it.

OK, here's a little more information.

I successfully installed XOOPS 2.0.18.1 with zero issues; it connected to my database just fine. One thing I noticed in this install is that it asked me for the database name, whereas the XOOPS 2.3.3 installer did not (mysql was the only option).

Hopefully this helps

yes persistent connections was unchecked. I also tried substituting that new snippet of code and it did not work :(

OK, I am at a loss. I understand what you are saying, but do not understand exactly where to make those changes. The mainfile.php is blank at the moment, since I am still trying to install.

In the db_connection step of the install process, everytime I enter the data into the provided fields, It get the Cannot Connect to the Database error. I've tried to edit the file, but don't have a good enough grasp of the programming language to really understand where I need to make the changes.

I tried inputting the data into this area:

if ( @empty( $vars['DB_HOST'] ) ) {
// Fill with default values
$vars = array_merge( $vars,
array('DB_TYPE' => 'mysql',
'DB_HOST' => 'MYSQLSERVER',
'DB_USER' => 'USERNAME',
'DB_PASS' => 'PASSWORD',
'DB_PCONNECT' => 0,

but that didn't work and those, to me, just tell me what the default values are. Either way I still got the error.

please forgive my stupidity, I really want to learn

OK I just got a response from one of my provider's higher level technicians.

Here is what he said to me (I changed my DB name, username, etc.):

Quote:

This is what dbtest.php contains:

<?php
mysql_connect("MY SQL SERVER", "USERNAME", "PASSWORD") or die(mysql_error());
echo "Connected to MySQL<br />";
mysql_select_db("family") or die(mysql_error());
echo "Connected to Database";
?>

He is telling me I need to take that code, or that info and manually change the page_dbconnection.php file. I did test his dbtest.php and it worked: I was able to connect to my database. But being a noob, I can't figure out where to insert it, or change the page_dbconnection.php file.

Any help would be immensely appreciated!

This is the page_dbconnection.php file contents. Where would I insert that info???

<?php
/*
You may not change or alter any portion of this comment or credits
of supporting developers from this source code or any supporting source code
which is considered copyrighted (c) material of the original comment or credit authors.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
*/
/**
* Installer database configuration page
*
* See the enclosed file license.txt for licensing information.
* If you did not receive this file, get it athttp://www.fsf.org/copyleft/gpl.html
*
* @copyright The XOOPS projecthttps://xoops.org/
* @licensehttp://www.fsf.org/copyleft/gpl.html GNU General Public License (GPL)
* @package installer
* @since 2.3.0
* @author Haruki Setoyama <haruki@planewave.org>
* @author Kazumi Ono <webmaster@myweb.ne.jp>
* @author Skalpa Keo <skalpa@xoops.org>
* @author Taiwen Jiang <phppp@users.sourceforge.net>
* @author DuGris (aka L. JEN) <dugris@frxoops.org>
* @version $Id: page_dbconnection.php 2822 2009-02-20 08:50:48Z phppp $
**/

require_once './include/common.inc.php';
if ( !defined('XOOPS_INSTALL') ) { die('XOOPS Installation wizard die'); }

$pageHasForm = true;
$pageHasHelp = true;

$vars =& $_SESSION['settings'];

if ( $_SERVER['REQUEST_METHOD'] == 'POST' ) {
$params = array( 'DB_TYPE', 'DB_HOST', 'DB_USER', 'DB_PASS' );
foreach ( $params as $name ) {
$vars[$name] = $_POST[$name];
}
$vars['DB_PCONNECT'] = @$_POST['DB_PCONNECT'] ? 1 : 0;
}

$error = '';
if ( $_SERVER['REQUEST_METHOD'] == 'POST' && !empty( $vars['DB_HOST'] ) && !empty( $vars['DB_USER'] ) ) {
$func_connect = empty( $vars['DB_PCONNECT'] ) ? "mysql_connect" : "mysql_pconnect";
if ( ! ( $link = @$func_connect( $vars['DB_HOST'], $vars['DB_USER'], $vars['DB_PASS'], true ) ) ) {
$error = ERR_NO_DBCONNECTION;
}
if ( empty( $error ) ) {
$wizard->redirectToPage( '+1' );
exit();
}
}

if ( @empty( $vars['DB_HOST'] ) ) {
// Fill with default values
$vars = array_merge( $vars,
array('DB_TYPE' => 'mysql',
'DB_HOST' => 'localhost',
'DB_USER' => '',
'DB_PASS' => '',
'DB_PCONNECT' => 0,
)
);
}
ob_start();
?>
<?php if ( !empty( $error ) ) echo '<div class="x2-note errorMsg">' . $error . "</div>\n"; ?>
<fieldset>
<legend><?php echo LEGEND_CONNECTION; ?></legend>
<label for="DB_DATABASE_LABEL" class="center">
<?php echo DB_DATABASE_LABEL ; ?>
<select size="1" name="DB_TYPE">
<?php
foreach ($wizard->configs['db_types'] as $db_type) {
$selected = ($vars['DB_TYPE'] == $db_type) ? 'selected' : '';
echo "<option value='$db_type' selected='$selected'>$db_type</option>";
}
?>
</select>
</label>
<?php echo xoFormField( 'DB_HOST', $vars['DB_HOST'], DB_HOST_LABEL, DB_HOST_HELP ); ?>
<?php echo xoFormField( 'DB_USER', $vars['DB_USER'], DB_USER_LABEL, DB_USER_HELP ); ?>
<?php echo xoPassField( 'DB_PASS', $vars['DB_PASS'], DB_PASS_LABEL, DB_PASS_HELP ); ?>

<label for="DB_PCONNECT" class="center">
<?php echo DB_PCONNECT_LABEL; ?>
<input class="checkbox" type="checkbox" name="DB_PCONNECT" value="1" <?php echo $vars['DB_PCONNECT'] ? "'checked'" : ""; ?>/>
<div class="xoform-help"><?php echo DB_PCONNECT_HELP; ?></div>
</label>
</fieldset>

<?php
$content = ob_get_contents();
ob_end_clean();
include './include/install_tpl.php';
?>

MySql, through FatCow webhosting

PHP Version
5.2.5

MySQL Version: 5.0.45