install problem

Ok so I am new and cant find any info on installation problems.

I have installed jot with the latest version of modx but when I put it into my page I get this error

« 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 near ’ENGINE=MyISAM’ at line 7 »
SQL: CREATE TABLE IF NOT EXISTS `modx_jot_fields` ( `id` mediumint(10) NOT NULL, `label` varchar(50) NOT NULL, `content` text, KEY `id` (`id`), KEY `label` (`label`) ) ENGINE=MyISAM
[Copy SQL to ClipBoard]

Parser timing
MySQL: 0.0045 s s (8 Requests)
PHP: 0.0604 s s
Total: 0.0650 s s


Have I installed it properly, I did copy the contents of the zip to the folder it said, and created the dito snippet and put the content from the text file.

or is it the call? [[Jot? &subscribe=`1` &pagination=`10`]] do I put this inside a content page?

many thanks

My bad... the sql install syntax is wrong for older versions of mysql

Attached to this post is the correct jot.install.db.sql file...
Copy this over the one in the release and it will fix your problem..

I also updated the 1.0 RC1 release in the repostory with the correct file.

Thanks man its working! now I can play with it, once again thank you for your quick response and hard work.

Simon

I have only just got round to using jot its installed but now when I post a comment I get this

« 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 near ’’ at line 1 »
SQL: UPDATE `eshop_modx`.modx_jot_content SET title=’hello’,content=’hello’,createdon=’1162469374’,createdby=’1’,secip=’87.194.40.198’,sechash=’87020b323d2061fbd984de1bf3700cfe’,uparent=’4’,tagid=’’,published=’1’ WHERE id=;
[Copy SQL to ClipBoard]

Parser timing
MySQL: 0.0080 s s (3 Requests)
PHP: 0.1355 s s
Total: 0.1434 s s

what is the jot call?

this is the 2nd time someone posted this type of error.. it seems like jot is thinking that you are updating a comment rather then entering a new one... i’ll try to find out why.

[!Jot? &subscribe=`1` &pagination=`10` &moderated=`1` &notify=`2`!]

the call is made from within a chunk.

Cheers
ss

Also I modified it to just [!Jot? &subscribe=`1` &pagination=`10`!] and still got the same error, is this something to do with my version of mysql?

I get the same SQL 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 `mysite`.site_jot_content SET title=’Re: ’,content=’test’,createdon=’1162528517’,createdby=’1’,
secip=’12.15.103.174’,sechash=’766931dea5f9b4c8242c21120dca8195’,uparent=’17’,tagid=’’,published=’1’ WHERE id=;

Any updates to why I cant post using jot?

update to Jot 1.0.1

ah at last its working, I can go play with it now