SQL

[Legato]

Everytime I use the Mailing NPC or @mail command this error shows up.

I found the sql queries for the mail inside the upgrade_svn11548.sql file. But it keeps on showing "Unknown column" for every queries when I execute it.

And inside the game I get this error "You have failed to mail a message. Recipient does not Exist"

[CalciumKid]

What compile version are you using?

This is also in the wrong section.

[whitesn]

You use newer version from eAthena or other emu yet you don't update your SQL databases.

Try injecting the updates from /compile/sql-files/ to your database and update it.

[Legato]

Apologies. Please, move it to the right section. Thanks.

I'm using 14908 and there's no /compile/ folder.

[whitesn]

i mean your trunk / stable folder.. Just go to sql-files folder and load the upgrade_svnXXXXX.sql ( version from your old compile until now

and inject it to your database )

[KeiKun]

Hi TS

i suggest you use the latest one

but if you will still use 14908

here's the thing

you don't need to inject "upgrade_svn11548.sql"

since main.sql already has it

--
-- Table structure for table `mail`
--
CREATE TABLE IF NOT EXISTS `mail` (
 `id` bigint(20) unsigned NOT NULL auto_increment,
 `send_name` varchar(30) NOT NULL default '',
 `send_id` int(11) unsigned NOT NULL default '0',
 `dest_name` varchar(30) NOT NULL default '',
 `dest_id` int(11) unsigned NOT NULL default '0',
 `title` varchar(45) NOT NULL default '',
 `message` varchar(255) NOT NULL default '',
 `time` int(11) unsigned NOT NULL default '0',
 `status` tinyint(2) NOT NULL default '0',
 `zeny` int(11) unsigned NOT NULL default '0',
 `nameid` int(11) unsigned NOT NULL default '0',
 `amount` int(11) unsigned NOT NULL default '0',
 `refine` tinyint(3) unsigned NOT NULL default '0',
 `attribute` tinyint(4) unsigned NOT NULL default '0',
 `identify` smallint(6) NOT NULL default '0',
 `card0` smallint(11) NOT NULL default '0',
 `card1` smallint(11) NOT NULL default '0',
 `card2` smallint(11) NOT NULL default '0',
 `card3` smallint(11) NOT NULL default '0',
 PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

btw

the /compile/ he meant

was /SVN/

where your rAthena files are found ( root )

[Legato]

Ohh. Hiya, Keikun. Yep, I saw that from main.sql. But, how is that I get that error everytime I try to mail someone.

2essy2killu, do I have to execute it all? Entries would be duplicated.

EDIT :

Is this the correct link for download for renewal?

Edited December 4, 2011 by Legato

[Z3R0]

This topic is currently under review

[KeiKun]

Ohh. Hiya, Keikun. Yep, I saw that from main.sql. But, how is that I get that error everytime I try to mail someone.

2essy2killu, do I have to execute it all? Entries would be duplicated.

EDIT :

Is this the correct link for download for renewal?

try to

truncate mail table

then if still error

try to re-execute the whole main.sql

and yes

thats rA's Renewal branch

[Squishyyy]

hes using 3ceam are we even supporting that?

[KeiKun]

i know thats its 3ceam

but 3CeAM came from eA Trunk

EDIT:

and i don't see 3CeAM doing an update with Mail System~

Edited December 4, 2011 by KeiKun

[Legato]

Yes. It's 3ceam based. And I wasn't asking anything about 3ceam.

Thank you, Keikun. Done doing that.

[whitesn]

Ohh. Hiya, Keikun. Yep, I saw that from main.sql. But, how is that I get that error everytime I try to mail someone.

2essy2killu, do I have to execute it all? Entries would be duplicated.

Impossible because all of the upgrade sql don't have CREATE command for the previouses

version that will do duplicate entries.. If it's failed just take CREATE table mail from main.sql

[MWestfall]

Umm, shouldn't the user be downloading directly from the RA SVN to avoid confusion a/o issues?