Bug 125432

Summary: Kexi Form won't open
Product: [Applications] KEXI Reporter: Vic099 <victor.lz>
Component: FormsAssignee: Jarosław Staniek <staniek>
Status: CLOSED FIXED    
Severity: normal    
Priority: NOR    
Version: 1.0 (KOffice 1.5)   
Target Milestone: ---   
Platform: Fedora RPMs   
OS: Linux   
Latest Commit: Version Fixed In:
Sentry Crash Report:
Attachments: fix for loading forms (and reports, but reports should not be used anyway)
form_plugins.patch

Description Vic099 2006-04-12 16:50:15 UTC
Version:            (using KDE KDE 3.5.2)
Installed from:    Fedora RPMs
OS:                Linux

Kexi Form won't open with office-kexi-1.5.0-0.3.fc5.kde. Form was created using Kexi 1.5 rc1. Database originally created with Knoda and Mysql and imported with kexi 1.5 rc1. Kexi only imported tables but not forms. Forms were recreated using Kexi 1.5 rc1 and worked fine until most recent update.

Also fonts in properties window extremely small (8 ?) and don't know how to change.
Comment 1 Jarosław Staniek 2006-04-12 17:10:40 UTC
1. What is the error message in Kexi? 
2. Are you able to create and save new forms?
3. If you can please send me the original database in .kexi format you have problem with. 

> Also fonts in properties window extremely small (8 ?) and don't know how 
> to change. 

We've had this problem in Kexi 0.8 and it may be related to invalid DPI settings for your monitor DPI. As a quick and easy workaround, you can increase the font size as described in http://bugs.kde.org/show_bug.cgi?id=105020

Comment 2 Vic099 2006-04-12 18:49:48 UTC
1. There is no error mesg.  The form shows up under "Forms" but nothing 
happens when I click on it. Neither "Design view" or  "Data view" are 
active.

2.  Can't add form to this database. "Insert" only shows Table, Query or 
Script.  Tried creating a new database using MySQL and again "Insert" 
only shows Table, Query or Script.  NB only tried out MySQL server 
based databases.

On Wednesday 12 April 2006 11:10, you wrote:
[bugs.kde.org quoted mail]
Comment 3 Jarosław Staniek 2006-04-12 21:10:32 UTC
I've reported the problem here https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=188746

In addition if you can, please: 
1. uninstall any kexi version and install the newest version again
2. make me sure you havent compiled kexi by hand, if no, there are no messed kexi-related files in your KDE directories
3. try to install the kexi version on another computer with Fedora, if you have an access to such
Comment 4 Vic099 2006-04-13 16:13:16 UTC
1. Tried  uninstall and re-install.  No change in results
2. I checked /usr/lib/kde3  but did not see any old kexi related files 
that I could identify. Other directories to check??
3. don't have access to another machine

On Wednesday 12 April 2006 15:10, Jaroslaw Staniek wrote:
[bugs.kde.org quoted mail]
Comment 5 Vic099 2006-04-13 16:37:23 UTC
Reverted to rc1 version and everything works ok. "Insert" shows Tables, 
Queries, Forms, Reports and Scripts. Notes that in latest 
release "Reports" as well as "Forms" option was missing from the Insert 
menu item. 

 On Wednesday 12 April 2006 15:10, Jaroslaw Staniek wrote:
[bugs.kde.org quoted mail]
Comment 6 Stefan Lücking 2006-05-09 19:38:09 UTC
I guess, I've got the same problem.

I've installed koffice-database-1.5.0-2.i586.rpm for SuSE 10.0.

But there is no possibility to use forms or reports in kexi.

There no menu items for "forms" or "reports" in the insert menu.

Double clicking on an existing form does nothing. There is not even a console message when I have started kexi form the konsole.

I thought this is a problem of the SuSE packages, but when the same issue occurs with Redhat packages, too, there might be some deeper problem.
Comment 7 Jarosław Staniek 2006-05-09 20:15:35 UTC
> But there is no possibility to use forms or reports in kexi.

Reports were never available on Kexi.

About forms: 
You may want to enable logging to stderr in kdebugrc file for the following areas:
44000        KexiDB
44001        KexiDB (driver impl)
44010        Kexi (general)
44020        Kexi (core)
44021        Kexi (plugins)

You also need .so files like:

kexihandler_form
kformdesigner

Random idea: Eventually, it's possible that many distros have not updated their specs.
You can take a look at the list of .so files (containing "form" word in the name) for any package that work, eg. Debian or Kubuntu.
Comment 8 Vic099 2006-05-09 22:50:18 UTC
Now using koffice-kexi-1.5.0-1.fc5 with KDE 3.5.2. Forms now works.

On Tuesday 09 May 2006 13:38, Stefan Lücking wrote:
[bugs.kde.org quoted mail]
Comment 9 Jarosław Staniek 2006-05-19 18:28:15 UTC
Fixed by an emergency patch for 1.5.1.
Comment 10 Jarosław Staniek 2006-05-19 18:29:33 UTC
Created attachment 16177 [details]
fix for loading forms (and reports, but reports should not be used anyway)
Comment 11 Jarosław Staniek 2006-05-19 19:00:21 UTC
Dear packagers,
Another patch, this time a critical one.

The attached patch should be applied to the source code of recently released 
KOffice 1.5.1 tarball. 
Otherwise Kexi Forms will not be available at all, making the application 
almost unusable. 

The defect was already reported here 
https://bugs.kde.org/show_bug.cgi?id=125432

I am sorry for the inconvenience.

Details:
Affected are probably any environments where --disable-rpath and 
--enable-new-ldflags are used.
Thanks to Stephan Binner (SUSE) for pointing this out.


Created an attachment (id=16178)
form_plugins.patch