I tried this and cannot create new comments, gives me an sql error. Also, the comments are numbered wrong, the oldest comment (on mine) is 4, the newest is one. Any ideas?
Quote from: zi at Oct 30, 2006, 09:02 AM
bS` , How can I modify the post sort order ? ... by default it displays new first, but I want it to display the new posts at the end.
&sortby=`createdon:a`
« 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: UPDATE `Yankee2_v4`.modx_jot_content SET title='blue',content='dsfhfhsdh',createdon='1162274270',createdby='-1',secip='xxx.xxx.xxx.xxx',sechash='2031a9175e31c5e10ef7c5264db18623',uparent='16',tagid='',published='1' WHERE id=; [Copy SQL to ClipBoard]
[!Jot? &customfields=`name,email` &subscribe=`0` &pagination=`10` &badwords=`{{Badwords}}` &canmoderate=`Admins` &output=`0` &placeholders=`1` !] [+jot.html.navigation+] [+jot.html.comments+] [+jot.html.moderate+] [+jot.html.form+]
Debug shows placeholders set to 1 and jot.html.* displays the output.
When reinstalling take these steps:
1. Clear the jot directory
2. Delete the Jot snippet from the resource manager
2. Delete the *_jot_* tables from the modx database
3. Copy the content of rc1 to /assets/snippets/jot
4. Create a new snippet called Jot and copy the content of jot.snippet.txt into the code field.
5. Reload the page with the Jot call.
if you set &debug to 1 can you confirm that the jot.html -- placeholder values are filled and that the jot.placeholder value is set to 1?
I will not rest before you can run Jot.. lol
UPDATE: Deleted Jot and MySQL tables, reinstalled, still getting the same sql error and no placeholders. Once I get home today I’ll try deleting everything and reinstalling MODx fresh. I’ve got a lot of extra crap that I need to delete anyways Thanks for all the help bS.