Saving of CustomViews

Hi,

My first install of vtiger for some time, installed on an update-to-date OpenSuSE leaf box with vtiger 6.4.

I initially got an issue when trying to save custom views (both from the create and when saving an advanced search).

I've traced it to the setDefaults and setMetrics columns. They are coming through into the model CustomView/models/Record.php as null - unsurprisingly as they are checkboxes on the form and therefore an unticked value doesn't persist into the form post.

There's a simple fix (which I'm happy to create a pull request for) which can be inserted at line 246 onwards in the above file.

if ( !$setDefault ) $setDefault = 0; if ( !$setMetrics) $setMetrics = 0;

I seem to be getting other issues though and I'm now wondering if there's a compatibility issue with something. For example creating an event isn't showing up in the calendar - it's not getting saved to the table and this is almost identical symptoms to what I saw above.

Is there a general regression somewhere? or is it my environment?

Are people able to save custom views (when set default and set metrics is unticked in the web page) on their vanilla installs - if so then it's a problem with my environment which I'm happy to investigate.

cheers,

g

@gary.hunt Yes - we can save filters and events etc... It might be that you have a very modern version of PHP perhaps which has not been tested yet, or your MySQL config has STRICT_ALL_TABLES set perhaps:

http://code.vtiger.com/vtiger/vtigercrm/issues/54

@lord_alan - that definitely looks like a similar issue - I'll check the STRICT_ALL_TABLES setting and see if that makes a difference.

The two values in the customview table both have defaults - but it's too close an issue not to be worth checking.

cheers,

g

Added ~22 label

mentioned in issue #54 (closed)

We prefer - STRICT_ALL_TABLES turned off.

Quick update - this is also MariaDB rather than MySQL - so I'll put together a set of notes for use of MariaDB as the config options are somewhat more extensive.

For my evaluation purposes though I'll get MySQL installed.

Yes please.

mentioned in issue #202 (closed)

Fixed 053eba12

Status changed to closed

mentioned in issue #202 (closed)