Bug in ODBC import

[Shadow]

I have bumped into a minor bug in ODBC import: in case of table copy you want to import a table which name matches the name of one of the already existing table in the MySql db, SQLyog will fail. It should rather display a warning, that a table with that name already exists, and perhaps it should offer two options wether you want to override the existing table or not.

Conditions: import from MSAccess 2000 to MySql 4.0.12 on Win2K by SQLyog 3.11.

[Ritesh]

Quote:

SQLyog will fail

Do you mean that SQLyog is crashing?

You can override an existing table during ODBC Import. Click on the Transform button for the specified table in the Select Table(s)… page of the wizard. Check the Drop and Recreate Table… option in the Column Mapping and Transformation dialog.

HTH

[Shadow]

Yep, that's what I have meant, SQLyog crashes when I would like to select the table with the matching name from the list. So, it crashes BEFORE the Transformation button would appear, not to mention the “Column mapping and transformation” dialog.

I let Dr Watson to complete its error log (the word you won't understand are in Hungarian, but I provided the translations – hope accurately enough):

(the end of the processlist)

1652 SQLyog.exe

1760 drwtsn32.exe

0 _Total.exe

(00400000 – 004A8000)

(77F80000 – 77FFC000)

(77E80000 – 77F39000)

(77E10000 – 77E75000)

(77F40000 – 77F7C000)

(76AE0000 – 76B1D000)

(70BD0000 – 70C35000)

(78000000 – 78046000)

(77DB0000 – 77E0D000)

(770F0000 – 77161000)

(71710000 – 71794000)

(77560000 – 777AA000)

(77A50000 – 77B45000)

(779B0000 – 77A4B000)

(1F7B0000 – 1F7E1000)

(10000000 – 10043000)

(74FE0000 – 74FE9000)

(74FC0000 – 74FD3000)

(74FB0000 – 74FB8000)

(1F850000 – 1F866000)

(77260000 – 772CC000)

(6E360000 – 6E366000)

(75E00000 – 75E1A000)

(77810000 – 7781C000)

(77980000 – 779A4000)

(772F0000 – 77303000)

(774D0000 – 774D5000)

(772D0000 – 772E7000)

(750E0000 – 750F0000)

(75100000 – 7514F000)

(77BE0000 – 77BEF000)

(75150000 – 75156000)

(77950000 – 7797A000)

(77360000 – 7738E000)

(77330000 – 77352000)

(77800000 – 7780E000)

(77860000 – 778EF000)

(77C10000 – 77C6F000)

(77490000 – 774C2000)

(77470000 – 77481000)

(774E0000 – 77502000)

(77310000 – 77329000)

(777B0000 – 777B8000)

(777C0000 – 777C5000)

(74F60000 – 74F7D000)

(74FA0000 – 74FA7000)

(68B40000 – 68BC5000)

(77820000 – 7785E000)

(77070000 – 77093000)

(76F50000 – 76F5F000)

(77390000 – 773A5000)

(71160000 – 7125D000)

(013F0000 – 01539000)

(1F8F0000 – 1F932000)

(1B000000 – 1B16F000)

(1B5C0000 – 1B655000)

(1F8E0000 – 1F8EF000)

(1B2C0000 – 1B2CD000)

(1B2D0000 – 1B2F9000)

(1F800000 – 1F818000)

(777F0000 – 777F7000)

(75950000 – 75956000)

(1B7F0000 – 1B82A000)

(0F9A0000 – 0F9AB000)

(0F9C0000 – 0FA22000)

A szál (azonosító: 0x4b4) állapotlistája: – thread (id 0x4b4) state:

eax=00000001 ebx=002205d2 ecx=00454c68 edx=ffff7561 esi=00000000 edi=00000000

eip=00448cfe esp=0012e6c8 ebp=0012eaf8 iopl=0 nv up ei pl nz na pe nc

cs=001b ss=0023 ds=0023 es=0023 fs=0038 gs=0000 efl=00000202

függvény: -function:

00448ce6 56 push esi

00448ce7 8a11 mov dl,[ecx] ds:00454c68=61

00448ce9 8b7c2410 mov edi,[esp+0x10] ss:00c0bc9b=????????

00448ced 84d2 test dl,dl

00448cef 7469 jz 0045175a

00448cf1 8a7101 mov dh,[ecx+0x1] ds:00f3223a=??

00448cf4 84f6 test dh,dh

00448cf6 744f jz 00451847

00448cf8 8bf7 mov esi,edi

00448cfa 8b4c2414 mov ecx,[esp+0x14] ss:00c0bc9b=????????

HIBA ->00448cfe 8a07 mov al,[edi] ds:00000000=?? <-ERROR 00448d00 46 inc esi 00448d01 38d0 cmp al,dl 00448d03 7415 jz 0045111a 00448d05 84c0 test al,al 00448d07 740b jz 00451714 00448d09 8a06 mov al,[esi] ds:00000000=?? 00448d0b 46 inc esi 00448d0c 38d0 cmp al,dl 00448d0e 740a jz 0045111a 00448d10 84c0 test al,al 00448d12 75f5 jnz 0044ec09 *—-> Az egymásba ágyazott függvényhívások (fordított sorrendben) <----* *—->Nested function calls (in reverse order) <----* FramePtr ReturnAd Param#1 Param#2 Param#3 Param#4 Function Name 0012EAF8 0040CBDC 00000000 002205D2 00000003 00000000 !

0012F320 0040C4B7 00000000 0012F340 00E430E0 00454100 !

0012F3C4 0040BE55 00000000 00454100 00E42AF8 00000000 !

0012F3DC 00403EF1 001405DA 00000002 00000000 00454100 !

0012F400 00402E4F 00000000 00000000 00000201 00E42AF8 !

0012F448 004017F2 00000001 00180025 0012F578 0012F580 !

0012F464 77E11D0A 001405DA 00000201 00000001 00180025 !

0012F484 77E11BC8 0040164E 001405DA 00000201 00000001 user32!DispatchMessageW

0012F510 77E11CEF 0012F578 00000000 77E1ACA5 0012F578 user32!GetAppCompatFlags2

0012F540 71749972 001A049E 006124C0 000003FC 00141A60 user32!DispatchMessageW

0012F55C 7174B306 00141A60 0012F578 00141B6C 00141A60 comctl32!Ordinal389

0012F5B8 7174B517 0014DAE0 0012F7C0 0012F7C0 0012F86C comctl32!Ordinal389

0012F5D0 7174B56B 0012F5E4 00000007 180106B7 00000034 comctl32!Ordinal164

0012F618 0040B270 0012F7C0 77E172B7 0012F86C 00E41FF8 comctl32!PropertySheetA

0012F840 00409C4D 00E409FC 00439D77 00400000 00220450 !

0012FAF0 0042307C 00E41F28 77E12521 0025044E 00139EE0 !

0012FCFC 004217D4 00009D22 C0000000 00000111 0063D070 !

0012FD18 77E11D0A 0025044E 00000111 00009D22 002304D0 !

0012FD38 77E1350E 00421545 0025044E 00000111 00009D22 user32!DispatchMessageW

0012FD68 77E137A6 0063D070 00000111 00009D22 002304D0 user32!DefWindowProcW

0012FD88 7175D72E 0025044E 00000111 00009D22 002304D0 user32!SendMessageW

0012FDCC 7171A263 00139EE0 002304D0 00000202 00009D22 comctl32!CreateToolbar

0012FE38 77E11D0A 002304D0 00000202 00000000 000B000E comctl32!Ordinal320

0012FE58 77E11BC8 71719926 002304D0 00000202 00000000 user32!DispatchMessageW

0012FEE4 77E172B4 0012FF08 00000001 00446B00 0012FF08 user32!GetAppCompatFlags2

0012FF34 00449999 00E41F28 00000000 00133335 00000001 user32!DispatchMessageA

0012FFC0 77E9CA90 00000000 00000000 7FFDF000 C0000005 !

0012FFF0 00000000 004498CB 00000000 000000C8 00000100 kernel32!CreateProcessW

*—-> A veremtár tartalma <----* *—->Contents of the stack <----* 0012e6c8 10 a5 e3 00 d2 05 22 00 – 00 41 45 00 c6 fe 40 00 ……”..AE…@. 0012e6d8 00 00 00 00 68 4c 45 00 – 00 00 00 00 e0 30 e4 00 ….hLE……0.. 0012e6e8 6c f8 12 00 73 68 6f 77 – 20 66 69 65 6c 64 73 20 l…show fields 0012e6f8 66 72 6f 6d 20 60 6d 64 – 62 32 60 2e 60 54 e1 62 from `mdb2`.`T.b 0012e708 6c 61 31 60 00 00 00 00 – 00 00 00 00 00 00 00 00 la1`………… 0012e718 00 00 00 00 00 00 00 00 – 00 00 00 00 00 00 00 00 ……………. 0012e728 00 00 00 00 00 00 00 00 – 00 00 00 00 00 00 00 00 ……………. 0012e738 00 00 00 00 00 00 00 00 – 00 00 00 00 00 00 00 00 ……………. 0012e748 00 00 00 00 00 00 00 00 – 00 00 00 00 00 00 00 00 ……………. 0012e758 00 00 00 00 00 00 00 00 – 00 00 00 00 00 00 00 00 ……………. 0012e768 00 00 00 00 00 00 00 00 – 00 00 00 00 00 00 00 00 ……………. 0012e778 00 00 00 00 00 00 00 00 – 00 00 00 00 00 00 00 00 ……………. 0012e788 00 00 00 00 00 00 00 00 – 00 00 00 00 00 00 00 00 ……………. 0012e798 00 00 00 00 00 00 00 00 – 00 00 00 00 00 00 00 00 ……………. 0012e7a8 00 00 00 00 00 00 00 00 – 00 00 00 00 00 00 00 00 ……………. 0012e7b8 00 00 00 00 00 00 00 00 – 00 00 00 00 00 00 00 00 ……………. 0012e7c8 00 00 00 00 00 00 00 00 – 00 00 00 00 00 00 00 00 ……………. 0012e7d8 00 00 00 00 00 00 00 00 – 00 00 00 00 00 00 00 00 ……………. 0012e7e8 00 00 00 00 00 00 00 00 – 00 00 00 00 00 00 00 00 ……………. 0012e7f8 00 00 00 00 00 00 00 00 – 00 00 00 00 00 00 00 00 …………….

[Ritesh]

Thanks 😀

We will work on it.

[Author]

Posts