[FLOW3-general] How to get Blog working??

[Dmitri Pisarev]

Hey,
On 14.06.2011 14:42, Gideon So wrote:
> Hi Nicolas,
>
>
> 於 西元2011年06月14日 16:10, Nicolas Forgerit 提到:
>
>>> 1. I cannot import the DDL.SQL file. It keeps say that there is some
>>> syntax error.
>> Here we have a first case of the rule from above. Please, give us more
>> information of that syntax error. :)
>
> I tried to import the sql file with phpmyadmin and it gave me this error:
>
> #1064 - You have an error in your SQL syntax; check the manual that
> corresponds to your MySQL server version for the right syntax to use
> near '"entities" (
> "identifier" CHAR(36) PRIMARY KEY NOT NULL,
> "type" VARC' at line 1
I had to search and replace for straight double quotes(") to the quotes, 
which mysql likes(`).
>
>>
>>> 2. While I do this ./flow3 typo3:site:import<
>>> Packages/Sites/PhoenixDemoTypo3Org/Resources/Private/Content/Sites.xml.
>>> A error occurred:
>>>
>>> Error: During import an exception occured. SQLSTATE[28000] [1045] Access
>>> denied for user 'root'@'localhost' (using password: NO)
>> Okay this is pretty straight-forward. In order for putting some stuff
>> into your database, you need to set up a user account that is able to
>> write to the database. I would recommend not using your root account
>> for that since this often leads to slipping into insecure production
>> systems when you have to "get things done". Instead, set up a user
>> like "f3-blog-ex" with a random password.
>> You may do so by using tools like phpMyAdmin or you may set it up
>> using the CLI mode (e.g. [2]). What is the lamp-stack you are using?
>> They often bring along an easy peasy admin-backend with them.
>> Afterwards you need to configure F3 to do use those account
>> information. Get back to us if you need help with that.
>
> Of course I know that but where to put my mysql stuff?? I put them in
> the Setting.yaml file as Dmitir instructs in his web page.
Hmm this is really strange... May be the configuration got cached or 
contains typos? Are you editing the right file 
(/Configuration/Settings.yaml)? Are you running in development context? 
Anyway, try to clear the caches this way:
./flow3 flow3:cache:flush
and see if it helps.
>
>>
>>
>>> Any Ideas??
>>>
>>> By the way, I just want to try the FLOW3 Blog. Look like it is too
>>> complicated to test it.
>> Don't despair, we are with you. :)
>
> Thanks. This is all TYPO3 all about.
Indeed!
>>
>>
>> Ciao
>> Nico
>>
>
> Gideon So
Dmitri.