ever since i bought a server, i've been having ridiculous problems with it. it constantly crashes and my server admin says it's because i'm using up too many resources.... i think the version of mysql is really messed up, for the following reason:
whenever i use phpMyAdmin, the queries do not work. i try to do something, and it executes at least two times. example:
PHP Code:
Error
SQL-query :
CREATE TABLE `test_table` (
`id` INT NOT NULL AUTO_INCREMENT ,
`field1` VARCHAR( 255 ) NOT NULL ,
`field2` INT NOT NULL ,
`id` INT NOT NULL AUTO_INCREMENT ,
`field1` VARCHAR( 255 ) NOT NULL ,
`field2` INT NOT NULL ,
PRIMARY KEY ( `id` )
) CHARACTER SET = latin1
MySQL said:
#1060 - Duplicate column name 'id'
the charset also refuses to be set to anything but latin1, which has resulted in really screwing up my tables, which have all become corrupted. this happens with whatever type of query i try to do... update, drop, etc. do you think this duplicate query problem is the fault of myPhpAdmin, or is it a mysql problem?
Bookmarks