[TYPO3-english] Installing and extension with Oracle as the DB

Bonneville, Douglas Douglas.Bonneville at pyramis.com
Fri Jan 14 15:59:32 CET 2011


I have T3 4.4.6 running in a Linux / Oracle setup. T3 installed just fine. But I went to install TV, which needs Static Tables, but the page just times out. I'm stuck on the page that shows you the SQL that the extension is about to execute. But again, the page just hangs.

We sent the Oracle DBA, who knows nothing about T3, and he said:

"These statements are not configured for Oracle

1. There are no datatypes 'Tinyint' in oracle
2. 'unsigned' is not valid in the column definition
3. UID is a reserved word in Oracle

In order to get these to function in Oracle we will need to restructure the statements"

I'll take his word for it...but since we installed T3 using the DBAL, I thought all SQL would be sanitized by it, and made to play nice with Oracle.

What could be going wrong?

I'm not even 100% it's a DB error - it just looks that way because the "install" button at the bottom of the extension installation page (with all the SQL) just hangs.

If it's not the DBAL failing, or anything DB related, what else could it be?

Fidelity has a regulatory review system that monitors and records incoming and outgoing e-mail communications, including attachments. This email is only intended for the recipient to whom it was addressed. If you are not the intended recipient of this email, please notify the sender immediately and delete it (including any attachments) from your system. Do not distribute or reproduce this email or its contents without permission from Pyramis Global Advisors. Information presented is for discussion purposes only. It is not intended as investment advice. It is not an offer or solicitation to buy or sell any ecurities or any investment strategies in any jurisdiction. This email and its contents are not intended for distribution to, or use by, any person or entity in any jurisdiction or country where such distribution or use would be contrary to law or regulation. Past performance is no guarantee of future results. An investment may be risky and may not be suitable for an investor's goals, objectives and risk tolerance; any investment involves the risk that you may lose all or a substantial amount of your investment. Pyramis does not provide legal or tax advice and we encourage you to consult your own lawyer, accountant, or other advisor before making any financial decision.




More information about the TYPO3-english mailing list