WebLeague help
- A Meteorite
- Private First Class
- Posts: 1786
- Joined: Thu Apr 28, 2005 12:56 am
- Location: California, U.S.
- Contact:
Are you using a stock version of PHP? And what version of MySQL?
Type this at the command line:
Type this at the command line:
Code: Select all
php -v && mysql --version
Owner @ BZFX
Core Admin @ CAN
Email me: bzmet…@gmail.com
Code: Select all
PHP 4.4.1 (cli) (built: Mar 3 2006 16:22:28)
Copyright (c) 1997-2004 The PHP Group
Zend Engine v1.3.0, Copyright (c) 1998-2004 Zend Technologies
Code: Select all
mysql Ver 14.12 Distrib 5.0.16, for apple-darwin8.2.0 (powerpc) using readline 5.0
- A Meteorite
- Private First Class
- Posts: 1786
- Joined: Thu Apr 28, 2005 12:56 am
- Location: California, U.S.
- Contact:
There's a newer version of MySQL (5.0.18), give that a try. As for PHP, you could try PHP5, but that might be a hassle installing it...Scorch wrote:Code: Select all
PHP 4.4.1 (cli) (built: Mar 3 2006 16:22:28) Copyright (c) 1997-2004 The PHP Group Zend Engine v1.3.0, Copyright (c) 1998-2004 Zend Technologies
Are those good?Code: Select all
mysql Ver 14.12 Distrib 5.0.16, for apple-darwin8.2.0 (powerpc) using readline 5.0
I usually just try to make sure everything is up-to-date as sometimes that can be the problem...
Owner @ BZFX
Core Admin @ CAN
Email me: bzmet…@gmail.com
- A Meteorite
- Private First Class
- Posts: 1786
- Joined: Thu Apr 28, 2005 12:56 am
- Location: California, U.S.
- Contact:
It looks like that's because there are no teams... (that's the best I can tell, I've never used Web-League)
Have you tried making a team?
Have you tried making a team?
Owner @ BZFX
Core Admin @ CAN
Email me: bzmet…@gmail.com
- The Red Baron
- Sergeant First Class
- Posts: 987
- Joined: Sat Dec 07, 2002 6:21 am
- Contact:
- menotume
- Major General
- Posts: 232
- Joined: Tue Jul 01, 2003 7:48 pm
- Location: SE Pennsylvania, USA
- Contact:
web-league will run fine with php4 and your mysql.
The problem could be with the runme script for setting up tables, it's not been tried on darwin AFAIK.
go to the support/sqlscripts/create_new_install directory and run: ./runme.sh
do you get any error messages ?
Also, you may want to try a fresh database (or delete the one you have). From the error messages, it looks like the tables are there, but the fields aren't right - I don't know how that can happen.
The problem could be with the runme script for setting up tables, it's not been tried on darwin AFAIK.
go to the support/sqlscripts/create_new_install directory and run: ./runme.sh
do you get any error messages ?
Also, you may want to try a fresh database (or delete the one you have). From the error messages, it looks like the tables are there, but the fields aren't right - I don't know how that can happen.
1. Run the installer again and pipe all output in a file. Post that file here to inspect.
2. After the installer has run, make a table dump and send the resulting file.
Maybe this gives menotume the opportunity to verify the difference between is and should.
Is the server located on the same machine, or you use a remote install from your machine?
2. After the installer has run, make a table dump and send the resulting file.
Maybe this gives menotume the opportunity to verify the difference between is and should.
Is the server located on the same machine, or you use a remote install from your machine?
mistake
same machine. can i just copy paste instead of piping? how do i dump a table? I looked and the stuff it's whining about exists.
*******************************************************************************
Make sure that .config/bzlsql.php contains the proper values for sql connection
THIS SCRIPT WILL DELETE ALL TABLES IN THE DATABASE
Abort now if this is not what you want
(Enter to continue)
*******************************************************************************
creating tables ...
creating admin player with password of 'admin'
CHANGE THE PASSWORD with the 'profile' webpage
*******************************************************************************
Make sure that .config/bzlsql.php contains the proper values for sql connection
THIS SCRIPT WILL DELETE ALL TABLES IN THE DATABASE
Abort now if this is not what you want
(Enter to continue)
*******************************************************************************
creating tables ...
creating admin player with password of 'admin'
CHANGE THE PASSWORD with the 'profile' webpage
Use mysqldump in your mysql package to create the dump.
would be something like this:
just read the manuals for details
would be something like this:
Code: Select all
mysqldump -h <yourhost> -u<user> -p<pwd> -a -c -C -r outputfile.dump.sql --add-drop-table <database> <the list of tables to dump>
mistake