[Rating] MySQL ERROR on export
Posted: 13 July 2007 01:44 AM   [ Ignore ]
Newbie
Rank
Total Posts:  23
Joined  2007-01-16

If I push in the CP the button “Ratings” then below the green button “Export” another green button appears with the title “txt”.

And if I push this button I get the following error message:

MySQL ERROR:
Error Number: 1054
Description: Unknown column ‘entry_date’ in ‘order clause’
Query: SELECT * FROM exp_ratings WHERE entry_id != ‘’ ORDER BY entry_date ASC

Thanks for your help.
MISC

Profile
 
 
Posted: 13 July 2007 03:01 AM   [ Ignore ]   [ # 1 ]
Sr. Member
Avatar
RankRankRankRank
Total Posts:  336
Joined  2005-07-09

Thank you for bringing this to our attention. I can confirm this behavior, and believe it to be a bug. I looks like “entry_date” should be “rating_date”, as exp_ratings does not contain a column entry_date. Our programmers will look into the issue.

 Signature 

Ingmar Greil

Profile
 
 
Posted: 13 July 2007 09:36 AM   [ Ignore ]   [ # 2 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  693
Joined  2004-03-30

I caught this bug a couple of days ago. I’m still adding some more enhancements to Rating, but wanted to release a corrected version right now. So Rating 2.1.0 is ready for download.

mk

 Signature 

Mitchell Kimbrough

Profile
 
 
Posted: 05 August 2007 11:52 PM   [ Ignore ]   [ # 3 ]
Newbie
Rank
Total Posts:  23
Joined  2007-01-16

The same problem appears in the Freeform module ...

Kind regards,
MISC

Profile