[maemo-developers] QtSql and Debian package probelm

[From: Sascha Mäkelä]

I have now like this:

QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
QString name = QDir::homePath() + "/CurrencyConverter";
db.setDatabaseName(name);
return db.open();

It works fine directly from Qt Creator, but it doesn't work when installing
the Debian package. Any ides?


On Thu, Jun 10, 2010 at 16:39, Daniil Ivanov <daniil.ivanov at gmail.com>wrote:

>   It's actually better to use getenv("HOME"), instead of /home/user.
>
> Thanks, Daniil.
>
> On Thu, Jun 10, 2010 at 4:37 PM, Daniil Ivanov <daniil.ivanov at gmail.com>
> wrote:
> > Ok, no need for directory:
> >
> >  QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
> >  db.setDatabaseName("/home/user/.AppName");
> >  if (!db.open())
> >      qDebug() << db.lastError();
> >
> > Thanks, Daniil.
> >
> > On Thu, Jun 10, 2010 at 4:33 PM, Sascha Mäkelä <sascha.makela at gmail.com>
> wrote:
> >> Ehr... no. And how would I do that? Sorry for these silly questions...
> >> Thanks,
> >> Sascha
> >> PS. As such it didn't work in the package. But then again, I did not
> create
> >> the directory...
> >>
> >> On Thu, Jun 10, 2010 at 16:31, Daniil Ivanov <daniil.ivanov at gmail.com>
> >> wrote:
> >>>
> >>>  Did you create /home/user/.somedir/?
> >>>
> >>> Thanks, Daniil.
> >>>
> >>> On Thu, Jun 10, 2010 at 4:28 PM, Sascha Mäkelä <
> sascha.makela at gmail.com>
> >>> wrote:
> >>> > OK, let me try that. But at least it doesn't like it when running
> from
> >>> > Qt
> >>> > Creator (I'm using Nokia Qt SDK). The database stops working and
> behaves
> >>> > the
> >>> > same way as in the package.
> >>> >
> >>> > On Thu, Jun 10, 2010 at 16:08, Daniil Ivanov <
> daniil.ivanov at gmail.com>
> >>> > wrote:
> >>> >>
> >>> >> Hi!
> >>> >>
> >>> >>   You should be using something like this:
> >>> >>
> >>> >>   QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
> >>> >>   db.setDatabaseName("/home/user/.somedir/AppName");
> >>> >>
> >>> >>
> >>> >>   return db.open();
> >>> >>
> >>> >> Thanks, Daniil.
> >>> >>
> >>> >> On Thu, Jun 10, 2010 at 4:01 PM, Sascha Mäkelä
> >>> >> <sascha.makela at gmail.com>
> >>> >> wrote:
> >>> >> > I'm just getting:
> >>> >> > QSqlQuery::value: not positioned on a valid record
> >>> >> > It's like the app is unable to write any data to the SQLite
> database.
> >>> >> > As
> >>> >> > I
> >>> >> > said, it does work fine when running it from Qt Creator or MADDE.
> >>> >> >
> >>> >> > On Thu, Jun 10, 2010 at 15:57, David King <davidk at openismus.com>
> >>> >> > wrote:
> >>> >> >>
> >>> >> >> On 2010-06-10 15:47, Sascha Mäkelä <sascha.makela at gmail.com>
> wrote:
> >>> >> >>>
> >>> >> >>> This how it looks now:
> >>> >> >>>
> >>> >> >>> Depends: ${shlibs:Depends}, ${misc:Depends}, libqt4-network,
> >>> >> >>> libqt4-sql,
> >>> >> >>> libqt4-sql-sqlite
> >>> >> >>>
> >>> >> >>> But still it doesn't work. Am I missing something? The app works
> >>> >> >>> fine
> >>> >> >>> when I
> >>> >> >>> run it in N900 from Qt Creator.
> >>> >> >>
> >>> >> >> Which database provider do you use, I guess SQLite? If so, your
> >>> >> >> Depends:
> >>> >> >> line looks correct. When you say that the SQL parts of the
> >>> >> >> application
> >>> >> >> do
> >>> >> >> not work, what is the problem? You could try starting your
> program
> >>> >> >> from
> >>> >> >> the
> >>> >> >> terminal to check for clues in the output. Either that, or report
> >>> >> >> any
> >>> >> >> error
> >>> >> >> messages that the application gives you.
> >>> >> >>
> >>> >> >>> Thanks for all your help,
> >>> >> >>> Sascha
> >>> >> >>>
> >>> >> >>> On Thu, Jun 10, 2010 at 15:12, David King <davidk at openismus.com
> >
> >>> >> >>> wrote:
> >>> >> >>>
> >>> >> >>>> On 2010-06-10 15:01, Sascha Mäkelä <sascha.makela at gmail.com>
> >>> >> >>>> wrote:
> >>> >> >>>>
> >>> >> >>>>> Hi,
> >>> >> >>>>>
> >>> >> >>>>> I just made a Debian package of my app. I'm using QtSql in it.
> >>> >> >>>>> But
> >>> >> >>>>> for
> >>> >> >>>>> some
> >>> >> >>>>> reason when I install the package, all the SQL things don't
> work.
> >>> >> >>>>> My
> >>> >> >>>>> guess
> >>> >> >>>>> is that I'm missing something in the Build-Depends line in the
> >>> >> >>>>> control
> >>> >> >>>>> file.
> >>> >> >>>>> How can I check what libs I need to add there and what are
> their
> >>> >> >>>>> correct
> >>> >> >>>>> names?
> >>> >> >>>>>
> >>> >> >>>>> Cheers,
> >>> >> >>>>> Sascha
> >>> >> >>>>>
> >>> >> >>>>> PS. Currently it's like this: Build-Depends: dephelper (>5),
> >>> >> >>>>> libqt4-dev,
> >>> >> >>>>> libqt4-network
> >>> >> >>>>>
> >>> >> >>>>
> >>> >> >>>> You need to add the relevant Qt SQL provider packages to the
> >>> >> >>>> ‘Depends:’
> >>> >> >>>> line, not the ‘Build-Depends:’ line, as the SQL providers are
> >>> >> >>>> plugins
> >>> >> >>>> that
> >>> >> >>>> are not required at build time, but at runtime. You probably
> want
> >>> >> >>>> libqt4-sql-mysql or libqt4-sql-sqlite in Depends, depending on
> >>> >> >>>> which
> >>> >> >>>> database provider you are using.
> >>> >> >>
> >>> >> >> --
> >>> >> >> David King | http://amigadave.com/
> >>> >> >> _______________________________________________
> >>> >> >> maemo-developers mailing list
> >>> >> >> maemo-developers at maemo.org
> >>> >> >> https://lists.maemo.org/mailman/listinfo/maemo-developers
> >>> >> >
> >>> >> >
> >>> >> > _______________________________________________
> >>> >> > maemo-developers mailing list
> >>> >> > maemo-developers at maemo.org
> >>> >> > https://lists.maemo.org/mailman/listinfo/maemo-developers
> >>> >> >
> >>> >> >
> >>> >
> >>> >
> >>
> >>
> >
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.maemo.org/pipermail/maemo-developers/attachments/20100611/bd8157f1/attachment.htm>