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:
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:
change to:
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:
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:
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.
------------------
I'll add new reports to this thread.
1. "SQLite doesn't work!"
Report text:
HOW TO FIX:this is what happen to me when i try to install your accCode: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.
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
Code:
extension=php_pdo_sqlite.dll
OFFICIAL SITE OF XAMPP FOR WINDOWS
2. "MySQL doesn't work!", "Can't connect to database"
Report text:
HOW TO FIX:MySQL IS running, and the rest in config.lua is ok, too!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.
The server can also connect to the database but your AAC not..
Avarins AAC can connect to the database, too....so whats wrong?!
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:
HOW TO FIX:MySQL error:SQLite 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
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
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.
------------------
I'll add new reports to this thread.