[Duvida] Help Aqui Plix

[484539 9]

Eala Gelara do XTibia (se estiver em areá errada peço que movam para areá correta PF)

 

 

Eu estou usando o PFiled 2.0 e editei 95% ele e tudo +

 

Mas acontece que, eu criei um site para meu serve e ate ai blz . mas ele aparece um erro assim que abre o server e assim que alguem tenta entra no server

 

Error :001 \/

[30/09/2011 23:33:13] mysql_real_query(): SELECT `id`, `name`, `password`, `viptime` as `premdays`, `lastday`, `key`, `warnings` FROM `accounts` WHERE `id` = 1 LIMIT 1 - MYSQL ERROR: Unknown column 'viptime' in 'field list' (1054)
[30/09/2011 23:33:13] mysql_real_query(): SELECT `id`, `name`, `password`, `viptime` as `premdays`, `lastday`, `key`, `warnings` FROM `accounts` WHERE `id` = 2 LIMIT 1 - MYSQL ERROR: Unknown column 'viptime' in 'field list' (1054)

 

*obs esse erro impede a entrada no server e tudo começou depois que criei um Site no MODERN ACC para ele

 

e gostaria de saber se essa duplicação de itens pode fazer com que derrube o server.

 

Error : 002

 

 

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2378

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2379

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2380

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2381

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2382

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2383

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2384

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2385

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2386

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2387

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2388

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2389

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2390

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2391

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2392

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2393

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2394

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2395

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2396

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2397

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2398

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2399

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2400

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2401

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2402

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2403

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2404

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2405

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2406

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2407

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2408

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2409

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2410

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2411

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2412

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2413

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2414

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2415

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2416

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2417

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2418

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2419

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2420

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2421

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2422

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2423

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2424

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2425

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2426

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2427

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2428

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2429

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2430

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2431

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2432

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2433

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2434

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2435

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2436

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2437

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2438

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2439

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2440

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2441

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2442

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2443

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2444

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2445

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2446

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2447

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2448

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2449

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2451

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2452

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2453

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2454

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2455

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2456

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2457

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2458

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2459

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2460

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2461

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2462

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2465

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2466

[30/09/2011 23:32:58] [Warning - Items::loadFromXml] Duplicate registered item with id 2467

[30/09/2011 23:32:59] [Warning - Items::loadFromXml] Duplicate registered item with id 2468

[30/09/2011 23:32:59] [Warning - Items::loadFromXml] Duplicate registered item with id 2469

[30/09/2011 23:32:59] [Warning - Items::loadFromXml] Duplicate registered item with id 2470

[30/09/2011 23:32:59] [Warning - Items::loadFromXml] Duplicate registered item with id 2471

[30/09/2011 23:32:59] [Warning - Items::loadFromXml] Duplicate registered item with id 2472

[30/09/2011 23:32:59] [Warning - Items::loadFromXml] Duplicate registered item with id 2473

[30/09/2011 23:32:59] [Warning - Items::loadFromXml] Duplicate registered item with id 2474

[30/09/2011 23:32:59] [Warning - Items::loadFromXml] Duplicate registered item with id 2475

[30/09/2011 23:32:59] [Warning - Items::loadFromXml] Duplicate registered item with id 2476

[30/09/2011 23:32:59] [Warning - Items::loadFromXml] Duplicate registered item with id 2477

[30/09/2011 23:32:59] [Warning - Items::loadFromXml] Duplicate registered item with id 2478

[30/09/2011 23:32:59] [Warning - Items::loadFromXml] Duplicate registered item with id 2479

 

 

 

Peço a que saiba arrumar me faça um mini tutorial explicando como arrumar esses erros + peço a colaboração de todos que ajudem com oque sabem toda ajuda é bem vinda já que o PokeRevolution Online é um server voltado ao bem estar dos players.

Agradeço desde já a atenção e a colaboração de todos.

[digo1040 56]

Eai, tudo bem?

Bom o primeiro erro diz que na tabela accounts não existe a coluna viptime, então simplesmente crie a coluna no banco de dados, ou procure o script que faça essa consulta.

Quanto ao segundo erro, simplesmente vá no items.xml e remova os duplicados, deixando somente uma tag pra cada item.

 

Qualquer duvida so postar

Editado Outubro 1, 2011 por Digaao

[484539 9]

Eai, tudo bem?

Bom o primeiro erro diz que na tabela accounts não existe a coluna viptime, então simplesmente crie a coluna no banco de dados, ou procure o script que faça essa consulta.

 

 

Mais como eu crio a colina no banco de dados ou esse script de consulta que vc me falo???

[digo1040 56]

Eai, para adicinar a coluna vá no seu banco de dados e execute esse sql:

ALTER TABLE  `accounts` ADD  `viptime` INT( 15 ) NOT NULL ;

E verificar os arquivos que eu digo é você ir nos creaturescripts e/ou globalevents e verificar se não há no script a consulta, se não for algo necessário apagá-lo.