When I empty catch or loading node with subform field I get

Warning: array_diff() [function.array-diff]: Argument #1 is not an array in /home/animalso/public_html/insectsoftheworld/474/modules/cck/subform/subform.module on line 1147

Warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND vid IN ( ' at line 7 query: SELECT `field_type_one_cn`, `field_type_two_cn` FROM `node_content_relation_type` WHERE `nid` = AND vid IN ( SELECT MAX( vid ) AS vid FROM `node_content_relation_type` GROUP BY nid ); in /home/mysite/474/includes/database.mysql.inc on line 121

Warning: array_diff() [function.array-diff]: Argument #1 is not an array in /home/mysite/474/modules/cck/subform/subform.module on line 1147
that

Setup ..
Views V. 47.1 fresh install
CCK V. 47.1 beta fresh install
Drupal V. 474 fresh install
MySQL database 4.1.21
PHP 4.4.4
Unicode library PHP Mbstring Extension
Web server Apache/1.3.37 (Unix) mod_fastcgi/2.4.2 mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 FrontPage/5.0.2.2635.SR1.2 mod_ssl/2.8.28 OpenSSL/0.9.7a PHP-CGI/0.1b

Comments

MrTaco’s picture

MrTaco commented
Title: canot create subforms or empty detabase catch with out these error messages » cannot create subforms or empty detabase catch with out these error messages

i'm not 100% sure what would be causing that, but i've made quite a few changes today related to the queries

try again with the 0.25 i'm about to put up, and lemme know if ur still experiencing the problem

MrTaco’s picture

MrTaco commented

ok see the latest release 0.25
lemme know if this issue is resolved, i'm 95% sure that this was one of the same issues i had/fixed today

MrTaco’s picture

MrTaco commented
Assigned: Unassigned » MrTaco
Status: Active » Postponed
mcreature’s picture

mcreature commented

Thanks for your quick response and taking the time to create this module Mrtaco. I have tested all relation type modules to date and looking forward to testing and seing this one work, infact I setup a test site just for this module yesterday.
I will let you know my new findings, ASAP.
Regards Lowell

mcreature’s picture

mcreature commented

here is an update created a completly new fresh install of drupal cck and views
included the latest release 0.25 from doday
updated all modules including: persistant field set, content type refernce, but than when added
subform module I throughs the following errors and I have to deleate it from drupal site to get the modules page working again, I also tried clearing the catch with no success.
Any ideas here is the errors message......

Warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND vid IN ( ' at line 7 query: SELECT `field_type_one_cn`, `field_type_two_cn` FROM `node_content_relation_type` WHERE `nid` = AND vid IN ( SELECT MAX( vid ) AS vid FROM `node_content_relation_type` GROUP BY nid ); in /home/animalso/public_html/insectsoftheworld/474/includes/database.mysql.inc on line 121

Warning: Cannot modify header information - headers already sent by (output started at /home/animalso/public_html/insectsoftheworld/474/includes/database.mysql.inc:121) in /home/animalso/public_html/insectsoftheworld/474/includes/common.inc on line 269

will try again when you get this fixed
Lowell

MrTaco’s picture

MrTaco commented
Status: Postponed » Fixed

i've done a complete wipe/reinstall and used subform (0.26) with your same softwware combination (php/mysql versions), and i now experience no errors

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)