Error in search page

[lazysheepmedia]

Folks

I have a search form set up but when I submit a search I get this error

Fatal error: Call to undefined method JModel::getInstance() in /home/sites/mysite.co.uk/public_html/j3/components/com_fabrik/models/listfilter.php on line 753

To see what I mean please use this link

http://www.lettingagentsupportklub.co.uk/j3/free-tools/search-members.html

Thanks for any assistance

Regards

 

[cheesegrits]

Can you try changing that line of code to use JModelLegacy instead of JModel, see if that fixes it.

-- hugh

 

[lazysheepmedia]

Thanks Hugh

It kind of works but is now throwing a sql error which I am investigation

Unknown column 'b9tfj_extendedreg_users.id' in 'field list' SQL=SELECT SQL_CALC_FOUND_ROWS DISTINCT `b9tfj_extendedreg_users`.`user_id` AS `b9tfj_extendedreg_users___user_id`,

Regards

 

[lazysheepmedia]

It looks like it was searching for a PK which I have now set as the user_id in that table, although it did throw an error in admin

1091 Can't DROP 'PRIMARY'; check that column/key exists SQL=ALTER TABLE `b9tfj_extendedreg_users` DROP PRIMARY KEY

That aside, it now works - Thanks!

Regards

 

[cheesegrits]

Hmmm, I'd be careful setting user_id as the PK, if you are going to be adding rows on that list through Fabrik.

Committing that change to JModelLegacy to github now.

-- hugh

 

[lazysheepmedia]

Thanks Hugh I was just being lazy - I have added the PK to the table

 

[cheesegrits]

Good.

-- hugh