Unable to add/ edit records - Help needed!
Hi, We have been using a simple mySQL database successfully for some time. The database has a couple of tables and 1000 records in the primary table. It has been well behaved and performing well. Development record maintenance is taking place locally under Delphi/ dbExpress applications and on a web site using php. All of a sudden we can no longer add/ edit records. One tell tale message is that we constantly get error dialogs Action not possible on a uni-directional database I have repaired the database etc. But we haven't changed anything in the mySQL installations, development environments etc. I have removed all keys (except and autoinc primary key) and restrictions on the records and fields. The problem persists. I'm stumped and I'd be most grateful if someone could point me in the direction of a solution. Thanks -- Pierre du Parté Final Filer Software 349 Worrigee Road Worrigee, NSW, Australia 2540 http://www.finalfiler.com Phone 61 2 44216374 Mobile 0413 483 066 If it feels good, do it! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Unable to add/ edit records - Help needed!
Nevermind- I just re-installed mySQL and rebooted. everything works again. Pierre Pierre du Parte wrote: Hi, We have been using a simple mySQL database successfully for some time. The database has a couple of tables and 1000 records in the primary table. It has been well behaved and performing well. Development record maintenance is taking place locally under Delphi/ dbExpress applications and on a web site using php. All of a sudden we can no longer add/ edit records. One tell tale message is that we constantly get error dialogs Action not possible on a uni-directional database I have repaired the database etc. But we haven't changed anything in the mySQL installations, development environments etc. I have removed all keys (except and autoinc primary key) and restrictions on the records and fields. The problem persists. I'm stumped and I'd be most grateful if someone could point me in the direction of a solution. Thanks -- Pierre du Parté Final Filer Software 349 Worrigee Road Worrigee, NSW, Australia 2540 http://www.finalfiler.com Phone 61 2 44216374 Mobile 0413 483 066 If it feels good, do it! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php