[Vtigercrm-developers] Mysqli unsupport
Holbok István
holbok at gmail.com
Mon Sep 22 13:44:16 GMT 2014
Hi Rishab,
I have just finished a fresh install with the latest SVN Changeset
14295, where the MYSQLI hotfix was released.
It partly resolved the issue described in my earlier letter sent to the
list:
http://lists.vtigercrm.com/pipermail/vtigercrm-developers/2014-August/029214.html
*The issue was*: despite the fact that the server MySQL (5.6) default
engine was InnoDB, the most of tables in vtiger DB were created as
MyISAM at the install time.
I repeated the install with different 6.1 beta version on this server
(CentOS, C-panel, MySQL 5.6.17) but the result were too same -> the most
of tables in vtiger DB were created as MyISAM at the install time.
*Using the SVN 14295 this issue was partly resolved in this server.*
Now, the most of tables are InnoDB, only some of tables are MyISAM. For
example the all tables where the table name end with *_seq* are MyISAM
and few others e.g. *vtiger_asteriskincomingevents* also MyISAM.
My note was that time: It indicates there is some *uncertainty *and the
SQL table install depended in this case from some environment variables.
If you would like to check the created DB I can send you a dump-
Kindest regards:
István
2014.09.22. 13:31 keltezéssel, Rishab K írta:
> Refer
> Trac Link: http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/8255
>
> For the modified mysqli patch.
>
> Regards,
> Rishab
>
> On Mon, Sep 22, 2014 at 4:59 PM, Rishab K <rishab.k at vtiger.com
> <mailto:rishab.k at vtiger.com>> wrote:
>
> Please check
> http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/8255.The patch has
> some changes to be taken
>
> Regards,
> Rishab
>
> On Mon, Sep 22, 2014 at 4:41 AM, Manuel Fernando
> <ptdesigner at gmail.com <mailto:ptdesigner at gmail.com>> wrote:
>
> Just one thing.
>
> I never had this before:
> In module tickets if click in related module Services, get this
>
> *Warning*: Invalid argument supplied for foreach() in
> */home/testtest/public_html/vtiger61/include/Webservices/WebserviceField.php*
> on line *200*
> result is not an object*
> *
> Best Regards
> Manuel
>
> No dia 21/09/2014, às 12:49, Manuel Fernando
> <ptdesigner at gmail.com <mailto:ptdesigner at gmail.com>> escreveu:
>
>> Ho Yea, very good.
>>
>> no we are talking about!!!
>>
>> Works great and solved lots of users problems believe me,
>> problems like cannot creat web forms etc
>>
>> After i will send related tickets on trac that you can close
>> that are already solved with this change
>>
>> Best regards
>> Manuel
>>
>> No dia 21/09/2014, às 11:41, Prasad <prasad at vtiger.com
>> <mailto:prasad at vtiger.com>> escreveu:
>>
>>> adodb seem to be missing schema parsing support for mysqli -
>>> patch suggested:
>>> http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/8255#comment:1
>>>
>>> Please try and suggest your feedback.
>>>
>>> *Connect with us on: *Twitter <http://twitter.com/vtigercrm>
>>> *I* Facebook
>>> <http://www.facebook.com/pages/vtiger/226866697333578?sk=wall>
>>> *I* Blog <https://blogs.vtiger.com/>* I* Wiki
>>> <http://wiki.vtiger.com/index.php/Main_Page> *I *Forums
>>> <https://discussions.vtiger.com/>*I* Website
>>> <https://www.vtiger.com/>
>>>
>>> On Sun, Sep 21, 2014 at 8:01 AM, Prasad <prasad at vtiger.com
>>> <mailto:prasad at vtiger.com>> wrote:
>>>
>>> Noted:
>>> http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/8255 -
>>> (seems like bug in adodb lib will review soon)
>>>
>>> *Connect with us on: *Twitter
>>> <http://twitter.com/vtigercrm> *I* Facebook
>>> <http://www.facebook.com/pages/vtiger/226866697333578?sk=wall>
>>> *I* Blog <https://blogs.vtiger.com/>* I* Wiki
>>> <http://wiki.vtiger.com/index.php/Main_Page> *I *Forums
>>> <https://discussions.vtiger.com/>*I* Website
>>> <https://www.vtiger.com/>
>>>
>>> On Sat, Sep 20, 2014 at 9:10 PM, Manuel Fernando
>>> <ptdesigner at gmail.com <mailto:ptdesigner at gmail.com>> wrote:
>>>
>>> As Prasad said here
>>>
>>> https://discussions.vtiger.com/index.php?p=/discussion/173157/vtiger-6-1-ga-live-demo
>>>
>>> "If you are not sure - all tables other than _seq
>>> tables should be InnoDB for establishing the foreign
>>> key constraints. "
>>>
>>>
>>> Why installation put all tables MyISAM?
>>>
>>>
>>> No dia 20/09/2014, às 16:35, Manuel Fernando
>>> <ptdesigner at gmail.com <mailto:ptdesigner at gmail.com>>
>>> escreveu:
>>>
>>>> Yes, it depends and i understand if i use php 5.5
>>>> but i’m using php 5.3.29
>>>>
>>>> so installation should control that depending of of
>>>> the versions and apply InnoDB to the necessary tables.
>>>>
>>>> Because after will create problems in the search
>>>> area (well, more complicated).
>>>>
>>>> No dia 20/09/2014, às 16:27, Zebra Hosting
>>>> <support at zebrahosting.eu
>>>> <mailto:support at zebrahosting.eu>> escreveu:
>>>>
>>>>> Manual, I just did a fresh install from the SVN
>>>>> files and all are InnoDB. Might depend on other
>>>>> things too.
>>>>>
>>>>> I used Ubuntu 14 with PHP 5.5. And MySQL 5.5
>>>>>
>>>>> Bastiaan Houtkooper
>>>>> Zebra Hosting
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> From: Manuel Fernando <ptdesigner at gmail.com
>>>>> <mailto:ptdesigner at gmail.com>>
>>>>> Reply-To:
>>>>> "vtigercrm-developers at lists.vtigercrm.com
>>>>> <mailto:vtigercrm-developers at lists.vtigercrm.com>"
>>>>> <vtigercrm-developers at lists.vtigercrm.com
>>>>> <mailto:vtigercrm-developers at lists.vtigercrm.com>>
>>>>> Date: zaterdag 20 september 2014 17:13
>>>>> To: "vtigercrm-developers at lists.vtigercrm.com
>>>>> <mailto:vtigercrm-developers at lists.vtigercrm.com>"
>>>>> <vtigercrm-developers at lists.vtigercrm.com
>>>>> <mailto:vtigercrm-developers at lists.vtigercrm.com>>
>>>>> Subject: [Vtigercrm-developers] Mysqli unsupport
>>>>>
>>>>> Last source from svn doesn’t act correct on mysqli.
>>>>>
>>>>> It create all tables with engine MyISAM instead InnoDB
>>>>>
>>>>> It install a lot faster but all tables with MyISAM
>>>>>
>>>>>
>>>>> <print.jpg>
>>>>>
>>>>> Best Regards
>>>>> Manuel
>>>>> <print.jpg>_______________________________________________
>>>>> http://www.vtiger.com/
>>>>
>>>
>>>
>>> _______________________________________________
>>> http://www.vtiger.com/
>>>
>>>
>>>
>>> _______________________________________________
>>> http://www.vtiger.com/
>>
>
>
> _______________________________________________
> http://www.vtiger.com/
>
>
>
>
>
> _______________________________________________
> http://www.vtiger.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20140922/0295674e/attachment-0001.html>
More information about the vtigercrm-developers
mailing list