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]