Bug 355649

Summary: cannot open a file made with 2.9.9
Product: [Applications] KEXI Reporter: Albrecht Will <albrecht.will>
Component: KexiDBAssignee: Kexi Bugs <kexi-bugs>
Status: CLOSED FIXED    
Severity: normal CC: adam, inksi, staniek
Priority: NOR    
Version: 2.8.0   
Target Milestone: ---   
Platform: Other   
OS: Linux   
Latest Commit: Version Fixed In:
Sentry Crash Report:
Attachments: issue opening kexi-file
version kexi
Detail openening a kexi file in KAOS
attachment-9525-0.html

Description Albrecht Will 2015-11-20 15:45:33 UTC
Traing to open a recent kexi-file is impossible. Send 2 screenshots.

Reproducible: Always
Comment 1 Albrecht Will 2015-11-20 15:46:13 UTC
Created attachment 95617 [details]
issue opening kexi-file
Comment 2 Albrecht Will 2015-11-20 15:47:07 UTC
Created attachment 95618 [details]
version kexi

Linux Chakra
Comment 3 Jarosław Staniek 2015-11-20 15:50:34 UTC
Thanks Albrecht. Is this about any .kexi file created with 2.9.9 or specific one?
Could you please use the "Open" dialog instead of "Welcome" screen with recent files?

Thanks
Comment 4 Albrecht Will 2015-11-20 17:36:40 UTC
Am Friday 20 November 2015, 15:50:34 schrieben Sie:
> https://bugs.kde.org/show_bug.cgi?id=355649
> 
> Jarosław Staniek <staniek@kde.org> changed:
> 
>            What    |Removed                     |Added
> ----------------------------------------------------------------------------
> CC|                            |staniek@kde.org
> 
> --- Comment #3 from Jarosław Staniek <staniek@kde.org> ---
> Thanks Albrecht. Is this about any .kexi file created with 2.9.9 or specific
> one?
> Could you please use the "Open" dialog instead of "Welcome" screen with
> recent files?
> 
> Thanks

Yes, its about any kexi-file, and I used the "Open" dialog.
Comment 5 Jarosław Staniek 2015-11-20 20:12:01 UTC
1. What's displayed when you click the Details>> button?

2. Are you sure you have the current (2.96.1) KDb library installed? In Kexi 3.0 it is responsible for handling databases.
Comment 6 Jarosław Staniek 2015-11-20 20:34:20 UTC
Could you please pick the distribution you're using?

Checked the Kexi version, it's the newest one, and I cannot reproduce the issue so far.

If you build on your own, please do so for kexi, and dependencies: https://community.kde.org/Calligra/Building/3#List_of_required_dependencies 
If you update Kexi, update the dependencies as well, every Monday there can be changes.

If you don't build yourself please ask the packager to carefully package with above requirements in mind. 

Thanks.
Comment 7 Jarosław Staniek 2015-11-20 20:37:54 UTC
Could you attach me your include/KDb/config-kdb.h file. Or version of the kdb package, the one that provides libKDb.so file.
Comment 8 Albrecht Will 2015-11-23 15:49:56 UTC
(In reply to Jarosław Staniek from comment #5)
> 1. What's displayed when you click the Details>> button?

ad1. look pict. Screenshot_20151123_113032.png

> 2. Are you sure you have the current (2.96.1) KDb library installed? In Kexi
> 3.0 it is responsible for handling databases.

Please give me an advice what i have to search.
I test KAOS-Linux in Virtual-Box.
Comment 9 Albrecht Will 2015-11-23 15:51:22 UTC
Created attachment 95671 [details]
Detail openening a kexi file in KAOS
Comment 10 Albrecht Will 2015-11-23 15:55:00 UTC
(In reply to Jarosław Staniek from comment #7)
> Could you attach me your include/KDb/config-kdb.h file. Or version of the
> kdb package, the one that provides libKDb.so file.

Where I have to look for?
Comment 11 Jarosław Staniek 2015-11-23 16:14:00 UTC
Hi Albrecht,
For using Alpha software I recommend building on your own (if you do using opensuse or ubuntu distributions you can hope to get more help from the team... especially if you're not technical Linux person) or close cooperation with people who make the packages. KAOS isn't the most popular out there...

The error in the Details section clearly shows that driver (kdb sqlite) isn't installed.
Please refer to the docs of the OS and contact/cooperate with the authors of the packages. It would be good if you report the issue. I think Kexi should show the error even earlier and say something like "Kexi is not correctly installed, please contact with distributor".

Summing up, it's a deployment issue by KAOS, marking as such in the resolution, thanks for testing!

If I can help more, please let me know.
Comment 12 Albrecht Will 2015-11-23 16:52:04 UTC
(In reply to Jarosław Staniek from comment #11)
> Hi Albrecht,
> For using Alpha software I recommend building on your own (if you do using
> opensuse or ubuntu distributions you can hope to get more help from the
> team... especially if you're not technical Linux person) or close
> cooperation with people who make the packages. KAOS isn't the most popular
> out there...
> 
> The error in the Details section clearly shows that driver (kdb sqlite)
> isn't installed.
> Please refer to the docs of the OS and contact/cooperate with the authors of
> the packages. It would be good if you report the issue. I think Kexi should
> show the error even earlier and say something like "Kexi is not correctly
> installed, please contact with distributor".
> 
> Summing up, it's a deployment issue by KAOS, marking as such in the
> resolution, thanks for testing!
> 
> If I can help more, please let me know.

It's more my couriosity to see how your work is going on.  It exceeds my possibilties to help KAOS.
But I would happy to learn some basic sql-commands for kexi. For ex. I search in the web for a field "is empty".
Comment 13 Jarosław Staniek 2015-11-23 17:38:34 UTC
Created attachment 95675 [details]
attachment-9525-0.html

That's OK, feel free to ask on the forums for the SQL commands.

Also, 2.9.9 currently contains these functions
https://community.kde.org/Kexi/Plugins/Queries/SQL_Functions#Typical_Scalar_Functions
and it's tested while 3.0.0 just I just ported them and did not test
everything.

(you can search for the meaning of the functions in SQLite, MySQL or
PostgreSQL docs, we'd like to document them in Kexi book too)


On 23 November 2015 at 17:52, Albrecht Will via KDE Bugzilla <
bugzilla_noreply@kde.org> wrote:

> Albrecht Will <albrecht.will@online.de> changed bug 355649
> <https://bugs.kde.org/show_bug.cgi?id=355649>
> What Removed Added Resolution DOWNSTREAM FIXED
>
> It's more my couriosity to see how your work is going on. It exceeds my
> possibilties to help KAOS. But I would happy to learn some basic
> sql-commands for kexi. For ex. I search in the web for a field "is empty"
>
> ------------------------------
> You are receiving this mail because:
>
>    - You are on the CC list for the bug.
>    - You are watching someone on the CC list of the bug.
>
>