Unknown column 'a.pc_aid' in 'on clause'

mbax wrote on Tuesday, November 22, 2005:

Has anyone ever had this problem and know how to solve it? This message appears in the main_screen and if I look for this field in the  openemr_postcalendar_events table (the one that is being queried), pc_aid is there.

I’m using PHP 4.4.1 and MySql Ver 14.12 Distrib 5.0.15.

Thanks in advance.

mdrtec wrote on Saturday, November 26, 2005:

I have the exact same problem - cant figure it out either and I’m a developer — hummmmmm

sunsetsystems wrote on Saturday, November 26, 2005:

Perhaps a MySQL version compatibility thing.  What’s the full text of the query?

– Rod
www.sunsetsystems.com

sunsetsystems wrote on Saturday, November 26, 2005:

With a bit of googling, I’ve found some more info that appears relevant:

http://bugs.mysql.com/bug.php?id=12943
http://www.4homepages.de/forum/index.php?topic=10184.new

Also I expect the code generating the query is in interface/main/calendar/modules/PostCalendar/pnuserapi.php.

Happy debugging!  :slight_smile:

– Rod
www.sunsetsystems.com

youngthor wrote on Sunday, December 11, 2005:

FWIW,I too am having this problem :frowning:

I am running Xampp 1.5 on Fedora Core 4
which includes
- Apache 2.0.55
- MySQL 5.0.15
- PHP 4.4.1

I suppose I’ll be switching to MySQL 4.xx till a fix comes out.
-art