error splms in orders - Forum | JoomShaper
Awaiting an answer Extensions

error splms in orders

Asked by Alejandra Cuesta Cuesta 5 years ago Last activity 5 years ago

hello I am using sp lms and it gives me the following error when I enter orders

500 Unknown column 'a.title' in 'where clause' <br/> Unknown column 'a.title' in 'where clause'

Can you help me thank you.

4 replies

Oldest first Newest first Most helpful
Ariba Staff
5 years ago · edited

Hello

Can you try the following please:
Please go to:
administrator/components/com_splms/models/orders.php
Find out this code

$query->where('(d.title LIKE ' . $search . ')');

And Replace with this code

$query->where('(d.name LIKE ' . $search . ')');
Alejandra Cuesta Cuesta Asked this
5 years ago

thanks!!

Ariba Staff
5 years ago · edited

You are most welcome.

Please do let me know if you have any other queries, i am happy to help :)

If there is no other problem, kindly accept my answer of solution in order to close and resolve the post.
Have a great day!

Ariba Staff
5 years ago

Your kind review on the link below will be highly appreciated :)

Please do take some time to share your thoughts.

Have a great day and stay safe

Log in to reply.