[FAQ] Gesior acc. maker for TFS

Thread with account manager has ~40 pages. Newbies report bugs/problems
already reported. In this thread I post how to fix all problems with
account manager configuration and installation.

1. "SQLite doesn't work!"
Report text:

Quote:

Code: STEP 2 Check database connection If you don't see any errors press link to STEP 3 - Add tables and columns to DB. If you see some errors it mean server has wrong configuration. Check FAQ or ask author of acc. maker.Database error - can't open SQLite database. Possible reasons: C:/Documents and Settings/Tommy.HALLDATORN/Skrivbord/Open Tibia_TFS/forgottenserver.s3db - file isn't valid SQLite database. C:/Documents and Settings/Tommy.HALLDATORN/Skrivbord/Open Tibia_TFS/forgottenserver.s3db - doesn't exist. this is what happen to me when i try to install your acc

HOW TO FIX:
In 90% it is problem with your www server configuration.
1. Do not use "WebServ" or other out of date distro. Delete it!
2. Download XAMPP 1.6.5 or new version, install, run "Apache" (and "MySQL" if you use MySQL database)
3. Go to directory: ~/xampp/apache/bin/
and find file php.ini, open this file in text editor and find line:

Code:

;extension=php_pdo_sqlite.dll

change to:

Code:

extension=php_pdo_sqlite.dll

4. Now "Stop" and "Start" Apache in XAMPP and install again "Gesior acc. maker"
OFFICIAL SITE OF XAMPP FOR WINDOWS

2. "MySQL doesn't work!", "Can't connect to database"
Report text:

Quote:

Code: STEP 2 Check database connection If you don't see any errors press link to STEP 3 - Add tables and columns to DB. If you see some errors it mean server has wrong configuration. Check FAQ or ask author of acc. maker.Database error - can't connect to MySQL database. Possible reasons: 1. MySQL server is not running on host. 2. MySQL user, password, database or host isn't configured in: C:/Documents and Settings/admin/Desktop/Mystic Spirit/config.lua . 3. MySQL user, password, database or host is wrong. MySQL IS running, and the rest in config.lua is ok, too! The server can also connect to the database but your AAC not.. Avarins AAC can connect to the database, too....so whats wrong?!

HOW TO FIX:
In 70% it is problem with your www server, in 30% it is problem with
your acc. maker/TFS configuration, remember to don't ignore errors in
"Step 1" of installation (load server configuration).
1. Gesior acc. maker use new PHP functions. Other acc. makers
work on WebServ, but my need new version of PHP to connect to database.
2. Do not use "WebServ" or other out of date distro.
Delete it!
3. Download XAMPP 1.6.5 or new version, install, run "Apache" and "MySQL" if you use MySQL database
OFFICIAL SITE OF XAMPP FOR WINDOWS

3. "Error when I try to login/open highscores"
Report text:

Quote:

MySQL error: Code: Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'balance' in 'field list'' in C:\xampp\htdocs\pot\OTS_Player.php:111 Stack trace: #0 C:\xampp\htdocs\pot\OTS_Player.php(111): PDO->query('SELECT `id`, `n...') #1 C:\xampp\htdocs\pot\OTS_Row_DAO.php(53): OTS_Player->load(1) #2 C:\xampp\htdocs\pot\OTS_Base_List.php(224): OTS_Row_DAO->__construct(1) #3 C:\xampp\htdocs\accountmanagement.php(62): OTS_Base_List->current() #4 C:\xampp\htdocs\index.php(134): include('C:\xampp\htdocs...') #5 {main} thrown in C:\xampp\htdocs\pot\OTS_Player.php on line 111 SQLite error: Code: Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: Extraneous additional parameters' in C:\Xampp\htdocs\pot\OTS_SQLite_Results.php:75 Stack trace: #0 C:\Xampp\htdocs\pot\OTS_SQLite_Results.php(75): PDOStatement->fetchAll(0, NULL, NULL) #1 C:\Xampp\htdocs\pot\OTS_Base_List.php(234): OTS_SQLite_Results->fetchAll() #2 C:\Xampp\htdocs\accountmanagement.php(62): OTS_Base_List->rewind() #3 C:\Xampp\htdocs\index.php(134): include('C:\Xampp\htdocs...') #4 {main} thrown in C:\Xampp\htdocs\pot\OTS_SQLite_Results.php on line 75

HOW TO FIX:
It's problem with columns/tables in database.
1. In my post are two versions of acc. maker "..for TFS 0.3" and "..for TFS 0.2.x"
2. If you use TFS 0.2.6 - 0.2.12 server/database use version "..for TFS 0.2.x"
3. If you use TFS 0.3 server/database use version "..for TFS 0.3"
Else you get this error. If you actualized your database from 0.2.x to 0.3 and get this error something is wrong in database.

ehh, this is download section..... not a support section

Post the FAQ in the fileDownload thread. Closed.