[dba-issues] [Issue 68263] Illegal operation on empty result set error message in m180
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=68263 User wurzel changed the following: What|Old value |New value Status|STARTED |RESOLVED Resolution| |WORKSFORME --- Additional comments from [EMAIL PROTECTED] Fri May 9 17:38:42 + 2008 --- This now works for me in 3.0 Beta m3 Aqua OOo. Setting to resolved, WFM. Alex - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 68263] Illegal operation on empty result set error message in m180
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=68263 User smsm1 changed the following: What|Old value |New value Status|RESOLVED |CLOSED --- Additional comments from [EMAIL PROTECTED] Fri May 9 22:49:48 + 2008 --- closing - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 68263] Illegal operation on empty result set error message in m180
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=68263 User jjmckenzie changed the following: What|Old value |New value OtherIssuesDependingOnTh|69308 | is| | --- Additional comments from [EMAIL PROTECTED] Mon Jan 7 01:33:44 + 2008 --- Removed dependency to an old issue. This issue is independent of any release version. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 68263] Illegal operation on empty result set error message in m180
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=68263 --- Additional comments from [EMAIL PROTECTED] Wed Feb 14 11:09:06 + 2007 --- @james Tried the binary MyODBC driver for MacIntel platform you suggested, but it throws the following error : [iODBC][DriverManager] dlopen(/usr/local/myodbc/lib/libmyodbc3_r_3.51.12.so,6) :Library no loaded : /usr/lib/libltdl.3.dylib Referenced from : /usr/local/myodbc/lib/libmyodbc3_r_3.51.12.so Reason : image not found SQL Status : 0 Error Code : -1341126392 This was tested on OOo 2.1, I can not install a dev version on the MacIntel production machine. Alex - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 68263] Illegal operation on empty result set error message in m180
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=68263 --- Additional comments from [EMAIL PROTECTED] Tue Jan 2 23:26:02 -0800 2007 --- cc'ing fs: Frank, do you know somebody who would be able to debug the scenario which happens also in 2.1? If you in the OOo/Mac community do not know who could debug this, who else should? :) If somebody can provide me with a stack of the crash at least, I could have a look at it (attach it to this issue). For the error in displaying the tables: If somebody can provide information about when/where the respective com::sun::star::sdbc::SQLException is thrown (the debugger should be able to break on this event, and show the stack), this might also give a hint. Besides this, I'm not sure about the tracing capabilities of the JDBC drivers. If there were some, you could try looking what's done last. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 68263] Illegal operation on empty result set error message in m180
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=68263 User jjmckenzie changed the following: What|Old value |New value Status|NEW |STARTED --- Additional comments from [EMAIL PROTECTED] Mon Jan 1 21:07:43 -0800 2007 --- @wurzel: There are MySQL ODBC drivers available for the Mac Intel at: http://www.graphiccare.ca/index.php?option=com_contenttask=viewid=56Itemid=37 I would like to pass my thanks to Thomas Page of Graphic Care for building and releasing them. I have not been able to test them with a remote connection. James McKenzie - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 68263] Illegal operation on empty result set error message in m180
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=68263 User macjogi changed the following: What|Old value |New value CC|'jjmckenzie,smsm1'|'fs,jjmckenzie,smsm1' --- Additional comments from [EMAIL PROTECTED] Sat Dec 30 02:25:48 -0800 2006 --- cc'ing fs: Frank, do you know somebody who would be able to debug the scenario which happens also in 2.1? - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 68263] Illegal operation on empty result set error message in m180
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=68263 --- Additional comments from [EMAIL PROTECTED] Sat Dec 30 09:44:18 -0800 2006 --- This issue may be related to 66123. More investigation is needed. James McKenzie - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 68263] Illegal operation on empty result set error message in m180
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=68263 User wurzel changed the following: What|Old value |New value CC|'smsm1' |'jjmckenzie,smsm1' --- Additional comments from [EMAIL PROTECTED] Tue Dec 5 04:01:04 -0800 2006 --- The problem is still there with 2.1rc1, and OOo still crashes after about 5 or 6 unsuccessful attempts to display the remote table alex - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 68263] Illegal operation on empty result set error message in m180
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=68263 User smsm1 changed the following: What|Old value |New value CC|''|'smsm1' --- Additional comments from [EMAIL PROTECTED] Sun Nov 5 04:33:16 -0800 2006 --- smsm1 - wurzel: Do you have some sample SQL tables that can be used to make testing of this easier? - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 68263] Illegal operation on empty result set error message in m180
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=68263 --- Additional comments from [EMAIL PROTECTED] Sun Nov 5 08:14:58 -0800 2006 --- @smsm1 : here's a sample table definition : CREATE TABLE citation ( citation_id int(11) unsigned zerofill NOT NULL auto_increment, family_id int(11) NOT NULL default '0', citation_ref varchar(100) NOT NULL default '', majdate timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY_KEY (citation_id) ) ENGINE=MyISAM DEFAULT CHARSET=Latin1 I can't give you the data, it is covered by my professional secrecy obligations (attorney client privilege). Alex - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 68263] Illegal operation on empty result set error message in m180
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=68263 User wurzel changed the following: What|Old value |New value Keywords|oooqa |crash, oooqa Priority|P3|P2 --- Additional comments from [EMAIL PROTECTED] Tue Aug 29 23:39:58 -0700 2006 --- adding crash keyword because if you try to access a table that produces the error message three or four times in a row, OOo systematically crashes. Upping priority to P2 Alex - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 68263] Illegal operation on empty result set error message in m180
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=68263 User wurzel changed the following: What|Old value |New value OtherIssuesDependingOnTh| |65572 is| | --- Additional comments from [EMAIL PROTECTED] Tue Aug 29 23:45:32 -0700 2006 --- linking to i65572 - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 68263] Illegal operation on empty result set error message in m180
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=68263 --- Additional comments from [EMAIL PROTECTED] Tue Aug 29 23:46:35 -0700 2006 --- BTW, the problem is still present in D680_m1 Alex - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 68263] Illegal operation on empty result set error message in m180
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=68263 --- Additional comments from [EMAIL PROTECTED] Sun Aug 20 10:24:19 -0700 2006 --- @all : I have installed a mysql server locally on the Mac machine and created some tables with varying fields in them (INT, AUTO_INCREMENT, VARCHAR, DATE,etc). I can write to these tables from within OOo m180 using either of the JDBC drivers, although the 3.1.12 driver doesn't work properly in that it refuses to display auto_increment fields. The 5.03 JDBC driver works OK in this regard. Also, the 3.1.12 driver won't display field names with accents in (Latin characters like é and è), for example like the fields proposed in the OOo Table Creation Wizard (Contacts). I beleive this was a known limitation of the driver. Anyway, locally there is write access. Remote access still results in the Illegal operator message. On the fourth attempt to access a table that provokes this error message, OOo m180 crashes and opens the Apple bug reporter. So, remote access doesn't work, and this is what we use in our production set up. Alex - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 68263] Illegal operation on empty result set error message in m180
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=68263 --- Additional comments from [EMAIL PROTECTED] Sun Aug 20 10:26:58 -0700 2006 --- @all : I have installed a mysql server locally on the Mac machine and created some tables with varying fields in them (INT, AUTO_INCREMENT, VARCHAR, DATE,etc). I can write to these tables from within OOo m180 using either of the JDBC drivers, although the 3.1.12 driver doesn't work properly in that it refuses to display auto_increment fields. The 5.03 JDBC driver works OK in this regard. Also, the 3.1.12 driver won't display field names with accents in (Latin characters like é and è), for example like the fields proposed in the OOo Table Creation Wizard (Contacts). I beleive this was a known limitation of the driver. Anyway, locally there is write access. Remote access still results in the Illegal operator message. On the fourth attempt to access a table that provokes this error message, OOo m180 crashes and opens the Apple bug reporter. So, remote access doesn't work, and this is what we use in our production set up. Alex - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 68263] Illegal operation on empty result set error message in m180
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=68263 --- Additional comments from [EMAIL PROTECTED] Sun Aug 20 10:30:31 -0700 2006 --- I might add that updating from the Mac to the remote mysql database works fine from within CocoaMysql, so it's definitely linked to the way Mac OOo version uses the MySQL JDBC driver to call the data from the remote server. Alex - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 68263] Illegal operation on empty result set error message in m180
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=68263 --- Additional comments from [EMAIL PROTECTED] Fri Aug 18 10:24:21 -0700 2006 --- @james : I am going to try and install a local mysql server on the Mac machine, but disk space is very tight, and I might not have enough room. This is one of the reasons why we are doing remote access to mysql servers from the Mac boxes. I'll keep you posted. Alex - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 68263] Illegal operation on empty result set error message in m180
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=68263 User wurzel changed the following: What|Old value |New value Version|680m179 |680m180 --- Additional comments from [EMAIL PROTECTED] Thu Aug 17 07:48:13 -0700 2006 --- Hi, I've just now tried this on a Linux box with m180 connecting via MySQL JDBC Connector 3.1.13 to a remote mysql server, and it works fine. The problem appears to be Mac specific (yet again, sigh). Alex - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 68263] Illegal operation on empty result set error message in m180
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=68263 --- Additional comments from [EMAIL PROTECTED] Thu Aug 17 18:52:39 -0700 2006 --- @alex Thank you for creating this issue. Can you connect to a LOCAL database on your Mac system like I asked you to do in IZ 65572? James M. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 68263] Illegal operation on empty result set error message in m180
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=68263 User clu changed the following: What|Old value |New value Assigned to|dbaneedsconfirm |macjogi --- Additional comments from [EMAIL PROTECTED] Wed Aug 16 06:45:45 -0700 2006 --- works fine with a 3.1.12 JDBC driver on a winxp in a src680m180 - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 68263] Illegal operation on empty result set error message in m180
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=68263 --- Additional comments from [EMAIL PROTECTED] Wed Aug 9 00:49:55 -0700 2006 --- Update : If I insert values via the mysql CLI into a table that previously had no data stored in it, and then try to access this table via the OOo GUI by opening it from within an ODB document, I get the same error message as for all the other tables that already had data in them. Conclusion : you still can not write data into a table using the MySQL JDBC connector from OOo Mac OSX PPC m180. Once you write data into a previously empty table, the table data can no longer be read from within the OOo GUI. Alex - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 68263] Illegal operation on empty result set error message in m180
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=68263 User wurzel changed the following: What|Old value |New value Summary|Illegal operation on empty|Illegal operation on empty | result set error message | result set error message | |in m180 --- Additional comments from [EMAIL PROTECTED] Tue Aug 8 10:03:05 -0700 2006 --- correcting title alex - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 68263] Illegal operation on empty result set error message in m180
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=68263 --- Additional comments from [EMAIL PROTECTED] Tue Aug 8 11:14:05 -0700 2006 --- more info : the tables which cause the error message already have data in them. Other tables, that are as yet free of any data, can be opened. See my comments in i65572 - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 68263] Illegal operation on empty result set error message in m180
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=68263 --- Additional comments from [EMAIL PROTECTED] Tue Aug 8 11:19:49 -0700 2006 --- Just tried writing data via the opened table from within OOo ODB table window. Error message : illegal operation. To sum up : You can't open tables that already have data in them. You can open tables that don't yet have any data in them. You can't write new data into these virgin tables. Alex - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
