Precacher - Missing file errors

[Silvercloud]

got it imported with heidiSQL... thats a nice GUI.... running test in MYSQL now...

[Silvercloud]

Ok now the feat queue time is down to a mere 10 seconds.... so yes... something in sqlite isn't that happy about the way the PRC convocc works...

guess i could change everything to mysql to solve the issue...

[Silvercloud]

Hmmm... heatstroke could you help me out with the other SQL i dont know what is different between SQLite and MYSQL, and I exported my tables into SQL format, but it is being denied as not being correct format... If you could be so kind to help me insert these tables i would be all done...

CREATE TABLE bankdata(
player varchar(64) NOT NULL default '~',
tag varchar(64) NOT NULL default '~',
name varchar(64) NOT NULL default '~',
val text,
expire int(11) default NULL,
last timestamp(14) NOT NULL default current_timestamp,
PRIMARY KEY (player,tag,name)
);
CREATE TABLE pwdata(
player varchar(64) NOT NULL default '~',
tag varchar(64) NOT NULL default '~',
name varchar(64) NOT NULL default '~',
val text,
expire int(11) default NULL,
last timestamp(14) NOT NULL default current_timestamp,
PRIMARY KEY (player,tag,name)
);
CREATE TABLE pwobjdata (
        player varchar(64) NOT NULL default '~',
        tag varchar(64) NOT NULL default '~',
        name varchar(64) NOT NULL default '~',
        val blob,
        expire int(11) default NULL,
        last timestamp NOT NULL default current_timestamp,
        PRIMARY KEY (player,tag,name)
        );
CREATE TABLE tbl_questdata(
   ID                   int auto_increment,
   player_acct          varchar(64) NOT NULL DEFAULT '',
   player_character     varchar(64) NOT NULL DEFAULT '',
   szPlotID             varchar(32) NOT NULL DEFAULT '',
   szPlotState          varchar(4) NOT NULL DEFAULT ''
);
CREATE TABLE timedata(
player varchar(64) NOT NULL default '~',
tag varchar(64) NOT NULL default '~',
name varchar(64) NOT NULL default '~',
val text,
expire int(11) default NULL,
last timestamp(14) NOT NULL default current_timestamp,
PRIMARY KEY (player,tag,name)
);

[DM Heatstroke]

I'm afraid I don't know enough about SQL to craft an insert statement for all that.  I really don't know anything about SQLite at all.  No idea how to convert between the two.

When you import out.sql into MySQL thru a GUI, there should be a way force it to create the tables & schemas you need upon import.

[Silvercloud]

Thanks for looking at it anyway... I found out by posting on another forum... so its all good...! thanks to you both for the efforts, I'm off to beta-test