FuelPHP Forums

Muts

K so I'm trying to get the characters the logged users owns by writing the following:

$characters_owned = Model_Character::find()
   ->related('simpleusers_api')
   ->where('user_id', $this->user_id)
   ->get();

But this is the error I get:

1054! Fuel\Core\Database_Exception [ 1054 ]: Unknown column 't0.user_id' in 'where clause' [ SELECT `t0`.`id` AS `t0_c0`, `t0`.`character_id` AS `t0_c1`, `t0`.`character_name` AS `t0_c2`, `t0`.`is_public` AS `t0_c3`, `t0`.`api_id_id` AS `t0_c4`, `t1`.`id` AS `t1_c0`, `t1`.`api_id` AS `t1_c1`, `t1`.`api_key` AS `t1_c2`, `t1`.`user_id` AS `t1_c3` FROM `simpleusers_characters` AS `t0` LEFT JOIN `simpleusers_api` AS `t1` ON (`t0`.`api_id_id` = `t1`.`api_id`) WHERE `t0`.`user_id` = 25 ]

Here are my models
http://scrp.at/XE

Muts

K so apparently the update didn't change any issue.
But what I did however find was that 'simpleusers_api' isn't reconised cause of the alias 't1'.
If I change simpleusers_api to t1 it works however. How come? fyi: the aliases are done automaticly.

Jelmer Schreuder

Let me first quote myself:

Ah, you're on RC2 aren't you? This is only supported in the latest dev branch.

RC2 doesn't support this yet, this was added very recently and will be in RC3 which should be released very soon. (final is still a bit off as a lot of Unit tests still need to be written)

Muts

Oh sorry,
I thought you were reffering to RC2 with the dev branch... I'm not quite familiar with names and versions

So dev branch means still in development?
what does RC stands for then? r=release? c=?

Kurt

RC = Release Candidate http://en.wikipedia.org/wiki/Software_release_life_cycle#Release_candidate

Jelmer Schreuder

Does the characters table have a column with name 'user_id'? If not why would you expect your where condition to work?
I can't check your models because Scrapyrd is timing out right now. But judging from the query user_id is part of the simpleusers_api table. And you should request it from that table by prepending the relation name and a dot. Check the docs for examples on how that can be done.

Muts

Oh well forgot to update my message, but I did however written

$characters_owned = Model_Character::find()
   ->related('simpleusers_api')
   ->where('simpleusers_api.user_id', $this->user_id)
   ->get();

But still gives about the same problem

Jelmer Schreuder

Could you give it anyway, because it can't be exactly the same... there is some subtle difference this should cause.

Muts

This is the index:

public function action_index()
    {
  $characters_owned = Model_Character::find()
   ->related('simpleusers_api')
   ->where('simpleusers_api.user_id', $this->user_id)
   ->get();
  // $characters_permitted = Model_Character::find();
  $characters = Model_Character::find()->where('is_public', '=', 1)->order_by('character_name', 'asc')->get();
  
        $this->template->title = 'Characters list';
        $this->template->content = View::factory('characters/index')
   ->set('characters_owned', $characters_owned)
   // ->set('characters_permitted', $characters_permitted)
   ->set('characters', $characters);
    }

As of now the scrap website works... So you can find the related models.

Jelmer Schreuder

I meant the error message

Muts

Oh sorry, here: http://scripttesting.com/phpfuel/index.php/characters

Jelmer Schreuder

Ah, you're on RC2 aren't you? This is only supported in the latest dev branch.

Muts

To be honest I'm not sure on what I'm now. I can only find RC1 on the website.
Fyi it might be usefull to put a download link. So what do I need to do? update to ?

Huzzi

https://github.com/downloads/fuel/fuel/fuel-1.0-rc2.zip

FuelPHP Forums

Ask your question about FuelPHP in the appropriate forum, or help others by answering their questions.

Howdy, Stranger!

Categories

In this Discussion