[SailfishDevel] QSqlDatabase cannot create db file when deployed as rpm package

[Stockona]

Ah no wonder... thanks for pointing that out I will change the location accordingly.



________________________________
 From: Andrey Kozhevnikov <coderusinbox at gmail.com>
To: devel at lists.sailfishos.org 
Sent: Tuesday, November 12, 2013 12:30 AM
Subject: Re: [SailfishDevel] QSqlDatabase cannot create db file when deployed as rpm package
 


ah. you have no write permissions to these folders.
create db in /home/nemo/.local/share/Sockona
or /home/nemo/.config/Stockona


On 12.11.2013 14:25, Stockona wrote:

I have QT += sql in my pro.
>DB path= "/usr/share/Stockona/.stockona_db" 
>By the way, db.lastError().text() and type() gave me:
>"Error: DB failed to open,  "out of memory Error opening
        database"  errorType= 1"
>
>The path I got when deployed as binary was:
>DB path= "/opt/sdk/Stockona/usr/share/Stockona/.stockona_db" 
>Database file can be created as expected with this
        configuration.
>
>Thanks,
>William
>
>
>
>
>________________________________
> From: Andrey Kozhevnikov <coderusinbox at gmail.com>
>To: devel at lists.sailfishos.org 
>Sent: Tuesday, November 12, 2013 12:14 AM
>Subject: Re: [SailfishDevel] QSqlDatabase cannot create db file when deployed as rpm package
> 
>
>
>have you added sql to your project CONFIG?
>
>and what is resulting dbPath value?
>
>
>On 12.11.2013 14:12, Stockona wrote:
>
>Source code:
>>
>>
>>Q_DECL_EXPORTintmain(intargc,char*argv[]) { 
>>... 
>>    FileHandler*fileHandler=newFileHandler(); 
>>view->rootContext()->setContextProperty("fileHandler",fileHandler);
>>... 
>>}
>>
>>
>>FileHandler::FileHandler(QObject*parent):QObject(parent){
>>    ...
>>
>>// /usr/share/Stockona/
 QStringdbPath=QString(DEPLOYMENT_PATH); dbPath.append(".stockona_db"); qDebug()<<"DBpath="<<dbPath; QSqlDatabasedb=QSqlDatabase::addDatabase("QSQLITE"); db.setDatabaseName(dbPath);    // Cannot open database when deployed as rpm     boolok=db.open(); ...
} 
>>
>>
>>
>>________________________________
>> From: Andrey Kozhevnikov <coderusinbox at gmail.com>
>>To: devel at lists.sailfishos.org 
>>Sent: Monday, November 11, 2013 11:32 PM
>>Subject: Re: [SailfishDevel] QSqlDatabase cannot create db file when deployed as rpm package
>> 
>>
>>
>>My project working with QSQLITE local database, and everything good :)
>>
>>Share your code and we can found
                                  issues.
>>
>>
>>On 12.11.2013 02:35, Stockona wrote:
>>
>>When I switched to "Deploy by copying binary", the database is created and connected correctly. 
>>>Changing the deployment to rpm package the same code just failed with database error message "out of memory Error opening database."
>>>
>>>
>>>I checked in Emulator terminal and the database file was not created at all. Is this a permission issue? How do I work around this?
>>>Thanks in advance!
>>>
>>>
>>>
>>>
>>>
>>>_______________________________________________
SailfishOS.org Devel mailing list
>>
>>
>>_______________________________________________
>>SailfishOS.org Devel mailing list
>>
>>
>>
>>
>>_______________________________________________
SailfishOS.org Devel mailing list
>
>
>_______________________________________________
>SailfishOS.org Devel mailing list
>
>
>
>
>_______________________________________________
SailfishOS.org Devel mailing list


_______________________________________________
SailfishOS.org Devel mailing list
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.sailfishos.org/pipermail/devel/attachments/20131112/12a435f7/attachment.html>