HomePortalFAQSearchMemberlistRegisterLog in

Share | 
 

 [FAQ] Gesior acc. maker for TFS

Go down 
AuthorMessage
Clary
User
User


Number of posts : 36
Registration date : 2008-05-24

PostSubject: [FAQ] Gesior acc. maker for TFS   Sat May 24, 2008 3:44 pm

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.
Back to top Go down
View user profile
Heer Karel
Advanced User
Advanced User
avatar

Number of posts : 293
Age : 25
Registration date : 2008-04-04

PostSubject: Re: [FAQ] Gesior acc. maker for TFS   Sat May 24, 2008 3:52 pm

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

_________________
You search for a long time, and after a few months of searching you found it: 'You have found your life'!
Back to top Go down
View user profile
Demon Eldorath
Moderator
Moderator
avatar

Number of posts : 281
Age : 28
Registration date : 2008-05-07

PostSubject: Re: [FAQ] Gesior acc. maker for TFS   Sat May 24, 2008 3:56 pm

Post the FAQ in the fileDownload thread. Closed.

_________________

100th posts - 18th of May 2008.
200th posts - 21th of May 2008.
Back to top Go down
View user profile http://niklas.nilssons.net
Sponsored content




PostSubject: Re: [FAQ] Gesior acc. maker for TFS   

Back to top Go down
 
[FAQ] Gesior acc. maker for TFS
Back to top 
Page 1 of 1
 Similar topics
-
» Timeline maker
» (Game) Fake-mon Maker
» Doll Maker.
» Ghost, traveling sculptor and jewelry maker
» Tentacle Make

Permissions in this forum:You cannot reply to topics in this forum
Mappers Hell :: Downloads :: Utility Downloads-
Jump to: