display element plugin creates field in DB

[Mezhuev]

Hello,
I have a lot of explanation text in my form and if I understood fabrik architect correct display element serves that function. But every time I create new display element I see new related field in my DB table which is always NULL but still exists. Is there any way to use display element without new db column creation in related table?

I'm using fabrik 3 and Joomla 2.5

 

[felixkat]

This is normal behaviour.

I believe this question was asked once before by Fred04 and from what I remember Hugh said it had to be there.

Much of the Fabrik code would expect a field in the mysql database so I imagine huge changes would have to be made if a field wasn't created. I don't think it would be a worthwhile exercise putting 'if display element' all over the Fabrik code.

It shouldn't really impact performance but you could always change the mysql field to be the smallest INT possible if you are worried about performance.

 

[Mezhuev]

Got it

Hmm...I understand. But still I think it will be right in terms of design to separate display element from db. Anyhow thank you for replay.

 

[felixkat]

An alternative is to create a custom template and insert the code to perform the query.

 

[cheesegrits]

This is one of those "we'll fix it one day" issues, as it really has very little impact on anything, it's more of a cosmetic issue. Having unused fields in the table really doesn't hurt anything, it'd "just be nice" if we didn't create them.

-- hugh

 

[PtrNrs]

Where is this up to?

I note that on my website, the display element does not create a table field and does not mind the when displaying.

On an exact copy of the website on my Mac, the display element does create a table field and does mind displaying (I get an SQL missing error) if the field does not exist.

The version of Fabrik is Github circa Nov 2013.

Any ideas?

Website
PHP Built On Linux safeserver.artful.net.au 2.6.32-431.3.1.el6.x86_64 #1 SMP Fri Jan 3 21:39:27 UTC 2014 x86_64
Database Version 5.5.35-cll
Database Collation utf8_general_ci
PHP Version 5.3.28
Web Server Apache
WebServer to PHP Interface cgi-fcgi
Joomla! Version Joomla! 2.5.18 Stable [ Ember ] 6-February-2014 16:00 GMT
Joomla! Platform Version Joomla Platform 11.4.0 Stable [ Brian Kernighan ] 03-Jan-2012 00:00 GMT
User Agent Mozilla/5.0 (Macintosh; Intel Mac OS X 10_7_5) AppleWebKit/537.31 (KHTML, like Gecko) Chrome/26.0.1410.65 Safari/537.31

Mac
PHP Built On Darwin 192-168-1-7.tpgi.com.au 11.4.2 Darwin Kernel Version 11.4.2: Thu Aug 23 16:25:48 PDT 2012; root:xnu-1699.32.7~1/RELEASE_X86_64 x86_64
Database Version 5.5.9
Database Collation utf8_general_ci
PHP Version 5.3.5
Web Server Apache/2.0.64 (Unix) PHP/5.3.5 DAV/2
WebServer to PHP Interface apache2handler
Joomla! Version Joomla! 2.5.18 Stable [ Ember ] 6-February-2014 16:00 GMT
Joomla! Platform Version Joomla Platform 11.4.0 Stable [ Brian Kernighan ] 03-Jan-2012 00:00 GMT
User Agent Mozilla/5.0 (Macintosh; Intel Mac OS X 10_7_5) AppleWebKit/537.31 (KHTML, like Gecko) Chrome/26.0.1410.65 Safari/537.31