Re: [TYPO3-english] Powermail error

[Jigal van Hemert]

Hi,

On 16/09/2016 18:11, "HocomAdvies [  Wiechert Hooghwinkel ]" wrote:

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.


In this case it's the STRICT_TRANS_TABLES that causes the problem. Newer 
releases of MySQL (and MariaDB) have this setting active by default.
I personally find the behaviour rather strange. The error complains that 
a TEXT field doesn't have a default value, but it's also not possible to 
set a default value for TEXT/BLOB columns.
The "solution" seems to be to explicitly set a value for each TEXT/BLOB 
column when inserting a record. TYPO3 doesn't perform such actions, so 
for the time being it's best to turn STRICT_TRANS_TABLES off.


--
Jigal van Hemert
TYPO3 CMS Active Contributor

TYPO3  inspiring people to share!
Get involved: typo3.org
___
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 ]]

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

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

[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

[TYPO3-english] Powermail error div positioning

[N³]

Hi everyone,

I’m trying to give the powermail .error div a better positioning. I found this 
snippet (see below) and put it to the end of my Typoscript Setup but 
unfortunately it has no effect whatsoever on my page. Anyone else with a 
solution?

I'm using Powermail 1.6.4, T3jQuery 2.0.5 and TYPO3 4.5.7

Thank you
Jan

---

lib.powermailjs.10 {
  value = position: 'center right', offset: [0,0], message: 'div/div'
}

[userFunc = user_powermailOnCurrentPage]  [userFunc = 
user_powermailCheckT3jquery(false)]
  page.jsFooterInline.10  lib.powermailjs
[end]

[userFunc = user_powermailOnCurrentPage]  [userFunc = 
user_powermailCheckT3jquery(true)]
  page.31320.40.jsdata.cObject  lib.powermailjs
[end]​




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

Re: [TYPO3-english] Powermail error div positioning

[N³]

Hey,
Found it myself -.-

plugin.powermail.template.frontendJsTemplatePath = ...

Powermail 1.6.4 introduced a js template. Didn't see that before. This allows 
to edit the offset (around line 140). Still this is not ideal, in IE (9) its 
about 15px lower than in Firefox, so a good positioning is not possible. Shame 
...

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