Installing gesior AAC problem

[Djivar]

Hello there i have a problem when i'm going to install gesior AAC

When i'm installing the database and going to import all the tables like players and everything i get this:

STEP 3

Add tables and columns to DB
Installer try to add new tables and columns to database.
Add columns to table accounts

Can't add column page_lastday to table accounts, already exist?
Can't add column email_new to table accounts, already exist?
Can't add column email_new_time to table accounts, already exist?
Can't add column created to table accounts, already exist?
Can't add column rlname to table accounts, already exist?
Can't add column location to table accounts, already exist?
Can't add column page_access to table accounts, already exist?
Can't add column email_code to table accounts, already exist?
Can't add column next_email to table accounts, already exist?
Can't add column premium_points to table accounts, already exist?
Can't add column vote to table players, already exist?
Can't add column last posts to table accounts, already exist?
Can't add column flag to table accounts, already exist?
Add columns to table guilds

Can't add column description to table guilds, already exist?
Can't add column logo_gfx_name to table guilds, already exist?
Add columns to table players

Can't add column created to table players, already exist?
Can't add column nick_verify to table players, already exist?
Can't add column old_name to table players, already exist?
Can't add column hide_char to table players, already exist?
Can't add column worldtransfer to table players, already exist?
Can't add column comment to table players, already exist?
Can't add column comment to table players, already exist?
Can't add column comment to table players, already exist?
Can't add column comment to table players, already exist?
Can't add column comment to table players, already exist?
Can't add column comment to table players, already exist?
Add new tables to database

Added table z_news_tickers
Added table z_spells
Added table z_monsters
Added table z_ots_comunication (shopsystem).
Added table z_shop_offer (shopsystem).
Added table z_shop_history_item (shopsystem).
Added table z_shop_history_pacc (shopsystem).
Added table z_polls (poll-system).
Added table z_polls_answers (poll-system).
Added table zaypay_payment.
Added table z_bug_tracker (bug tracker).
Added table z_changelog (changelog).
Added table z_forum (forum).

the thing is that the database is empty when i try to add them and as it says i just get the tables it added, why dose it do like this? and i dont have any error on the steps before. thanks

 

[SoloQ]

Right database selected in the config?

 

[Djivar]

Right database selected in the config?

Yes

Any idea why it's do like this?

- - - Updated - - -

And i have re installed xampp and i have tryed to change the forgottenserver.s3db but it dose not help.

 

[SoloQ]

Use uniform server.

The Uniform Server

(same principle as xampp but more secure)

 

[Djivar]

The thing is that i want to use gesior acc :/

Can't i insert them by hand? and what whould all the scripts be if so? or dose someone els know anything i can do so i works?

- - - Updated - - -

when i try to add the table "accounts" by my self i get this error:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"accounts" ( "key" VARCHAR(255) NOT NULL DEFAULT, "page_lastday" I' at line 1

And the code i made looks like this:

CREATE TABLE "accounts" (
						"key" VARCHAR(255) NOT NULL DEFAULT,
						"page_lastday" INTEGER(11) NOT NULL DEFAULT 0,
						"email_new" VARCHAR(255) NOT NULL DEFAULT,
						"email_new_time" INTEGER(15) NOT NULL DEFAULT 0,
						"created" INTEGER(11) NOT NULL DEFAULT 0,
                                                "rlname" VARCHAR(255) NOT NULL DEFAULT,
                                                "location" VARCHAR(255) NOT NULL DEFAULT,
                                                "page_access" INTEGER(11) NOT NULL DEFAULT 0,
                                                "email_code" VARCHAR(255) NOT NULL DEFAULT 0,
                                                "next_email" INTEGER(11) NOT NULL DEFAULT 0,
                                                "premium_points" INTEGER(11) NOT NULL DEFAULT 0,)

 

[SoloQ]

Xampp is the database host. Uniform is another database host. Try uniform with gesior. Will work (have it myself)

 

[Ninja]

database host

It's called web server. ^_^

I could set up Gesior AAC for you via TeamViewer if you would like that, just send me a Private Message.

 

[Angry encoder]

Do you know what already exist? means ?

 

[UpInSmoke]

Use Znote AAC, its more secure

 

[Raggaer]

Use Znote AAC, its more secure

Or use new gesior version..

 

[Djivar]

Use Znote AAC, its more secure

I want to use gesior because of all the Scripts/Customizations and it has the most layouts.

Or use new gesior version..

I'm using this one http://otland.net/f118/geisor-0-3-8-reuploaded-154270/

Do you know what already exist? means ?

yes i do and i also see that you can't read a text so?

Before you comment something like this you should read the whole text, cuz look what i said in the first post :

the thing is that the database is empty when i try to add them

Well i manage do fix that problem now but now i got this error help me

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'name' in 'where clause'' in E:\xampp\htdocs\install.php:513 Stack trace: #0 E:\xampp\htdocs\install.php(513): PDO->query('SELECT * FROM p...') #1 {main} thrown in E:\xampp\htdocs\install.php on line 513

- - - Updated - - -

bump