We’re with you. JoomShaper is offering a 20% Discount on all plans due to the impact of COVID-19.

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

Your Time: Our Time:

Installation Upgrade Error

Featured Lock Resolved Bug
Hi, I've just upgraded the site to the latest version and I have a number of errors:-
DatabaseExceptionExecuting: Table 'db8gefdpjkup6w.#__splms_lessiontopics' doesn't exist in /home/customer/www/physicalsecurityskills.com/public_html/libraries/joomla/database/driver/mysqli.php:665 Stack trace: #0 /home/customer/www/physicalsecurityskills.com/public_html/libraries/joomla/database/driver.php(1701): JDatabaseDriverMysqli->execute() #1 /home/customer/www/physicalsecurityskills.com/public_html/components/com_splms/models/course.php(114): JDatabaseDriver->loadObjectList() #2 /home/customer/www/physicalsecurityskills.com/public_html/components/com_splms/models/course.php(85): SplmsModelCourse->getTopics(2) #3 /home/customer/www/physicalsecurityskills.com/public_html/libraries/src/MVC/View/HtmlView.php(425): SplmsModelCourse->getItem() #4 /home/customer/www/physicalsecurityskills.com/public_html/components/com_splms/views/course/view.html.php(19): Joomla\CMS\MVC\View\HtmlView->get('Item') #5 /home/customer/www/physicalsecurityskills.com/public_html/libraries/src/MVC/Controller/BaseController.php(672): SplmsViewCourse->display() #6 /home/customer/www/physicalsecurityskills.com/public_html/libraries/src/MVC/Controller/BaseController.php(710): Joomla\CMS\MVC\Controller\BaseController->display() #7 /home/customer/www/physicalsecurityskills.com/public_html/components/com_splms/splms.php(31): Joomla\CMS\MVC\Controller\BaseController->execute('') #8 /home/customer/www/physicalsecurityskills.com/public_html/libraries/src/Component/ComponentHelper.php(402): require_once('/home/customer/...') #9 /home/customer/www/physicalsecurityskills.com/public_html/libraries/src/Component/ComponentHelper.php(377): Joomla\CMS\Component\ComponentHelper::executeComponent('/home/customer/...') #10 /home/customer/www/physicalsecurityskills.com/public_html/libraries/src/Application/SiteApplication.php(194): Joomla\CMS\Component\ComponentHelper::renderComponent('com_splms') #11 /home/customer/www/physicalsecurityskills.com/public_html/libraries/src/Application/SiteApplication.php(233): Joomla\CMS\Application\SiteApplication->dispatch() #12 /home/customer/www/physicalsecurityskills.com/public_html/libraries/src/Application/CMSApplication.php(196): Joomla\CMS\Application\SiteApplication->doExecute() #13 /home/customer/www/physicalsecurityskills.com/public_html/index.php(49): Joomla\CMS\Application\CMSApplication->execute() #14 {main}

Any advice please..

22 Answers

BenL

More than a month ago #Permalink
hi @Alan, i have similar issue after installing 3.4, do you find solution for that?
Regards.

Alan Davies

More than a month ago #Permalink
Hi Ben,

Sorry to say not as yet. I tried to raise it via the contact form, but the issue doesn't appear to warrant any urgency.
I restored the site, so I have that back.
Hopefully someone will look at this this week.

Kind regards,

Alan

Scherpereel Corine

More than a month ago #Permalink
Hi Ben,

the same problem.. my website is now out of service :(
error 1054
Unknown column 'social_youtube' in 'field list'

BenL

More than a month ago #Permalink
@hello Scheperrel, here you have similar issue.

gourou

More than a month ago #Permalink
each update and the story continues, no pain, no gain - so let's get down to it. :(

BenL

More than a month ago #Permalink
each update and the story continues, no pain, no gain - so let's get down to it. :(



hope support will help as fix asap all bugs related to sp lms

Alan Davies

More than a month ago #Permalink
No returns / refunds will be offered for digital products except if the product you’ve purchased is:
Completely non-functional.
And you’ve posted a support post on forum but you didn't get any respond in 48h (business days only).

How do I request a refund?

BenL

More than a month ago #Permalink
No returns / refunds will be offered for digital products except if the product you’ve purchased is:
Completely non-functional.
And you’ve posted a support post on forum but you didn't get any respond in 48h (business days only).

How do I request a refund?


C'mon Alan, give them time to fix it :p

Alan Davies

More than a month ago #Permalink
Hi Ben,

I'm happy to give as much time as they need, but an acknowledgement to say they have noticed this feedback and the errors will be looked at would be helpful and encouraging. I love their software too!

regards,
Alan

Ofi Khan - Staff

More than a month ago #Permalink
Hello Alan,
Apology for the delayed response. Please uninstall SP LMS from Extenions -> Manage. Then download the latest SP LMS from here: https://www.joomshaper.com/downloads/extension/sp-lms and install it again.

- Best regards

Alan Davies

More than a month ago #Permalink
Hi Ofi,

Just completed - now showing
Error
JDatabaseExceptionExecuting: Unknown column 'a.topic_id' in 'where clause' in /home/customer/www/physicalsecurityskills.com/public_html/libraries/joomla/database/driver/mysqli.php:665 Stack trace: #0 /home/customer/www/physicalsecurityskills.com/public_html/libraries/joomla/database/driver.php(1701): JDatabaseDriverMysqli->execute() #1 /home/customer/www/physicalsecurityskills.com/public_html/components/com_splms/models/course.php(145): JDatabaseDriver->loadObjectList() #2 /home/customer/www/physicalsecurityskills.com/public_html/components/com_splms/models/course.php(118): SplmsModelCourse->getLessons(2, '1') #3 /home/customer/www/physicalsecurityskills.com/public_html/components/com_splms/models/course.php(85): SplmsModelCourse->getTopics(2) #4 /home/customer/www/physicalsecurityskills.com/public_html/libraries/src/MVC/View/HtmlView.php(425): SplmsModelCourse->getItem() #5 /home/customer/www/physicalsecurityskills.com/public_html/components/com_splms/views/course/view.html.php(19): Joomla\CMS\MVC\View\HtmlView->get('Item') #6 /home/customer/www/physicalsecurityskills.com/public_html/libraries/src/MVC/Controller/BaseController.php(672): SplmsViewCourse->display() #7 /home/customer/www/physicalsecurityskills.com/public_html/libraries/src/MVC/Controller/BaseController.php(710): Joomla\CMS\MVC\Controller\BaseController->display() #8 /home/customer/www/physicalsecurityskills.com/public_html/components/com_splms/splms.php(31): Joomla\CMS\MVC\Controller\BaseController->execute('') #9 /home/customer/www/physicalsecurityskills.com/public_html/libraries/src/Component/ComponentHelper.php(402): require_once('/home/customer/...') #10 /home/customer/www/physicalsecurityskills.com/public_html/libraries/src/Component/ComponentHelper.php(377): Joomla\CMS\Component\ComponentHelper::executeComponent('/home/customer/...') #11 /home/customer/www/physicalsecurityskills.com/public_html/libraries/src/Application/SiteApplication.php(194): Joomla\CMS\Component\ComponentHelper::renderComponent('com_splms') #12 /home/customer/www/physicalsecurityskills.com/public_html/libraries/src/Application/SiteApplication.php(233): Joomla\CMS\Application\SiteApplication->dispatch() #13 /home/customer/www/physicalsecurityskills.com/public_html/libraries/src/Application/CMSApplication.php(196): Joomla\CMS\Application\SiteApplication->doExecute() #14 /home/customer/www/physicalsecurityskills.com/public_html/index.php(49): Joomla\CMS\Application\CMSApplication->execute() #15 {main}

Scherpereel Corine

More than a month ago #Permalink
same

Attachments (1)

  • bug03.png
    bug03.png 88.2 KB

Toufiq - Staff

More than a month ago #Permalink
Hi there,

Sorry for the inconvenience. Please follow the process.

1. Install a fresh Joomla on your localhost & install the LMS latest version on this site (localhost)
2. And watch this video
https://drive.google.com/file/d/1o6pbSc1cpjOIB4xe-unKDvoE_OFn9dpf/view

-Thanks

Alan Davies

More than a month ago #Permalink
So, I need to start again and rebuild the website?
Not much of an upgrade, and If I had known that in June I could have started much earlier.
Did't get much from the video apart from see what's mssing.:(

Very disappointing.

BenL

More than a month ago #Permalink
Yes its very disappointing, this update broke anything, db and views for pages for lms. Im start compere fresh lms installation with update, i notice that not only db has been not updated, but also files,
Now lms is installing under components not under template (educon for me), i notice that events page, course page looks different on fresh installation comparing to updated one.

Now on updated page i have new files for sp lms under component and old one under educon template, i dont know with one are ok.

For courses page i dont see related courses and i have old look, new look is also broken, some page formatting missing. There is so meny bugs and differences there, i think its not possible to fix it using any update only fresh installation...its not should works in this way...

They promise update and fix that, now we are waiting one week, for it, i think we dont get is asap. Shame, they have chance to build nice module like lms, now when most person use page during covid time.

They still dont fully update educon demo page to compare how its looks, or for them its looks partially.

gourou

More than a month ago #Permalink
yeah still waiting for educon quickstart package update but it must too difficult for the joomshaper team to do it
perhaps next year ...o: each time new release new problems

BenL

More than a month ago #Permalink
Im new here, i will remember this advice, thanks.

Toufiq - Staff

4 weeks ago #Permalink
So, I need to start again and rebuild the website?
Not much of an upgrade, and If I had known that in June I could have started much earlier.
Did't get much from the video apart from see what's mssing.:(

Very disappointing.


Hi there, I didn't tell you to make your site again. Please watch the video carefully. Thanks
Hi,
I've watched the PHPmyAdmin video again, very interesting, but my memory isn't that good.
I think I'll delete the website and start afresh.

Alan

BenL

2 weeks ago #Permalink
Hello support, there is about 3 weeks afters last release of sp lms, when we can expect new version?

Toufiq - Staff

2 weeks ago #Permalink
Hello support, there is about 3 weeks afters last release of sp lms, when we can expect new version?


Hi BenL, Thanks for your reply. We need more time. Thanks


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

126

Templates

333379

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