Error En Worldserver

Trinity Localized Languages
1

[ERROR]: In mysql_stmt_prepare() id: 58, sql: “SELECT c.country FROM ip2nationCountries c, ip2nation i WHERE i.ip < ? AND c.code = i.country ORDER BY i.ip DESC LIMIT 0,1”

[ERROR]: Table ‘world.ip2nationCountries’ doesn’t exist

Alguien sabe a que se debe? cuando enciendo Wordserver me dice eso.

Saludos

2

Te debe faltar un update de TC.

Prueba el fichero: “2012_03_23_00_world_ip2nation.sql”

[CODE]DROP TABLE IF EXISTS ip2nation;

CREATE TABLE ip2nation (
ip int(11) unsigned NOT NULL default ‘0’,
country char(2) NOT NULL default ‘’,
KEY ip (ip)
);

DROP TABLE IF EXISTS ip2nationCountries;

CREATE TABLE ip2nationCountries (
code varchar(4) NOT NULL default ‘’,
iso_code_2 varchar(2) NOT NULL default ‘’,
iso_code_3 varchar(3) default ‘’,
iso_country varchar(255) NOT NULL default ‘’,
country varchar(255) NOT NULL default ‘’,
lat float NOT NULL default ‘0’,
lon float NOT NULL default ‘0’,
PRIMARY KEY (code),
KEY code (code)
);

[/sql][/CODE]

3

[B]Gildor[/B] tiene razon con eso ya deve solucionarse el problema…