Icy Phoenix

Old Support Topics - Installation Problem On Mysql

erfinestra [ Tue 20 Oct, 2009 12:43 ]
Post subject: Installation Problem On Mysql

Hi guys, I have a problem installing on a host ip taken.
Basically I start the installation and the creation of the database
I see I error
"There was an error during the database upgrade
BLOB / TEXT column 'config_vars' can not have a default value "

Having not ever happened in Aruba, I wrote you care and I copy
answer:
"Probably the database creation script is a bit 'old
In fact the last version of mysql (from one year to this part) the
TEXT fields can not have a value of defuault
if you have any further problems please feel free to contact us'

So as I understand is a problem of IP, how can I solve?
Thanks ragazzuoli

Mighty Gorgon [ Wed 21 Oct, 2009 00:15 ]
Post subject: Re: Installation Problem On Mysql

Thanks for reporting.

Please open install/schemas/mysql_schemas.sql

FIND MULTIPLE OCCURRENCES

Code: [Hide] [Select]

TEXT NOT NULL DEFAULT ''

REPLACE MULTIPLE OCCURRENCES

Code: [Hide] [Select]

TEXT

FIND MULTIPLE OCCURRENCES

Code: [Hide] [Select]

TEXT DEFAULT ''

REPLACE MULTIPLE OCCURRENCES

Code: [Hide] [Select]

TEXT

erfinestra [ Thu 22 Oct, 2009 08:20 ]
Post subject: Re: Installation Problem On Mysql

BINGO!! Boys do the task! I entered the admin panel, management styles, and re-installed the template. Now you see everything!
Finally. If you want the edited file oup mysql_schemas.sql do not know
He can be useful to someone. Put solved in the title, thanks always guys!

Mighty Gorgon [ Thu 22 Oct, 2009 08:59 ]
Post subject: Re: [SOLVED] Installation Problem On Mysql

Yes, post a zip file with the changed files here.

I already edited the core files to reflect that, but I'm still debugging the patch for 1.3.0.53.

Thanks.