current community

your communities

more stack exchange communities

Stack Exchange
tour help
Take the 2-minute tour ×
ExpressionEngine® Answers is a question and answer site for administrators, end users, developers and designers for ExpressionEngine® CMS. It's 100% free, no registration required.
up vote 0 down vote favorite

I have a page that allows registered users to post a entry on my site.

Since upgrading to the latest version of EE, I'm getting the following error, instead of the page loading:

Error Number: 1054

Unknown column 'date' in 'order clause'

SELECT DISTINCT exp_channel_titles.entry_id, exp_channel_titles.title FROM (exp_channel_titles) WHERE exp_channel_titles.channel_id IN ('5') AND exp_channel_titles.entry_date < 1369859305 AND (exp_channel_titles.expiration_date = 0 OR exp_channel_titles.expiration_date > 1369859305) ORDER BY date desc

Filename: modules/safecracker/libraries/safecracker_lib.php

Line Number: 2736

share|improve this question
    
I don't think it would happen. Can you check if Safecraker module files have been replaced with the latest version. –  Bhashkar Yadav May 30 '13 at 10:26
    
Yes, I'm using the current version (2.1) of Safecracker. And I'm getting this error every time. –  Barry Parr Jun 3 '13 at 1:01

1 Answer 1

up vote 0 down vote accepted

I was able to solve this problem myself using the following bug report on the EE site:

https://support.ellislab.com/bugs/detail/19321

Although the bug has been fixed in more-recent versions of EE -- you can see the patches in the source files -- it still may be necessary to open and save any relationship fields in your channels.

Just go to Administration / Channel Fields, and check set set of fields for any relationship fields. Open them, don't change anything, and then update them. That solved the problem for me.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.