mysql queries do not work

1 post / 0 new
#1 Wed, 02/20/2008 - 06:19
ronald's picture

mysql queries do not work

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 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]