Thread

After upgrading to 2.6.1 I am getting this error.  It seems there is a previous post which claims its a known issue in 2.6 (and the fix is applied in 2.6.1) however, I am still getting this error.

Please HELP!!

A Database Error Occurred
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 (‘1’) AND `exp_channel_titles`.`entry_date` <  368299973 AND (exp_channel_titles.expirati OR exp_channel_titles.expiration_date > 1368299973) AND `exp_channel_titles`.`entry_id` != ‘409’ ORDER BY `date` asc

Filename: fieldtypes/relationship/ft.relationship.php

Line Number: 359

You should look here https://support.ellislab.com/bugs/detail/19321

I’m having the same issue error as above running 2.6.1 when accessing CP Publish or Edit OR Standalone entry form except the latter produces the error shown below.

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 (‘4’) AND `exp_channel_titles`.`entry_date` <  370993455 AND (exp_channel_titles.expirati OR exp_channel_titles.expiration_date > 1370993455) ORDER BY `date` desc

Filename: modules/safecracker/libraries/safecracker_lib.php

Line Number: 2736

Michael:

I’m having the same problem. Did you ever figure this out or get help on it?

I just have midnight gift since install 2.6.1

A Database Error Occurred
Error Number: 1054

Unknown column ‘’ 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 (NULL) AND `exp_channel_titles`.`entry_date` <  374693963 AND (exp_channel_titles.expirati OR exp_channel_titles.expiration_date > 1374693963) AND `exp_channel_titles`.`entry_id` != ‘1357’ ORDER BY `

Filename: fieldtypes/relationship/ft.relationship.php

Line Number: 359

But when the folder forum in system/expressionengine/modules/forum/ is empty then the problem will look like this

An Error Was Encountered
Unable to load requested publish tab file: tab.forum.php

anyone have solution?

just trying this https://support.ellislab.com/bugs/detail/19321 hope it works

Just fix the problem with:
1. copy old files (mine 2.5.5) from fieldtypes/rel/ft.rel.php—> to make admin/channel field working (still with error, but its able to change the setting)
2. Then manually change all my relationships field Order entries by from Entry to Date

That work for me to make the channel entry active again. But still have problem when i delete fieldtypes/rel/ft.rel.php

An Error Was Encountered
Unable to load requested field type file: ft.rel.php.
Confirm the fieldtype file is located in the expressionengine/third_party/ directory

still pointing to ft.rel.php , not to ft.relationship.php. any clue?

THE SOLUTION TO THIS PROBLEM IS SIMPLE!

EE Screwed up in their naming of the Relationships Addon Fieldtype in the latest version by using the singular of the word.

Simply go to Addons/fieldtypes and you should see 2 fieldtypes called Relationship and Relationships. UNINSTALL the singular “Ralationship” and this should take care of the problem. At least it did for me.

Good Luck!

Oh Thanks MichaelSimone, it works.