Windows install website

[melegy]

i've this error when iam in my way to install my website

Query: SELECT * FROM z_news_tickers WHERE image_id = 1 AND author = 1 AND hide_ticker = 0 LIMIT 1 OFFSET 0
SQLSTATE: 00000
Driver code:
Error message:
News ticker sample is already in database. New sample is not needed.
STEP 4
Add samples to DB:
Query: SELECT `id`, `name`, `world_id`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `rank_id`, `guildnick`, `lastlogout`, `blessings`, `balance`, `stamina`, `direction`, `loss_experience`, `loss_mana`, `loss_skills`, `loss_containers`, `loss_items`, `premend`, `online`, `marriage`, `promotion`, `deleted`, `description`, `create_ip`, `create_date`, `comment`, `hide_char`, `signature` FROM `players` WHERE `name` = 'Account Manager'
SQLSTATE: 42S22
Driver code: 1054
Error message: Unknown column 'world_id' in 'field list'

Fatal error: Call to a member function fetch() on a non-object in C:\xampp\htdocs\classes\player.php on line 36

Please help
regards.

 

[Raggaer]

Error message: Unknown column 'world_id' in 'field list'

You are missing this column on your players table

ALTER TABLE `players` ADD `world_id` int(11) NOT NULL;

 

[melegy]

Error message: Unknown column 'world_id' in 'field list'

You are missing this column on your players table

ALTER TABLE `players` ADD `world_id` int(11) NOT NULL;

still have this error

Query: SELECT * FROM z_news_tickers WHERE image_id = 1 AND author = 1 AND hide_ticker = 0 LIMIT 1 OFFSET 0
SQLSTATE: 00000
Driver code:
Error message:
News ticker sample is already in database. New sample is not needed.
STEP 4
Add samples to DB:
Query: SELECT `id`, `name`, `world_id`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `rank_id`, `guildnick`, `lastlogout`, `blessings`, `balance`, `stamina`, `direction`, `loss_experience`, `loss_mana`, `loss_skills`, `loss_containers`, `loss_items`, `premend`, `online`, `marriage`, `promotion`, `deleted`, `description`, `create_ip`, `create_date`, `comment`, `hide_char`, `signature` FROM `players` WHERE `name` = 'Account Manager'
SQLSTATE: 00000
Driver code:
Error message:
Error occured!
Error ID:
More info: Character Account Manager does not exist. Cannot install sample characters!

File: C:\xampp\htdocs/install.php Line: 641

 

[Raggaer]

You are missing Account Manager character, I guess you can go ahead and insert it manually on your database

 

[melegy]

You are missing Account Manager character, I guess you can go ahead and insert it manually on your database

Iam working on ,it's a shit takes too long.

 

[Raggaer]

Iam working on ,it's a shit takes too long.

Almost all columns have a default value so its not that long =)

 

[melegy]

Almost all columns have a default value so its not that long =)

players insert almost done take a look if there's error before insert

insert into players
(id,name,group_id,account_id,level,vocation,health,healthmax,experience,lookbody,
lookfeet,lookhead,looklegs,looktype,lookaddons,maglevel,mana,manamax,manaspent,
soul,town_id,posx,posy,posz,conditions,cap,sex,lastlogin,lastip,save,skull,
skulltime,lastlogout,blessings,onlinetime,deletion,balance,offlinetraining_time,offlinetraining_skill,
stamina,skill_fist,skill_fist_tries,skill_club,skill_club_tries,skill_sword,skill_sword_tries,skill_axe,
skill_axe_tries,skill_dist,skill_dist_tries,skill_shielding,skill_shielding_tries,skill_fishing,skill_fishing_tries,
created,nick_verify,old_name,hide_char,world_id,comment,show_outfit,show_eq,show_bars,show_skills,show_quests,deleted,
description,create_ip,create_date,signature,broadcasting,viewers,rank_id,guildnick,direction,loss_experience,
loss_mana,loss_skills,loss_containers,loss_items,premend,online,marriage,promotion)
values (1,'Account manager',1,1,8,0,150,150,0,0,0,0,0,110,0,0,0,0,0,0,0,1000,1000,7,'[BLOB - 0B]',
400,0,0,0,0,0,0,0,0,0,0,0,0,0,201660000,
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,100,100,0,100,100,0,0,0,0)

iam in my way to code accounts.

 

[Raggaer]

You should not insert the BLOB field that way just dont insert it. You can ommit a lot of 0 values.... I think the name, account_id and the timestamp fields are the only ones required. You can then edit the result to your needs

I think that way is easier so you dont go crazy with a long query failing xD

 

[melegy]

You should not insert the BLOB field that way just dont insert it. You can ommit a lot of 0 values.... I think the name, account_id and the timestamp fields are the only ones required. You can then edit the result to your needs

I think that way is easier so you dont go crazy with a long query failing xD

now this error appear

Set Admin Account
Query:    SELECT `id`, `vip_time`, `guild_points`, `backup_points`, `name`, `password`, `premdays`, `lastday`, `email`, `key`, `group_id`, `create_ip`, `create_date`, `premium_points`, `page_access`, `location`, `rlname`, `email_new`, `email_new_time`, `email_code`, `next_email`, `last_post`, `flag`, `vote` FROM `accounts` WHERE `name` = '1'
SQLSTATE:    42S22
Driver code:    1054
Error message:    Unknown column 'group_id' in 'field list'

Fatal error: Call to a member function fetch() on a non-object in C:\xampp\htdocs\classes\account.php on line 33

 

[Raggaer]

You miss group_id field... How did you install your website? Seems a little bit broken.

ALTER TABLE accounts ADD group_id INT(11) NOT NULL DEFAULT 0;

From mobile so not tested