Support Forums

Support Offline : Mon - Fri / 10am - 6pm (GMT +6)

Your Time: Our Time:

Error after upgrading to latest SP LMS Extension

Featured Lock Resolved
I upgraded to the latest version of SP LMS extension 2.0 and everything seemed fine except I get a major error:

1054
Unknown column 'alias' in 'field list' SQL=SELECT splms_course_id,title,alias,short_description,price,image FROM `mkqsb_splms_courses` WHERE `enabled` = 1 AND `featured_course` = 1 LIMIT 0, 4

Please advise!

7 Answers

hekamultimedia

More than a month ago #Permalink
I'm sorry, I left out information:

I get this error on pages created with Pagebuilder with the SP LMS Courses addon on the page. This is the error I get on ages with that addon:

1054
Unknown column 'alias' in 'field list' SQL=SELECT splms_course_id,title,alias,short_description,price,image FROM `mkqsb_splms_courses` WHERE `enabled` = 1 AND `featured_course` = 1 LIMIT 0, 4

Sport4Kids

More than a month ago #Permalink
Same Here!

Toufiq - Staff

More than a month ago #Permalink
Hi,

Thanks for your query. Please give me administrator info via pm.

-Thanks

hekamultimedia

More than a month ago #Permalink
Toufiq wrote:

Hi,

Thanks for your query. Please give me administrator info via pm.

-Thanks


I sent a PM with info, but havent heard anything back from you. Your help in this matter is appreciated.

Toufiq - Staff

More than a month ago #Permalink
Dear hekamultimedia,

Thanks for your pm. Your site is now running upgraded version of SP LMS. If you have more query, please let us know.

-Thanks

Eric

More than a month ago #Permalink
Getting attached error after upgrading from v1.0.3 to v1.0.7 when accessing the pages menu.

Please advise

Attachments (1)

  • Screen Shot 2016-01-16 at 21.44.09.png
    Screen Shot 2016-01-16 at 21.44.09.png 116.5 KB

Toufiq - Staff

More than a month ago #Permalink
Eric wrote:

Getting attached error after upgrading from v1.0.3 to v1.0.7 when accessing the pages menu.

Please advise


Dear, Please make an another forum post for your query. Thanks


There are no replies made for this post yet.
Be one of the first to reply to this post!

Leaderboard (30 days)

Paul Frankowski

Paul Frankowski

Total Accepted Answers: 129
Sifat

Sifat

Total Accepted Answers: 88
Toufiq

Toufiq

Total Accepted Answers: 41
Pavel

Pavel

Total Accepted Answers: 6
Al Mamun

Al Mamun

Total Accepted Answers: 3

114

Templates

292580

Community Users

Newsletter

Don’t miss any updates of our new templates and extensions and all the astonishing offers we bring for you.
We never spam

Joomla! ® name is used under a limited license from Open Source Matters in the United States and other countries. JoomShaper.com is not affiliated with or endorsed by Open Source Matters or the Joomla! Project.

Connect Us