[FLOW3-general] Flow3 pdo blog error

[Peter Beernink]

Hi,

"Vinay Vinay" wrote:
> Hi,
>
> Thanks for your reply.
>
> Database is in Objects.db
>
>
> How do you I run the query
>
> ALTER TABLE properties_data ADD COLUMN  array CHAR(24);
>
> I am not able to find any interface to run the query.
>
> Can you please guide me in right direction ?

There is no interface to run the query, at least no FLOW3 interface.
I take it you use the default settings of FLOW3?
In that case you need to install the SQLite command line client in order to 
execute it. On Ubuntu for example you can do it by running apt-get install 
sqlite3

After that you can simply run
sqlite3 Data/Persistent/Objects.db 'ALTER TABLE "properties_data" ADD COLUMN 
"array" CHAR(24)'

>
> Why the persistant data won't be stored int the database I use ?

What database would that be? If you changed any settings, like the usage of 
MySQL instead of SQLite which is the default than you don't need to use the 
SQLite client, but need to perform that query using a client for that 
database system, like the MySQL command line, or phpMyAdmin.

>
> What is the need of using  Objects.db ?
>

If you didn't change anything in the settings, the default is to use 
Objects.db (which is an sqlite database) to store all persistant data.
You can also store it in an other database system like MySQL, but in that 
case you need to create the required tables and change some settings.

I hope this message gives you the right direction.

Greets,

Peter