forum overzetten(probleem)

[thomaswes]

Ik wil graag mijn forum overzetten maar nu krijg ik de volgende fout :

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /data/members/paid/d/u/dutchp2pforum.com/htdocs/www/phpBB2/db/mysql4.php on line 330

Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /data/members/paid/d/u/dutchp2pforum.com/htdocs/www/phpBB2/db/mysql4.php on line 331
phpBB : Critical Error

Could not connect to the database

Ik heb dit bekeken in de db en deze geeft dit aan(ik heb regel 130 en 131 aangeduid met erachter een *

<?php
/***************************************************************************
* mysql4.php
* -------------------
* begin : Saturday, Feb 13, 2001
* copyright : (C) 2001 The phpBB Group
* email : supportphpbb.com
*
* $Id: mysql4.php,v 1.5 2002/04/02 21:13:47 the_systech Exp $
*
***************************************************************************/

/***************************************************************************
*
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*
***************************************************************************/

if(!defined("SQL_LAYER"))
{

define("SQL_LAYER","mysql4");

class sql_db
{

var $db_connect_id;
var $query_result;
var $row = array();
var $rowset = array();
var $num_queries = 0;
var $in_transaction = 0;

//
// Constructor
//
function sql_db($sqlserver, $sqluser, $sqlpassword, $database, $persistency = true)
{
$this->persistency = $persistency;
$this->user = $sqluser;
$this->password = $sqlpassword;
$this->server = $sqlserver;
$this->dbname = $database;

$this->db_connect_id = ($this->persistency) ? mysql_pconnect($this->server, $this->user, $this->password) : mysql_connect($this->server, $this->user, $this->password);

if( $this->db_connect_id )
{
if( $database != "" )
{
$this->dbname = $database;
$dbselect = mysql_select_db($this->dbname);

if( !$dbselect )
{
mysql_close($this->db_connect_id);
$this->db_connect_id = $dbselect;
}
}

return $this->db_connect_id;
}
else
{
return false;
}
}

//
// Other base methods
//
function sql_close()
{
if( $this->db_connect_id )
{
//
// Commit any remaining transactions
//
if( $this->in_transaction )
{
mysql_query("COMMIT", $this->db_connect_id);
}

return mysql_close($this->db_connect_id);
}
else
{
return false;
}
}

//
// Base query method
//
function sql_query($query = "", $transaction = FALSE)
{
//
// Remove any pre-existing queries
//
unset($this->query_result);

if( $query != "" )
{
$this->num_queries++;
if( $transaction == BEGIN_TRANSACTION && !$this->in_transaction )
{
$result = mysql_query("BEGIN", $this->db_connect_id);
if(!$result)
{
return false;
}
$this->in_transaction = TRUE;
}

$this->query_result = mysql_query($query, $this->db_connect_id);
}
else
{
if( $transaction == END_TRANSACTION && $this->in_transaction )
{
$result = mysql_query("COMMIT", $this->db_connect_id);
}
}

if( $this->query_result )
{
unset($this->row[$this->query_result]);
unset($this->rowset[$this->query_result]);

if( $transaction == END_TRANSACTION && $this->in_transaction )
{
$this->in_transaction = FALSE;

if ( !mysql_query("COMMIT", $this->db_connect_id) )
{
mysql_query("ROLLBACK", $this->db_connect_id);
return false;
}
}

return $this->query_result;
}
else
{
if( $this->in_transaction )
{
mysql_query("ROLLBACK", $this->db_connect_id);
$this->in_transaction = FALSE;
}
return false;
}
}

//
// Other query methods
//
function sql_numrows($query_id = 0)
{
if( !$query_id )
{
$query_id = $this->query_result;
}

return ( $query_id ) ? mysql_num_rows($query_id) : false;
}

function sql_affectedrows()
{
return ( $this->db_connect_id ) ? mysql_affected_rows($this->db_connect_id) : false;
}

function sql_numfields($query_id = 0)
{
if( !$query_id )
{
$query_id = $this->query_result;
}

return ( $query_id ) ? mysql_num_fields($query_id) : false;
}

function sql_fieldname($offset, $query_id = 0)
{
if( !$query_id )
{
$query_id = $this->query_result;
}

return ( $query_id ) ? mysql_field_name($query_id, $offset) : false;
}

function sql_fieldtype($offset, $query_id = 0)
{
if( !$query_id )
{
$query_id = $this->query_result;
}

return ( $query_id ) ? mysql_field_type($query_id, $offset) : false;
}

function sql_fetchrow($query_id = 0)
{
if( !$query_id )
{
$query_id = $this->query_result;
}

if( $query_id )
{
$this->row[$query_id] = mysql_fetch_array($query_id, MYSQL_ASSOC);
return $this->row[$query_id];
}
else
{
return false;
}
}

function sql_fetchrowset($query_id = 0)
{
if( !$query_id )
{
$query_id = $this->query_result;
}

if( $query_id )
{
unset($this->rowset[$query_id]);
unset($this->row[$query_id]);

while($this->rowset[$query_id] = mysql_fetch_array($query_id, MYSQL_ASSOC))
{
$result[] = $this->rowset[$query_id];
}

return $result;
}
else
{
return false;
}
}

function sql_fetchfield($field, $rownum = -1, $query_id = 0)
{
if( !$query_id )
{
$query_id = $this->query_result;
}

if( $query_id )
{
if( $rownum > -1 )
{
$result = mysql_result($query_id, $rownum, $field);
}
else
{
if( empty($this->row[$query_id]) && empty($this->rowset[$query_id]) )
{
if( $this->sql_fetchrow() )
{
$result = $this->row[$query_id][$field];
}
}
else
{
if( $this->rowset[$query_id] )
{
$result = $this->rowset[$query_id][$field];
}
else if( $this->row[$query_id] )
{
$result = $this->row[$query_id][$field];
}
}
}

return $result;
}
else
{
return false;
}
}

function sql_rowseek($rownum, $query_id = 0)
{
if( !$query_id )
{
$query_id = $this->query_result;
}

return ( $query_id ) ? mysql_data_seek($query_id, $rownum) : false;
}

function sql_nextid()
{
return ( $this->db_connect_id ) ? mysql_insert_id($this->db_connect_id) : false;
}

function sql_freeresult($query_id = 0)
{
if( !$query_id )
{
$query_id = $this->query_result;
}

if ( $query_id )
{
unset($this->row[$query_id]);
unset($this->rowset[$query_id]);

mysql_free_result($query_id);

return true;
}
else
{
return false;
}
}

function sql_error()
{
$result['message'] = mysql_error($this->db_connect_id); *
$result['code'] = mysql_errno($this->db_connect_id); *

return $result;
}

} // class sql_db

} // if ... define

?>

wat ik er van heb begrepen is dat je in de config.php de naam van database enzo moet veranderen,dit heb ik echter gedaan maar nu staan de oude settings er weer.

iemand enig idee

[Luuk]

Volgens mij gebruikt lycos (je zit toch op lycos paid ) mysql 3 en niet 4.
Vervang in config.php mysql4 eens naar mysql.

[thomaswes]

heb ik gedaan maar elke keer worden de instellingen in de config weer vervangen door de oude

[ElbertF]

Dat lijkt me sterk, de enige keer dat er naar dat bestand geschreven wordt is tijdens de intallatie. Misschien dat er bij de upload iets niet goed gaat?

[thomaswes]

In je .php files, gebruik je de volgende code :

<?
mysql_connect("localhost", "", "your_password");
mysql_select_db("");
?>

Deze word aangegeven idoor lycos,waar moet ik deze dan plaatsen?
TRouwens dit is em http://www.dutchp2pforum.com/phpBB2/

[Luuk]

De databaseconnectie wordt in db.php gedaan, maar daar kan het niet aan liggen.

[thomaswes]

nou uploaden is gelukt maar nu krijg ik weer een andere verassing

phpBB : Critical Error

Could not query config information

DEBUG MODE

SQL Error : 1146 Table 'dutchp2pforum_com_1.phpbb_config' doesn't exist

SELECT * FROM phpbb_config

Line : 219
File : /data/members/paid/d/u/dutchp2pforum.com/htdocs/www/phpBB2/common.php

[Luuk]

Kijk eens in je database of er wel (phpbb) tabellen in staan. Kjk ook wat de prefix is, hetgene wat in de plaats van xxx_ staat bij bijvoorbeeld de tabel "xxx_config".

[thomaswes]

nou ik heb het voor elkaar ik heb het forum erop staan maar ik ben flink wat vam, m'n posts kwijt en ook mijn members zijn weg. De postts worden wel aangegeven met cijfers maar daar weer achter staat dan weer geen posts.
Iemand enig idee hoe ik dat weer goed krijg

[thomaswes]

Nou ja dat liep dus voor geen meter maar goed ik heb het hele spul maar weer opnieuwe geinstalleerd.Is er dan wel een optie om uit de backup die ik heb gemaakt om de members er weer in te zetten?

[Luuk]

De tabel phpbb_users verwijderen en die uit de backup weer terugzetten.

[thomaswes]

hartstikke bedankt werkt perfect,nu heb ik nog een vraag kan ik ook posts vanuit mijn oude forum overzetten naar de nieuwe?En hoe doe ik dat?
Alvast bedankt...

[Luuk]

De tabellen:
phpbb_auth_access
phpbb_user_group
phpbb_groups
phpbb_categories
phpbb_forum_prune
phpbb_forums
phpbb_posts
phpbb_posts_text
phpbb_topics
phpbb_topics_watch
phpbb_vote_desc
phpbb_vote_results
phpbb_vote_voters

Verwijderen en uit de backup halen. Dan heb je al bijna alles overgezet