I tried to change the foreignkey drop down to text field in the symfony filter form. But after i change the drop down field to text field, my field name changed to xxx_filter[‘foreign_id’][‘text’] instead of xxx_filter[‘foreign_id’]. And everytime i submit the form it show “SQLSTATE[HY093]: Invalid parameter number: parameter was not defined”.
After few hours of googling, i manage to find the solution for this filter form problem. To solve the problem follow the steps below:-
Advertisements
- Open your filter class from lib/doctrine/yyyyFormFilter.class.php
- now you add a function in the yyyyFormFilter.class.php file like below:-
public function convertXXXXXXValue($value) { if (is_array($value) && isset($value['text']) && '' != $value['text']) { return $value['text']; } }
** replace the XXXXXX to your column name
- Now you may try your form again. It should be working now 🙂
Related posts:
How to remove newline character in PHP
Free FTP Client for Mac OS X / Win XP / Vista
Symfony doctrine schema relationship sample
How to set out of office auto responder in Zimbra
How to backup MySQL Database in command line with compression
OpenOffice Calc worksheet tab went missing
How to clear play history in VLC media player
Composer: PHP Fatal error: Allowed memory size of ... exhausted...
Share this with your friends:-