Create Another Data Base File

Create Another Data Base File Rate Topic:

#1 Sler

Junior Member

Group: Members
Posts: 97
Joined: 17-July 12

Posted 01 January 2013 - 05:51 AM

Hello guys,

I was wondering if I could create another testdrive.db or maybe edit it. It is found on the webapp/protected/data/tesdrive.db, is there anyway I can make it? Thank you.

#2 KonApaz

Advanced Member

Group: Members
Posts: 506
Joined: 21-February 11
Location:Greece

Posted 01 January 2013 - 07:02 AM

Hi Sler

check the bellow link.
http://sourceforge.n.../sqlitebrowser/

if you create another one (with the mentioned software) set another file in prodected/config/main.php file like that

'components'=>array(
        ......
        'db'=>array(
            'connectionString'=>'sqlite:/.../.../protected/data/yourfile.db',
            ...
        ),
    ),

#3 Sler

Junior Member

Group: Members
Posts: 97
Joined: 17-July 12

Posted 01 January 2013 - 08:31 AM

KonApaz, on 01 January 2013 - 07:02 AM, said:

Hi Sler

check the bellow link.
http://sourceforge.n.../sqlitebrowser/

if you create another one (with the mentioned software) set another file in prodected/config/main.php file like that

'components'=>array(
        ......
        'db'=>array(
            'connectionString'=>'sqlite:/.../.../protected/data/yourfile.db',
            ...
        ),
    ),

It's the one I'm looking for but the application will crash after I execute query

#4 KonApaz

Advanced Member

Group: Members
Posts: 506
Joined: 21-February 11
Location:Greece

Posted 01 January 2013 - 09:36 AM

Sler, on 01 January 2013 - 08:31 AM, said:

It's the one I'm looking for but the application will crash after I execute query

Did you check the query in sqlite editor ?
which is your query / Yii method?
What is the error message?
Also check the protected/runtime/application.log file for error tracking