From: Richard T. <rt...@my...> - 2002-11-13 14:43:16
|
Why can't I add or update records in version 5.0 or 5.1? To make sure it wasn't a problem with my table I used phpMyAdmin to create a simple test mysql table with 2 columns, making sure I have a primary key: CREATE TABLE `pme1` ( `id` INT( 3 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , `test` VARCHAR( 15 ) NOT NULL ); Then I use phpMyAdmin to insert two records. I run phpMyEditSetup.php: Hostname: localhost Username: root Password: password click Submit on my test database, Submit on my pme1 table, and Submit to accept the defaults showing "id" as the identifier (it shows not_null primary_key auto_increment). It says content file written successfully so I go to ./pme1.php where it shows me my table. I click Add, provide dummy values (including setting the id of 3 - the next auto_incrementing number) and it returns me to my table with no errors, but it did not add a record. If I select a record and click Change, modify the varchar field contents and click Save, it does not update the record. I CAN copy and delete. I can get it to work in version 4. Maybe it has something to do with the column types or idexes or where / = what type the primary key is? I even tried CVS code and on two different = systems - still no luck. Any ideas? |