Hi again Mrtaco

here is an update and fileing this one a a sepporate bug as it happens durring module install

I first 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

I will keep testing, thanks again for your efforts.

Comments

MrTaco’s picture

MrTaco commented
Assigned: Unassigned » MrTaco
MrTaco’s picture

MrTaco commented

i've just wiped my testbed and reinstalled cck, views, and all the subform pieces

i didn't get any database errors during install, but when going to create the first subform as part of a content type, I do get a database error when trying to access the views_view table, which is apparently not created by the views system until after its first direct use

MrTaco’s picture

MrTaco commented
Status: Active » Fixed

ok i've now received the same error that you received, and i got the error during install

previously i had not yet turned on the views module, when i enabled the views module, i got that error

what is happening, is that on initial enablement, views goes ahead and queries other system modules for any predefined views

when subform is queried for preset views, in the process of checking for the existence of any subforms, it was trying to check the child type of an undefined relation type. i've put some checks in the funtions that get these values, and they will now silently return if they're asked to do something stupid like this

i have again wiped my testbed install, and rebuilt from scratch, and i'm now installing cck/views/and the subform pieces, with no errors. as well i've created initial content types and relations, and everything is working so far

i'm going to update this release, with this fix

thank you for bringing this bug to my attention

Anonymous’s picture

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