[www-issues] [Issue 113088] Many issues were spammed by raz71abb6 and others
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113088 --- Additional comments from jhanso...@openoffice.org Thu Nov 11 01:55:29 + 2010 --- enpizafapw 12482 - 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: issues-unsubscr...@openoffice.org For additional commands, e-mail: issues-h...@openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 51383] Disallowed Implicit Conver sion with Money fields in SQL Server table
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=51383 --- Additional comments from jhanso...@openoffice.org Mon Jan 18 04:32:29 + 2010 --- I'm unable to test it as the company upgraded their SQL Server database to Access/Jet and SQL Server is no longer available to me (my opinion on that transition is too profane for here). - 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: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 78725] Sort failure in DSB with r enamed columns
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78725 Issue #|78725 Summary|Sort failure in DSB with renamed columns Component|Database access Version|OOo 2.2 Platform|PC URL| OS/Version|Windows Vista Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|jhansonxi --- Additional comments from [EMAIL PROTECTED] Thu Jun 21 02:58:52 + 2007 --- OOO 2.2.0 on Vista connecting to an Access 2007 DB via ADO. If a query renames a column using the "AS" keyword, attempting to sort the data in the data source browser fails on that column. Error dialogs: The data content could not be updated SQL Status: 07001 Error code: -2147217904 [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. The SQL command leading to this error is: SELECT `PDES`.`PartNumber` AS `PN`, `PDES`.`InventoryLocation` AS `Location`, `PDES`.`QuantityOnHand` AS `Qty`, `PDES`.`Description`, `MFG`.`CompanyName` AS `Mfg`, `MFGPN`.`ManufacturerPart` AS `Mfg PN`, `PDES`.`Voltage`, `PDES`.`Current`, `PDES`.`Power`, `PDES`.`MinimumTemperature` AS `MinTemp`, `PDES`.`MaximumTemperature` AS `MaxTemp`, `PDES`.`Case`, `PDES`.`DefaultFootprint`, `PDES`.`VisualIdentifier` AS `Visual ID`, `DIST`.`CompanyName` AS `Dist`, `DISTPN`.`DistributorPart` AS `DistPN` FROM ( ( ( `Parts` AS `PDES` LEFT JOIN `ManufacturerParts` AS `MFGPN` ON `MFGPN`.`SienaPart` = `PDES`.`PartNumber` ) LEFT JOIN `Manufacturers` AS `MFG` ON `MFG`.`ID` = `MFGPN`.`Manufacturer` ) LEFT JOIN `DistributorParts` AS `DISTPN` ON `DISTPN`.`ManufacturerPart` = `MFGPN`.`ID` ) LEFT JOIN `Distributors` AS `DIST` ON `DIST`.`ID` = `DISTPN`.`Distributor` WHERE `PDES`.`Class` LIKE '14' ORDER BY `Mfg` Readable original query (why does OOO remove line breaks?): SELECT PDES.`PartNumber` AS `PN`, PDES.`InventoryLocation` AS `Location`, PDES.`QuantityOnHand` AS `Qty`, PDES.`Description`, MFG.`CompanyName` AS `Mfg`, MFGPN.`ManufacturerPart` AS `Mfg PN`, PDES.`Voltage`, PDES.`Current`, PDES.`Power`, PDES.`MinimumTemperature` AS `MinTemp`, PDES.`MaximumTemperature` AS `MaxTemp`, PDES.`Case`, PDES.`DefaultFootprint`, PDES.`VisualIdentifier` AS `Visual ID`, DIST.`CompanyName` AS `Dist`, DISTPN.`DistributorPart` AS `DistPN` FROM (((Parts PDES LEFT JOIN `ManufacturerParts` MFGPN ON MFGPN.`SienaPart`=PDES.`PartNumber`) LEFT JOIN `Manufacturers` MFG ON MFG.`ID`=MFGPN.`Manufacturer`) LEFT JOIN `DistributorParts` DISTPN ON DISTPN.`ManufacturerPart`=MFGPN.`ID`) LEFT JOIN `Distributors` DIST ON DIST.`ID`=DISTPN.`Distributor` WHERE PDES.`Class` LIKE '14' If the ORDER BY statement is replaced with the following then it works: ORDER BY MFG.`CompanyName` I get the same error in CuteSQL so it's the structure of the ORDER BY statement that OOO adds that is incompatible with this query. - 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 51383] Disallowed Implicit Conver sion with Money fields in SQL Server table
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=51383 --- Additional comments from [EMAIL PROTECTED] Fri Jul 7 09:35:52 -0700 2006 --- Still occurs with 2.0.3 (same settings). I can't seem to get ODBC tracing working in XP so I can't see what is happening. - 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 51383] New - Disallowed Implicit Conversion with Money fields in SQL Server tab le
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=51383 Issue #:|51383 Summary:|Disallowed Implicit Conversion with Money fields in |SQL Server table Component:|Database access Version:|OOo 2.0 Beta Platform:|PC URL:| OS/Version:|Windows XP Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P2 Subcomponent:|none Assigned to:|dbaneedsconfirm Reported by:|jhansonxi --- Additional comments from [EMAIL PROTECTED] Wed Jun 29 13:10:32 -0700 2005 --- Client: OOO 1.9.100 Base and Data Source Browser, Windows XP SP2 Server: SQL Server 2000 Connection: ODBC Table: Parts.dbo.Sources (Inventory sources table) Fields: Index: Primary Key, Table Identity (seed 1, inc 1), bigint, length 8 Part Number: nvarchar, length 7 Source: nvarchar, length 50, nulls allowed Source Part Number: nvarchar, length 50, nulls allowed Minimum Quantity: int, length 4, nulls allowed Maximum Cost: money, length 8, nulls allowed Use For Estimates: bit Whenever I try to enter a value into the Maximum Cost field via the DSB or the table editor in Base, I get an error: [Microsoft][ODBC SQL Server Driver][SQL Server]Disallowed implicit conversion from data type char to data type money, table 'Parts.dbo.Sources', column 'Maximum Cost'. Use the CONVERT function to run this query. Is this a bug in OOO that it tries to send the wrong data type or is it a problem with ODBC or SQL Server 2000? - 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 51380] UNION statement support
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=51380 --- Additional comments from [EMAIL PROTECTED] Wed Jun 29 12:25:54 -0700 2005 --- I forgot to mention that I'm using ODBC connected to an SQL Server 2000 database. I haven't tried any other connect method so I don't know if it is an ODBC-specific limitation or not. - 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 51380] New - UNION statement supp ort
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=51380 Issue #:|51380 Summary:|UNION statement support Component:|Database access Version:|OOo 2.0 Beta Platform:|PC URL:| OS/Version:|Windows XP Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|ENHANCEMENT Priority:|P3 Subcomponent:|none Assigned to:|dbaneedsconfirm Reported by:|jhansonxi --- Additional comments from [EMAIL PROTECTED] Wed Jun 29 12:24:01 -0700 2005 --- Enter any SQL query with a UNION statement and an error is reported when saving: The given command is not a SELECT statement. Only queries are allowed. UNION statements should be supported. - 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] =?UTF-8?B?W0lzc3VlIDQ2NTE0XSAgU2hpZnQrc3BhY2UgZXJyb25lb3VzbHkgbQ==?= =?UTF-8?B?YXBwZWQ=?=
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=46514 --- Additional comments from [EMAIL PROTECTED] Mon Jun 13 07:25:42 -0700 2005 --- Still occurs in 1.9.100 - 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 46514] New - Shift+space erroneously mapped
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=46514 Issue #:|46514 Summary:|Shift+space erroneously mapped Component:|Database access Version:|680m87 Platform:|PC URL:| OS/Version:|Windows XP Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|none Assigned to:|msc Reported by:|jhansonxi --- Additional comments from [EMAIL PROTECTED] Fri Apr 1 12:45:58 -0800 2005 --- I've noticed that Shift+space seems to be mapped to select column but it shows up as unmapped in the Customize > Keyboard panel. This affects both Base and Data Source Browser. I often hit Shift-Space by accident and lose my table edits when the column is selected. It's really annoying not being able to unmap it or map it to a space. - 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]
[framework-issues] [Issue 39622] Crash report utility crashes
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=39622 --- Additional comments from [EMAIL PROTECTED] Thu Mar 24 06:35:19 -0800 2005 --- Crash report data submitted. Includes Dr. Watson report, dump, and Dependency Walker (http://www.dependencywalker.com) reports on crashrep.com and crashrep.exe files. System is WinXP Pro SP2, OOO 1.9.87 (previous beta uninstalled first). - 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]
[framework-issues] [Issue 39622] Crash report utility crashes
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=39622 User jhansonxi changed the following: What|Old value |New value Attachment data| |Created an attachment | |(id=24250) crash report | |data --- Additional comments from [EMAIL PROTECTED] Thu Mar 24 06:30:39 -0800 2005 --- Created an attachment (id=24250) crash report data - 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]
[framework-issues] [Issue 39622] Crash report utility crashes
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=39622 --- Additional comments from [EMAIL PROTECTED] Thu Mar 24 06:18:31 -0800 2005 --- I encountered this one also. I was using Base and the Data Source Browser previously. No error noticed on exit at end of day. Next morning, OOO reports that the Base file (ODBC link) needed recovery. Crashrep popped up to report the nonerror. OOO continued to load without problems but crashrep crashed when report was sent. Debug data will be submitted. - 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]
[framework-issues] [Issue 44281] Error Report tool crashed on send
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=44281 --- Additional comments from [EMAIL PROTECTED] Thu Mar 24 06:12:29 -0800 2005 --- Possible duplicate of Issue 39622 - 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 21266] Duplicates shown in DSB when copying tables
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=21266 --- Additional comments from [EMAIL PROTECTED] Thu Feb 10 09:01:58 -0800 2005 --- Unable to verify. I am now using 1.9.69 with SQL Server 2000 DBs connected via ODBC. DBs are read-only through DSB - at least they are with my current configuration. - 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]