MySql Error related to Section Editor
3 posts by 2 authors in: Forums > CMS Builder
Last Post: August 5, 2008 (RSS)
I'm new to CMSB, so pardon if this question is daft.
I've just created my first Section Editor & arranged all the fields & presets the way I want them. I saved the info & the link appeared in my menu bar as expected. However, when I click the link I get the following error message:
MySQL Error: Unknown column 'title' in 'order clause'
Have I done something wrong?
I've just created my first Section Editor & arranged all the fields & presets the way I want them. I saved the info & the link appeared in my menu bar as expected. However, when I click the link I get the following error message:
MySQL Error: Unknown column 'title' in 'order clause'
Have I done something wrong?
Re: [james_jackson] MySql Error related to Section Editor
Addendum: When deleting a user account I just got the following error message:
Notice: Use of undefined constant mysql_affected_rows - assumed 'mysql_affected_rows' in /home/anthony/anthonyrealtor.com/cmsAdmin/lib/menus/default/actionHandler.php on line 73
Notice: Use of undefined constant mysql_affected_rows - assumed 'mysql_affected_rows' in /home/anthony/anthonyrealtor.com/cmsAdmin/lib/menus/default/actionHandler.php on line 73
Re: [james_jackson] MySql Error related to Section Editor
By Dave - August 5, 2008
Hi James,
Are you running the latest version? If not you might try upgrading. Let me know, I'm curious about the second error you posted about.
>MySQL Error: Unknown column 'title' in 'order clause'
Check for a field called "Order By" under the "Sorting Tab" in the Section Editors. That field tells the program how to sort your records, but if you remove a field you need to remove it from there as well.
Hope that helps, let me know if you still are having problems after that.
Are you running the latest version? If not you might try upgrading. Let me know, I'm curious about the second error you posted about.
>MySQL Error: Unknown column 'title' in 'order clause'
Check for a field called "Order By" under the "Sorting Tab" in the Section Editors. That field tells the program how to sort your records, but if you remove a field you need to remove it from there as well.
Hope that helps, let me know if you still are having problems after that.
Dave Edis - Senior Developer
interactivetools.com
interactivetools.com