Warning "Unknown column 'fm_show_record_number'" when creating layout [#1266074]

user warning: Unknown column 'fm_show_record_number' in 'field list' query: INSERT INTO filemaker (nid, vid, fmcid, layout, fmview, fm_show_record_number) VALUES (137469, 175214, 1, '', 'none', 1) in E:\wwwroot\sites\all\modules\filemaker\filemaker.module on line 501.
user warning: Unknown column 'fm_show_record_number' in 'field list' query: SELECT fmcid, layout, fmview, fm_show_record_number FROM filemaker WHERE vid = 175214 in E:\wwwroot\sites\all\modules\filemaker\filemaker.module on line 490.

Not sure of the impact of this warning yet. If I find related issues I'll post here.

Drupal 6.12
PHP 5.2.17
MySQL 5.5.8
Libraries Module 6.x-1.0

What else can I tell you to help you?

thanks,

jyg

Comment	File	Size	Author
#6	schema_fix_for_show_record_number-1266074-6.patch	679 bytes	tedstein

Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Comment #1

jyg CreditAttribution: jyg commented 31 August 2011 at 22:42

When viewing the layout I get error from line 490 again.

jyg

Comment #2

jyg CreditAttribution: jyg commented 31 August 2011 at 23:18

I have also been unable to make a connection to the FileMaker Server running on the same host as the Drupal server.

•user warning: Unknown column 'fm_show_record_number' in 'field list' query: SELECT fmcid, layout, fmview, fm_show_record_number FROM filemaker WHERE vid = 175215 in E:\wwwroot\sites\all\modules\filemaker\filemaker.module on line 490.
•FileMaker nodes require a connection to a FileMaker database.

Comment #3

jyg CreditAttribution: jyg commented 31 August 2011 at 23:24

My databases Filemaker table certainly does not have that fm_show_record_number column.

jyg

Comment #4

jyg CreditAttribution: jyg commented 2 September 2011 at 23:03

The problem is that this module has an update which is not applied upon install/already in released code. I had to install the module and then apply the updates by hand (that is, by going to /update.php).

jyg