If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > MySQL > Error Altering Table

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 12-10-03, 16:45
dbman007 dbman007 is offline
Registered User
 
Join Date: Jan 2003
Posts: 6
Error Altering Table

When I run the following command:
ALTER staff ADD status char(1)

mySQL returns the following error:

Error on rename of '.\Common\staff.MYI' to '.\Common\#sql2-6a-2fc3.MYI' (Errcode: 13)

What is the problem?

Thankyou.
Reply With Quote
  #2 (permalink)  
Old 12-11-03, 15:03
ika ika is offline
Registered User
 
Join Date: Oct 2003
Location: Slovakia
Posts: 482
Re: Error Altering Table

Quote:
Originally posted by dbman007
When I run the following command:
ALTER staff ADD status char(1)

mySQL returns the following error:

Error on rename of '.\Common\staff.MYI' to '.\Common\#sql2-6a-2fc3.MYI' (Errcode: 13)

What is the problem?

Thankyou.
Problem is between chair and monitor :-)))
Now seriously. Problem is in the syntax of command.
The right command is following:
alter table staff add column status char(1);

More at url: http://www.mysql.com/doc/en/ALTER_TABLE.html
Reply With Quote
  #3 (permalink)  
Old 12-11-03, 15:43
dbman007 dbman007 is offline
Registered User
 
Join Date: Jan 2003
Posts: 6
Re: Error Altering Table

Quote:
Originally posted by ika
Problem is between chair and monitor :-)))
Now seriously. Problem is in the syntax of command.
The right command is following:
alter table staff add column status char(1);

More at url: http://www.mysql.com/doc/en/ALTER_TABLE.html
I tried it exactly as above and till gives me the same error.
Reply With Quote
  #4 (permalink)  
Old 12-11-03, 16:21
ika ika is offline
Registered User
 
Join Date: Oct 2003
Location: Slovakia
Posts: 482
Re: Error Altering Table

Quote:
Originally posted by dbman007
I tried it exactly as above and till gives me the same error.
Hmmm... this seems to be a bug in the MySQL product.

OK
1.What version you are running?
2. What Operating system you are runnig?
Reply With Quote
  #5 (permalink)  
Old 12-11-03, 16:46
dbman007 dbman007 is offline
Registered User
 
Join Date: Jan 2003
Posts: 6
OS = Windows 2000
mySQL = 3.23.47-nt
Reply With Quote
  #6 (permalink)  
Old 12-11-03, 17:00
ika ika is offline
Registered User
 
Join Date: Oct 2003
Location: Slovakia
Posts: 482
Quote:
Originally posted by dbman007
OS = Windows 2000
mySQL = 3.23.47-nt
Solution:
http://www.mysql.com/doc/en/ALTER_TABLE_problems.html
Reply With Quote
  #7 (permalink)  
Old 12-17-03, 13:21
dbman007 dbman007 is offline
Registered User
 
Join Date: Jan 2003
Posts: 6
I read the man page but can not find any a- or b- files. I did notice that my error code was different from the example on the man page.

Mine is error: 13 and the example is error: 17. Were can I find the meaning of these codes?
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On