Need Bosi help

[gom]

First of all, thanks to all who read the post and if you can help, I appreciate it.

I have a copy of BOSI 1.0, and I found the instructions, and I'm having an error at the following part(s):

In order to install and use BOSI, your host must provide you with MySQL. You can install these tables in a database you have already created, or create a new one (If you are installing on a PhP Nuke sight, you MUST use the same DB that you installed Nuke into). To create a new database, go to your control panel and create it from there. You don't need to name it anything special. Just note the database and user/password that you'll be installing these tables into.

Once you have a database, you can open up PhPMyAdmin, and select the database you have chosen. On the top right window, you should see a choice called SQL. This will open up a window that would allow you to type in a SQL query, or run a SQL script. Below is a picture of the screen:

Click on the Browse button next to the "Or Location of the textfile :", find the directory where you installed BOSI, and choose the bosi_tables.sql file. Then, click on the Go button. It'll take a couple of seconds, but when finished, it should say it completed successfully, and 53 tables should have been created.

I get 56 tables, not 53. Don't know if this is causing it.

To test that you have installed everything correctly, run the Standings report h ttp://www.yoursite.com/bosidir/standings.php?lid=#. (For PhPNuke sites, it would be h ttp://www.yoursite.com/standings.php?lid=1. If you see the BOSI header with Standings Not Available, you are good to go. You will see this error: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /~whatever your bosi path is~/includes/bosi_left.php on line 38 and that's ok. Now, time to register the super user. Click on the Register link and create a user with the same username you put in your BOSI_CONFIG file. After you create that user, login. At the top, you should see "You are the league administrator. Admin options are below." and the administration block will appear on the bottom left of your screen.

I get the to the point of "Standings not available". I DO NOT see the error on line 38.
When I try to setup the username, I get the following error:

Error creating user. Please include the following text when reporting to webmaster .. insert into USER_BOSI(name,uname,email,user_icq,user_from,user _viewemail,user_aim,user_yim,user_msnm,pass) VALUES('','commish','temp',0,'',1,'','','',passwor d('sith0712'))]

You can see it on the web here:

http://www.talksoxbbl.com/bosi/user_admin.php?t=1

Any help would be appreciated. You can reach me via AIM at sith712 or PM here if anyone can run me through it.

[gom]

Ok, I fixed the bosi_config.php so that the localhost is my server. That fixed the error creating user problem.

Here is what I did:

I am very new to this, and I could really appreciate any help.

I created a database called "mwalid_database". The username is "mwalid_user". The database password is "password". The main user is "commish".

My localhost address is "mysql30.ixwebhosting.com"

Here is the original file I am to edit:

$db_user = "DBUSER";
$db_pass = "DBPASS";
$db_mysql = "DBNAME";
$main_user = "ADMIN USER";
if (!defined('NUKE'))
define('NUKE',0);
// Added to see if we are using PhP Nuke or not
if (constant("NUKE")==0)
{
$dbi=mysql_connect ("localhost", "$db_user", "$db_pass");
mysql_select_db ("$db_mysql",$dbi);
}
else
{
require_once("mainfile.php");
}
global $prefix, $dbi;
?>

I am not using nuke.

As far as I can see, I made the following changes:

$db_user = "mwalid_user";
$db_pass = "password";
$db_mysql = "mwalid_database";
$main_user = "commish";
if (!defined('NUKE'))
define('NUKE',0);
// Added to see if we are using PhP Nuke or not
if (constant("NUKE")==0)
{
$dbi=mysql_connect ("mysql30.ixwebhosting.com", "mwalid_user", "password");
mysql_select_db ("mwalid_database",$dbi);
}
else
{
require_once("mainfile.php");
}
global $prefix, $dbi;
?>

I am able to create users, but no attempts at logging in, either by creating a normal or superuser, makes any difference. I get a login un-successful every time. The URL for the website is www.talksoxbbl.com/bosi/standings.php?lid=#

If anyone can post/email or IM me at AOL sith712, I'd appreciate it. TIA.


Now....I can successfully create a username. However, whenever I try to login, be it a superuser or a regular user, the login is unsuccessful.

Any ideas?

[gom]

Seems to me the problem was that it was on a windows server. When I switched to linux, it worked perfectly. On the windows server, the sessions timed out immediately and gave me an unsuccesful login error.