Próbowałem już wszelakich sposobów i nie mogę do tego dojść. Tutaj podaję plik, który musi być odpowiednio zmodyfikowany pod moją bazę:
Dodam, że user bazy to: psor_1, nazwa bazy to psor_1 i host to psor.nazwa.pl:3307
Wydaje mi się, że wszystko wpisuje ok, a jednak ciągle coś wywala.
<?php
/*********************************************************
* Author: John Astill (c)
* Date : 10th December 2001
* File : systemvars.php
* Desc : Global data definitions. This is where the
* : prediction league is configured for the
* : specific installation.
********************************************************/
require "userclass.php";
require "logfunctions.php";
require "error.php";
//////////////////////////////////////////
// System variable and configuration
//////////////////////////////////////////
//////////////////////////////////////////
// Constants
//////////////////////////////////////////
/////////////////////////////////////////////////
// Default points for scoring, this can be
// set in the config screen.
/////////////////////////////////////////////////
$corrHomeScore = 1;
$corrAwayScore = 1;
$corrMargin = 1;
$corrResult = 1;
$corrScore = 3;
//////////////////////////////////////////////////////////////
// Modify the values from here to where you are told to stop.
// The numbers match those in the installation steps in
// the file INSTALL.TXT.
//////////////////////////////////////////////////////////////
//////////////////////////////////////////
// 1.Prediction League Title
// The title of the Prediction League.
// Change the value between the "" to
// give the prediction league the title
// of your choice
//////////////////////////////////////////
$PredictionLeagueTitle = "Prediction Football.com";
//////////////////////////////////////////////////////////////
// 2. Header Row
// This is the header to be displayed in
//all the pages. It can contain HTML code.
//////////////////////////////////////////////////////////////
$HeaderRow = "<table cellpadding=\"0\" cellspacing=\"0\"><tr><td align=\"center\" class=\"TBLHEAD\"><font class=\"TBLHEAD\"><img border=\"0\" src=\"banner.jpg\"></font></td></tr></table>";
//////////////////////////////////////////////////////////////
// 3. Database hostname
// Database hostname
// The fqdn of the host containing the
// database
//////////////////////////////////////////////////////////////
$dbaseHost = "psor.nazwa.pl:3307";
//////////////////////////////////////////////////////////////
// 4. Base Directory Name
// The directory storing the prediction
// league files
//////////////////////////////////////////////////////////////
$baseDirName = "typer";
//////////////////////////////////////////////////////////////
// 5. Username
// User name
// The username to be used for logging
// into the database
//////////////////////////////////////////////////////////////
$dbaseUsername = "psor_1";
//////////////////////////////////////////////////////////////
// 6. Password
// Password to be used for logging into
// the database
//////////////////////////////////////////////////////////////
$dbasePassword = "haslo";
//////////////////////////////////////////////////////////////
// 7. Database Name.
// This is the name of the database. This *MUST* be the same
// name as the name you used when creating the database.
//////////////////////////////////////////////////////////////
$dbaseName = "psor_1";
Podczas instalacji, gdy zaznaczam by stworzyło tylko tabele (bez bazy) to wyskakuje taki błąd:
Query failed: CREATE TABLE psor_1.pluserdata (lid int NOT NULL , userid int NOT NULL AUTO_INCREMENT, username varchar(32) NOT NULL , password varchar(40), email varchar(60), icon varchar(128), lang varchar(32), usertype smallint, dflths smallint DEFAULT 0, dfltas smallint DEFAULT 0, since DATE, auto enum('Y','N') DEFAULT 'N', PRIMARY KEY (lid,userid));
Incorrect TABLE definition; there can be only one auto COLUMN AND it must be defined AS a KEY