Apache OpenOffice (AOO) Bugzilla – Issue 22374
'Invalid Cursor State' entering new records in MySQL with Auto_Increment
Last modified: 2006-05-31 14:29:06 UTC
When I try to enter a new record into a MySQL table which has an "Auto Increment" field, I get the following error: "[unixODBC][Driver Manager] Invalid Cursor State" The error means I'm unable to 'leave' the new-record field cleanly. However, a new record *is* added to the table each time I try to leave the record-field. Repeated attempts at leaving the record-field (generating an Invalid Cursor State error each time) results in OO seg-fautling. The stack-trace is appended below. cheers, Bryan Fatal exception: Signal 6 Stack: /home/bryan/OpenOffice.org1.1/program/libsal.so.3[0x40bb2e2a] /home/bryan/OpenOffice.org1.1/program/libsal.so.3[0x40bb2fb4] /home/bryan/OpenOffice.org1.1/program/libsal.so.3[0x40bb307a] /lib/tls/libpthread.so.0[0x4112c7c8] /lib/tls/libc.so.6(abort+0x1d3)[0x42028b93] /home/bryan/OpenOffice.org1.1/program/libstdc++.so.5[0x41262424] /home/bryan/OpenOffice.org1.1/program/libstdc++.so.5[0x41262471] /home/bryan/OpenOffice.org1.1/program/libstdc++.so.5[0x412625e5] /home/bryan/OpenOffice.org1.1/program/libodbcbase2.so(_ZN12connectivity4odbc6OTo ols14ThrowExceptionEPNS0_11OConnectionEslsRKN3com3sun4star3uno9ReferenceINS7_10X InterfaceEEEht+0x44d)[0x4726dd0b] /home/bryan/OpenOffice.org1.1/program/libodbcbase2.so(_ZN12connectivity4odbc6OTo ols8getValueEPNS0_11OConnectionEllsRhRKN3com3sun4star3uno9ReferenceINS8_10XInter faceEEEPvl+0x8e)[0x4726d0a2] /home/bryan/OpenOffice.org1.1/program/libodbcbase2.so(_ZN12connectivity4odbc10OR esultSet8getValueElsPvl+0x100)[0x47263532] /home/bryan/OpenOffice.org1.1/program/libodbcbase2.so(_ZN12connectivity4odbc10OR esultSet6getIntEl+0x47)[0x47263f2b] /home/bryan/OpenOffice.org1.1/program/libodbcbase2.so(_ZN12connectivity4odbc10OR esultSet7fillRowEl+0x47b)[0x47269503] /home/bryan/OpenOffice.org1.1/program/libodbcbase2.so(_ZN12connectivity4odbc10OR esultSet8getValueElsPvl+0x6f)[0x472634a1] /home/bryan/OpenOffice.org1.1/program/libodbcbase2.so(_ZN12connectivity4odbc10OR esultSet6getIntEl+0x47)[0x47263f2b] /home/bryan/OpenOffice.org1.1/program/libdba645li.so[0x470c0f9c] /home/bryan/OpenOffice.org1.1/program/libdba645li.so[0x4709152b] /home/bryan/OpenOffice.org1.1/program/libdba645li.so[0x4709a8dc] /home/bryan/OpenOffice.org1.1/program/libdba645li.so[0x470a3d69] /home/bryan/OpenOffice.org1.1/program/libdba645li.so[0x470a7562] /home/bryan/OpenOffice.org1.1/program/libdba645li.so[0x470a4a2f] /home/bryan/OpenOffice.org1.1/program/libdba645li.so[0x470a2dd5] /home/bryan/OpenOffice.org1.1/program/libdba645li.so[0x4706a73d] /home/bryan/OpenOffice.org1.1/program/libsvx645li.so(_ZN13DbGridControl10SeekCur sorElh+0x121)[0x43d6b0ed] /home/bryan/OpenOffice.org1.1/program/libsvx645li.so(_ZN13DbGridControl7SeekRowE l+0x34)[0x43d691d0] /home/bryan/OpenOffice.org1.1/program/libsvt645li.so(_ZN9BrowseBox13ImplPaintDat aER12OutputDeviceRK9Rectanglehh+0x2a4)[0x4063d018] /home/bryan/OpenOffice.org1.1/program/libsvt645li.so(_ZN9BrowseBox9PaintDataER6W indowRK9Rectangle+0xae)[0x4063da0a] /home/bryan/OpenOffice.org1.1/program/libsvt645li.so(_ZN14BrowserDataWin5PaintER K9Rectangle+0x56)[0x40641dc4] /home/bryan/OpenOffice.org1.1/program/libvcl645li.so(_ZN6Window13ImplCallPaintEP K6Regiont+0x3d6)[0x40211950] /home/bryan/OpenOffice.org1.1/program/libvcl645li.so(_ZN6Window13ImplCallPaintEP K6Regiont+0x49d)[0x40211a17] /home/bryan/OpenOffice.org1.1/program/libvcl645li.so(_ZN6Window13ImplCallPaintEP K6Regiont+0x49d)[0x40211a17] /home/bryan/OpenOffice.org1.1/program/libvcl645li.so(_ZN6Window13ImplCallPaintEP K6Regiont+0x49d)[0x40211a17] /home/bryan/OpenOffice.org1.1/program/libvcl645li.so(_ZN6Window13ImplCallPaintEP K6Regiont+0x49d)[0x40211a17] /home/bryan/OpenOffice.org1.1/program/libvcl645li.so(_ZN6Window13ImplCallPaintEP K6Regiont+0x49d)[0x40211a17] /home/bryan/OpenOffice.org1.1/program/libvcl645li.so(_ZN6Window13ImplCallPaintEP K6Regiont+0x49d)[0x40211a17] /home/bryan/OpenOffice.org1.1/program/libvcl645li.so(_ZN6Window13ImplCallPaintEP K6Regiont+0x49d)[0x40211a17] /home/bryan/OpenOffice.org1.1/program/libvcl645li.so(_ZN6Window13ImplCallPaintEP K6Regiont+0x49d)[0x40211a17] /home/bryan/OpenOffice.org1.1/program/libvcl645li.so(_ZN6Window13ImplCallPaintEP K6Regiont+0x49d)[0x40211a17] /home/bryan/OpenOffice.org1.1/program/libvcl645li.so(_ZN6Window20ImplCallOverlap PaintEv+0x6a)[0x40211b46] /home/bryan/OpenOffice.org1.1/program/libvcl645li.so(_ZN6Window18ImplHandlePaint HdlEPv+0x2c)[0x40211bda] /home/bryan/OpenOffice.org1.1/program/libvcl645li.so(_ZN6Window26LinkStubImplHan dlePaintHdlEPvS0_+0x26)[0x40211ba6] /home/bryan/OpenOffice.org1.1/program/libvcl645li.so(_ZN5Timer7TimeoutEv+0x1f)[0 x400eaf6b] /home/bryan/OpenOffice.org1.1/program/libvcl645li.so(_Z21ImplTimerCallbackProcv+ 0x82)[0x400eacba] /home/bryan/OpenOffice.org1.1/program/libvcl645li.so(_ZNK7SalData7TimeoutEv+0x12 )[0x402af29a] /home/bryan/OpenOffice.org1.1/program/libvcl645li.so(_ZN7SalXLib12CheckTimeoutEb +0xd6)[0x402aede6] /home/bryan/OpenOffice.org1.1/program/libvcl645li.so(_ZN7SalXLib5YieldEh+0x2e7)[ 0x402af0db] /home/bryan/OpenOffice.org1.1/program/libvcl645li.so(_ZN11SalInstance5YieldEh+0x 34)[0x402b7f70] /home/bryan/OpenOffice.org1.1/program/libvcl645li.so(_ZN11Application5YieldEv+0x 61)[0x400e53c9] /home/bryan/OpenOffice.org1.1/program/libvcl645li.so(_ZN11Application7ExecuteEv+ 0x35)[0x400e52db] /home/bryan/OpenOffice.org1.1/program/soffice.bin(_ZN7desktop7Desktop4MainEv+0x1 acc)[0x8064eac] /home/bryan/OpenOffice.org1.1/program/libvcl645li.so(_Z6SVMainv+0x49)[0x400ea197 ] /home/bryan/OpenOffice.org1.1/program/libvcl645li.so(main+0x1c)[0x402adb7c] /lib/tls/libc.so.6(__libc_start_main+0xe4)[0x420156a4] /home/bryan/OpenOffice.org1.1/program/soffice.bin(_ZN6Window11RequestHelpERK9Hel pEvent+0x3d)[0x805e311] Aborted [bryan@bryan program]$
Upgrading MyODBC-2.5 to version 3.51 fixed this problem. I.e. it's not an OpenOffice issue. I'll set this to 'Invalid'. Bryan
Hi so I close this issue. BYe Marc
change subcomponent to 'none'