[TYPO3-english] TYPO3 - ORACLE
Hello TYPO3 community, for our current project its a must have to get TYPO3 running in association with an ORACLE database and the TYPO3 extension TemplaVoila. In addition it is necessary to run it on TYPO3 version 4.5.8 or lower (due to the required PHP-Version). Till now we didnt solve this by ourselves so we are looking for an experienced TYPO3 developer who can setup a working installation based on the given requirements. Be assured - youll get well paid! In brief: We want you to provide an operative TYPO3 installation with following requirements: - Newest TYPO3 version which is running on PHP version 5.2.x (currently it is the 4.5.8) - in combination with an ORACLE database (10g) - running with an completely functional TemplaVoila installation If youre interested we please you to contact us! ___ TYPO3-english mailing list TYPO3-english@lists.typo3.org http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english
Re: [TYPO3-english] TYPO3 - ORACLE
Am 15.12.11 11:50, schrieb Peter Löffelhardt: - Newest TYPO3 version which is running on PHP version 5.2.x (currently it is the 4.5.8) - … in combination with an ORACLE database (10g) - running with an completely functional TemplaVoila installation Hi Peter, rant TYPO3 and Oracle, a long standing love affair! Add Templavoila to it and you have a drama and not a romance. If you place them on an old stage like php 5.2 then you wont make it a classic but a box-office desaster. Add some more to cast list like DAM, Versions and Workspaces and you have a japanese godzilla movie full of destruction. /rant My 5 cents here: Drop Oracle as a requirement. It will save you lots of money implementing stuff all over again. Dont forget those Oracle DBAs can get MySQL support from a company called Oracle. If you still need support then feel free to query some of the listed companies here: (disclosure: mine is one of them) http://association.typo3.org/members/ref/assoc/memberlist/32/ Best regards, Olivier ___ TYPO3-english mailing list TYPO3-english@lists.typo3.org http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english
[TYPO3-english] TYPO3 - ORACLE - TV
Hello TYPO3 Community, for our current project its a must have to get TYPO3 running in association with an ORACLE Database. In addition it is necessary to run it on TYPO3 version 4.5.7 or lower (due to the required PHP-Version). Status quo: The PHP version is 5.3.5 and Im using the ORACLE 10g XE. I made a basic TYPO3-ORACLE installation running on Ubuntu (11.04), which is running on a VirtualBox on Windows 7. TemplaVoila is also running and Im able to create DS/TOs. My Problem starts here: When I want to assign a Page Template Structure (or the same for Subpages) on Web - Page properties - Appearance the following error is shown and the settings arent saved. 102: These fields are not properly updated in database: (tx_templavoila_ds,tx_templavoila_next_ds,tstamp) Probably value mismatch with fieldtype. Im looking forward to resolve this problem with your help! Using ORACLE is unfortunately a requirement. Thank you in advance! Best regards, Peter Löffelhardt Peter Löffelhardt| Interactive fischerAppelt, tv media GmbH Neckarstraße 155 | 70190 Stuttgart Tel.: +49 711 1857050 7308 | Fax: +49 711 1857050 7700 Mobil: | p...@fischerappelt.de http://www.fischerappelt-tvmedia.com/ http://www.fischerappelt-tvmedia.com fischerAppelt, tv media gehört zur fischerAppelt AG, Föderation der Ideen Sitz der Gesellschaft: Stuttgart Handelsregister: Amtsgericht Stuttgart, HRB 20321 Geschäftsführer: Mirco Völker, Matthias Wesselmann fischerAppelt tv media sucht: Flashprogrammierer, Webentwickler, Berater mit Schwerpunkt Bewegtbild, Redakteure Bewegtbild, Online Konzeptioner, Online Berater ___ TYPO3-english mailing list TYPO3-english@lists.typo3.org http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english
Re: [TYPO3-english] TYPO3 - ORACLE - TV
Hello Peter, i've heard, that some people got TYPO3 running with oracle, but it's always better to use native MySQL. To get TYPO3 up and running, you should enable the debug features in the installtool and you're required to have professional database AND TYPO3 knowledge. There tons of extensions which won't work with oracle. Regards Kay Am 22.11.2011 12:04, schrieb Peter Löffelhardt: Hello TYPO3 Community, for our current project it’s a must have to get TYPO3 running in association with an ORACLE Database. In addition it is necessary to run it on TYPO3 version 4.5.7 or lower (due to the required PHP-Version). Status quo: The PHP version is 5.3.5 and I‘m using the ORACLE 10g XE. I made a basic TYPO3-ORACLE installation running on Ubuntu (11.04), which is running on a VirtualBox on Windows 7. TemplaVoila is also running and I’m able to create DS/TO’s. My Problem starts here: When I want to assign a Page Template Structure (or the same for Subpages) on Web - Page properties - Appearance the following error is shown and the settings aren’t saved. “102: These fields are not properly updated in database: (tx_templavoila_ds,tx_templavoila_next_ds,tstamp) Probably value mismatch with fieldtype.” I’m looking forward to resolve this problem with your help! Using ORACLE is unfortunately a requirement. Thank you in advance! Best regards, Peter Löffelhardt Peter Löffelhardt| Interactive fischerAppelt, tv media GmbH Neckarstraße 155 | 70190 Stuttgart Tel.: +49 711 1857050 7308 | Fax: +49 711 1857050 7700 Mobil: | p...@fischerappelt.de http://www.fischerappelt-tvmedia.com/ http://www.fischerappelt-tvmedia.com fischerAppelt, tv media gehört zur fischerAppelt AG, Föderation der Ideen Sitz der Gesellschaft: Stuttgart Handelsregister: Amtsgericht Stuttgart, HRB 20321 Geschäftsführer: Mirco Völker, Matthias Wesselmann fischerAppelt tv media sucht: Flashprogrammierer, Webentwickler, Berater mit Schwerpunkt Bewegtbild, Redakteure Bewegtbild, Online Konzeptioner, Online Berater -- 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] TYPO3 - ORACLE - TV
Hi, I made a basic TYPO3-ORACLE installation running on Ubuntu (11.04), which is running on a VirtualBox on Windows 7. TemplaVoila is also running and I’m able to create DS/TO’s. My Problem starts here: When I want to assign a Page Template Structure (or the same for Subpages) on Web - Page properties - Appearance the following error is shown and the settings aren’t saved. “102: These fields are not properly updated in database: (tx_templavoila_ds,tx_templavoila_next_ds,tstamp) Probably value mismatch with fieldtype.” Did you try to modify TV to use mediumtext instead of mediumblob for those fields? I know it worked smoothly back when mediumtext was used. 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] TYPO3 - ORACLE - TV
Hi Xavier How do I configure TV to do that? (I'm using TV V. 1.6.0) If that doesn't run.. I got an idea, is there maybe the possibility to add the entry in the oracle database manually? It would be a uniquely action. So I already got a Template, created with TV. And now I just need to know, where I have to adjust the database. Right? Peter -Ursprüngliche Nachricht- Von: typo3-english-boun...@lists.typo3.org [mailto:typo3-english-boun...@lists.typo3.org] Im Auftrag von Xavier Perseguers Gesendet: Dienstag, 22. November 2011 14:13 An: typo3-english@lists.typo3.org Betreff: Re: [TYPO3-english] TYPO3 - ORACLE - TV Hi, I made a basic TYPO3-ORACLE installation running on Ubuntu (11.04), which is running on a VirtualBox on Windows 7. TemplaVoila is also running and Im able to create DS/TOs. My Problem starts here: When I want to assign a Page Template Structure (or the same for Subpages) on Web - Page properties - Appearance the following error is shown and the settings arent saved. 102: These fields are not properly updated in database: (tx_templavoila_ds,tx_templavoila_next_ds,tstamp) Probably value mismatch with fieldtype. Did you try to modify TV to use mediumtext instead of mediumblob for those fields? I know it worked smoothly back when mediumtext was used. 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 ___ TYPO3-english mailing list TYPO3-english@lists.typo3.org http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english
Re: [TYPO3-english] TYPO3 - ORACLE - TV
Hi Peter, How do I configure TV to do that? (I'm using TV V. 1.6.0) Basically, you have to make sure typo3conf/ext/templavoila/ext_tables.sql is modified, otherwise TYPO3 will complain that type does not match. And then you have to manually take care of modifying the DB to change the type. You may start by modifying ext_tables.sql, see how TYPO3 wants to ALTER your schema and do it manually as AFAIR you won't be able to ALTER the column type with Oracle. If that doesn't run.. I got an idea, is there maybe the possibility to add the entry in the oracle database manually? It would be a uniquely action. So I already got a Template, created with TV. And now I just need to know, where I have to adjust the database. Right? Easiest way I guess would be to backup your content somehow (using external tools), delete the two columns and recreate them from within TYPO3, this way you are totally sure they are created the way it should :) -- 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] TYPO3 - ORACLE - TV
Hi Peter, On 22-11-2011 14:43, Xavier Perseguers wrote: And then you have to manually take care of modifying the DB to change the type. You may start by modifying ext_tables.sql, see how TYPO3 wants to ALTER your schema and do it manually as AFAIR you won't be able to ALTER the column type with Oracle. Not to advertise anything, but the extension t3adminer should be able to work with all databases which are supported by TYPO3 (MySQL, PostgreSQL, Oracle, MS SQL) and it should also automatically recognize the DBAL configuration and connect to that database. I haven't been able to test it on Oracle yet, so this would be a nice test. If it works you can do your database manipulation from the TYPO3 backend. Maybe Adminer can change the column type on the fly? Of course you should backup the data in case it needs to do something drastic without notifying you first. -- 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