Call to undefined method Fabrik\Helpers\Worker::inAJAXValidation() after update

[Kordian]

Hi,
After updating Fabrik to 3.9.2 no lists can be viewed anymore. Even plain ones with id, date and field elements. Error displayed is:
0 Call to undefined method Fabrik\Helpers\Worker::inAJAXValidation()
/plugins/fabrik_element/date/date.php:425
Thank you in advance for any help.

 

[troester]

I can't replicate and nobody else is reporting this.
From which version did you update?
How? (Joomla update, installing package, GitHub)?
Maybe try to download and re-install the Fabrik3.9.2 package (in case of a corrupted file or so)

 

[Kordian]

From 3.9, through the joomla update.

 

[Kordian]

Well, when I try reinstalling Fabrik over joomla install, this comes out:
Warning
JInstaller: :Install: Error SQL Duplicate column name 'params'
Extension Update: SQL error processing query: DB function failed with error number 1060
Duplicate column name 'params'
SQL =
ALTER TABLE `#__fabrik_connections` CHANGE `attribs` `params` TEXT;
Package Install: There was an error installing an extension: com_fabrik_3.9.2.zip

This table contains already the params column.

 

[troester]

Is this an old, updated Joomla and Fabrik site?
It seems it's trying to run an unnecessary database update.

It may be this one

Hmmm. Theoretically, those update queries ("ALTER ...") should only happen if you are updating an existing install. Which means that J! thinks you have previously installed an earlier version.

Check your #__schemas table. Look at #__extensions, find the one with the 'name' of 'com_fabrik', and see if the 'extension_id' for that exists in #__schemas. If so, delete that row in schemas, and try installing again.

-- hugh

https://fabrikar.com/forums/index.php?threads/fresh-install-throwing-mysql-error.50732/#post-265144

 

[Kordian]

Well, how can I then skip that the installation process checks the database?

 

[troester]

Check your #__schemas table. Look at #__extensions, find the one with the 'name' of 'com_fabrik', and see if the 'extension_id' for that exists in #__schemas. If so, delete that row in schemas, and try installing again.

 

[Kordian]

Checked. The extension_id of com_fabrik is not present in _schemas table.

 

[troester]

Ok, one more to check:
in administrator/component/com_fabrik/sql/updates/mysql
do you have an old file 2.x-3.0.sql?

If yes: delete it and try again
If no: update from GitHub

 

[Kordian]

I have no "sql" folder in this location.

 

[troester]

Sure? administrator/component/com_fabrik/sql/updates/mysql

 

[Kordian]

OK, now it is there.
Deleted, tried again, this time a new error:
ALTER TABLE `#__fabrik_joins` CHANGE `table_id` `list_id` INT( 6 ) NOT NULL;
Number 1054

 

[troester]

Ok, the error is replicatable with an existing Fabrik and then manipulating the #_schemas row.
Please double-check the entries there:
in #_extentions look for name=com_fabrik, take the extension_id


in #_schemas the entry really should be there


Don't delete it but set the version_id to e.g.3.6.1

 

[Kordian]

No, I haven't got it.
The extension_id of com_fabrik is 10128, the _schemas does not have such entry number.

 

[Kordian]

OK, I added the entry manually. The installation was succesfull.
Now when viewing any list, this error appears:
Object of class stdClass could not be converted to string
/components/com_fabrik/views/list/tmpl/admin/default_buttons.php:36

 

[troester]

There's no
/components/com_fabrik/views/list/tmpl/admin
in the Fabrik defaults, this must be some custom template (which seems to need some php7.x update).

 

[Kordian]

Well, all lists use admin template. When I switch to default, they are working fine.