Bug #18962
closed
innodb-commands in sql-files crash adodb and dbal
Added by Anonymous about 16 years ago.
Updated about 14 years ago.
Description
hi!
adodb and dbal have problems with the innodb-addition to some create-table-commands.
every sql-command with "ENGINE=InnoDB;" makes adodb/dbal crash and showing me the following error:
ERROR: Query could not be parsed: "SQL engine parse ERROR: No action CHANGE, DROP or ADD found!: near "ENGINE=InnoDB "". Query: "ALTER TABLE cache_hash ENGINE=InnoDB;"
i'm wondering no other adodb-user has experiences this error.
btw, i'm using postgresql.
(issue imported from #M8718)
Hello everybody,
Ingo, I'm completely with you! Have the same error here. And I did a completely fresh install of Typo3 on a completely fresh PostgreSQL DB.
Unfortunately I experienced A LOT of problems with PostgreSQL. This is just one still unsolved, but I sincerely hope that some really good core developer will care about making the core REALLY DBAL compatible. Please, let the PostgreSQL community grow and make the core compatible soon. Thank you a lot. If you need any professional testing I am with you.
Mangan
dbal and adodb is the completely wrong way. they should go with pdo in typo3 5.0
As far is I see, PDO is not on the roadmap yet.
I keep on deleting every "ENGINE=..." in the ext_tables.sql files - works if there are no other problems ;-)
This error occured when i tried to install indexed search engine. I deactivated DBAL an installed the extension. Activated DBAL again. Works.
Is it still a problem in 4.4beta2 or newer?
According to Xavier in #19030 this has been fixed:
"This problem cannot be reproduced on TYPO3 4.3 beta3. Extension manager still proposes to ALTER TABLE with Engine=InnoDB as it does not exist on another plateform than MySQL but tables are created and usable anyway."
Also available in: Atom
PDF
Updated by 
Updated by 
Updated by