Hello,
When trying to "Preview" an unpublished blog post from the Content Manager, I get this error message, it’s not happening on other postings - could someone break this down in human language? Thank you!
« MODx Parse Error »
MODx encountered the following error while attempting to parse the requested resource:
« Execution of a query to the database failed - 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 ’’ at line 1 »
SQL: SELECT fullname FROM `stirbost_modxcms`.`modx_user_attributes` WHERE `stirbost_modxcms`.`modx_user_attributes`.id =
[Copy SQL to ClipBoard]
Parser timing
MySQL: 0.0052 s (5 Requests)
PHP: 0.0366 s
Total: 0.0417 s
-
☆ A M B ☆
- 24,524 Posts
It’s trying to pull data out of your user_attributes table with an empty user ID.
As to why it’s trying to do that, I have no idea; but that’s what the error means.
Thank you. I’m guessing there’s no easy way of figuring out why huh?
Cheers.
-
☆ A M B ☆
- 24,524 Posts
I guess it’s trying to display the author’s full name; no idea why it can’t find the author ID. Unless maybe... have you saved it yet?
Hmm, I’m not sure if this is the same thing, but I commented out the <!--[+author+]--> in the blog template chunk. I also commented this out of the template the blog posts use: <!--[[AuthorTime? &dateFormat=`%m/%d/%Y %` &usedDate=`pub_date` &tpl=`Posté par <strong>[+Author+]</strong> le [+Date+]`]]-->
Basically, the names shouldn’t show. Do you think this is correlated to the same Author’s Name you’re referring to?
Thanks,
msflux
-
☆ A M B ☆
- 24,524 Posts
