ALL VIDEO SHARE

Unknown column 'slg' in 'where clause'

Rakesh
Topic Author
Offline
Fresh Boarder

Posts: 1
Thank you received: 0

Unknown column 'slg' in 'where clause' was created by Rakesh

After updating to J4 I am getting this error in the video player:

1054
Unknown column 'slg' in 'where clause'

Please help
video page

8 months 1 week ago #10156

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

Administrator
Offline
Administrator

Posts: 2478
Thank you received: 1451

Replied by Administrator on topic Unknown column 'slg' in 'where clause'

Aah. I just noticed this issue that is related to Joomla 3 to Joomla 4 migration but occurs only when using our old "Custom Page URL" feature. I promise that our next version would address this issue.

Kindly follow the steps below as a quick solution,

1. Edit open the following file,

{SITE_ROOT}/modules/mod_allvideoshareplayer/src/Helper/AllVideoSharePlayer.php

2. Find the line (#72) below,

$query .= ' AND slg=' . $db->quote( $alias );

3. Replace it as,

$query .= ' AND slug=' . $db->quote( $alias );

4. Save the changes and check now.

Hope this solved your issue!

Last edit: 8 months 1 week ago by Administrator.

8 months 1 week ago #10157

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

Time to create page: 0.101 seconds