[TYPO3-irre] bekomme IRRE in eigener EXtension nicht zum laufen :(

[marcelin]

Hallo Community,

habe gestern einmal die IRRE Demoext. angeschaut, dort funktioniert alles wunderbar ☺. Allerdings bekomme ich das ganze bei mir irgendwie nicht zum laufen. Ich habe insgesamt 3 Tabellen (Person, Course, Person_Course_Rel). Ich möchte gern das wenn ich Kurse angelegt habe, diese dann bei den Personen zur Auswahl stehen. Aber irgendwie bekomme ich immer einen mysql_fetch_row(): supplied argument is not a valid MySQL result resource Fehler. Hoffe das mir jemand helfen kann.

Hier einmal mein Code :

DB:
#
# Table structure for table 'tx_irretester_person_course_rel'
# 
#
CREATE TABLE tx_irretester_person_course_rel (
  person_fk int(11) DEFAULT '0' NOT NULL,
  course_fk int(11) DEFAULT '0' NOT NULL,
  tablenames varchar(30) DEFAULT '' NOT NULL,
  sorting int(11) DEFAULT '0' NOT NULL,
  KEY person_fk (person_fk),
  KEY course_fk (course_fk)
);



#
# Table structure for table 'tx_irretester_person'
#
CREATE TABLE tx_irretester_person (
	uid int(11) NOT NULL auto_increment,
	pid int(11) DEFAULT '0' NOT NULL,
	…
	name varchar(30) DEFAULT '' NOT NULL,
	firstname varchar(30) DEFAULT '' NOT NULL,
	course_id int(11) DEFAULT '0' NOT NULL,
	
	PRIMARY KEY (uid),
	KEY parent (pid)
);



#
# Table structure for table 'tx_irretester_course'
#
CREATE TABLE tx_irretester_course (
	uid int(11) NOT NULL auto_increment,
	pid int(11) DEFAULT '0' NOT NULL,
	…
	name varchar(30) DEFAULT '' NOT NULL,
	max_person int(11) DEFAULT '0' NOT NULL,
	
	PRIMARY KEY (uid),
	KEY parent (pid)
);

TCA das wichtigste:
<?php
if (!defined ('TYPO3_MODE')) 	die ('Access denied.');

$TCA["tx_irretester_person"] = array (
	"ctrl" => $TCA["tx_irretester_person"]["ctrl"],
	"interface" => array (
		"showRecordFieldList" => "hidden,starttime,endtime,fe_group,name,firstname,course_id"
	),
	"feInterface" => $TCA["tx_irretester_person"]["feInterface"],
	"columns" => array (
		…
		"firstname" => Array (		
			"exclude" => 1,		
			"label" => "LLL:EXT:irre_tester/locallang_db.xml:tx_irretester_person.firstname",		
			"config" => Array (
				"type" => "input",	
				"size" => "30",	
				"max" => "30",	
				"eval" => "required,trim",
			)
		),
		"course_id" => Array (		
			"exclude" => 1,		
			"label" => "LLL:EXT:irre_tester/locallang_db.xml:tx_irretester_person.course_id",		
			"config" => Array (
				"type" => "inline",	
				"foreign_table" => "tx_irretester_person_course_rel",
				"foreign_field" => "person_fk",
				"foreign_sortby" => "sorting",
				"foreign_label" => "person_fk",
				"maxitems" => 1,	
			)
		),
	),
	"types" => array (
		"0" => array("showitem" => "hidden;;1;;1-1-1, name, firstname, course_id")
	),
	"palettes" => array (
		"1" => array("showitem" => "starttime, endtime, fe_group")
	)
);



$TCA["tx_irretester_course"] = array (
	"ctrl" => $TCA["tx_irretester_course"]["ctrl"],
	"interface" => array (
		"showRecordFieldList" => "hidden,name,max_person"
	),
	"feInterface" => $TCA["tx_irretester_course"]["feInterface"],
	"columns" => array (
		…
		"max_person" => Array (		
			"exclude" => 1,		
			"label" => "LLL:EXT:irre_tester/locallang_db.xml:tx_irretester_course.max_person",		
			"config" => Array (
				"type"     => "input",
				"size"     => "4",
				"max"      => "4",
				"eval"     => "int",
				"checkbox" => "0",
				"range"    => Array (
					"upper" => "1000",
					"lower" => "10"
				),
				"default" => 0
			)
		),
		"person_id" => Array(
      "exclude" => 1,
      "label" => "TEST",
      "config" => Array(
        "type" => "inline",
        "foreign_table" => "tx_irretester_person_course_rel",
				"foreign_field" => "course_fk",
				"foreign_sortby" => "sorting",
				"foreign_label" => "course_fk",
				"maxitems" => 1,
      )
		),
	),
	"types" => array (
		"0" => array("showitem" => "hidden;;1;;1-1-1, name, max_person, person_id")
	),
	"palettes" => array (
		"1" => array("showitem" => "")
	)
);

$TCA["tx_irretester_person_course_rel"] = array (
	"columns" => array (
		'person_fk' => array (		
			'label'   => 'Person',
			'config'  => array (
				'type'    => 'select',
				'foreign_table' => 'tx_irretester_person_course_rel',
				'foreign_table_where' => "AND tx_irretester_person.pid=###CURRENT_PID###",
				'maxitems' => 1,
			)
		),
		'course_fk' => array (		
			'label'   => 'Course',
			'config'  => array (
				'type'    => 'select',
				'foreign_table' => 'tx_irretester_person_course_rel',
				'foreign_table_where' => "AND tx_irretester_person.pid=###CURRENT_PID###",
				'maxitems' => 1,
			)
		),
	),
	"types" => array (
		"0" => array("showitem" => "hidden;;1;;1-1-1, person_fk, course_fk")
	),
	"palettes" => array (
		"1" => array("showitem" => "starttime, endtime, fe_group")
	)
);
?>