TYPO3Jack.net - Das TYPO3 Mailinglist Forum Archiv

TYPO3 Mailingliste: nicht fragen - lesen!

TYPO3 Mailingliste: nicht fragen - lesen!_RR_1-->
Zurück   TYPO3Jack.net - Das TYPO3 Mailinglist Forum Archiv > TYPO3-Mailinglists: ENGLISH > typo3-install@lists.netfielders.de

Registrieren Hilfe Benutzerliste Kalender Suchen Heutige Beiträge Alle Foren als gelesen markieren
  #1  
Alt 28.05.2008, 20:42
Franz mAIER
Gast
 
Beiträge: n/a
Standard [TYPO3-install] Using Mysql5 in MYSQL40 mode without changingsql-mode in my.ini

Hi,

We're trying to install Typo3 on Mysql 5 and PHP 5. This causes some troubles because we normally use Mysql in strict Mode. This prevents me from logging in to the BE, and creating new pages and so on.
Google brought up that setting sql-mode="MYSQL40" would solve the problem. This really worked, but it's no real solution, because our other Applications using the mysql-Database prefer strict-mode...
Is there a way to set the mysql sql-mode to 'MYSQL40' without setting it globally in my.ini?

Any help would be highly appreciated.


Best regards
Johannes



__________________________________________________ ________
Gesendet von Yahoo! Mail.
Dem pfiffigeren Posteingang.
http://de.overview.mail.yahoo.com
_______________________________________________
TYPO3-install mailing list
TYPO3-install (AT) lists (DOT) netfielders.de
http://lists.netfielders.de/cgi-bin/.../typo3-install
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Wong this Post!Spurl this Post!Reddit! Diesen Post bei linksilo.de bookmarken!
  #2  
Alt 23.07.2008, 21:56
Michiel Roos [netcreators]
Gast
 
Beiträge: n/a
Standard Re: [TYPO3-install] Using Mysql5 in MYSQL40 mode without changingsql-mode in my.ini

Hi Franz,

I guess you should be able to run mysqld in a second instance on another
port. Then you woult have to tweak either of the applications to use
that mysqld instead of the one behind the default port.

You should be able to do something like:
shell> mysqld --sql_mode="some mode stuff"

It's hackery though . . .

Regards,


Michiel

Franz mAIER schreef:
> Hi,
>
> We're trying to install Typo3 on Mysql 5 and PHP 5. This causes some troubles because we normally use Mysql in strict Mode. This prevents me from logging in to the BE, and creating new pages and so on.
> Google brought up that setting sql-mode="MYSQL40" would solve the problem. This really worked, but it's no real solution, because our other Applications using the mysql-Database prefer strict-mode...
> Is there a way to set the mysql sql-mode to 'MYSQL40' without setting it globally in my.ini?
>
> Any help would be highly appreciated.
>
>
> Best regards
> Johannes
>
>
>
> __________________________________________________ ________
> Gesendet von Yahoo! Mail.
> Dem pfiffigeren Posteingang.
> http://de.overview.mail.yahoo.com



--
Netcreators BV :: creation and innovation
www.netcreators.com

Interesse in werken bij Netcreators?
http://www.netcreators.com/bedrijf/vacatures/
_______________________________________________
TYPO3-install mailing list
TYPO3-install (AT) lists (DOT) netfielders.de
http://lists.netfielders.de/cgi-bin/.../typo3-install
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Wong this Post!Spurl this Post!Reddit! Diesen Post bei linksilo.de bookmarken!
 

Lesezeichen

Themen-Optionen
Ansicht Thema bewerten
Thema bewerten:

Forumregeln
Es ist dir nicht erlaubt, neue Themen zu verfassen.
Es ist dir nicht erlaubt, auf Beiträge zu antworten.
Es ist dir nicht erlaubt, Anhänge hochzuladen.
Es ist dir nicht erlaubt, deine Beiträge zu bearbeiten.

BB-Code ist an.
Smileys sind an.
[IMG] Code ist an.
HTML-Code ist aus.
Trackbacks are an
Pingbacks are an
Refbacks are an


Ähnliche Themen

Thema Autor Forum Antworten Letzter Beitrag
[TYPO3-install] Using Mysql5 in MYSQL40 mode without changingsql-mode in my.ini Franz mAIER typo3-install@lists.netfielders.de 0 29.05.2008 13:51
[TYPO3] mm_forum moderate mode Katja Lampela typo3-english@lists.netfielders.de 0 08.08.2007 12:56
[TYPO3-debian] SAFE MODE Mark Grieveson typo3-debian@lists.netfielders.de 5 28.05.2007 15:58
[TYPO3-install] SAFE MODE Mark Grieveson typo3-install@lists.netfielders.de 4 28.05.2007 13:01
Re: [TYPO3-install] SAFE MODE -- which php.ini? Axel Hinz typo3-install@lists.netfielders.de 2 27.05.2007 22:55


Alle Zeitangaben in WEZ +1. Es ist jetzt 14:11 Uhr.


Powered by vBulletin® Version 3.7.4 (Deutsch)
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.1.0
Template-Modifikationen durch TMS

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77