ID: 10394 User Update by: [EMAIL PROTECTED] Status: Open Bug Type: MySQL related Description: mysql_query() dosen't stable! Previous Comments: --------------------------------------------------------------------------- [2001-04-19 05:55:43] [EMAIL PROTECTED] Hi, I have a table: CREATE TABLE boardlist ( board_id int(11) DEFAULT '0' NOT NULL, header_inc mediumtext NOT NULL, footer_inc mediumtext NOT NULL, board_width varchar(10) NOT NULL, board_align varchar(10) NOT NULL, name varchar(50) NOT NULL, description varchar(255) NOT NULL, admin varchar(20) NOT NULL, password varchar(20) NOT NULL, email varchar(50) NOT NULL, mail_reply tinyint(4) DEFAULT '0' NOT NULL, color1 varchar(20) NOT NULL, color2 varchar(20) NOT NULL, color3 varchar(20) NOT NULL, color4 varchar(20) NOT NULL, color5 varchar(20) NOT NULL, img_id tinyint(4) DEFAULT '0' NOT NULL, btn_id tinyint(4) DEFAULT '0' NOT NULL, rows tinyint(4) DEFAULT '10' NOT NULL, pages tinyint(4) DEFAULT '10' NOT NULL, image_path1 varchar(50) NOT NULL, image_path2 varchar(50) NOT NULL, image_path3 varchar(50) NOT NULL, id_check tinyint(4) DEFAULT '0' NOT NULL, writer_check tinyint(4) DEFAULT '0' NOT NULL, date_check tinyint(4) DEFAULT '0' NOT NULL, point_check tinyint(4) DEFAULT '0' NOT NULL, counter_check tinyint(4) DEFAULT '0' NOT NULL, image_check tinyint(4) DEFAULT '0' NOT NULL, text_check tinyint(4) DEFAULT '0' NOT NULL, color_check tinyint(4) DEFAULT '0' NOT NULL, bg_image_check tinyint(4) DEFAULT '0' NOT NULL, bg_color_check tinyint(4) DEFAULT '0' NOT NULL, usertype tinyint(4) DEFAULT '0' NOT NULL, write_check tinyint(4) DEFAULT '0' NOT NULL, update_check tinyint(4) DEFAULT '0' NOT NULL, delete_check tinyint(4) DEFAULT '0' NOT NULL, reply_check tinyint(4) DEFAULT '0' NOT NULL, upload_check tinyint(4) DEFAULT '0' NOT NULL, PRIMARY KEY (board_id) ); ------------ and use: $board_id=2; $sql="insert boardlist(board_id, header_inc, footer_inc, board_width, board_align, name, description, admin, password, email, mail_reply, color1, color2, color3, color4, color5, img_id, btn_id, rows, pages, image_path1, image_path2, image_path3, id_check, writer_check, date_check, point_check, counter_check, image_check, text_check, color_check, bg_image_check, bg_color_check, usertype,write_check, update_check, delete_check, reply_check, upload_check) values('$board_id', '', '', '80%', 'left', 'Board', 'Board', 'admin', '1323', '', '0', '#7DA7D9', '#E1E1FA', '#FFFFFF', '#D0D0FC', '#D0D0FC', '1', '1', '10', '10','http://user.chollian.net/~dawn0121/icon.htm', '', '', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', '1', '1', '1', '1', '1');"; //$sql="insert into boardlist(board_id) values(".$board_id.")"; mysql_query($sql) or die(mysql_error()."<br>sql==".$sql); echo $sql; ------------------ Sometime it works (inserts ok) but sometime doesn't (without notice an error!). When it doesn't, I copy the sql statement from echo $sql result, paste into mysql command line,and run, but it always works!! --------------------------------------------------------------------------- Full Bug description available at: http://bugs.php.net/?id=10394 -- PHP Development Mailing List <http://www.php.net/> To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]