through the database manager as a user I create 2 tables with a query and add stuff into it. However it always returns with error syntax.
Then I go to phpmyadmin... execute the same queries...and....no problems.
It doesn't matter on what domain or as which user I use the webmin module or what query i drop into it. Alway syntax errors, while phpmyadmin simply executes without failure.
Is there a setting I need to click on to make the module work? Or is there some bug? Pls explain in detail what I should do (Im a DBM novice)
centos 5.1 VM Pro Latest versions of eveything
[code:1]CREATE TABLE categories (
id int(2) NOT NULL auto_increment,
name varchar(100) NOT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
CREATE TABLE news (
id int(7) NOT NULL auto_increment,
title varchar(240) NOT NULL,
text text NOT NULL,
cat varchar(100) NOT NULL,
main int(1) NOT NULL,
time int(15) NOT NULL,
UNIQUE KEY id (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;[/code:1]