SOLVED::Formalicious upgrade 2.0.5 no longer displays forms on front end

Support Extras
1

Hi,
I have Formalicious problems with the latest upgrade to 2.0.5.
No forms display on front end.
I have manually cleared the cache and am using Modx 2.8.6.
Thanks for any help.

Error log is as follows…

[2024-02-21 08:19:45] (ERROR @ /home/www/public_html/core/xpdo/om/xpdoobject.class.php : 240) Error 42000 executing statement: 
Array
(
    [0] => 42000
    [1] => 1064
    [2] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ASC' at line 1
)

[2024-02-21 08:19:45] (ERROR @ /home/www/public_html/core/xpdo/om/xpdoobject.class.php : 240) Error 42000 executing statement: 
Array
(
    [0] => 42000
    [1] => 1064
    [2] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ASC' at line 1
)
2

Did you update mysql to version 8.x? the key RANK is now a reserved name, I made a fix for this:

To fix this you need to search for the sortby rank and prefix those with the alias:

   from :  $criteria->sortby('rank', 'ASC');
   to :  $criteria->sortby('FormaliciousAnswer_rank', 'ASC');

see my pull request for all locations.

1 Like
3

Thank you so much. That has sorted the issue:-)
You’re a star! :star_struck:

1 Like