Create Another Data Base File

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.

Hi Sler

check the bellow link.

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 :(

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