Dhanashri, > ALTER TABLE `timesheet` ADD `phase_desc` VARCHAR( 50 ) > Error on rename of '.\etime\timesheet.MYI' to '.\etime\#sql2-64c-19.MYI' > (Errcode: 13)
I had the same kind of problem with ALTER TABLE and MySQL < 4.0.5 under Win2K. Errorcode 13 means it's a permission problem. I never solved this problem, but it disappeared an never returned after I upgraded to 4.0.5. I you do not want to upgrade to version 4 (for whatever reason, as it runs stable as rock), you might want to use the workaround I used: CREATE TABLE timesheetCopy SELECT * FROM timesheet; DROP TABLE timesheet; RENAME TABLE timesheetCopy TO timesheet; ALTER TABLE timesheet ADD phase_desc VARCHAR(50); For some strange reason, I never encountered permission errors with copied tables, only with the original ones. > My phpMySQL version is 3.23.55-nt Well, that's rather your MySQL version. See above what I said about upgrading. Regards, -- Stefan Hinz <[EMAIL PROTECTED]> Geschäftsführer / CEO iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 ----- Original Message ----- From: "Dhanashri Peramanu" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, January 27, 2003 10:25 PM Subject: MySQL error (Errcode: 13) > Anybody have an idea about the following error (Errcode: 13)? I am simply > trying to add one more field in the table timesheet. > My phpMySQL version is 3.23.55-nt > > Thanks. > > -Dhanashri Peramanu > > > > ---------------------------------------------------------------------- ------ > ---------------------------------------------------------------------- ------ > ------------------------------------------ > > Error > > SQL-query : > > ALTER TABLE `timesheet` ADD `phase_desc` VARCHAR( 50 ) > > MySQL said: > > > Error on rename of '.\etime\timesheet.MYI' to '.\etime\#sql2-64c-19.MYI' > (Errcode: 13) > > > ---------------------------------------------------------------------- ------ > ---------------------------------------------------------------------- ------ > --------------------------------------------- > > > > > --------------------------------------------------------------------- > 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 > --------------------------------------------------------------------- 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
