#1244 (Errorcode: 13) occurs when trying to add new column(s).

[Anonymous]

Originally created by: yuthic....@gmail.com

What exact steps will reproduce the problem?
1. Open blahdb.blah_tbl
2. Select 'Table: blah_tbl' tab
3. add some column (like 'column_new2') next push 'Save' button.

What was the expected output?
column(s) newly added.

What happened instead?
Errorcode 13 occured. as following log:

ALTER TABLE `blah_tbl`  COMMENT='blah',  ADD COLUMN `column_new2` INT(10)
NULL DEFAULT NULL ;
/* SQL Error: Error on rename of '.\blahdb\blah_tbl.MYI'
to '.\blahdb\#sql2-2640-156.MYI' (Errcode: 13) */

this error has nothing to do with primary/auxiliary type,
default value(null/not null) and dataType.

Suggested fix (optional)?

Version used?
HeidiSQL revision: x.y, [r2504] (and older versions too)
MySQL Server version: 3.23.54-nt
Operating system: Windows XP Professional, SP3

[Anonymous]

Originally posted by: rosenfie...@gmail.com

It's an error string generated by the server.  I'm not sure what HeidiSQL could do
about that.

The only thing I can think of is parsing the error string with a regular expression,
matching the "(Errcode: #)" part, and looking up an accurate error message for you.

You can look up the error code manually with the "perror" utility that comes with
MySQL Server.  Quite unwieldy, but at least it's there ;-):

=======================================================
Z:\MySQL Server 5.0\bin>perror 13
OS error code  13:  Permission denied
=======================================================

Apparently the server is denied permission to rename files in the "blahdb" database
folder.

[Anonymous]

Originally posted by: a...@anse.de

(No comment was entered for this change.)

Status: Upstream