7 messages in com.mysql.lists.win32Cannot edit row in table
FromSent OnAttachments
Chris Mendis09 Mar 2004 13:55 
Chris Mendis09 Mar 2004 14:03 
Petr Vileta09 Mar 2004 17:01 
Chris Mendis11 Mar 2004 06:19 
Chris Mendis11 Mar 2004 06:32 
Petr Vileta11 Mar 2004 07:15 
Chris Mendis11 Mar 2004 07:46 
Subject:Cannot edit row in table
From:Chris Mendis (Chri@camh.net)
Date:03/09/2004 01:55:41 PM
List:com.mysql.lists.win32

I'm running MySQL 4.4.0-dev on Windows 2000 Advanced Server. I just edited a row in a table, and now when I try to edit that row again nothing seems to happen. I click on the Edit button next to the row, and the link doesn't go anywhere. I can still edit the other rows in that table.

I tried flushing the table, but to no avail. I did a table check, and it came up okay. Any ideas?

Here's a dump of the table:

# phpMyAdmin MySQL-Dump # version 2.2.3 # http://phpwizard.net/phpMyAdmin/ # http://phpmyadmin.sourceforge.net/ (download page) # # Host: localhost # Generation Time: Mar 09, 2004 at 04:54 PM # Server version: 3.23.49 # PHP Version: 4.4.0-dev # Database : `partnerships` # --------------------------------------------------------

# # Table structure for table `camh_fieldinfo` #

CREATE TABLE camh_fieldinfo ( id mediumint(9) NOT NULL default '0', fieldname varchar(255) NOT NULL default '', displayname varchar(255) NOT NULL default '', inputtype varchar(255) NOT NULL default '', inputvalues text NOT NULL, doallowother tinyint(4) NOT NULL default '0', inputrule varchar(255) NOT NULL default '', ismandatory tinyint(4) NOT NULL default '0', comparison varchar(255) NOT NULL default '', dopublicsearch tinyint(4) NOT NULL default '0', doallowmultiple tinyint(4) NOT NULL default '0' ) TYPE=MyISAM;

# # Dumping data for table `camh_fieldinfo` #

INSERT INTO camh_fieldinfo VALUES (230, 'camh_program', 'Program/Department Name', 'select', 'Clinical Programs - Addictions Programs^Clinical Programs - Concurrent Disorders Program^Clinical Programs - Child, Family and Youth Program^Clinical Programs - Community Support and Research Unit^Clinical Programs - Dual Diagnosis Program^Clinical Programs - General Psychiatry Program^Clinical Programs - Law and Mental Health Programs^Clinical Programs - Mood and Anxiety Program^Clinical Programs - Neuro & Geriatric Psychiatry Program^Clinical Programs - Schizophrenia Program^Clinical Programs - Women\'s Mental Health Program^Corporate Services - Business Development^Corporate Services - Facilities Planning and Development^Corporate Services - Finance/Procurement^Corporate Services - Human Resources^Corporate Services - Information Management^Corporate Services - Occupational Healt, Safety and Risk Management^Corporate Services - Organizational Development and French Language Services^Corporate Services - Site Redevelopment^Corporate Services - Support Services^Corporate Services - Volunteer Services / Spiritual & Religious Care^Research - Clinical Research^Research - Neuroscience^Research - PET Centre^Research - Social, Prevention and Health Policy^CECH - Education and Publishing^CECH - Library^CECH - Public Affairs^CECH - Public Education and Information Services^CECH - North Region^CECH - Central East Region^CECH - West Region^CECH - Divisional Office^Community Relations - Community Relations^Community Relations - Diversity Programs Office', 1, '', 1, 'substring', 1, 0); INSERT INTO camh_fieldinfo VALUES (240, 'camh_keycontact', 'CAMH Key Contact (Name, Phone, e-mail)', 'text', '', 0, '', 1, '', 1, 0); INSERT INTO camh_fieldinfo VALUES (260, 'camh_strategicdirection', 'Strategic Direction', 'select', 'Improving Care and Enhancing Health^Discovering, Sharing and Applying New Knowledge^Influencing Public Policy and Promoting Positive System Change^Being the Best Place to Work and Learn^Ensuring Long Term Sustainability and Development^Providing Effective Information Management Systems and Technology^Developing Innovative Facilities', 0, '', 1, 'substring', 1, 1);

Thanks,