Re: [TYPO3-english] Powermail error

[HocomAdvies [  Wiechert Hooghwinkel ]]

Solved the error myself. If you have access to the server which runs 
mysql-server. Than you might adapt the file my.cnf  by commenting out the line:

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

and restart the mysql server. 

Best Regards,
HocomAdvies

Wiechert Hooghwinkel 






> Op 16 sep. 2016, om 15:45 heeft HocomAdvies [  Wiechert Hooghwinkel ] 
>  het volgende geschreven:
> 
> Any thoughts on this? 
> 
> Regards,
> 
> Wiechert
> 
>> Op 16 sep. 2016, om 11:53 heeft HocomAdvies [  Wiechert Hooghwinkel ] 
>>  het volgende geschreven:
>> 
>> Hi, for a Typo3 6.2.19 site I suddenly have a huge problem. Sending the 
>> powermail form throws an error:
>> 
>> #1247602160: Field 'body' doesn't have a default value
>> 
>> TYPO3\CMS\Extbase\Persistence\Generic\Storage\Exception\SqlErrorException 
>> thrown in file
>> /usr/share/typo3_src-6.2.19/typo3/sysext/extbase/Classes/Persistence/Generic/Storage/Typo3DbBackend.php
>>  in line 862
>> 
>> This might probably be caused by an update of the mysql-server from 5.5 to 
>> 5.7 (the php version is 5.6.24). Client API version mysqlnd 5.0.11-dev.
>> 
>> What could be a solution te get powermail working again? 
>> 
>> Thanks.
>> HocomAdvies,
>> 
>> Wiechert Hooghwinkel
>> 
>> 
>> 
>> www.hocom-advies.nl
>> 
>> ___
>> TYPO3-english mailing list
>> TYPO3-english@lists.typo3.org
>> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english
> 
> ___
> TYPO3-english mailing list
> TYPO3-english@lists.typo3.org
> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english

___
TYPO3-english mailing list
TYPO3-english@lists.typo3.org
http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english

[TYPO3-english] Run a task from typo3?

[Alexandra Constantin]

I have to send an e-mail to the user after he created an event.

First time I have created a task from the backend and set from the form the 
date and the hour and the e-mail was sent, but now I want to send the e-mail 
from php code automatically..
How can I schedule a task to run at a certain time from php code in my controller 
and not from the Backend -> Scheduler but have the same results?
Thank you!
___
TYPO3-english mailing list
TYPO3-english@lists.typo3.org
http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english

Re: [TYPO3-english] Powermail error

[HocomAdvies [  Wiechert Hooghwinkel ]]

Any thoughts on this? 

Regards,

Wiechert

> Op 16 sep. 2016, om 11:53 heeft HocomAdvies [  Wiechert Hooghwinkel ] 
>  het volgende geschreven:
> 
> Hi, for a Typo3 6.2.19 site I suddenly have a huge problem. Sending the 
> powermail form throws an error:
> 
> #1247602160: Field 'body' doesn't have a default value
> 
> TYPO3\CMS\Extbase\Persistence\Generic\Storage\Exception\SqlErrorException 
> thrown in file
> /usr/share/typo3_src-6.2.19/typo3/sysext/extbase/Classes/Persistence/Generic/Storage/Typo3DbBackend.php
>  in line 862
> 
> This might probably be caused by an update of the mysql-server from 5.5 to 
> 5.7 (the php version is 5.6.24). Client API version mysqlnd 5.0.11-dev.
> 
> What could be a solution te get powermail working again? 
> 
> Thanks.
> HocomAdvies,
> 
> Wiechert Hooghwinkel
> 
> 
> 
> www.hocom-advies.nl
> 
> ___
> TYPO3-english mailing list
> TYPO3-english@lists.typo3.org
> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english

___
TYPO3-english mailing list
TYPO3-english@lists.typo3.org
http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english

Re: [TYPO3-english] Fluid and categories (TYPO3 6.2.x): render a multilevel menu for Bootstrap 3.x

[Loek Hilgersom]

I saw a mistake already, first call should be something like this:


If you need complicated markup you might do a different rendering for each level 
(instead of the recursion), but it does get more ugly of course.


I'm curious to hear your results.

Loek


On 16-09-16 12:45, Bert Hiddink [BENDOO e-work solutions] wrote:

Hello Loek!

Thanks for your suggestion! I'll test it and let you know if it worked!

Thanks again!
Bert

On 15/09/16 15:45, Loek Hilgersom wrote:

Hi Bert,

It is possible to do this inside fluid, but not very elegant (you'll
need to loop over all categories and first pick only root categories,
and for each category you'll have to loop over all again to see if there
are any children not exactly optimal).

But the amount of code is not too bad if you use a recursive partial
CategoryLevel.html (untested):


  

  blabla category markup

  

  


And first call it like:



You'll have to fiddle around with it to get your markup, but you'll get
the idea.

For a more elegant solution you'll first need to get the categories
sorted inside a multidimensional array or object, so you'll need a
controller (or maybe some creative viewhelper).

Loek





On 15-09-16 14:00, Bert Hiddink [BENDOO e-work solutions] wrote:

Hello,

I need to render a multilevel menu from categories with Fluid, html
should be
something like this:


  
Item 3

  Subitem 1 
  
Subitem 1 a
Subitem 2 b
Subitem 3 c 

  Sub sub
item 1
  Sub sub
item 2

Subitem 4 d
  
  Subitem 2
  Subitem 3

Item 4

  Subitem 1
  Subitem 2
  Subitem 3

  


However, using the snippet below, how could I distinguish between the
different
menulevels since I need to give a different data-parent for each
level. Any ideas?




{category.item.title}






Thanks in advance!

Regards,
-brt



___
TYPO3-english mailing list
TYPO3-english@lists.typo3.org
http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english

Re: [TYPO3-english] Fluid and categories (TYPO3 6.2.x): render a multilevel menu for Bootstrap 3.x

[Bert Hiddink [BENDOO e-work solutions]]

Hello Loek!

Thanks for your suggestion! I'll test it and let you know if it worked!

Thanks again!
Bert

On 15/09/16 15:45, Loek Hilgersom wrote:

Hi Bert,

It is possible to do this inside fluid, but not very elegant (you'll
need to loop over all categories and first pick only root categories,
and for each category you'll have to loop over all again to see if there
are any children not exactly optimal).

But the amount of code is not too bad if you use a recursive partial
CategoryLevel.html (untested):


  

  blabla category markup

  

  


And first call it like:



You'll have to fiddle around with it to get your markup, but you'll get
the idea.

For a more elegant solution you'll first need to get the categories
sorted inside a multidimensional array or object, so you'll need a
controller (or maybe some creative viewhelper).

Loek





On 15-09-16 14:00, Bert Hiddink [BENDOO e-work solutions] wrote:

Hello,

I need to render a multilevel menu from categories with Fluid, html
should be
something like this:


  
Item 3

  Subitem 1 
  
Subitem 1 a
Subitem 2 b
Subitem 3 c 

  Sub sub
item 1
  Sub sub
item 2

Subitem 4 d
  
  Subitem 2
  Subitem 3

Item 4

  Subitem 1
  Subitem 2
  Subitem 3

  


However, using the snippet below, how could I distinguish between the
different
menulevels since I need to give a different data-parent for each
level. Any ideas?




{category.item.title}






Thanks in advance!

Regards,
-brt


___
TYPO3-english mailing list
TYPO3-english@lists.typo3.org
http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english

[TYPO3-english] Powermail error

[HocomAdvies [  Wiechert Hooghwinkel ]]

Hi, for a Typo3 6.2.19 site I suddenly have a huge problem. Sending the 
powermail form throws an error:

#1247602160: Field 'body' doesn't have a default value

TYPO3\CMS\Extbase\Persistence\Generic\Storage\Exception\SqlErrorException 
thrown in file
/usr/share/typo3_src-6.2.19/typo3/sysext/extbase/Classes/Persistence/Generic/Storage/Typo3DbBackend.php
 in line 862

This might probably be caused by an update of the mysql-server from 5.5 to 5.7 
(the php version is 5.6.24). Client API version mysqlnd 5.0.11-dev.

What could be a solution te get powermail working again? 

Thanks.
HocomAdvies,

Wiechert Hooghwinkel



www.hocom-advies.nl

___
TYPO3-english mailing list
TYPO3-english@lists.typo3.org
http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english