Request Fix?

Sentinos Posts : 43 Join date : 2008-03-21

alrite well I am missing something I think. I am getting this query error in my server every so often.

"Sql query failed due to [Table 'character2.mailbox_insert_queue' doesn't exist]

So apparently i am missing a table? But ehh I am looking in my character database and it is umm rite in front of me.

Subject: Re: Request Fix? Sat Mar 22, 2008 8:00 pm

Post the SQL you're trying to query.

Sentinos Posts : 43 Join date : 2008-03-21

Oh no I am not querying anything. I am actually requesting for a query to fix this error. This error appears in the ascent console.

Subject: Re: Request Fix? Sat Mar 22, 2008 8:42 pm

Maybe you need to make a new table, because I don't see any table called 'character2.mailbox_insert_queue' in my DB, but there is a mailbox_insert_queue..

Sentinos Posts : 43 Join date : 2008-03-21

Yeah I know character2 is my database. So what i think this warning is saying is that in my character2 database it cannot find the table. But what i am saying is that the table is rite in my database.

Subject: Re: Request Fix? Sat Mar 22, 2008 11:58 pm

Hmm you'll have to ask Rous, I only know so much about that stuff =[ Sorry! scratch

Sentinos Posts : 43 Join date : 2008-03-21

Calls out for Rous!! Rous please help me out here.

CN Elite Posts : 37 Join date : 2008-03-21

HalestormXV wrote:: Calls out for Rous!! Rous please help me out here.

ok i asked rous and you need this

If you have mailbox_insert_queue already in your database, delete the table. and execute this query

Code:: CREATE TABLE `mailbox_insert_queue` (
`sender_guid` int(30) NOT NULL,
`receiver_guid` int(30) NOT NULL,
`subject` varchar(200) NOT NULL,
`body` varchar(500) NOT NULL,
`stationary` int(30) NOT NULL,
`money` int(30) NOT NULL,
`item_id` int(30) NOT NULL,
`item_stack` int(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Sentinos Posts : 43 Join date : 2008-03-21

Alrite well.....now after i deleted it it sasys it still exisits and cannot create the table.....So do you hapen to have the query to delete the table so i can run that first and then run the create one...This is ridiculolus lol why do i always get this problems

CN Elite Posts : 37 Join date : 2008-03-21

HalestormXV wrote:: Alrite well.....now after i deleted it it sasys it still exisits and cannot create the table.....So do you hapen to have the query to delete the table so i can run that first and then run the create one...This is ridiculolus lol why do i always get this problems

ok delete the table manualy. Like click on it and DEL

then exit your SQleditor. Reopen databse and execute the query

Sentinos Posts : 43 Join date : 2008-03-21

That is what I did then I restarted SQL, and ran the query and it says that the table already exisits.......and well it is no longer on the list becasue i deleted it.. Lol.

» Signature Request
» *REQUEST* Enchancer Vendors
» [REQUEST] Textureing/Skinning Guide