I have had several goes at trying to use a MySQL view as a list data source. List creation works without any problem but when the primary key is saved this error occurs..
But the list saves ok and it is possible to see the data structure. Trying to display the data however gives a 500 error.
I used this post and created the tables and the view exactly as set out in the post. The 500 error is:
An error has occurred.
But the list saves ok and it is possible to see the data structure. Trying to display the data however gives a 500 error.
I used this post and created the tables and the view exactly as set out in the post. The 500 error is:
An error has occurred.
500 Fabrik has generated an incorrect query for the list : <br /><br /><pre>Unknown column 'pieview.' in 'field list' SQL=SELECT SQL_CALC_FOUND_ROWS DISTINCT `pieview`.`fabrik_internal_id` AS `pieview___fabrik_internal_id`, `pieview`.`fabrik_internal_id` AS `pieview___fabrik_internal_id_raw`, `pieview`.`date_time` AS `pieview___date_time`, `pieview`.`date_time` AS `pieview___date_time_raw`, `pieview`.`pecan` AS `pieview___pecan`, `pieview`.`pecan` AS `pieview___pecan_raw`, `pieview`.`apple` AS `pieview___apple`, `pieview`.`apple` AS `pieview___apple_raw`, `pieview`.`chess` AS `pieview___chess`, `pieview`.`chess` AS `pieview___chess_raw`, `pieview`.`punkin` AS `pieview___punkin`, `pieview`.`punkin` AS `pieview___punkin_raw`, `pieview`.`totpies` AS `pieview___totpies`, `pieview`.`totpies` AS `pieview___totpies_raw`, `pieview`.`` AS slug , `pieview`.`` AS `__pk_val` FROM `pieview` LIMIT 0, 10</pre>
Another more recent post suggested editing the fabrik_lists table and changing the end of the parameters field to show isview: 1 , I did this but the 500 error above still occurs.
What do I need to do to use a MySQL view ( in an external database ) as a list data source ? Thanks.