Error #1005 when reordering columns

This topic is empty.

Viewing 6 reply threads

Author

Posts
- December 3, 2004 at 7:40 pm #8683
  
  Visionweaver
  Member
  
  When trying to reorder the columns in a table of my database, the following error occurs:
  
  Error No. 1005
  
  Can't create table '/var/tmp/#sql/3097_3b608_3.frm' (errno. 140)
  
  I am using the trial Enterprise version, which I believe is the final v. 4.0 release
  
  Any ideas what is wrong?
- December 6, 2004 at 3:23 am #16631
  
  Ritesh
  Member
  
  Which version of MySQL?
- December 7, 2004 at 4:19 pm #16632
  
  Visionweaver
  Member
  
  The version of MySQL is 4.0.23 on the FreeBSD platform.
- December 7, 2004 at 5:18 pm #16633
  
  Ritesh
  Member
  
  I have forwarded the issue to my development team.
  
  I will let you know about the progress soon.
- December 17, 2004 at 4:05 am #16634
  
  Ritesh
  Member
  
  Are you using SQLyog Enterprise 4.0 FINAL version? A similar bug was fixed in one of the BETA releases of SQLyog Enterprise.
  
  BTW, can you just cut-n-paste the CREATE TABLE stmt. for the table?
- January 21, 2005 at 3:20 pm #16635
  
  zzapper
  Member
  
  Ritesh,
  
  altho i've reordered tables successfully b4, I am now getting this error with yogent4.0
  
  SQLyog Enterprise Ã—
  
  Error No. 1005
  
  Can't create table 'c:TEMP#sql10c_c_1.frm' (errno: 140)
  
  just about to try 4.1
  
  sorry still in 4.1
  
  it's a real simple table
  
  Field Type Null Key Default Extra
  
  ID mediumint(9) PRI (NULL) auto increment
  
  DivisionID char(3) YES (NULL)
  
  DivisionName varchar(30) YES (NULL)
  
  DivisionEmail varchar(50) YES (NULL)
  
  DivisionPhone varchar(20) YES (NULL)
  
  AssertaCode varchar(10) YES (NULL)
  
  divisionShortName varchar(20) YES (NULL)
- January 23, 2005 at 7:13 pm #16636
  
  peterlaursen
  Participant
  
  It could be an issue with the setting of the max_allowed_packet parameter in your mysql configuration file (my.ini)
  
  Try raising the value signifikcantly. You'll have to stop and restart the Mysql server for the changes to take effekt.
Author

Posts