[Vtigercrm-developers] Migration Issue - Need Help

[Prasad]

Hi,

If InnoDB support is turned-off for the MySQL server, 'SHOW TABLE STATUS'
returns NULL value result for InnoDB tables.

How to reproduce the issue?
You will end up with the described result if you have the following MySQL
configuration.
[mysqld]
default-storage-engine=MyISAM
skip-innodb

Please note, for vtiger CRM to work properly you will need to have InnoDB
support enabled in MySQL.

How to avoid the issue?
[mysqld]
default-storage-engine=INNODB
#skip-innodb

Regards,
Prasad
vtiger Team

On 7/27/09, den jean <djeandot at gmail.com> wrote:
>
> Hi,
> What are we supposed to have like error ?
> Regards,
>
> 2009/7/27 Asha <asha at vtiger.com>
>
>> Hi All,
>>
>> People have been reporting us a major issue with migration, where the
>> script that changes the MyISAM tables to InnoDB tables is not working.
>>
>> We are trying to reproduce this issue in our test labs and have not
>> succeeded yet.
>>
>> Whole problem is around the query 'SHOW TABLE STATUS FROM
>> <database-name>'.
>>
>> Would be great if anyone can provide us a helping hand in analyzing or
>> resolving the issue. Possibly if anyone can reproduce this issue on their
>> servers and can give us the access to the server, that would help a lot.
>>
>> Hoping to get a resolution for this issue soon so that people can migrate
>> to vtiger 5.1.0 smoothly.
>>
>> --
>> Regards,
>> Asha
>> vtiger Team
>> _______________________________________________
>> Reach hundreds of potential candidates - http://jobs.vtiger.com
>>
>
>
> _______________________________________________
> Reach hundreds of potential candidates - http://jobs.vtiger.com
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20090727/d129fa52/attachment-0003.html