Welcome, Guest

TOPIC: [FIXED] Problems with RElations

Problems with RElations 03 Dec 2015 10:31 #13701

MorganL
Offline
Platinum Member
Posts: 438
Thank you received: 53
Karma: 16

Further to another ticket I have raised, I have found the problem appears to be with FK Relations

I have created three cross ref tables, made sure there is data available, and dragged those three fields types into a form

In the BACKEND two work seamlessly, one just doesnt pull in any data (I have removed and recreated), just asks me to choose some options.. which are not there to choose

IN the FRONT END, none of the fields pull in data

This is also confirmed in SANDBOX

Project BidS...e (name is a brand not yet ready for release)

Main table - Films
xRef tables - Four in total, all used in the LEGAL form section

Front end - PLEase use the My Portfoilio view and click NEW, legal section again

Morgan Leecy MCSE

Novell / Linux
PHP. MYSQL, Apache, node.js
Coldfusion, JQuery, HTML5
Joomla

The administrator has disabled public write access.

Problems with RElations 03 Dec 2015 17:42 #13721

MorganL Offline Platinum Member Posts: 438 Thank you received: 53 Karma: 16	I had a table called RIGHTS which is one of the affected FK, and I though maybe due to the word right being protected as a SQL term it may be the problems. Changed instances of this word.. made no difference..
	Morgan Leecy MCSE Novell / Linux PHP. MYSQL, Apache, node.js Coldfusion, JQuery, HTML5 Joomla The administrator has disabled public write access.

Problems with RElations 03 Dec 2015 17:43 #13722

admin Online Administrator Chef Posts: 3711 Thank you received: 984 Karma: 140	I am currently checking.
	Coding is now a piece of cake The administrator has disabled public write access. The following user(s) said Thank You: MorganL

Problems with RElations 03 Dec 2015 18:29 #13723

MorganL Offline Platinum Member Posts: 438 Thank you received: 53 Karma: 16	Much appreciated, this is the only thing actually stopping me signing off a project over for user testing this evening!
	Morgan Leecy MCSE Novell / Linux PHP. MYSQL, Apache, node.js Coldfusion, JQuery, HTML5 Joomla The administrator has disabled public write access.

Problems with RElations 03 Dec 2015 18:32 #13724

admin Online Administrator Chef Posts: 3711 Thank you received: 984 Karma: 140	Fixed. Much better now. Right ?
	Coding is now a piece of cake The administrator has disabled public write access.

Problems with RElations 03 Dec 2015 18:58 #13725

MorganL Offline Platinum Member Posts: 438 Thank you received: 53 Karma: 16	BooYA! Works beautifully! Should I ideally download a new install package for these fixes?
	Morgan Leecy MCSE Novell / Linux PHP. MYSQL, Apache, node.js Coldfusion, JQuery, HTML5 Joomla The administrator has disabled public write access.

Problems with RElations 03 Dec 2015 19:02 #13726

admin Online Administrator Chef Posts: 3711 Thank you received: 984 Karma: 140	Only models/fil..s.php : __construct() : Remove the suffixes in the relation name: ex : myrelation_1 > myrelation. It is because Cook has planned to manage multiple instances of the same XRef on different fields, but in future... At the moment nobody is asking that. It was just messing up because you instance twice the same relation (back and front) But it should not do that. It was a Bug.
	Coding is now a piece of cake The administrator has disabled public write access. The following user(s) said Thank You: MorganL

Forum

Debug

Closed tickets.

[FIXED] Problems with RElations