[FLOW3-general] Flow3 pdo blog error

[Vinay Vinay]

Hi,

Thanks it helped me a lot.

On Sun, Jun 27, 2010 at 12:47 AM, Peter Beernink <p.beernink at drecomm.nl>wrote:

> 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
> _______________________________________________
> FLOW3-general mailing list
> FLOW3-general at lists.typo3.org
> http://lists.typo3.org/cgi-bin/mailman/listinfo/flow3-general
>