[TYPO3-english] Indexed_search problem with utf8 (Historia)

Girmangus Hailu girmangus at gmail.com
Fri Feb 11 13:36:30 CET 2011


Dear Herbert,

I thank you for the technical advice and here are things that I configure,

I'm using typo3 4.4.5 version and I'm running it under ubuntu 10.10, when I
create a database phpmyadmin shows me by default collation utf8_general_ci,
and every table is a ENGINE=InnoDB DEFAULT CHARSET=utf8, and as u have told
me, i have changes it to the collation utf8_unicode_ci and no change @ all.
for ur knowledge tt_news, back end DB check full search and the form search
finds the unicode characters  using collation utf8_general_ci, and I try to
add /u in the class.tx_indexedsearch.php line 1998 for the excess space but
still the problem is alive.

I thank you for ur precious time,


Girmangus H


On Fri, Feb 11, 2011 at 12:25 PM, <typo3-english-request at lists.typo3.org>wrote:

> Send TYPO3-english mailing list submissions to
>        typo3-english at lists.typo3.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
>        http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english
> or, via email, send a message with subject or body 'help' to
>        typo3-english-request at lists.typo3.org
>
> You can reach the person managing the list at
>        typo3-english-owner at lists.typo3.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of TYPO3-english digest..."
>
>
> Today's Topics:
>
>   1. First problems. Sharing a MySql database (Giuseppe Luigi)
>   2. Re: First problems. Sharing a MySql database (Christian Kuhn)
>   3. Re: First problems. Sharing a MySql database (Steffen Gebert)
>   4. Re: First problems. Sharing a MySql database (Xavier Perseguers)
>   5. Re: First problems. Sharing a MySql database
>      (Giuseppe Luigi Punzi)
>   6. Re: Newbie in typo3 (Giuseppe Luigi Punzi)
>   7.  Join the translation efforts (Fran?ois Suter)
>   8.  phpBB3 and TYPO3 running together - but how? (S?ren Vedel)
>   9. Re: phpBB3 and TYPO3 running together - but how? (Philipp Gampe)
>  10. Re: Newbie in typo3 (Andreas Becker)
>  11. Re: Indexed_search problem with utf8 (Historia)
>  12. Re: phpBB3 and TYPO3 running together - but how? (Kay Strobach)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Thu, 10 Feb 2011 19:43:48 +0100
> From: Giuseppe Luigi <glpunzi at lordzealon.com>
> Subject: [TYPO3-english] First problems. Sharing a MySql database
> To: TYPO3 English <typo3-english at lists.typo3.org>
> Message-ID:
>        <mailman.9904.1297363773.648.typo3-english at lists.typo3.org>
> Content-Type: text/plain; charset="UTF-8"
>
> Hi all,
>
> I'm on the way of installing new 4.5 in my host.
>
> The problem is, thath I only have 1 database, and I can't create more,
> but Typo3 installation, only gives me the options, of choose an empty
> database, or create one.
>
> Skipping 1.2.3 wizard, I only see (about databases):
> Database:
> (Can only select database if username/password/host is correctly set
> first)
>
> But this data is correctly entered.
>
> Can't I use Typo3 in a shared database with other site, using prefixes
> for each table?
>
> Cheers.
>
>
>
>
> ------------------------------
>
> Message: 2
> Date: Thu, 10 Feb 2011 19:57:41 +0100
> From: Christian Kuhn <lolli at schwarzbu.ch>
> Subject: Re: [TYPO3-english] First problems. Sharing a MySql database
> To: TYPO3 English <typo3-english at lists.typo3.org>
> Message-ID:
>        <mailman.9906.1297364373.648.typo3-english at lists.typo3.org>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> Hey,
>
> On 02/10/2011 07:43 PM, Giuseppe Luigi wrote:
> > Can't I use Typo3 in a shared database with other site, using prefixes
> > for each table?
>
> No, prefixing all tables is not possible.
>
> Regards
> Christian
>
>
> ------------------------------
>
> Message: 3
> Date: Thu, 10 Feb 2011 19:56:18 +0100
> From: Steffen Gebert <steffen.gebert at typo3.org>
> Subject: Re: [TYPO3-english] First problems. Sharing a MySql database
> To: typo3-english at lists.typo3.org
> Message-ID: <mailman.1.1297364286.19087.typo3-english at lists.typo3.org>
> Content-Type: text/plain; charset=UTF-8; format=flowed
>
> > Skipping 1.2.3 wizard, I only see (about databases):
> You should not skip that wizard.
>
> > Database:
> > (Can only select database if username/password/host is correctly set
> > first)
> > But this data is correctly entered.
> Probably it was not saved..
>
> > Can't I use Typo3 in a shared database with other site, using prefixes
> > for each table?
> Nope
>
>
> Kind regards
> Steffen
>
> --
> Steffen Gebert
> TYPO3 v4 Core Team Member
>
> TYPO3 .... inspiring people to share!
> Get involved: http://typo3.org
>
>
> ------------------------------
>
> Message: 4
> Date: Thu, 10 Feb 2011 19:58:50 +0100
> From: Xavier Perseguers <typo3 at perseguers.ch>
> Subject: Re: [TYPO3-english] First problems. Sharing a MySql database
> To: typo3-english at lists.typo3.org
> Message-ID: <mailman.1.1297364439.19262.typo3-english at lists.typo3.org>
> Content-Type: text/plain; charset=UTF-8; format=flowed
>
> Hi,
>
> Steffen Gebert wrote:
> >> Skipping 1.2.3 wizard, I only see (about databases):
> > You should not skip that wizard.
> >
> >> Database:
> >> (Can only select database if username/password/host is correctly set
> >> first)
> >> But this data is correctly entered.
> > Probably it was not saved..
> >
> >> Can't I use Typo3 in a shared database with other site, using prefixes
> >> for each table?
> > Nope
>
> Actually, it should work by using sysext DBAL and its mapping feature ;-)
>
> Xavier
>
>
> ------------------------------
>
> Message: 5
> Date: Thu, 10 Feb 2011 20:18:30 +0100
> From: Giuseppe Luigi Punzi <glpunzi at lordzealon.com>
> Subject: Re: [TYPO3-english] First problems. Sharing a MySql database
> To: typo3-english at lists.typo3.org
> Message-ID:
>        <mailman.9911.1297365623.648.typo3-english at lists.typo3.org>
> Content-Type: text/plain; charset="UTF-8"
>
> Well, then, at modelling I will do it in my private server, and when
> ready move it.
>
> Thanks.
>
> El jue, 10-02-2011 a las 19:56 +0100, Steffen Gebert escribi?:
>
> > > Skipping 1.2.3 wizard, I only see (about databases):
> > You should not skip that wizard.
> >
> > > Database:
> > > (Can only select database if username/password/host is correctly set
> > > first)
> > > But this data is correctly entered.
> > Probably it was not saved..
> >
> > > Can't I use Typo3 in a shared database with other site, using prefixes
> > > for each table?
> > Nope
> >
> >
> > Kind regards
> > Steffen
> >
>
>
>
>
> ------------------------------
>
> Message: 6
> Date: Thu, 10 Feb 2011 21:33:26 +0100
> From: Giuseppe Luigi Punzi <glpunzi at lordzealon.com>
> Subject: Re: [TYPO3-english] Newbie in typo3
> To: TYPO3 English <typo3-english at lists.typo3.org>
> Message-ID:
>        <mailman.9921.1297370123.648.typo3-english at lists.typo3.org>
> Content-Type: text/plain; charset="UTF-8"
>
> Hi Oliver,
>
>
> > *
> >
> http://typo3.org/documentation/document-library/tutorials/doc_tut_templselect/current/
> >
> > The TSREF is your friend:
>
>
> Is better this than TemplaVoila?
>
>
> >
> >
> http://typo3.org/documentation/document-library/core-documentation/doc_core_tsref/current/
> >
> > nevertheless your mileage may vary on the extensions to be used.
> >
> > * tt_news is great for news and for a blog (timtab)
> > * mm_forum is the defacto standard for forums
> > * shop? depending on the size. could be formhandler based solution up to
> > tt_products or commerce.
> >
> > As always this is my personal recomendation... make your own experience
> > here and share it with us!
>
>
> I will check all fo this, thanks.
>
>
> ------------------------------
>
> Message: 7
> Date: Thu, 10 Feb 2011 23:40:35 +0100
> From: Fran?ois Suter <fsu-lists at cobweb.ch>
> Subject: [TYPO3-english]  Join the translation efforts
> To: typo3-english at lists.typo3.org
> Message-ID: <mailman.1.1297377744.6216.typo3-english at lists.typo3.org>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> Hi all,
>
> As you may know we have recently officialized the process of translating
> the TYPO3 official documentation:
>
> http://news.typo3.org/news/article/translations-also-go-official/
>
> The response has been very good so far, but there is a lot of stuff to
> translate and many languages to translate into, so you are encouraged to
> join the effort.
>
> If you want to know more about the technical details, you can read more
> here:
>
> http://wiki.typo3.org/DocTeam/Official_Documentation
>
> Cheers
>
> --
>
> Francois Suter
> Cobweb Development Sarl - http://www.cobweb.ch
>
>
> ------------------------------
>
> Message: 8
> Date: Fri, 11 Feb 2011 00:13:00 +0100
> From: S?ren Vedel <sv at workhouse.dk>
> Subject: [TYPO3-english]  phpBB3 and TYPO3 running together - but how?
> To: typo3-english at lists.typo3.org
> Message-ID: <mailman.1.1297379689.9200.typo3-english at lists.typo3.org>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> Hi everybody,
>
> I am looking for at site, that has phpBB3 running together with TYPO3.
> Maybe integrated. Maybe in an iframe, or maybe something totally different.
>
> Has anyone done it, and could you tell me how, and give me a link to a
> live-site, where I can see your solution?
>
> The phpBB3 forum is actually nice and fast, too, but the main reason for
> me to use it, is that I have "inherited" it from the former client.
>
> I tried of course to import to mm_forum, but the import tool somehow
> crashed, and no matter what, I would loose parts of the current setup,
> that includes 40.000 post and 4-5.000 users, so....
>
>
> Med venlig hilsen/Kind regards
> S?ren Vedel
>
> PS: Please don't tell me, that it is very unsafe etc. - I know ;-)
>
>
> ------------------------------
>
> Message: 9
> Date: Fri, 11 Feb 2011 00:17:11 +0100
> From: Philipp Gampe <typo3.lists at philippgampe.info>
> Subject: Re: [TYPO3-english] phpBB3 and TYPO3 running together - but
>        how?
> To: typo3-english at lists.typo3.org
> Message-ID: <mailman.1.1297379939.9191.typo3-english at lists.typo3.org>
> Content-Type: text/plain; charset="UTF-8"
>
> Hi S?ren,
>
> S?ren Vedel wrote:
>
> > I am looking for at site, that has phpBB3 running together with TYPO3.
> > Maybe integrated. Maybe in an iframe, or maybe something totally
> > different.
> >
> > Has anyone done it, and could you tell me how, and give me a link to a
> > live-site, where I can see your solution?
>
> Maybe this is a start
> http://typo3.org/extensions/repository/view/phpbb_auth/current/
>
>
> Best regards
> --
> Philipp Gampe
>
>
> ------------------------------
>
> Message: 10
> Date: Fri, 11 Feb 2011 08:32:50 +0700
> From: Andreas Becker <ab.becker at web.de>
> Subject: Re: [TYPO3-english] Newbie in typo3
> To: TYPO3 English <typo3-english at lists.typo3.org>
> Message-ID:
>        <mailman.9935.1297388135.648.typo3-english at lists.typo3.org>
> Content-Type: text/plain; charset=UTF-8
>
> Hi Giuseppe
>
> TSREF is about TYPOscript and
>
> TemplaVoila is a great editor friendly way of Templating in Templavoila.
> They are 2 different things.
>
> You need to read the TSREF also when you are using TemplaVoila i.e. in the
> Framework for TemplaVoila http://templavoila.busynoggin.com
>
> Andi
>
> On Fri, Feb 11, 2011 at 3:33 AM, Giuseppe Luigi Punzi <
> glpunzi at lordzealon.com> wrote:
>
> > Hi Oliver,
> >
> >
> > > *
> > >
> >
> http://typo3.org/documentation/document-library/tutorials/doc_tut_templselect/current/
> > >
> > > The TSREF is your friend:
> >
> >
> > Is better this than TemplaVoila?
> >
> >
> > >
> > >
> >
> http://typo3.org/documentation/document-library/core-documentation/doc_core_tsref/current/
> > >
> > > nevertheless your mileage may vary on the extensions to be used.
> > >
> > > * tt_news is great for news and for a blog (timtab)
> > > * mm_forum is the defacto standard for forums
> > > * shop? depending on the size. could be formhandler based solution up
> to
> > > tt_products or commerce.
> > >
> > > As always this is my personal recomendation... make your own experience
> > > here and share it with us!
> >
> >
> > I will check all fo this, thanks.
> > _______________________________________________
> > TYPO3-english mailing list
> > TYPO3-english at lists.typo3.org
> > http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english
> >
>
>
> ------------------------------
>
> Message: 11
> Date: Fri, 11 Feb 2011 11:18:11 +0300
> From: Historia <newsletter at zimmermann-steinhart.de>
> Subject: Re: [TYPO3-english] Indexed_search problem with utf8
> To: typo3-english at lists.typo3.org
> Message-ID: <mailman.1.1297412418.5184.typo3-english at lists.typo3.org>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> hello Girmangus,
>
> I am working on this problem for quite some time and I am astonished
> about the problems. Yesterday I set up a clean 4.5 dummy on a brand new
> wampserver 2.1. with Mysql 5.5.8.
>
> Checked all values in the typo install and all is set to utf-8. However
> search was not working.
>
> The problem was the database which was set to COLLATE=latin1_swedish_ci
> and charset=latin1.
>
> Exported the Database with drop table, deleted it in Myadmin and made a
> new one with collation utf8_unicode_ci and imported the database again.
>
> The search is working with the standard search but not with indexed_search.
>
> Herbert
>
>
>
> Am 04.02.2011 10:39, schrieb Girmangus Hailu:
>  > I have a multi language site and I have installed the indexed search
>  > plugin. the indexed search search and brings me a result of number,
>  > date and english words but when I try to search using utf8 characters
>  > it doesn't show me the result, it simply says "no result found". I
>  > have checked the index fulltext and it has already the keywords that
>  > i'm searching for. I try to fix the preg_replace with /u and it
>  > doesn't show me any thing. pls help me guys.I know this problem face
>  > everybody before. I'm waiting for ur response and feel free to ask me
>  > if u need additional information.
>  >
>  > I thank you,
>  > Girmangus H
>
>
> Am 04.02.2011 10:39, schrieb Girmangus Hailu:
> > I have a multi language site and I have installed the indexed search
> > plugin. the indexed search search and brings me a result of number,
> > date and english words but when I try to search using utf8 characters
> > it doesn't show me the result, it simply says "no result found". I
> > have checked the index fulltext and it has already the keywords that
> > i'm searching for. I try to fix the preg_replace with /u and it
> > doesn't show me any thing. pls help me guys.I know this problem face
> > everybody before. I'm waiting for ur response and feel free to ask me
> > if u need additional information.
> >
> > I thank you,
> > Girmangus H
>
>
>
> ------------------------------
>
> Message: 12
> Date: Fri, 11 Feb 2011 10:22:17 +0100
> From: Kay Strobach <typo3 at kay-strobach.de>
> Subject: Re: [TYPO3-english] phpBB3 and TYPO3 running together - but
>        how?
> To: typo3-english at lists.typo3.org
> Message-ID: <mailman.1.1297416248.12617.typo3-english at lists.typo3.org>
> Content-Type: text/plain; charset=UTF-8
>
> Hi,
>
> made this in an intranet:
> > Maybe this is a start
> > http://typo3.org/extensions/repository/view/phpbb_auth/current/
>
> But even better was:
> http://single-signon.com/
>
> Regards
> Kay
>
> --
> http://www.kay-strobach.de - Open Source Rocks
>
>
> ------------------------------
>
> _______________________________________________
> TYPO3-english mailing list
> TYPO3-english at lists.typo3.org
> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english
>
> End of TYPO3-english Digest, Vol 89, Issue 28
> *********************************************
>


More information about the TYPO3-english mailing list