Hello there,

I Have a MySQL (latest community version) backend on Ubuntu 10.4 and testing Kexi 2.2.2 as front end. First problem I encounter is that when creating a new project and importing the tables from MySQL is that I get error messages for the fields with type Decimal.

First I get "the data type for fieldname could not be determined. Please select one of the following data type"
I can't select, the window is empty.

When finished nothing is imported and I get following error:
"Not connected to the database server.
Message from server: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UNSIGNED NOT NULL)' at line 1
Server result: 1064"

Googling came up with little info. Ideas anyone?

Thanks for your time.

Update: ignore the front end I mentioned. I just read the following:
"- Currently you can not "open" (i.e. connect to) databases created outside of Kexi. You can only import the tables and data."

I still would like to be able to import from MySQL to test an all in one solution. So I could still use some tips regarding the problems with the Decimal fields.

Decimal normally has to be followed by the length parameter; is it complaining because you have left off the length parameter?

I'm also experiencing this issue, and can attest to it.

I am running MySQL 5.1.47 and Kexi 2.2.2

Kexi chokes when attempting to interact with each column bearing datatype decimal.

My table definition is as follows...

CREATE TABLE `mytable` (
`src` char(2) DEFAULT NULL,
`id` char(8) NOT NULL,
`ver` char(1) DEFAULT NULL,
`dt` datetime DEFAULT NULL,
`lat` decimal(8,4) DEFAULT NULL,
`lon` decimal(8,4) DEFAULT NULL,
`mag` decimal(3,1) DEFAULT NULL,
`dep` decimal(5,2) DEFAULT NULL,
`nst` smallint(6) DEFAULT NULL,
`reg` varchar(100) DEFAULT NULL,
`dt_modified` datetime DEFAULT NULL,
`dt_created` datetime DEFAULT NULL,
`md5` char(32) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8

albinojones wrote:I'm also experiencing this issue, and can attest to it.

I am running MySQL 5.1.47 and Kexi 2.2.2

[..]

Hi, thanks for the feedback. I have one proposal. Reporting this issue at http://bugs.kde.org will help to address and track issues better for both users and developers.

Also please note that with next Kexi version, 2.4, will be released within the Calligra Suite, having its forum at viewforum.php?f=203.