SOLVED Installation Problem On Mysql


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

Subject: Re: Installation Problem On Mysql
Thanks for reporting.

Please open install/schemas/mysql_schemas.sql

FIND MULTIPLE OCCURRENCES
Code: [Download] [Hide] [Select]
TEXT NOT NULL DEFAULT ''


REPLACE MULTIPLE OCCURRENCES
Code: [Download] [Hide] [Select]
TEXT




FIND MULTIPLE OCCURRENCES
Code: [Download] [Hide] [Select]
TEXT DEFAULT ''


REPLACE MULTIPLE OCCURRENCES
Code: [Download] [Hide] [Select]
TEXT

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!

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.


Page 1 of 1


  
You cannot post new topics
You cannot reply to topics
You cannot edit your posts
You cannot delete your posts
You cannot vote in polls
You cannot attach files
You can download files
You cannot post calendar events

   

This is a "Lo-Fi" version of our main content. To view the full version with more information, formatting and images, please click here.

Powered by Icy Phoenix based on phpBB
Generation Time: 0.0734s (PHP: 39% SQL: 61%)
SQL queries: 10 - Debug Off - GZIP Enabled