In home www/ Starter Site show this: (but i can acces to admin panel correctly) <p

SQLSTATE[42000]: Syntax error or access violation about laravel-5-bootstrap-3-starter-site HOT 3 CLOSED

mrakodol commented on August 14, 2024

SQLSTATE[42000]: Syntax error or access violation

from laravel-5-bootstrap-3-starter-site.

Comments (3)

ricardopaiva commented on August 14, 2024

Alejandri, you can see the changes suggested by idangozlan. Check the only pull request that's active.

from laravel-5-bootstrap-3-starter-site.

alejandri commented on August 14, 2024

Thanks. I solved changed in HomeController this:

public function index()
{
$news = $this->news->orderBy('position', 'DESC')->orderBy('created_at', 'DESC')->limit(4)->get();
$sliders = Photo::join('photo_album', 'photo_album.id','=','photo.photo_album_id')
->where('photo.slider',1)
->orderBy('photo.position', 'DESC')
->orderBy('photo.created_at', 'DESC')
->select('photo.filename','photo.name','photo.description','photo_album.folderid')->get();

        $photoalbums = PhotoAlbum::select(array('photo_album.id', 'photo_album.name', 'photo_album.description',
                'photo_album.folderid',
                DB::raw('(select filename from photo WHERE album_cover=1 and photo.photo_album_id=photo_album.id) AS album_image'),
                DB::raw('(select filename from photo WHERE photo.photo_album_id=photo_album.id ORDER BY position ASC, id ASC LIMIT 1) AS album_image_first')))->limit(8)->get();

        $videoalbums = VideoAlbum::select(array('video_album.id', 'video_album.name', 'video_album.description',
                'video_album.folderid',
                DB::raw('(select youtube from video as v WHERE album_cover=1 and v.video_album_id=video_album.id) AS album_image'),
                DB::raw('(select youtube from video WHERE video.video_album_id=video_album.id ORDER BY position ASC, id ASC LIMIT 1) AS album_image_first')))->limit(8)->get();

        return view('site.home.index',compact('news','sliders','videoalbums','photoalbums'));
}

from laravel-5-bootstrap-3-starter-site.