Re: [TYPO3-english] constants.txt versus ext_typoscript_constants.txt

2011-11-14 Thread Peter Niederlag
Hello,

you'll *never* see constants themselves in PHP. constants can be used
inside setup:
plugin.txfoo_pi1.xyz = ${someConst}

You will see the result in $this-conf['xyz'].

Greets and hth,
Peter

Am 11.11.2011 15:56, schrieb Leen Strijk:
 Hi Peter,
 
 So far understood.
 So it's the ext_typoscript_constants file that is deprecated.
 I was under the impression that it was also the other way that was not
 preferred anymore, what makes no sence at all, and kind of implied that
 only flexforms were to be used.
 
 So I have included the file with :
 t3lib_extMgm::addStaticFile($_EXTKEY,'pi1/static','my_extension');
 I can see the keys and values in the BE constants, but in the script no
 data will be available. it should be with $this-conf but only the setup
 data apears while debugging.
 
 I have been searching for a long time now and i am really stuck.
 Whatever i try I can't get the values from either file
 
 btw I am on a local server(offcource) typo3 5.7
 
 
 On 11-11-2011 10:33, Peter Niederlag wrote:
 Hi Leen,

 in fact both approaches can be used in parallel:

 1)
 ext_typoscript_constants.txt will be loaded/included whenever it is
 available. All included code is therfor included globally just by
 installation of the extension. This approach is officially marked
 deprecated but widley used and IMO very useful.

 2)
 register some folder for TS-code in ext_tables.php:
 t3lib_extMgm::addStaticFile($_EXTKEY,'pi1/static','my_extension');

 pi1/static/setup.txt constants.txt ... will be made available as
 Include Static from extensions under the label my_extension when you
 edit a sys_template (TypoScript-template) in the BE on the Include(??)
 tab.

 This code is only executed when the user activly includes this template.

 hth and Greets,
 Peter

 Am 10.11.2011 20:27, schrieb Leen Strijk:
 Hi,
 I was having a problem with the constants.txt file.
 After a lot of searching I finally realised that my problem was that I
 also had a ext_typoscript_constants.txt file in the extension.

 So all the time I was looking at the constants.txt while the ext was
 looking at the ext_typoscript_constants.txt.

 I want to use the constants.txt but when i remove the
 ext_typoscript_constants.txt file the calues from constants.txt won't
 get read.
 I have
 t3lib_extMgm::addStaticFile($_EXTKEY,'pi1/static','my_extension');
 in ex_tables.php

 I read the following in another old topic
 [quote]
 Hi Tapio, Once you install an extension, and it uses the old method
 (ext_typoscript_constants.txt / ext_typoscript_setup.txt), then the
 TS is
 activated for the entire TYPO3 installation, also if you have more
 than one
 domain..

 Using the new method (static/constants.txt / static/setup.txt) You'll
 manually have to include the TS in the template. That way you can have
 different setups for different domains om the same site..

 -- 
 Peter Klein /Umloud Untd
 [/quote]

 So now I think there is a setting for this somewhere. I may have
 overlooked it in kickstarter.

 Does anyone know where i can find that setting or wich file?

 Kind regards
 Leen


 


-- 
Peter Niederlag
http://www.niekom.de * TYPO3  EDV Dienstleistungen *
___
TYPO3-english mailing list
TYPO3-english@lists.typo3.org
http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english


[TYPO3-english] BE sorting not work

2011-11-14 Thread Rayuth You

Hi list

By adding new field 'sorting' into my table, in BE list when I click 
sorting, it did not generated number into field 'sorting'.

In TCA I put 'sortby' = 'sorting'.

Need I do more in TCA? or what I need to do?

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


Re: [TYPO3-english] cache_pages.ibd

2011-11-14 Thread Katja Lampela

Hi,

14.11.2011 10:34, Dmitry Dulepov kirjoitti:

ibd is innodb data file. InnoDB work so that it never reuses the space. When 
record is deleted, the space remains unoccupied in the file. When the new record is 
added, it is added to the end of the file.

You can rebuild the file by executing the following command:

ANALYZE TABLE cache_pages;

That would rebuild the table into a new file. If that does not help (it does 
not, sometimes), you can also do:

ALTER TABLE cache_pages ENGINE=MyISAM;
ALTER TABLE cache_pages ENGINE=InnoDB;

You can add that as a cron job and run at night.



Great, thank you Dmitry! I will try this.


--
With kind regards

Katja Lampela
*Lieska-tuotanto*
www.lieska.net

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


Re: [TYPO3-english] BE sorting not work

2011-11-14 Thread Philipp Gampe
Rayuth You wrote:

 Hi list
 
 By adding new field 'sorting' into my table, in BE list when I click
 sorting, it did not generated number into field 'sorting'.
 In TCA I put 'sortby' = 'sorting'.
 
 Need I do more in TCA? or what I need to do?

Did you clear the cache?

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


Re: [TYPO3-english] BE sorting not work

2011-11-14 Thread Rayuth You

On 11/14/2011 05:19 PM, Philipp Gampe wrote:

Rayuth You wrote:


Hi list

By adding new field 'sorting' into my table, in BE list when I click
sorting, it did not generated number into field 'sorting'.
In TCA I put 'sortby' =  'sorting'.

Need I do more in TCA? or what I need to do?


Did you clear the cache?

Best regards


yes, I already cleared the cache. I tried to find some more hints on 
google but I found nothing.


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


[TYPO3-english] config.minifyJS deprecated since TYPO3 4-6?

2011-11-14 Thread Josef Florian Glatz

Hello list,

im actually refactoring my own framework-extension which I used to 
speedup developing websites. Many predefined static typoscript 
templates, ... are inside and ready to use.


Since a few TYPO3 versions config.minifyJS and config.minifyCSS and 
config.concatenateJsAndCss is available.



TYPO3 4-6 introduces:

config.compressJs = 1
config.compressCss = 1
config.concatenateJs = 1
config.concatenateCss = 1

(example)
page.includeJSlibs {
jquery = code.jquery.com/jquery-1.6.1.min.js
jquery.external = 1
jquery.disableCompression = 1
jquery.excludeFromConcatenation = 1
}


So I think for future websites I can using the new features and can 
forget config.minifyJS, config.minifyCSS andconfig.concatenateJsAndCss?


I know that this older settings needs an own handler to doing real 
minifying.



Thx in advance!


--
Regards,
Josef Florian Glatz
http://typo3blog.at
___
TYPO3-english mailing list
TYPO3-english@lists.typo3.org
http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english


[TYPO3-english] Extension searched for mailing to customers

2011-11-14 Thread hinterindien
Hi List, 

I am searching for a suitable extension for Typo3 4.5 to send plaintext-mails 
to our customers. Customer-data is in table fe_user and in connected tables.

- Preparation of recipient list has to be flexible: there has to be a 
possibility to select a subset of the customers depending on last mail sent, 
activity of customer, and other properties of the customer

- the mails have to be stored for future use and have to have an internal name 
so that they can be easily identified

- the emails should be stored in an extra table. Using the table pages as 
direct-mail does, doesn't work for us.

- it has to be possible to personalize the mail depending on the data stored 
for each customer

Any suggestions, which extension would do the job/nearly do the job?

Thank you for any suggestion
Nico
___
TYPO3-english mailing list
TYPO3-english@lists.typo3.org
http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english


Re: [TYPO3-english] Extension searched for mailing to customers

2011-11-14 Thread Oliver Salzburg

On 2011-11-14 12:44, hinterind...@gmx.net wrote:

Hi List,

I am searching for a suitable extension for Typo3 4.5 to send plaintext-mails 
to our customers. Customer-data is in table fe_user and in connected tables.

- Preparation of recipient list has to be flexible: there has to be a 
possibility to select a subset of the customers depending on last mail sent, 
activity of customer, and other properties of the customer

- the mails have to be stored for future use and have to have an internal name 
so that they can be easily identified

- the emails should be stored in an extra table. Using the table pages as 
direct-mail does, doesn't work for us.

- it has to be possible to personalize the mail depending on the data stored 
for each customer

Any suggestions, which extension would do the job/nearly do the job?

Thank you for any suggestion
Nico


I don't see why this shouldn't be possible with DirectMail.
___
TYPO3-english mailing list
TYPO3-english@lists.typo3.org
http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english


[TYPO3-english] Internet Explorer 9 and RealUrl

2011-11-14 Thread Stefan Frömken

Hello,

I just have fun with IE9 in combination with RealUrl.
In Frontend we have added a RTE but it will not work in IE9.
After activating Debugmode I got a huge list of errormessages:

[HTMLArea.Iframe::getStyleSheets]: Stylesheets not yet loaded (Empty 
rules and imports arrays).


And error_log of RealUrl table fills, too:

-
- sysext/rtehtmlarea/extensions/DefaultInline/skin/htmlarea.css
File htmlarea.css was not found (2)!

- 
konto/beitrag/typo3temp/rtehtmlarea/defaultPageStyle_6d11d5671ff4b72f54b3.css

File defaultPageStyle_6d11d5671ff4b72f54b3.css was not found (2)!

- konto/beitrag/fileadmin/css/rte/content.css
File content.css was not found (2)!
-

Any ideas how to remove konto/beitrag/ from path? What I'm doing wrong?

Stefan

Our realurl_autoconf.php is very simple (no really complex parts).

?php
$GLOBALS['TYPO3_CONF_VARS']['EXTCONF']['realurl'] = array (
'_DEFAULT' = array (
'init' = array (
'enableCHashCache' = true,
'appendMissingSlash' = 'ifNotFile,redirect',
'adminJumpToBackend' = true,
'enableUrlDecodeCache' = true,
'enableUrlEncodeCache' = true,
'emptyUrlReturnValue' = '/',
),
'pagePath' = array (
'type' = 'user',
			'userFunc' = 
'EXT:realurl/class.tx_realurl_advanced.php:tx_realurl_advanced-main',

'spaceCharacter' = '-',
'languageGetVar' = 'L',
'expireDays' = 7,
'rootpage_id' = 1,
'excludePageIds' = 2225,
),
'fixedPostVars' = array(),
'postVarSets' = array(
'_DEFAULT' = array(
'info' = array(
array(
'GETvar' = 
'tx_ttnews[tt_news]',
'lookUpTable' = array(
'table' = 'tt_news',
'id_field' = 'uid',
'alias_field' = 
'title',
'addWhereClause' = ' 
AND NOT deleted',
'useUniqueCache' = 1,
'useUniqueCache_conf' 
= array(
'strtolower' = 
1,
'spaceCharacter' 
= '-',
),
),
),
array(
'GETvar' = 'tx_ttnews[swords]',
),
),
),
),
'fileName' = array (
'defaultToHTMLsuffixOnPrev' = 1,
'acceptHTMLsuffix' = 1,
),
),
);
?
___
TYPO3-english mailing list
TYPO3-english@lists.typo3.org
http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english


Re: [TYPO3-english] BE sorting not work

2011-11-14 Thread Philipp Gampe
Hi,

Rayuth You wrote:

 By adding new field 'sorting' into my table, in BE list when I click
 sorting, it did not generated number into field 'sorting'.
 In TCA I put 'sortby' =  'sorting'.

 Need I do more in TCA? or what I need to do?

Can you check whether your added field shows up in TCA?
You can do so in backend using the module configuration and switching this 
to table configuration array ($TCA). There you can browse your full TCA.

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


Re: [TYPO3-english] Slow Queries From TT-News

2011-11-14 Thread Muriel le Pair

On 10-11-11 11:12, Victor Livakovsky wrote:

As far, as I understood, these part of queries are generated by
enableFields() of tslib_cObj class, which comes from core, and, I
believe, core members know, what they are doing.


If these queries are really produced by the core I seriously doubt that 
they know what they are doing (sorry, I don't mean to offend anybody, 
but the example query really sucks.

It does however explain why uncached TYPO3 pages are so terrible slow..

It's no problem to use LIKE, but if you are using LIKE with a wildcard 
at the beginning (LIKE '%,0') MySql is unable to use the index. 
http://dev.mysql.com/doc/refman/5.1/en/mysql-indexes.html



Most I'm scared about AND tt_news.pid IN(835,2905,...) - there is
really large number of pids. You better place all of your news records
into one folder and set pid to it with zero recursion level.


In my humble opinion LIKE '%,0' is a much bigger problem it shouldn't be 
used.


To speed up the site you could install the extension 'cachemgm' and set 
a scheduler to cache the pages automatically at night.



--
Kind regards,

Muriel le Pair

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


Re: [TYPO3-english] Slow Queries From TT-News

2011-11-14 Thread Xavier Perseguers

Hi,


It's no problem to use LIKE, but if you are using LIKE with a wildcard
at the beginning (LIKE '%,0') MySql is unable to use the index.
http://dev.mysql.com/doc/refman/5.1/en/mysql-indexes.html


The big problem comes from having to deal with comma-separated values to 
reference records (here fe_groups) instead of real foreign keys.


Hopefully, more and more extensions will have a better scheme.

Unfortunately, this is unlikely to happen for TYPO3 Core itself as it 
would break virtually too many extensions or would probably mean have a 
non-negligible overhead to have some fallback for them (scheduler job?).


Cheers

--
Xavier Perseguers
Release Manager TYPO3 4.6

TYPO3  inspiring people to share!
Get involved: http://typo3.org

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


Re: [TYPO3-english] Slow Queries From TT-News

2011-11-14 Thread Georg Ringer
Am 14.11.2011 19:58, schrieb Xavier Perseguers:
 The big problem comes from having to deal with comma-separated values to
 reference records (here fe_groups) instead of real foreign keys.
so how should an ideal query look like instead?

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


Re: [TYPO3-english] Slow Queries From TT-News

2011-11-14 Thread Xavier Perseguers

Hi,

Georg Ringer wrote:

Am 14.11.2011 19:58, schrieb Xavier Perseguers:

The big problem comes from having to deal with comma-separated values to
reference records (here fe_groups) instead of real foreign keys.

so how should an ideal query look like instead?


 (tt_news.fe_group='' OR tt_news.fe_group
 IS NULL OR tt_news.fe_group='0'

No group

 OR (tt_news.fe_group LIKE '%,0,%' OR
 tt_news.fe_group LIKE '0,%' OR tt_news.fe_group LIKE '%,0' OR
 tt_news.fe_group='0') OR (tt_news.fe_group LIKE '%,-1,%' OR
 tt_news.fe_group LIKE '-1,%' OR tt_news.fe_group LIKE '%,-1' OR
 tt_news.fe_group='-1')

-1 is a virtual group used to Hide content at any login [1]

So basically we search news which are targeted at no, group, group 0 
(= no group), or that should be hidden at login.


With a proper structure, we would have something like

- table tt_news (uid, ...)
- table fe_groups (uid, ...)
- table tt_news_fegroups_mm (uid_local, uid_foreign)

uid_local is a foreign key to tt_news(uid)
uid_foreign is a foreign key to fe_groups(uid)

Thus search for news without any group:

SELECT * FROM tt_news WHERE NOT EXISTS(SELECT * FROM tt_news_fegroups_mm 
WHERE uid_local=tt_news.uid)


Search news with the group -1:

SELECT * FROM tt_news WHERE EXISTS(SELECT * FROM tt_nerws_fegroups_mm 
WHERE uid_local=tt_news.uid AND uid_foreign=-1)


OK, when using DB constraints on foreign keys, we would need to have a 
real fe_group entry for -1 and -2 (or 0) but I guess you get the point.


The latter query could be rewritten as INNER JOIN without subquery as well.

HTH

[1] 
http://xavier.perseguers.ch/en/tutorials/typo3/articles/indexed-search-crawler.html#c868


--
Xavier Perseguers
Release Manager TYPO3 4.6

TYPO3  inspiring people to share!
Get involved: http://typo3.org

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


Re: [TYPO3-english] Slow Queries From TT-News

2011-11-14 Thread Georg Ringer
HI Xavier,

yeah but how to select then records with 20 pids set, this needs to be a
FIND_IN_SET or IN(), no matter if inside a join or not, right?

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


Re: [TYPO3-english] Internet Explorer 9 and RealUrl

2011-11-14 Thread Kay Strobach
Hi,

set the baseUri for you website and it should work ;)

Regards
Kay

Am 14.11.2011 16:05, schrieb Stefan Frömken:
 Hello,
 
 I just have fun with IE9 in combination with RealUrl.
 In Frontend we have added a RTE but it will not work in IE9.
 After activating Debugmode I got a huge list of errormessages:
 
 [HTMLArea.Iframe::getStyleSheets]: Stylesheets not yet loaded (Empty
 rules and imports arrays).
 
 And error_log of RealUrl table fills, too:
 
 -
 - sysext/rtehtmlarea/extensions/DefaultInline/skin/htmlarea.css
 File htmlarea.css was not found (2)!
 
 -
 konto/beitrag/typo3temp/rtehtmlarea/defaultPageStyle_6d11d5671ff4b72f54b3.css
 
 File defaultPageStyle_6d11d5671ff4b72f54b3.css was not found (2)!
 
 - konto/beitrag/fileadmin/css/rte/content.css
 File content.css was not found (2)!
 -
 
 Any ideas how to remove konto/beitrag/ from path? What I'm doing wrong?
 
 Stefan
 
 Our realurl_autoconf.php is very simple (no really complex parts).
 
 ?php
 $GLOBALS['TYPO3_CONF_VARS']['EXTCONF']['realurl'] = array (
 '_DEFAULT' = array (
 'init' = array (
 'enableCHashCache' = true,
 'appendMissingSlash' = 'ifNotFile,redirect',
 'adminJumpToBackend' = true,
 'enableUrlDecodeCache' = true,
 'enableUrlEncodeCache' = true,
 'emptyUrlReturnValue' = '/',
 ),
 'pagePath' = array (
 'type' = 'user',
 'userFunc' =
 'EXT:realurl/class.tx_realurl_advanced.php:tx_realurl_advanced-main',
 'spaceCharacter' = '-',
 'languageGetVar' = 'L',
 'expireDays' = 7,
 'rootpage_id' = 1,
 'excludePageIds' = 2225,
 ),
 'fixedPostVars' = array(),
 'postVarSets' = array(
 '_DEFAULT' = array(
 'info' = array(
 array(
 'GETvar' = 'tx_ttnews[tt_news]',
 'lookUpTable' = array(
 'table' = 'tt_news',
 'id_field' = 'uid',
 'alias_field' = 'title',
 'addWhereClause' = ' AND NOT deleted',
 'useUniqueCache' = 1,
 'useUniqueCache_conf' = array(
 'strtolower' = 1,
 'spaceCharacter' = '-',
 ),
 ),
 ),
 array(
 'GETvar' = 'tx_ttnews[swords]',
 ),
 ),
 ),
 ),
 'fileName' = array (
 'defaultToHTMLsuffixOnPrev' = 1,
 'acceptHTMLsuffix' = 1,
 ),
 ),
 );
 ?


-- 
http://www.kay-strobach.de - Open Source Rocks

TYPO3  inspiring people to share!
Get involved: http://typo3.org

Answere was usefull: https://flattr.com/profile/kaystrobach
___
TYPO3-english mailing list
TYPO3-english@lists.typo3.org
http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english


Re: [TYPO3-english] Slow Queries From TT-News

2011-11-14 Thread Jigal van Hemert

Hi,

On 9-11-2011 21:04, Louis Coppola wrote:

tt_news.endtime1315613160) AND (tt_news.fe_group='' OR tt_news.fe_group
IS NULL OR tt_news.fe_group='0' OR (tt_news.fe_group LIKE '%,0,%' OR
tt_news.fe_group LIKE '0,%' OR tt_news.fe_group LIKE '%,0' OR
tt_news.fe_group='0') OR (tt_news.fe_group LIKE '%,-1,%' OR
tt_news.fe_group LIKE '-1,%' OR tt_news.fe_group LIKE '%,-1' OR
tt_news.fe_group='-1'))


Which version of TYPO3 are you using here? Since 4.5 these constructions 
are replaced with FIND_IN_SET(). Maybe that's reason enough for you to 
upgrade?


By the way: for other databases DBAL uses appropriate functions or 
replacements when FIND_IN_SET is used.


--
Kind regards / met vriendelijke groet,

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


[TYPO3-english] 4.6 upgrading errors

2011-11-14 Thread Lamb, Brian
Hi all, 

I recently upgraded to 4.6 and am experiencing two errors that I cannot seem to 
resolve:

1) My tt_news items no longer show up. When I go to the page where they used to 
be, it does not render any tt_news items. I looked at the page configuration 
and nothing seems out of place there. 

2) I'm getting the following error: 
Fatal error: Call to undefined method t3lib_div::GPvar() 
/my/path/to/typo3conf/ext/rggooglemap/pi1/class.tx_rggooglemap_pi1.php on line 
1022

I was getting this error with Templavoila as well but when I upgraded it, it 
went away. Does this mean this extension is unusable at this point?

Thanks, 

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


Re: [TYPO3-english] 4.6 upgrading errors

2011-11-14 Thread Steffen Gebert

Hi Brian,

thanks for your reports.


I recently upgraded to 4.6 and am experiencing two errors that I cannot seem to 
resolve:

1) My tt_news items no longer show up. When I go to the page where they used to 
be, it does not render any tt_news items. I looked at the page configuration 
and nothing seems out of place there.
Did you update to the most recent tt_news version? I read that an update 
is needed, but don't know exactly, what the incompatibility was.



2) I'm getting the following error:
Fatal error: Call to undefined method t3lib_div::GPvar() 
/my/path/to/typo3conf/ext/rggooglemap/pi1/class.tx_rggooglemap_pi1.php on line 
1022

Does this mean this extension is unusable at this point?
Exactly. You could ask Georg to update his extension. It shouldn't be a 
big problem..


General advice: Check your deprecation log before upgrading to 4.6!

Kind regards
Steffen

--
Steffen Gebert
TYPO3 v4 Core Team Member
TYPO3 Server Administration Team Member

TYPO3  inspiring people to share!
Get involved: http://typo3.org
___
TYPO3-english mailing list
TYPO3-english@lists.typo3.org
http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english


Re: [TYPO3-english] 4.6 upgrading errors

2011-11-14 Thread Jigal van Hemert

Hi,

On 14-11-2011 22:47, Lamb, Brian wrote:

I recently upgraded to 4.6 and am experiencing two errors that I
cannot seem to resolve:

1) My tt_news items no longer show up. When I go to the page where
they used to be, it does not render any tt_news items. I looked at
the page configuration and nothing seems out of place there.


Upgrade tt_news. There is a new version of tt_news which is compatible 
with TYPO3 4.6.



2) I'm getting the following error: Fatal error: Call to undefined
method t3lib_div::GPvar()
/my/path/to/typo3conf/ext/rggooglemap/pi1/class.tx_rggooglemap_pi1.php
on line 1022


t3lib_div::GPvar() was removed in 4.6 after being deprecated since TYPO3 
3.6 (!). The use of this function in rggooglemap was logged in the 
deprecation log since 4.4.


There is a version 3.0.3 of rggooglemap in TER which does not contain 
this function. Maybe you should try upgrading this extension too?


--
Kind regards / met vriendelijke groet,

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


Re: [TYPO3-english] Slow Queries From TT-News

2011-11-14 Thread Xavier Perseguers

Hi Georg,


yeah but how to select then records with 20 pids set, this needs to be a
FIND_IN_SET or IN(), no matter if inside a join or not, right?


You use an IN(), yes, no problem (I found once that number of items 
within IN is limited in some DBMS. In Oracle 10 for instance IIRC it is 
1000. Then you have to split your list into something like


column IN (i1, i2, i3, ... i1000) OR column IN (i1001, ...)

Regarding FIND_IN_SET, Jigal is right, the aforementioned query should 
in fact be written using FIND_IN_SET and not the LIKE construct for 
MySQL but anyway, it is prettier but even without number at hand I 
really fear it is not quicker than the LIKE statements because basically 
the only method to properly search that is having full text search 
capability, something that allows special indices to be built where the 
string is tokenized in reverse order as well to let the % be placed at 
the beginning as well.


If you have the possibility to use a real relation, do it without 
hesitation! And do not forget to add CREATE INDEX statements, basically 
as a rule of thumb, for all your foreign keys.


Regards

--
Xavier Perseguers
Release Manager TYPO3 4.6

TYPO3  inspiring people to share!
Get involved: http://typo3.org

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


Re: [TYPO3-english] BE sorting not work

2011-11-14 Thread Rayuth You

On 11/14/2011 10:35 PM, Philipp Gampe wrote:

Hi,

Rayuth You wrote:


By adding new field 'sorting' into my table, in BE list when I click
sorting, it did not generated number into field 'sorting'.
In TCA I put 'sortby' =   'sorting'.

Need I do more in TCA? or what I need to do?


Can you check whether your added field shows up in TCA?
You can do so in backend using the module configuration and switching this
to table configuration array ($TCA). There you can browse your full TCA.

Best regards


Hi

You are right, when I check table configuration array ($TCA) I found 
no 'sorting'.

But when I added:
'sorting' = array(
'config' = array(
'type' = 'input',
'size' = 30,
)
),

It's still not work.

Did I configure anything wrong?

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


[TYPO3-english] disable tt_content element showin on page type=folder

2011-11-14 Thread Domi

Hello,

I want to disable the backend layout and tt_content elements, if a 
be-user is on a page with type folder. I know that this was in TV a 
default behavior, is this also possible without TV?


Cheers and Thanks,

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


Re: [TYPO3-english] disable tt_content element showin on page type=folder

2011-11-14 Thread Georg Ringer

Am 15.11.2011 04:22, schrieb Domi:

I know that this was in TV a
default behavior, is this also possible without TV?


not without coding, if you need it pay one or do it yourself and publish it

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


[TYPO3-english] js_slidernews

2011-11-14 Thread Historia

Hello,
I am working with slidernews and like the extension very much.  I have a 
two language site in English and Amharic. Not a language which is yet 
supported in Typo3, but I manage. However the date in slidernews is not 
in the right coding. Only in Style 6 the days are correct in Amharic. In 
the menu the days are always coded wrong.


Typo3 4.5.5
t3s_jslidernews 2.2.0

I already tried version 2.2.1 which doesn't exchange the markers on my 
system.


By the way. The Amharic weekdays seem to come out of the localization of 
the webserver (Server: Apache/2.2.10 (Linux/SUSE) X-Powered-By: 
PHP/5.2.13) because there are is no other localization on the system.


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

Re: [TYPO3-english] Internet Explorer 9 and RealUrl

2011-11-14 Thread Stefan Frömken

Hello Kay,

sorry...baseUrl ist set correctly in HTML (with ending slash)

base href=http://relaunch.myPage.com/; /

Stefan


Am 14.11.2011 21:46, schrieb Kay Strobach:

Hi,

set the baseUri for you website and it should work ;)

Regards
Kay

Am 14.11.2011 16:05, schrieb Stefan Frömken:

Hello,

I just have fun with IE9 in combination with RealUrl.
In Frontend we have added a RTE but it will not work in IE9.
After activating Debugmode I got a huge list of errormessages:

[HTMLArea.Iframe::getStyleSheets]: Stylesheets not yet loaded (Empty
rules and imports arrays).

And error_log of RealUrl table fills, too:

-
- sysext/rtehtmlarea/extensions/DefaultInline/skin/htmlarea.css
File htmlarea.css was not found (2)!

-
konto/beitrag/typo3temp/rtehtmlarea/defaultPageStyle_6d11d5671ff4b72f54b3.css

File defaultPageStyle_6d11d5671ff4b72f54b3.css was not found (2)!

- konto/beitrag/fileadmin/css/rte/content.css
File content.css was not found (2)!
-

Any ideas how to remove konto/beitrag/ from path? What I'm doing wrong?

Stefan

Our realurl_autoconf.php is very simple (no really complex parts).

?php
$GLOBALS['TYPO3_CONF_VARS']['EXTCONF']['realurl'] = array (
 '_DEFAULT' =  array (
 'init' =  array (
 'enableCHashCache' =  true,
 'appendMissingSlash' =  'ifNotFile,redirect',
 'adminJumpToBackend' =  true,
 'enableUrlDecodeCache' =  true,
 'enableUrlEncodeCache' =  true,
 'emptyUrlReturnValue' =  '/',
 ),
 'pagePath' =  array (
 'type' =  'user',
 'userFunc' =
'EXT:realurl/class.tx_realurl_advanced.php:tx_realurl_advanced-main',
 'spaceCharacter' =  '-',
 'languageGetVar' =  'L',
 'expireDays' =  7,
 'rootpage_id' =  1,
 'excludePageIds' =  2225,
 ),
 'fixedPostVars' =  array(),
 'postVarSets' =  array(
 '_DEFAULT' =  array(
 'info' =  array(
 array(
 'GETvar' =  'tx_ttnews[tt_news]',
 'lookUpTable' =  array(
 'table' =  'tt_news',
 'id_field' =  'uid',
 'alias_field' =  'title',
 'addWhereClause' =  ' AND NOT deleted',
 'useUniqueCache' =  1,
 'useUniqueCache_conf' =  array(
 'strtolower' =  1,
 'spaceCharacter' =  '-',
 ),
 ),
 ),
 array(
 'GETvar' =  'tx_ttnews[swords]',
 ),
 ),
 ),
 ),
 'fileName' =  array (
 'defaultToHTMLsuffixOnPrev' =  1,
 'acceptHTMLsuffix' =  1,
 ),
 ),
);
?





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


Re: [TYPO3-english] js_slidernews

2011-11-14 Thread Historia

Hello,

I think I found the problem

By using utf8-encode the date in utf-8 is encoded in a different way. So 
the marker DATE is wrong, but the marker DATE_ICON  is right, because it 
is not changed.


if ($GLOBALS['TSFE']-tmpl-setup['config.']['renderCharset'] == 'utf-8') {
$marksItem['###DATE###'] = 'span class=date'. 
utf8_encode(strftime($this-conf['dateFormat'],$record['datetime'])).'/span'; 


} else {
$marksItem['###DATE###'] = 'span 
class=date'.strftime($this-conf['dateFormat'],$record['datetime']).'/span';

}

$marksItem['###DATE_ICON###'] = 'span 
class=date_icon'.strftime($this-conf['dateFormat'],$record['datetime']).'/span';


The renderCharset setting in tx_extbase is triggering the fault. But why 
is this if statement in the definition? There is no need to encode if it 
is already encoded, or is there another issue?


Herbert



Am 15/11/2011 9:19 ጡዋት, schrieb Historia:

Hello,
I am working with slidernews and like the extension very much. I have a
two language site in English and Amharic. Not a language which is yet
supported in Typo3, but I manage. However the date in slidernews is not
in the right coding. Only in Style 6 the days are correct in Amharic. In
the menu the days are always coded wrong.

Typo3 4.5.5
t3s_jslidernews 2.2.0

I already tried version 2.2.1 which doesn't exchange the markers on my
system.

By the way. The Amharic weekdays seem to come out of the localization of
the webserver (Server: Apache/2.2.10 (Linux/SUSE) X-Powered-By:
PHP/5.2.13) because there are is no other localization on the system.

Thanks


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