desktop-packages team mailing list archive

[Dario Sepulveda <833741@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

I use Ubuntu 64bit 11.04 and Libreoffice Base 3.3.3 and mysql 5.1.54
I have 4 different schema in mysql, each with different tables.
In LOB I use a form combining tables from different schema for data input.
I use native mysql connector, from LOB to connect to mysql server, specifying no database name, thus from LOB I had access to all schemas and their corresponding tables.
The mysql server runs in the same computer as LOB, thus the connection is to "localhost".
After updating (which solved a tremendous problem with forms in Base) I receive a message of:
SQL status: 42000 
Error Code: 1049

Unknown database 'localhost:3306'

When opening the forms in LOB (which worked perfectly before!)

I found that changing the connector to mysql (JDBC) and back to mysql
(native) I am able to see all schema and tables as before.

** Affects: libreoffice (Ubuntu)
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to libreoffice in Ubuntu.
https://bugs.launchpad.net/bugs/833741

Title:
  libreoffice base problem connecting mysql with various schema

Status in “libreoffice” package in Ubuntu:
  New

Bug description:
  I use Ubuntu 64bit 11.04 and Libreoffice Base 3.3.3 and mysql 5.1.54
  I have 4 different schema in mysql, each with different tables.
  In LOB I use a form combining tables from different schema for data input.
  I use native mysql connector, from LOB to connect to mysql server, specifying no database name, thus from LOB I had access to all schemas and their corresponding tables.
  The mysql server runs in the same computer as LOB, thus the connection is to "localhost".
  After updating (which solved a tremendous problem with forms in Base) I receive a message of:
  SQL status: 42000 
  Error Code: 1049

  Unknown database 'localhost:3306'

  When opening the forms in LOB (which worked perfectly before!)

  I found that changing the connector to mysql (JDBC) and back to mysql
  (native) I am able to see all schema and tables as before.

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/833741/+subscriptions