Level 16
Can you verify you have an id field in the clientSites table?
Oct 6, 2014
35
Level 2
Error -> Illuminate \ Database \ QueryException (42S22) SQLSTATE[42S22]: Column not found: 1054 Unknown column 'clientSites.id' in 'where clause' (SQL: select * from `clientSites` where `clientSites`.`id` = {ClientSites} limit 1)
This is the code in my route [code]Route::get('/edit/{ClientSite}','PagesController@edit'); Route::post('/edit', 'PagesController@doEdit');[/code] This is my controller code [code] public function edit($clientID) { // get the clientsite $ClientSite = ClientSite::find($clientID);
// show the edit form and pass the clientsite
return View::make('edit')
->with('ClientSite', $ClientSite);
}
public function doEdit()
{
$ClientSite = ClienSite::findOrFail(Input::get('clientID'));
$ClientSite->siteName = Input::get('siteName');
$ClientSite->description = Input::get('description');
$ClientSite->save();
return Redirect::action('PagesController@home');
}[/code]
and this in my view [code]
Edit client {{ $ClientSites->clientID }}
{{ Form::open(['url'=> '/edit', 'class'=>'form']) }}
{{ Form::hidden('clientID', $ClientSites->clientID) }}
<div class="form=group">
{{ Form::label('siteName', 'siteName:') }}
{{ Form::text('siteName', $ClientSites->siteName,['class' => 'form-control']) }}
</div>
<div class="form=group">
{{ Form::label('description', 'description:') }}
{{ Form::textarea('description', $ClientSites->description,['class' => 'form-control']) }}
</div>[/code]
Level 65
Check what this returns
return Input::get('clientID');
dat title length
Level 2
fraserk, I am using clientID as my clientSites Id its working with the rest of the application .. Here is a link to the project on github.. https://github.com/webdevdea/DynamiX3
Level 65
We can see the code but you need to debug it yourself. Try see where it's going wrong by returning parts of the code.
Level 2
Thank you bashy, I am trying, Like I said I am new to this and am trying to figure it out myself.
Level 2
Still the same error
Level 16
In the clientsite model try
public static $key = 'clientID';
Level 2
fraserk, tried and failed. :-(
Level 16
Sorry that should be
protected $primaryKey = 'clientID';
Level 2
Nothing changed
Level 16
what error are you get now? I just look at you code on line 19 of ClientSite model add ;
Level 2
Thanks, yeah I caught that.. I am getting this class not found error.
Symfony \ Component \ Debug \ Exception \ FatalErrorException (E_ERROR)
Class 'ClientSites' not found
Level 16
In your controller, you should be calling ClientSite:: not ClientSites
Level 2
Awesome, I am not getting an error now but a dump I think?
string(70) "select * from clientSites where clientSites.clientID = ? limit 1"
Level 2
Getting closer to a solution it seems. I am not getting this error
ErrorException (E_UNKNOWN)
Trying to get property of non-object (View: /Applications/MAMP/htdocs/DynamiX3/app/views/edit.blade.php)
Level 16
Whats the line # that's giving the error?
Level 2
- Illuminate\View\Engines\CompilerEngine handleViewException …/vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php41
Level 2
If I change it to the name of the table in the database i get this error. Undefined variable: ClientSites (View: /Applications/MAMP/htdocs/DynamiX3/app/views/edit.blade.php)
Level 16
It should be ClientSite. on the edit page are you passing in a cliendId in the url.. example.com/edit/1
Level 2
I get this error ErrorException (E_UNKNOWN)
Trying to get property of non-object (View: /Applications/MAMP/htdocs/DynamiX3/app/views/edit.blade.php)
Level 16
I see, on the edit view you using $ClientsSites but in you controlller you're sending $ClientSite
You can change
this
return View::make('edit')->with('ClientSite', $ClientSite);
to
return View::make('edit')->with('ClientSites', $ClientSite);
Level 2
ErrorException (E_UNKNOWN)
Undefined variable: ClientSite (View: /Applications/MAMP/htdocs/DynamiX3/app/views/edit.blade.php) [code]return View::make('edit')->with('ClientSites', $ClientSite); [/code] [code]Route::get('/edit/{clientSite}','PagesController@edit');[/code]
Level 13
You are passing ClientSites (plural) to your view but try to access ClientSite (singular)
Level 16
check your edit view file, be sure all you variables are $clientSites. you still have this in the edit view
{{ Form::hidden('clientID', $ClientSite->clientID) }}
Level 2
Changed them all to $clientSites and get this error
ErrorException (E_UNKNOWN)
Undefined variable: clientSites (View: /Applications/MAMP/htdocs/DynamiX3/app/views/edit.blade.php)
Level 13
Then $ClientSites is not an object. dd() it in your controller and see what it is!
Level 16
no on edit view line 20 still have $ClientSite, unless you didnt comit the changes
{{ Form::hidden('clientID', $ClientSite->clientID) }}
Level 2
keevitaja I will have to google what you are saying to do and get back with you on that one, I am very very new to this framework.. thank you in advance
Level 2
keevitaja , I have this dd($clientSites);
I stuck it on there and it does not change anything
Level 16
Post your edit method here..
Please or to participate in this conversation.