Mappers Hell
Would you like to react to this message? Create an account in a few clicks or log in to continue.



 
HomePortalLatest imagesSearchRegisterLog in

 

 [FAQ] Gesior acc. maker for TFS

Go down 
3 posters
AuthorMessage
Clary
User
User



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

[FAQ] Gesior acc. maker for TFS Empty
PostSubject: [FAQ] Gesior acc. maker for TFS   [FAQ] Gesior acc. maker for TFS Icon_minitimeSat 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
Heer Karel
Advanced User
Advanced User
Heer Karel


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

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

ehh, this is download section..... not a support section
Back to top Go down
Demon Eldorath
Moderator
Moderator
Demon Eldorath


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

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

Post the FAQ in the fileDownload thread. Closed.
Back to top Go down
http://niklas.nilssons.net
Sponsored content





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

Back to top Go down
 
[FAQ] Gesior acc. maker for TFS
Back to top 
Page 1 of 1
 Similar topics
-
» Gesior acc. maker for TFS
» [8.1&8.11][SQL]The Best War by Gesior (beta)
» Ver. 0.1.0 - Gesior ITEM/PACC Shop (PHP+LUA) for TFS
» TFS Raid Maker

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