MODx encountered the following error while attempting to parse the requested...

Hi!
I have installed modX .No changes from my side. When i`m trying to add a comment on page How to Start Posting with MODx Mini-Blogs i get the following 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; check the manual that corresponds to your MySQL server version for the right syntax to use near ’’ at line 1 »
      SQL: UPDATE `modx`.modx_jot_content SET title=’Topic1’,content=’Comment1’,createdon=’1173619505’,createdby=’-2’,secip=’127.0.0.1’,sechash=’66bdcc49bb898112067978e80ee45071’,uparent=’9’,tagid=’’,published=’1’ WHERE id=;
modX v. 0.9.5; Jot v. 1.0

---

sorry for my bad english...i`ve learned it by games and Deftones songs  in far-far away country of Ukraine : ))

Update Jot to newer version. The one included in the package has an error.

As you can see, here lies the error: .....secip=’127.0.0.1’,sechash=’66bdcc49bb898112067978e80ee45071’,uparent=’9’,tagid=’’,published=’1’ WHERE id=;

Quote from: nosebleed at Mar 13, 2007, 03:46 PM

Hi!
I have installed modX .No changes from my side. When i`m trying to add a comment on page How to Start Posting with MODx Mini-Blogs i get the following 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; check the manual that corresponds to your MySQL server version for the right syntax to use near ’’ at line 1 »
SQL: UPDATE `modx`.modx_jot_content SET title=’Topic1’,content=’Comment1’,createdon=’1173619505’,createdby=’-2’,secip=’127.0.0.1’,sechash=’66bdcc49bb898112067978e80ee45071’,uparent=’9’,tagid=’’,published=’1’ WHERE id=;
modX v. 0.9.5; Jot v. 1.0

---

sorry for my bad english...i`ve learned it by games and Deftones songs in far-far away country of Ukraine : ))

If you use PHP4 try to change a file assets/snippets/jot/jot.class.inc.php, line 802 from
$xObj = $this->provider;
to
$xObj = &$this->provider;

Quote from: andrazk at Mar 13, 2007, 04:26 PM

Update Jot to newer version. The one included in the package has an error.

As you can see, here lies the error: .....secip=’127.0.0.1’,sechash=’66bdcc49bb898112067978e80ee45071’,uparent=’9’,tagid=’’,published=’1’ WHERE id=;

I see,but I don`t know what to do with it : ))

If you use PHP4 try to change a file assets/snippets/jot/jot.class.inc.php, line 802 from
$xObj = $this->provider;
to
$xObj = &$this->provider;

You are magician )) It works. Thanks.

ty the update worked well for me.