Hello Keith i am sorry that this is still a problem for you. Maybe i can assist you.
First i need to know if you are getting any error messages? Then i would like to refer you to this site to see if there is anything there that will help you! http://www.phpfreaks.com/ As far as your problem i will run a few test and search and work with you on that and then i should be able to provide you with some results. I am sorry that non-of the Tech were able to get to your post sooner. We are a little busy. Xavier A. Mathews Student/Developer/Web-Master GG Client Based Tech Support Specialist Hazel Crest Illinois [EMAIL PROTECTED] "Fear of a name, only increases fear of the thing itself." On Sat, Oct 11, 2008 at 9:58 AM, Keith <[EMAIL PROTECTED]> wrote: > > Hi Villas, > > I tried clearing out the cache and that didn't fix it unfortunately. > > I have the max debug level set. The code appears to be operating as > programmed. > > I tried a simple habtm with belongs_to in a scenario where I only had > those two models and still got the same results. > > I think it's a problem with how CakePHP is creating the array. The > first element in the array has no numeric identifier. If you look > back at the screenshot in the initial post you'll see that the first > entry in the array is not [0] but rather is called [id] as it would be > when there is a belongs_to and not a HABTM as well. > > Unless I can figure something out I'm going to go ahead and just > report it to cakePHP as a bug because there are legit reasons, like > the one I'm building, where you'd want a habtm with a belongs_to in > the same model. > > - Keith > > On Oct 11, 8:14 am, villas <[EMAIL PROTECTED]> wrote: > > Hi Keith > > > > Thanks for the extra info although it still isn't very clear to me > > from that what's going on. However, I would mention: > > 1. Are you clearing your cache? You might have old data hanging > > around. > > 2. Did you try to set a higher debug level to get more info? > > 3. Did you try to experiment with Bake? You can try different > > scenarios which you should be able to get working without too much > > sweat. > > > > Best regards. > > > > On Oct 11, 6:31 am, Keith <[EMAIL PROTECTED]> wrote: > > > > > Just as a clarification on why I have it set up this way... > > > > > The belongs_to is there because the users that creates the project > > > becomes the owner. > > > The has_and_belongs_to_many is there so that if a user wants someone > > > outside their department to access it they can manually add them. > > > > > The problem looks like it's stemming from how cakePHP is handling the > > > array... > > > > > for the belongs_to the array keys are based on field names like [id] & > > > [first_name], etc. > > > for the HABTM array the array keys are sequential as the "related > > > users" foreach loop expects. > > > > > - Keith > > > > > On Oct 11, 1:18 am, Keith <[EMAIL PROTECTED]> wrote: > > > > > > It looks to me like this is what is happening, but it's very > > > > strange... > > > > > > Even when no users are associated I'm getting 8 blank associated > users > > > > which is exactly how many elements are in the array... > > > > > > So... > > > > > > It looks like it's taking the first character from each part of the > > > > first entry in the array and putting it there... > > > > K = Keith = First Name > > > > M = Medlin = Last Name > > > > etc. for each of the fields. > > > > > > So...I'm totally confused why the following code would produce that: > > > > > > SQL Query: > > > > SELECT `User`.`id`, `User`.`first_name`, `User`.`last_name`, > > > > `User`.`email`, `User`.`date_created`, `User`.`last_login`, > > > > `User`.`username`, `User`.`password`, `ProjectsUser`.`user_id`, > > > > `ProjectsUser`.`project_id` FROM `users` AS `User` JOIN > > > > `projects_users` AS `ProjectsUser` ON (`ProjectsUser`.`project_id` = > 1 > > > > AND `ProjectsUser`.`user_id` = `User`.`id`) WHERE 1 = 1 > > > > > > Which returns a normal looking data set in SQL... > > > > > > Relevant View Code: > > > > <?php > > > > $i = 0; > > > > foreach ($project['User'] as $user): > > > > $class = null; > > > > if ($i++ % 2 == 0) { > > > > $class = ' class="altrow"'; > > > > } > > > > ?> > > > > <tr<?php echo $class;?>> > > > > <td><?php echo $user['id'];?></td> > > > > <td><?php echo $user['first_name'];?></td> > > > > <td><?php echo $user['last_name'];?></td> > > > > <td><?php echo $user['email'];?></td> > > > > <td><?php echo $user['date_created'];?></td> > > > > <td><?php echo $user['last_login'];?></td> > > > > <td><?php echo $user['username'];?></td> > > > > <td><?php echo $user['password'];?></td> > > > > > > project['User'] is what you see dumped above the related users table > > > > so you can see that the array doesn't look strange in any way. Is > > > > this possibly a bug that needs reporting to the CakePHP trac? > > > > > > - Keith > > > > > > On Oct 10, 11:58 pm, Keith <[EMAIL PROTECTED]> wrote: > > > > > > > Thanks for the response. > > > > > > > The documents table exists but I'm not having any issues with that > > > > > relationship as it's a simple has_many and belongs_to with my user > > > > > model. > > > > > > > The real issue is why, what appears to be a valid array is > rendering > > > > > the way it is in the related users table on the view for the > projects > > > > > page. > > > > > > > To get the array that's there I just did a print_r on the $users > array > > > > > that is automatically generated by CakePHP. As you can see there > are > > > > > no missing keys and the hash lines up correctly with the data. > > > > > > > The thing I cannot figure out is why I have those garbage rows in > the > > > > > table. My database is clean. It has 3 users with normal looking > > > > > data. The projects_users join table is clean with: > > > > > > > user_id | project_id > > > > > 3 | 1 > > > > > 2 | 1 > > > > > > > The user_id associated with the table has a corresponding user as > you > > > > > can see in the array. So I'm not sure why it's chunking up data > that > > > > > way it is in the related users table. > > > > > > > Any ideas? Or can you think of anything specifically I should > check > > > > > on outside of running the queries directly in SQL which I've done > and > > > > > they return the correct data. I think the problem is in the view > or > > > > > how the users array is being interpreted possibly. > > > > > > > - Keith > > > > > > > On Oct 10, 6:48 pm, villas <[EMAIL PROTECTED]> wrote: > > > > > > > > Hi Keith > > > > > > > > Not sure you've provided enough info here, and what we see looks > a > > > > > > bit confusing. > > > > > > Is there also a 'documents' table? > > > > > > Did you set up a join table for the HABTM? > > > > > > What is the logic of having a Project belonging to a User in > addition > > > > > > to using a join table so that many Projects may belong to a User? > > > > > > Maybe what you have written makes more sense to others, but it > > > > > > suggests to me that you probably didn't read the > book.cakephp.org > > > > > > carefully enough. Have a good look again at the Models section > and > > > > > > then post a followup question, bearing in mind my comments above > and > > > > > > we can try our best to assist you better. > > > > > > > > Kind regards. > > > > > > > > On Oct 10, 9:44 pm, Keith <[EMAIL PROTECTED]> wrote: > > > > > > > > > I am running into a strange issue when I've got the following > model > > > > > > > structure: > > > > > > > > > User: > > > > > > > Has_Many: Projects > > > > > > > HABTM: Projects > > > > > > > > > Projects: > > > > > > > Belongs_To: User > > > > > > > HABTM: Users > > > > > > > > > So...everything works fine. When I create a new project and > select > > > > > > > multiple users they are indeed associated with the project as > is the > > > > > > > correct user who "owns' the project as per the Belongs_To model > > > > > > > relationship. > > > > > > > > > However... > > > > > > > > > In the scaffolded view I get a really strange result that the > SQL > > > > > > > query doesn't actually generate when I run it in SQL... > > > > > > > > > I get a really bizarre output in the Related Users. Here's a > > > > > > > screenshot:http://www.keithmedlin.com/habtm_error.png > > > > > > > > > Any idea on why I've got what looks like a normal array > rendering > > > > > > > pretty garbled? > > > > > > > > > I've run the SQL from the debug mode and the output looks > exactly like > > > > > > > I expect it should look with the 2 users Rich & Lisa associated > with > > > > > > > the document properly. > > > > > > > > > Thank you in advance for any help you might be able to provide! > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
