Search found 2 matches

by MindFreakz
Mon Nov 07, 2005 5:41 pm
Forum: SQL Parser
Topic: multiple-column primary key
Replies: 3
Views: 7956

Re: multiple-column primary key

I found another bug, this time, it's in the on-line conversion tool (don't know about the current easymod version). If you proces a string (with offcourse single-quotes), it doesn't addslashes to it, when it's creating the php-page: the query: INSERT INTO phpbb_chatbox (chat_name) VALUES ('Public ch...
by MindFreakz
Mon Oct 17, 2005 6:49 pm
Forum: SQL Parser
Topic: multiple-column primary key
Replies: 3
Views: 7956

multiple-column primary key

If you give a sql-statement, which contains a primairy key, that contains more than one column, EM gives a error. The sql runs fine using phpMyAdmin. CREATE TABLE phpbb_chatbox_auth ( `chat_id` int(11) NOT NULL, `group_id` int(11) NOT NULL, `speak` tinyint(3) default '0', PRIMARY KEY ( `chat_id`, `g...