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

CommentFileSizeAuthor
#6 schema_fix_for_show_record_number-1266074-6.patch679 bytestedstein

Comments

jyg’s picture

jyg commented

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

jyg

jyg’s picture

jyg commented

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.
jyg’s picture

jyg commented

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

jyg

jyg’s picture

jyg commented

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

tedstein’s picture

tedstein commented

Tested, reproduced, and I am fixing it now.

Thanks for the bug report.

tedstein’s picture

tedstein commented
Status: Active » Needs review
StatusFileSize
new schema_fix_for_show_record_number-1266074-6.patch679 bytes

Here is a patch. Anyone willing to test it?

tedstein’s picture

tedstein commented
Assigned: Unassigned » tedstein
Status: Needs review » Fixed

I tested and applied the patch. Closing now, please re-open if you encounter any issues.

tedstein’s picture

tedstein commented
Status: Fixed » Closed (fixed)