Jump to content
  • 0

Question

k9my8.png

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"

Link to comment
Share on other sites

13 answers to this question

Recommended Posts

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.

Link to comment
Share on other sites

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 )

Link to comment
Share on other sites

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 )

Link to comment
Share on other sites

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 by Legato
Link to comment
Share on other sites

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

Link to comment
Share on other sites

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 by KeiKun
Link to comment
Share on other sites

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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.



×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use and Privacy Policy.