Ditto 1.02 Archive SQL-Error

Hi,

i´ve tried the archive-function of Ditto 1.01 on MODx 0.921 and there is a bug allready described here:
http://modxcms.com/forums/index.php/topic,11761.0.html

Now, i´ve installed Version 1.02 of Ditto. But now there´s a DB-Error which cause the whole site to break down:


Do anybody know why this happens und how to fix it?

Peace, Alex

Use the Ditto 2 beta and Reflect. Much better and far fewer bugs, actually, even in it’s beta state.

Is there any tutorial out there how to use it? And works the 1.1 Beta 2 with MODx Ver. 0.921?

Cheers Alex

Oh, i´m really sick of this...

This is the result when i use Ditto 1.1 Beta 2 with the same way to install as with Ver. 1.01 or 1.02:

MODx encountered the following error while attempting to parse the requested resource:
« Execution of a query to the database failed - Unknown column ’sc.createon’ in ’field list’ »
SQL: SELECT DISTINCT sc.createon,sc.id,sc.published FROM `jedoxav_db1`.modx_site_content sc LEFT JOIN `jedoxav_db1`.modx_document_groups dg on dg.document = sc.id WHERE (sc.parent IN (40) AND sc.published=1 AND sc.deleted=0 AND hidemenu = 0) AND (sc.privateweb=0) ORDER BY sc.createon ASC

What´s the problem?

Peace Alex

You should really upgrade your 0.9.2.1 install first and foremost ... for security reasons if nothing else.

At this point, if it were me, I’d go straight to the 096 series though. I suspect Ditto 2 will resolve a lot of issues, and it is much better than the 1.x by far.

Hi Ryan,

i really would like to upgrade, but my actuall site is running on latin1 and i´ll will get serious problems with the german ’umlaute’ after upgrading to 0.95. Did my Ditto Problem with Ver. 1.1 depends on running 0.921? And how should i resolve this charset problem? Any suggestions?

Peace, Alex

createon is not a field. createdon is. Change that as your dateSource and you should be fine.

Hi Mark,

i didn´t understand your answer.

Did you forget a word? Where to find the dateSource? What to change?

Thanks, Alex

You have sortBy=`createon`. That is not a valid field name. createdon is. Note the d.