An error was encountered while creating the tables for the MUTicket module.

[shefik]

I get this error when trying to install under Zikula 1.3.4:

"An error was encountered while creating the tables for the MUTicket module."

[Portugao]

Hmmhmm....are there any specials with your system?

[shefik]

No. I am using MAMP Pro on Mac - http://www.mamp.info/en/mamp-pro/index.html

[Portugao]

I just created a system with Zikula 1.3.4 and tested online......and the module was installed.....so I don't know what causes this error!

What about the version of php?

[shefik]

PHP 5.3.14 MySQL 5.5.25

[Portugao]

Is there a prefix set in the config.php?

[Portugao]

Try to change the config to:

$ZConfig['System']['legacy_prefilters'] = false $ZConfig['System']['compat_layer'] = false

if is set in both cases to true

[shefik]

They were both already set to "true"

With development mode one, I now get this error:

Doctrine Exception: SQLSTATE[HY000]: General error: 1005 Can't create table 'database_name.#sql-365_190' (errno: 150) An error was encountered while creating the tables for the MUTicket module.

---

However, I do see the tables in the database. So, they do get created, even though the error appears, and the module does not install.

[Portugao]

@guite Hi Axel, do you have an idea?

[Portugao]

@shefik

So you can set the module to 'is installed' by hand and it works or is there really a table missing?

[shefik]

No, the module does not work. It does not install at all for me. It breaks at that error. Even though the error says there is an issue with the tables, I do see tables created in phpMyAdmin. But, the module remains in an uninstalled state.

[Portugao]

You should have 4 tables named:

muticket_rating muticket_supporter muticket_ticket muticket_ticket_category

[shefik]

When I manually change the module state from "1" to "3", the view pages of the module do load correctly.

However, when I try to uninstall the module, I get this error:

Doctrine Exception: Unknown database type longblob requested, Doctrine\DBAL\Platforms\MySqlPlatform may not support it. An error was encountered while dropping the tables for the MUTicket module.

So, perhaps the install is failing because it is trying to set "longblob" in a table?

[Portugao]

Ok. So you have a module with a longblob field, that causes the error also during the installation, I think!

[shefik]

I don't know yet if I do have another module with a longblob field. But, I am not installing another module. Just this one. Why would another module's table structure effect the installation of this particular module?

[Portugao]

I cannot answer your question absolutely. We had the issue with the longblob field in other places.

And the error message, if we accept it as correct, illustrates, there must be a longblob in your database....also it shows, that doctrine does not support longblob....

Indeed very strange...

[Portugao]

Do you use a fresh installation of Zikula 1.3.4?

[Portugao]

Because I get no further informations to clear the reason of this issue, I close it. Feel free to reopen if someone can confirm this issue.

[shefik]

Yes, it is a fresh install of Zikula 1.3.4.

[Portugao]

So I have no other idea at the moment?!

[shefik]

I am still having the same problem under Zikula 1.3.5. I can't install the module at all. Always stops when the tables are attempted to be created. There is most likely a problem somewhere in the table structure. That is what the error 105 indicates. A problem with foreign keys. Please check to see that the correct structure is used that match the same structure of the foreign keys being referenced.

[Portugao]

Hmmhmm...I just checked under Zikula 1.3.5 online. It is no wonder, that It got installed without an issue.

Did you try MUTicket 1.0.0?

Which modules else are installed?

[Portugao]

No chance to reproduce at the moment, so I close again.