|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
|
|||
|
|||
|
Phpmyadmin INSERT error
I have just upgraded to Apache 2.2, Mysql 5 and PHP 5.2. When I do a manual insert into phpmyadmin data base the id will not auto increment. The following error is returned:
#1366 - Incorrect integer value: '' for column 'id' at row 1 I have set the field to read as id, int, not null, auto_increment, primary key. Is it a bug? How do I fix it? ![]() |
|
#2
|
|||
|
|||
|
This is the Export SQL. Data is only added to db if I insert by using a form or if I manually add the next id number. I did not have to add the id number manually before I upgraded and can't work out why it is happening now. Any suggestions would be helpful.
phpMyAdmin SQL Dump -- version 2.6.3-pl1 -- (URL address blocked: See forum rules) -- -- Host: localhost -- Generation Time: May 12, 2007 at 09:37 AM -- Server version: 5.0.37 -- PHP Version: 5.2.1 -- -- Database: `school_2007` -- -- -------------------------------------------------------- -- -- Table structure for table `testing` -- CREATE TABLE `testing` ( `id` int(11) NOT NULL auto_increment, `name` varchar(50) NOT NULL, `address` varchar(50) NOT NULL, `town` varchar(50) NOT NULL, `phone` varchar(20) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ; -- -- Dumping data for table `testing` -- INSERT INTO `testing` VALUES (2, 'sue', 'wilmot rd', 'glen alvie', '098878755434'); INSERT INTO `testing` VALUES (3, 'Lizzie', 'The Couch', 'Dullsville', '000000000000'); INSERT INTO `testing` VALUES (4, 'Trev', 'fjasfjfj', 'jgdsgjsdgj', '35723857'); |
![]() |
| Viewing: Dev Articles Community Forums > Databases > Database Development > Phpmyadmin INSERT error |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|