Re: [TYPO3-english] 6.2.0 Install Tool Update Wizard: MySQL-Error

2014-01-15 Thread Xavier Perseguers
Hi Thomas, I'm currently trying to get TYPO3 6.2.0 (yesterdays master, fresh install) to work with utf8_unicode_ci collation (instead of utf8_general_ci), but whenever I click on Update Wizard in the Install Tool, I'm getting this mySQL Error: llegal mix of collations

[TYPO3-english] Database Error Caused by cli_dispatch.phpsh scheduler

2014-01-15 Thread Scotty C
Hi everyone, For security reasons, I had to change my database password. Now, I also made sure to change the database password in the Install Tool. However, I must have missed something because I'm getting this error emailed to me 60 times per day: Cron /usr/local/bin/php

Re: [TYPO3-english] Database Error Caused by cli_dispatch.phpsh scheduler

2014-01-15 Thread Stefano Kowalke
Hi Scott, change the password in the typo3conf/localconf.php file. There is a section which handles the database settings. Be sure that the database settings occur only once in that file. Hope that helps Stefano ___ TYPO3-english mailing list

[TYPO3-english] Re: 6.2.0 Install Tool Update Wizard: MySQL-Error

2014-01-15 Thread Thomas Skierlo
Hi Xavier, thank you for your answer. Quote: Xavier Perseguers (xperseguers) wrote on Wed, 15 January 2014 09:30 Hi Thomas, I'm currently trying to get TYPO3 6.2.0 (yesterdays master, fresh install) to work with utf8_unicode_ci collation

Re: [TYPO3-english] Database Error Caused by cli_dispatch.phpsh scheduler

2014-01-15 Thread Scotty C
Thorsten, Good suggestion! But yes, it's 755 so no luck with that :-( -Scott. P.S. I plan to upgrade to 6.2 LTS ... if it ever comes out ;-) From: Thorsten Kahler thorsten.kah...@typo3.org To: typo3-english@lists.typo3.org Sent: Wednesday, January 15, 2014

Re: [TYPO3-english] Database Error Caused by cli_dispatch.phpsh scheduler

2014-01-15 Thread Scotty C
Thorsten, Sorry, cli_dispatch is 755. localconf.php is 660 -S. From: Thorsten Kahler thorsten.kah...@typo3.org To: typo3-english@lists.typo3.org Sent: Wednesday, January 15, 2014 4:16:17 AM Subject: Re: [TYPO3-english] Database Error Caused by

Re: [TYPO3-english] 6.2.0 Install Tool Update Wizard: MySQL-Error

2014-01-15 Thread Thorsten Kahler
Hi Thomas, Thomas Skierlo schrieb am 14.01.14 17:48: Hi, I'm currently trying to get TYPO3 6.2.0 (yesterdays master, fresh install) to work with utf8_unicode_ci collation (instead of utf8_general_ci), but whenever I click on Update Wizard in the Install Tool, I'm getting this mySQL Error:

[TYPO3-english] Re: 6.2.0 Install Tool Update Wizard: MySQL-Error

2014-01-15 Thread Thomas Skierlo
Hello Thorsten, Quote: Thorsten Kahler (thorsten) wrote on Wed, 15 January 2014 11:33 Hi Thomas, Thomas Skierlo schrieb am 14.01.14 17:48: Hi, I'm currently trying to get TYPO3 6.2.0 (yesterdays master, fresh install) to work with

Re: [TYPO3-english] Database Error Caused by cli_dispatch.phpsh scheduler

2014-01-15 Thread Philipp Gampe
Hi Scotty C, Scotty C wrote: Yup, I know the section you're speaking of - $typo_db_password - and it was the first thing I checked. The password is showing in plain text and I can see it is correct. Are you sure that the cron job reads the correct localconf.php file? Does it work if you run

Re: [TYPO3-english] 6.2.0 Install Tool Update Wizard: MySQL-Error

2014-01-15 Thread Markus Klein
Hi! Which patch are you referring to? Kind regards Markus Markus Klein TYPO3 CMS Active Contributors Team Member -Original Message- From: typo3-english-boun...@lists.typo3.org [mailto:typo3-english-

Re: [TYPO3-english] 6.2.0 Install Tool Update Wizard: MySQL-Error

2014-01-15 Thread Oliver Klee
Hi, Am 14.01.2014 17:48, schrieb Thomas Skierlo: I'm currently trying to get TYPO3 6.2.0 (yesterdays master, fresh install) to work with utf8_unicode_ci collation (instead of utf8_general_ci), but whenever I click on Update Wizard in the Install Tool, I'm getting this mySQL Error: llegal

Re: [TYPO3-english] 6.2.0 Install Tool Update Wizard: MySQL-Error

2014-01-15 Thread Philipp Gampe
Hi Markus, Markus Klein wrote: Which patch are you referring to? Maybe the one that allowed you to insert something different than SET NAMES UTF8? I cannot find it currently, but I remember that I had a look into it once. Best regards -- Philipp Gampe – PGP-Key 0AD96065 – TYPO3 UG Bonn/Köln

Re: [TYPO3-english] 6.2.0 Install Tool Update Wizard: MySQL-Error

2014-01-15 Thread Markus Klein
I already found it http://forge.typo3.org/issues/36754 No, it's not about not having used utf8. It is just the collation, which is IMO valid to be adopted as necessary. And the collation of the DB has to be set before you even install TYPO3. Kind regards Markus

Re: [TYPO3-english] WEC Map FE User Coordinates

2014-01-15 Thread Jan Bartels
Am 15.01.2014 01:55, schrieb Miguel: However, i am not suceeding in making WEC Map search for the coordinates in the fields that i have created inside fe_users table: user_lat and user_long. The map is still giving me the users with the cache coordinates. So if you please give a quick check in

[TYPO3-english] Re: 6.2.0 Install Tool Update Wizard: MySQL-Error

2014-01-15 Thread Thomas Skierlo
UPDATE About 6 hours ago the problem was solved. Download latest Master and add SET NAMES utf8 COLLATE utf8_unicode_ci; via Install Tool / All Configuration My problem was gone afterwards. What I still don't understand is why this string is needed at all, if the server is forced to use the

Re: [TYPO3-english] 6.2.0 Install Tool Update Wizard: MySQL-Error

2014-01-15 Thread Markus Klein
You need it, because the connection needs to be in that collation as well. Default seems to be utf8_general_ci. With this setting you define the connection to use Unicode_ci and therefore the CAST method will use the correct collation, which in turn makes the string comparison in the SQL query

[TYPO3-english] Re: Re: Re: WEC Map FE User Coordinates

2014-01-15 Thread Miguel
Sorry to bother you one more time, but your tip didnt worked out, i pasted unset $TCA['fe_users']['ctrl']['EXT']['wec_map']; after the instruction where i define the usergroup but it still is showing the coordinates from the cache table, is not reading from the fields in fe_users table...

Re: [TYPO3-english] WEC Map FE User Coordinates

2014-01-15 Thread Jan Bartels
Am 15.01.2014 21:20, schrieb Miguel: Sorry to bother you one more time, but your tip didnt worked out, i pasted unset $TCA['fe_users']['ctrl']['EXT']['wec_map']; after the instruction where i define the usergroup but it still is showing the coordinates from the cache table, is not reading from

[TYPO3-english] News plugin - Search Form and Real Url

2014-01-15 Thread Indira
Hi guys, I have some configuration in file realurl_conf.php to shorten urls. Everything was working fine until I added the 'Search form' that comes with tx_news extension. The action of the form is not correct if real url is enabled. Without real url the action is fine, and it looks like: