New Dynamic YouTube Gallery - Embed YouTube Playlist, Channel, Live Stream in minutes. Read More

Unknown column 'slg' in 'where clause'

  • Rakesh
  • Topic Author
  • Offline
  • Fresh Boarder
  • 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 4 days ago #10156

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

  • 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 4 days ago by Administrator.
8 months 4 days ago #10157

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

Time to create page: 0.082 seconds

We accept cookies to provide you the best viewing experience. By using our services, you agree to our use of cookies