Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC:

Problems with RElations 03 Dec 2015 10:31 #13701

  • MorganL
  • MorganL's Avatar Topic Author
  • Offline
  • Platinum Member
  • Platinum Member
  • Posts: 438
  • Thank you received: 53
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

Please Log in or Create an account to join the conversation.

Problems with RElations 03 Dec 2015 17:42 #13721

  • MorganL
  • MorganL's Avatar Topic Author
  • Offline
  • Platinum Member
  • Platinum Member
  • Posts: 438
  • Thank you received: 53
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

Please Log in or Create an account to join the conversation.

Problems with RElations 03 Dec 2015 17:43 #13722

  • admin
  • admin's Avatar
  • Offline
  • Administrator
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 986
I am currently checking.
Coding is now a piece of cake
The following user(s) said Thank You: MorganL

Please Log in or Create an account to join the conversation.

Problems with RElations 03 Dec 2015 18:29 #13723

  • MorganL
  • MorganL's Avatar Topic Author
  • Offline
  • Platinum Member
  • Platinum Member
  • Posts: 438
  • Thank you received: 53
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

Please Log in or Create an account to join the conversation.

Problems with RElations 03 Dec 2015 18:32 #13724

  • admin
  • admin's Avatar
  • Offline
  • Administrator
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 986
Fixed.

Much better now.
Right ?
Coding is now a piece of cake

Please Log in or Create an account to join the conversation.

Problems with RElations 03 Dec 2015 18:58 #13725

  • MorganL
  • MorganL's Avatar Topic Author
  • Offline
  • Platinum Member
  • Platinum Member
  • Posts: 438
  • Thank you received: 53
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

Please Log in or Create an account to join the conversation.

Problems with RElations 03 Dec 2015 19:02 #13726

  • admin
  • admin's Avatar
  • Offline
  • Administrator
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 986
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 following user(s) said Thank You: MorganL

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
Time to create page: 0.455 seconds

Although I found this tool some time ago I just started learning experimenting and building this first component on Monday and now on Thursday afternoon it's already online. Although I already had a working version done with another tool this is much easier to build and at the end you have the freedom to own your own component. Once you know how to use Cook you will boost your productivity as the learning curve is really moderate compared to many other tools.
Giori (Forum)

Get Started