This maybe an old question or problem

[gonepostal_1]

I am tring to install the phpbb2. But when I try to submit this shows up:

Warning: odbc_connect(): SQL error: [Microsoft][ODBC Driver Manager] Invalid string or buffer length, SQL state S1090 in SQLConnect in C:\Program Files\Abyss Web Server\htdocs\community\phpBB2\db\msaccess.php on line 55
phpBB : Critical Error

Could not connect to the database

DEBUG MODE

SQL Error : Error

I am ussing access2000

I have also install MYSQL 4

Can someone enlighten me on what I am doing wrong?
_________________
The Rebel Clan
Unreal Tournament 2004

http://unreal04.no-ip.org

[gonepostal_1]

never mind about the last post. Thanks for no help.

But if anyone cares to. Here is the link to my board see if it works for you.

http://66.190.221.30:81/community/phpBB2/index.php
_________________
The Rebel Clan
Unreal Tournament 2004

http://unreal04.no-ip.org

[iNaNimAtE]

[gonepostal_1]

Well I tried to use My SQL and could not get it to work. And yes I get the same 5 second "append an sid" . I installed My SQL 4 could not get it to work. MS access was the one I could get to work.

ok, I found the php.ini file. The only line I see that says anything about error reporting is the following:

; Eval the expression with current error_reporting(). Set to true if you want
; error_reporting(0) around the eval().
;assert.quiet_eval = 0

Is this something I should change?

Is this supposed to be set to off:

; Compatability mode with old versions of PHP 3.0.
mssql.compatability_mode = Off

Most all this is foriegn language to me as if people have not figured it out yet.
_________________
The Rebel Clan
Unreal Tournament 2004

http://unreal04.no-ip.org

[iNaNimAtE]

Search for "display_errors" in the php.ini file.
_________________
Bienvenidos!

[gonepostal_1]

ok I hope this was it. I changed the following:

; Print out errors (as a part of the output). For production web sites,
; you're strongly encouraged to turn this feature off, and use error logging
; instead (see below). Keeping display_errors enabled on a production web site
; may reveal security information to end users, such as file paths on your Web
; server, your database schema or other information.
display_errors = Off <<< I changed this from on to off:

But it still does the append_sid thing
_________________
The Rebel Clan
Unreal Tournament 2004

http://unreal04.no-ip.org

[iNaNimAtE]

That was the correct thing to change. Now, about the append sid, the only thing I can suggest is to try and reinstall phpBB. You can also talk to people on the phpBB website instead, as I'm sure they know a lot more about it than I do.
_________________
Bienvenidos!

[gonepostal_1]

ok-thanks for your help. Just one more thing. how do I get the DB into the SQL? If you could tell me?

I am assuming it would probably better to use. Since it seems everyone here usses it
_________________
The Rebel Clan
Unreal Tournament 2004

http://unreal04.no-ip.org

[iNaNimAtE]

You want to start using MySQL I presume. The tutorial at http://www.aprelium.com/forum/viewtopic.php?t=1070 is the one I followed (and TRUSTpunk also offers tutorials at os17fan.cjb.net). Once you get that, you can follow the tutorial for how to install phpMyAdmin where you can add new databases and configure MySQL a lot easier than doing it from the command line.
_________________
Bienvenidos!

[gonepostal_1]

yes I have found those links on another posting. But the screenshots that Trustpunk have on his tutorial look nothing like myphpadmin that I have.

Welcome to phpMyAdmin 2.5.3-rc3

this is the heading I have on my phpadmin page

And that command line stuff. If I try that I will probably blow up my pc-lol

But I am reading it tring to figure it out.
_________________
The Rebel Clan
Unreal Tournament 2004

http://unreal04.no-ip.org

[TRUSTAbyss]

You do know that if your having trouble with my tutorials
I offer free online help , I just need to get home on sunday
and maybe I can get your problems fixed , in the mean time
post some screenshots of your phpMyAdmin page.

[gonepostal_1]

ok-I got past that. I am now at the install page for the forum. I followed all of the turoril that you have and when I try to instal I get this mesage:

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in C:\Program Files\Abyss Web Server\htdocs\community\phpBB2\db\mysql4.php on line 330

Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in C:\Program Files\Abyss Web Server\htdocs\community\phpBB2\db\mysql4.php on line 331
phpBB : Critical Error

Could not connect to the database

Now I see one thing about the install is. I am using MySql 5.x and the options only have :

MySQL 3.x
MySQL 4.x

but no MYSQL 5.x

Should I start over and instal MySQL 4.x?
_________________
The Rebel Clan
Unreal Tournament 2004

http://unreal04.no-ip.org

[iNaNimAtE]

Yes.
_________________
Bienvenidos!

[gonepostal_1]

It seems to be working now:

http://66.190.221.30:81/community/phpBB2/index.php


i have my fingers crossed:

SCRATCH THIS POST NOW ITS NOT WORKING!
_________________
The Rebel Clan
Unreal Tournament 2004

http://unreal04.no-ip.org

[TRUSTAbyss]

Do you have MySQL turned on , do you see the stop
light green in your system tray , if so than it should
work but from the looks of it , its still not working.

[gonepostal_1]

Yes the green light is there. It worked once. I was able to go to my admin page and set the email. then went a veiw the board and looked at the sample post. Then my PC shut down a restarted by itself. when it came back up I could no longer get to the board. It quit working.

Also when I open up MySQl and go to databases it only shows test. It does not show the bbs one I created. Is that right?
_________________
The Rebel Clan
Unreal Tournament 2004

http://unreal04.no-ip.org

[TRUSTAbyss]

Its possible you lost some unsaved data
from your BBS database , check the folder

C:\mysql\ and look for databases
do you see your forum database ?

[gonepostal_1]

yes it is still there. I can also get into phpmyadmin page and it is all there also. the phpmyadmin shows 3 databases:

bbs
sql
test

not sure what happens when you try to get to the forum. but this is what i get.

Warning: mysql_connect(): Access denied for user: 'gonepostal71'@'localhost' (Using password: YES) in C:\Program Files\Abyss Web Server\htdocs\community\phpBB2\db\mysql4.php on line 48

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in C:\Program Files\Abyss Web Server\htdocs\community\phpBB2\db\mysql4.php on line 330

Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in C:\Program Files\Abyss Web Server\htdocs\community\phpBB2\db\mysql4.php on line 331
phpBB : Critical Error

Could not connect to the database

I am just gonna start over from scratch I probably did something wrong somewhere.
_________________
The Rebel Clan
Unreal Tournament 2004

http://unreal04.no-ip.org

[iNaNimAtE]

Well it looks like you are entering the wrong password for your username.

Here's what I suggest:
Remove phpBB and MySQL. First, install MySQL (version 4) and leave the username 'root' with no password. Then, install phpMyAdmin and change the config.inc.php to access the database on "localhost" with "root" and no password. Then, make an alias in Abyss to make C:\your\path\to\phpMyAdmin be /phpMyAdmin. You can then type http://localhost/phpMyAdmin into your browser and add a password for root. Then, go back into the config.inc.php and add your password that you specified. Then, go back into phpMyAdmin (we'll finish soon--don't worry) and add a new database called "phpbb." Finally, you can unzip phpBB and install it for MySQL version 4, using database "phpbb" on "localhost" with user "root" and your password.

After your done all that, you can password protect the phpMyAdmin directory using Abyss and add an alias for phpBB if necessary.
_________________
Bienvenidos!

[gonepostal_1]

in the cofig file. I still need to put the url in this line right?

$cfg['PmaAbsoluteUri'] = '';

or is this all I need to worry about?

$cfg['Servers'][$i]['host'] = 'localhost'; // MySQL hostname or IP address
$cfg['Servers'][$i]['port'] = ''; // MySQL port - leave blank for default port
$cfg['Servers'][$i]['socket'] = ''; // Path to the socket - leave blank for default socket
$cfg['Servers'][$i]['connect_type'] = 'tcp'; // How to connect to MySQL server ('tcp' or 'socket')
$cfg['Servers'][$i]['compress'] = FALSE; // Use compressed protocol for the MySQL connection
// (requires PHP >= 4.3.0)
$cfg['Servers'][$i]['controluser'] = ''; // MySQL control user settings
// (this user must have read-only
$cfg['Servers'][$i]['controlpass'] = ''; // access to the "mysql/user"
// and "mysql/db" tables)
$cfg['Servers'][$i]['auth_type'] = 'config'; // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user'] = 'root'; // MySQL user
$cfg['Servers'][$i]['password'] = ''; // MySQL password (only needed
// with 'config' auth_type)

I have tried it the way it looks now could not find page:

I tried it with this line changed

$cfg['PmaAbsoluteUri'] = 'http://66.190.221.30:81/phpmyadmin';

And also this way.

$cfg['PmaAbsoluteUri'] = 'http://127.0.0.1:81/phpmyadmin';

and the page shows up but it I see the html or the source. Not the web page itself.
_________________
The Rebel Clan
Unreal Tournament 2004

http://unreal04.no-ip.org

[iNaNimAtE]

Yes, you need that line also. Use /phpMyAdmin for it.
_________________
Bienvenidos!

[gonepostal_1]

This is what I get when I load this url:

http://127.0.0.1:81/phpMyAdmin


<?php
/* $Id: index.php,v 1.54 2003/07/11 09:35:05 rabus Exp $ */
// vim: expandtab sw=4 ts=4 sts=4:


/**
* Gets core libraries and defines some variables
*/
require('./libraries/grab_globals.lib.php');
require('./libraries/common.lib.php');

// Gets the default font sizes
PMA_setFontSizes();

// Gets the host name
// loic1 - 2001/25/11: use the new globals arrays defined with php 4.1+
if (empty($HTTP_HOST)) {
if (!empty($_ENV) && isset($_ENV['HTTP_HOST'])) {
$HTTP_HOST = $_ENV['HTTP_HOST'];
}
else if (!empty($HTTP_ENV_VARS) && isset($HTTP_ENV_VARS['HTTP_HOST'])) {
$HTTP_HOST = $HTTP_ENV_VARS['HTTP_HOST'];
}
else if (@getenv('HTTP_HOST')) {
$HTTP_HOST = getenv('HTTP_HOST');
}
else {
$HTTP_HOST = '';
}
}


/**
* Defines the frameset
*/
// loic1: If left light mode -> urldecode the db name
if (isset($lightm_db)) {
// no longer urlencoded because of html entities in the db name
// $db = urldecode($lightm_db);
$db = $lightm_db;
unset($lightm_db);
}
$url_query = PMA_generate_common_url(isset($db) ? $db : '');

header('Content-Type: text/html; charset=' . $GLOBALS['charset']);

require('./libraries/relation.lib.php');
$cfgRelation = PMA_getRelationsParam();

if ($cfg['QueryHistoryDB'] && $cfgRelation['historywork']) {
PMA_purgeHistory($cfg['Server']['user']);
}

$phpmain_hash = md5($cfg['PmaAbsoluteUri']);
$phpmain_hash_js = time();
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Frameset//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-frameset.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="<?php echo $available_languages[$lang][2]; ?>" lang="<?php echo $available_languages[$lang][2]; ?>" dir="<?php echo $text_dir; ?>">
<head>
<title>phpMyAdmin <?php echo PMA_VERSION; ?> - <?php echo $HTTP_HOST; ?></title>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo $charset; ?>" />
<link rel="stylesheet" type="text/css" href="./css/phpmyadmin.css.php?lang=<?php echo $lang; ?>&amp;js_frame=right" />
</head>

<?php
if ($cfg['QueryFrame']) {

if ($cfg['QueryFrameJS']) {
echo '<script type="text/javascript">' . "\n";
echo '<!--' . "\n";
echo ' document.writeln(\'<frameset cols="' . $cfg['LeftWidth'] . ',*" rows="*" border="1" frameborder="1" framespacing="0">\');' . "\n";
echo ' document.writeln(\' <frameset rows="*, 50" framespacing="0" frameborder="0" border="0">\');' . "\n";
echo ' document.writeln(\' <frame src="left.php?' . $url_query . '&amp;hash=' . $phpmain_hash . $phpmain_hash_js . '" name="nav" frameborder="0" />\');' . "\n";
echo ' document.writeln(\' <frame src="queryframe.php?' . $url_query . '&amp;hash=' . $phpmain_hash . $phpmain_hash_js . '" name="queryframe" frameborder="0" scrolling="no" />\');' . "\n";
echo ' document.writeln(\' </frameset>\');' . "\n";
echo ' document.writeln(\' <frame src="' . (empty($db) ? $cfg['DefaultTabServer'] : $cfg['DefaultTabDatabase']) . '?' . $url_query . '" name="phpmain' . $phpmain_hash . $phpmain_hash_js . '" border="0" frameborder="0" />\');' . "\n";
echo ' document.writeln(\' <noframes>\');' . "\n";
echo ' document.writeln(\' <body bgcolor="#FFFFFF">\');' . "\n";
echo ' document.writeln(\' <p>' . str_replace("'", "\'", $strNoFrames) . '</p>\');' . "\n";
echo ' document.writeln(\' </body>\');' . "\n";
echo ' document.writeln(\' </noframes>\');' . "\n";
echo ' document.writeln(\'</frameset>\');' . "\n";
echo '//-->' . "\n";
echo '</script>' . "\n";
echo "\n";
echo '<noscript>' . "\n";
}

echo '<frameset cols="' . $cfg['LeftWidth'] . ',*" rows="*" border="1" frameborder="1" framespacing="0">' . "\n";
echo ' <frameset rows="*, 50" framespacing="0" frameborder="0" border="0">' . "\n";
echo ' <frame src="left.php?' . $url_query . '&amp;hash=' . $phpmain_hash . '" name="nav" frameborder="0" />' . "\n";
echo ' <frame src="queryframe.php?' . $url_query . '&amp;hash=' . $phpmain_hash . '" name="queryframe" frameborder="0" scrolling="no" />' . "\n";
echo ' </frameset>' . "\n";
echo ' <frame src="' . (empty($db) ? $cfg['DefaultTabServer'] : $cfg['DefaultTabDatabase']) . '?' . $url_query . '" name="phpmain' . $phpmain_hash . '" frameborder="0" />' . "\n";

} else {

echo '<frameset cols="' . $cfg['LeftWidth'] . ',*" rows="*" border="1" frameborder="1" framespacing="0">' . "\n";
echo ' <frame src="left.php?' . $url_query . '&amp;hash=' . $phpmain_hash . '" name="nav" frameborder="0" />' . "\n";
echo ' <frame src="' . (empty($db) ? $cfg['DefaultTabServer'] : $cfg['DefaultTabDatabase']) . '?' . $url_query . '" name="phpmain' . $phpmain_hash . '" frameborder="1" />' . "\n";

}
?>

<noframes>
<body bgcolor="#FFFFFF">
<p><?php echo $strNoFrames; ?></p>
</body>
</noframes>
</frameset>
<?php
if ($cfg['QueryFrame'] && $cfg['QueryFrameJS']) {
echo '</noscript>' . "\n";
}
?>

</html>

this is what the page looks like when it loads.
_________________
The Rebel Clan
Unreal Tournament 2004

http://unreal04.no-ip.org

[iNaNimAtE]

...wait a second; do you have PHP installed?

http://www.aprelium.com/abyssws/php.html
_________________
Bienvenidos!

[gonepostal_1]

oop's-lol

When I was pissed off last night nothing was working I went and deleted everything and forgot to re-install php.

ok I am moving on now
_________________
The Rebel Clan
Unreal Tournament 2004

http://unreal04.no-ip.org

[gonepostal_1]

YEA YEA!!! It looks like all the help I got may have worked. At least I hope it did. Because it would appear that my forum is now working.


http://66.190.221.30:81/forum1/phpbb2/index.php


Someone please check it and see. Cross your fingures for me.[/url]
_________________
The Rebel Clan
Unreal Tournament 2004

http://unreal04.no-ip.org

[iNaNimAtE]

And the judges agree, it works!

Finally you did it. Good job.
_________________
Bienvenidos!

[TRUSTAbyss]

Welcome to the phpBB Forum software !

[gonepostal_1]

Thank you finally!!!!!
_________________
The Rebel Clan
Unreal Tournament 2004

http://unreal04.no-ip.org

[goose]

hehe thats fine no help is good...makes you learn lots ...
_________________
living in an armish paradise.....no gates here!

mawuahahaha :)