Newbie Install Problems

Codewalkers Forums Sponsor:

June 28th, 2004, 09:08 PM

Anonymous

Registered User

Codewalkers God 35th Plane (22000 - 22499 posts)

Join Date: Apr 2007

Posts: 22,309

Time spent in forums: < 1 sec
Reputation Power: 24

Newbie Install Problems

Got a Problem while installing the ltw_calendar available from this site:

____
ltwCalendar Installer (v4.0)
Error: Connection to MySQL server localhost failed.
Error: Connection to MySQL server localhost failed.
Error: Connection to MySQL server localhost failed.
Getting a list of tables from the database.

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/newschaefers/www/www/private/ltw_classes.php on line 624
Error: A problem was encountered while executing this query.
$query

--------------------------------------------------------------------------------
show tables
Error: Fatal db Error.

___
Now i am new to php but i don't get it here is the lines it has trouble with:

php Code:

Original - php Code
function db_query($query = ''){ switch( $this->db_type ){ case 1: //mySql $result = mysql_query($query, $this->dbh); if ( !$result ){ echo " Error: A problem was encountered while executing this query.<br> $query<BR><HR>$query<br> "; die ("Error: Fatal db Error.<br>n"); } break; }// end switch return $result; }// end function.db_query()

 
function db_query($query = ''){
    switch( $this->db_type ){
    case 1: //mySql
        $result = mysql_query($query, $this->dbh);
        if ( !$result ){
            echo "
            Error: A problem was encountered while executing this query.<br>
              $query<BR><HR>$query<br>
            ";
              die ("Error: Fatal db Error.<br>n");
            }
        break;
    }// end switch  
    return $result;
}// end function.db_query()

The first line i posted was 621 so maybe you guys understand.

June 29th, 2004, 08:25 PM

Anonymous

Registered User

Join Date: Apr 2007

Posts: 22,309

Time spent in forums: < 1 sec
Reputation Power: 24

RE: Newbie Install Problems

Mibble, Thanks for the reply however i do not see where these variables are defined,

Here is the first section of code wher this information should be contained:

php Code:

Original - php Code

<?php
//////////////////////////////////////////////////////////////////////////// 
// ltw_config.php 
// $Id: ltw_install.php,v 1.11 2003/08/16 13:09:25 t51admin Exp $ 
// 
// ltwCalendar Installer 
////////////////////////////////////////////////////////////////////////////
// needed files
require_once('./private/ltw_config.php');	
require_once($ltw_config['include_dir'].'/ltw_classes.php');

//the following lines are added for backwards compatibility for pre 4.1.0 PHP versions.. 
if ( !isset($_POST) 	) $_POST = $HTTP_POST_VARS;
if ( !isset($_REQUEST)) $_REQUEST = $HTTP_GET_VARS;
//end backward compatibility
 
// page header
echo "
<html>
<head><title>ltwCalendar (4.0) Installer</title></head>
<body>
ltwCalendar Installer (v4.0) 
 ";

// if no command passed, welcome
if ( empty($_REQUEST['command']) ){
	echo "
	This script will install a new ltwCalendar database if one is not defined, 
	or upgrade an existing V2.x or 3.x database to work with version 4.0. 
	Before running this process 
	It is highly recommended you back up your existing database structure and contents. 
	The script will alter existing tables to add columns needed for v4.0 to work properly. 
	<A href="".$_SERVER['PHP_SELF']."?command=install">Click to continue</A>
	";
	return;
}

// check for needed config parameters
$errors = '';
if ( empty($ltw_config['db_type']) ) $errors .= "Missing 'db_type' parameter in ltw_config.php ";
if ( empty($ltw_config['db_server']) ) $errors .= "Missing 'db_server' parameter in ltw_config.php ";
if ( empty($ltw_config['db_user']) ) $errors .= "Missing 'db_user' parameter in ltw_config.php ";
if ( empty($ltw_config['db_pass']) ) $errors .= "Missing 'db_pass' parameter in ltw_config.php ";
if ( empty($ltw_config['db_name']) ) $errors .= "Missing 'db_name' parameter in ltw_config.php ";
if ( empty($ltw_config['db_server']) ) $errors .= "Missing 'db_server' parameter in ltw_config.php ";

if ( empty($ltw_config['db_table_users']) ) $errors .= "Missing 'db_table_users' parameter in ltw_config.php ";
if ( empty($ltw_config['db_table_calendar'])) $errors .= "Missing 'db_table_calendar' parameter in ltw_config.php ";
if ( empty($ltw_config['db_table_category'])) $errors .= "Missing 'db_table_category' parameter in ltw_config.php ";
if ( empty($ltw_config['db_table_log']) ) $errors .= "Missing 'db_table_log' parameter in ltw_config.php ";
if ( !empty($errors) ) die($errors);

// I need my objects now
$db   = new ltwDb;
$auth = new ltwAuth;
$user = new ltwUser;

$showForm = 0;
$errors   = '';
$rstr     = '';

// If Submit was pressed, then we are going to
// create the user account in the db
if ( $_REQUEST['command'] == 'user' ){
	if ( empty($_POST['Submit']) ){
		$showForm = 1;
	}else{
		if ( empty($_POST['uname'])	){
			$errors .= "Missing username ";
		}else{
			if ( $user->findByName($_POST['uname']) ){
				$errors = "Username ".$_POST['uname']." already exists. ";
			}else{
				$rstr = $auth->isPasswordValid($_POST['uname'],'',$_POST['pword'], $_POST['pwa']);
				if ( !empty($rstr) ) $errors .= $rstr;
			}

// show the form if any errors!
			if ( !empty($errors) ){
				$showForm = 1;
			}else{
			 	$user->username  	= $_POST['uname']; 
				$user->password  	= crypt($_POST['pword'],$ltw_config['salt']);
				$user->email 	 	= $_POST['email'];
				$user->status    	= 0;
				$user->privledges	= UPADMIN;
				$user->bad_logins	= 0;
				$user->last_pw_change	= date("Y-m-d H:I:s");
				$user->create();

 
<?php
//////////////////////////////////////////////////////////////////////////// 
// ltw_config.php 
// $Id: ltw_install.php,v 1.11 2003/08/16 13:09:25 t51admin Exp $ 
// 
// ltwCalendar Installer 
////////////////////////////////////////////////////////////////////////////
// needed files
require_once('./private/ltw_config.php');   
require_once($ltw_config['include_dir'].'/ltw_classes.php');
 
//the following lines are added for backwards compatibility for pre 4.1.0 PHP versions.. 
if ( !isset($_POST)     ) $_POST = $HTTP_POST_VARS;
if ( !isset($_REQUEST)) $_REQUEST = $HTTP_GET_VARS;
//end backward compatibility
 
// page header
echo "
<html>
<head><title>ltwCalendar (4.0) Installer</title></head>
<body>
<b>ltwCalendar Installer (v4.0)</b><br>
 ";
 
// if no command passed, welcome
if ( empty($_REQUEST['command']) ){
    echo "
    This script will install a new ltwCalendar database if one is not defined,<br> 
    or upgrade an existing V2.x or 3.x database to work with version 4.0.<br><br>
    <b>Before running this process</b><br>
    It is <b><i>highly recommended</b></i> you back up your existing database structure and contents.<br>
    The script will alter existing tables to add columns needed for v4.0 to work properly.<br><br>
    <A href="".$_SERVER['PHP_SELF']."?command=install">Click to continue</A>
    ";
    return;
}
 
// check for needed config parameters
$errors = '';
if ( empty($ltw_config['db_type'])   ) $errors .= "Missing 'db_type' parameter in ltw_config.php<br>";
if ( empty($ltw_config['db_server']) ) $errors .= "Missing 'db_server' parameter in ltw_config.php<br>";
if ( empty($ltw_config['db_user'])   ) $errors .= "Missing 'db_user' parameter in ltw_config.php<br>";
if ( empty($ltw_config['db_pass'])   ) $errors .= "Missing 'db_pass' parameter in ltw_config.php<br>";
if ( empty($ltw_config['db_name'])   ) $errors .= "Missing 'db_name' parameter in ltw_config.php<br>";
if ( empty($ltw_config['db_server']) ) $errors .= "Missing 'db_server' parameter in ltw_config.php<br>";
 
if ( empty($ltw_config['db_table_users'])   ) $errors .= "Missing 'db_table_users' parameter in ltw_config.php<br>";
if ( empty($ltw_config['db_table_calendar'])) $errors .= "Missing 'db_table_calendar' parameter in ltw_config.php<br>";
if ( empty($ltw_config['db_table_category'])) $errors .= "Missing 'db_table_category' parameter in ltw_config.php<br>";
if ( empty($ltw_config['db_table_log'])     ) $errors .= "Missing 'db_table_log' parameter in ltw_config.php<br>";
if ( !empty($errors) ) die($errors);
 
// I need my objects now
$db   = new ltwDb;
$auth = new ltwAuth;
$user = new ltwUser;
 
$showForm = 0;
$errors   = '';
$rstr     = '';
 
// If Submit was pressed, then we are going to
// create the user account in the db
if ( $_REQUEST['command'] == 'user' ){
    if ( empty($_POST['Submit']) ){
        $showForm = 1;
    }else{
        if (  empty($_POST['uname'])    ){
            $errors .= "Missing username<br>";
        }else{
            if ( $user->findByName($_POST['uname']) ){
                $errors = "Username <b>".$_POST['uname']."</b> already exists.<br>";
            }else{
                $rstr = $auth->isPasswordValid($_POST['uname'],'',$_POST['pword'], $_POST['pwa']);
                if ( !empty($rstr) ) $errors .= $rstr;
            }
 
            // show the form if any errors!
            if ( !empty($errors) ){
                $showForm = 1;
            }else{
                $user->username    = $_POST['uname']; 
                $user->password     = crypt($_POST['pword'],$ltw_config['salt']);
                $user->email       = $_POST['email'];
                $user->status       = 0;
                $user->privledges   = UPADMIN;
                $user->bad_logins   = 0;
                $user->last_pw_change   = date("Y-m-d H:I:s");
                $user->create();

Thank you very much for your help I am used to using flash and scripting everything with vb, but the customer wanted the calender he saw on another site.

June 30th, 2004, 01:23 AM

System

Join Date: Apr 2007

Posts: 665

Time spent in forums: < 1 sec
Reputation Power: 2

Message Moved

Thread moved from 'PHP Coding' to 'ltwCalendar' by sliver.

Reason: ltw Calendar question

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: