Chapter 10 Cannot Delete Character

lucius · June 19th, 2007, 02:48 PM

I can create characters, edit characters, add powers, and edit powers, but when I try to delete a character it tells me:

Unknown table 'char_main' in MULTI DELETE

That is the name of the table.

Any ideas?

anabnl · August 16th, 2007, 05:36 PM

thanx for giving information .

fast0track · October 24th, 2007, 11:04 AM

I've got the same error message as well, I've compared the code twice from the book, tested the sql code that character in Ms-dos and same error message. The problem lies in the SQL code.

SQL:
====
DELETE FROM char_main, char_liar
USING char_main m, char_lair l
WHERE m.lair_id = l.id AND m.id = $cid;

Can someone verify this? Still need an answer to this problem.

happyness · February 5th, 2008, 12:45 AM

I have got the same error. And I have modified the code following #2 of http://p2p.wrox.com/topic.asp?TOPIC_ID=35015, but got something like: Not unique table/alias: 'char_main'.

Thank you to anyone who can throw some light on this.