No courses showing on admin page

Backend functionalities: user management, course management, reports, certificates, etc.
Post Reply
gianniteixeira
Newbie
Posts: 5
Joined: Wed May 26, 2021 4:21 pm

No courses showing on admin page

Post by gianniteixeira »

Hello all,
I just freshly installed forma LMS and when i create a course it doesn't show in the course table. I will send a screen shot so that you guys can have a look. Does anyone know what could be the problem? It just says no records found.

Thanks in advance.
Attachments
noRecordsFound.jpg

alfa24
Senior Boarder
Posts: 1296
Joined: Fri Nov 24, 2017 8:45 am
Version: forma.lms 1.4.2

Re: No courses showing on admin page

Post by alfa24 »

What kind of course did you create? Is it a classroom one?
I'm Jasmines, the One. If you need, you can contact me.

gianniteixeira
Newbie
Posts: 5
Joined: Wed May 26, 2021 4:21 pm

Re: No courses showing on admin page

Post by gianniteixeira »

I created a e-learning one. The courses will show up in the main page but on the admin area to manage courses they don't show up, the table is empty. So if i want to edit them I can't.

Same problem with the category. When i create one, the system accepts it and then once i refresh the page it do not show anymore. I'm wondering if its something related with the data base or anything like that.
Attachments
1.png
1.png (6.07 KiB) Viewed 234 times
2.png
3.png

alfa24
Senior Boarder
Posts: 1296
Joined: Fri Nov 24, 2017 8:45 am
Version: forma.lms 1.4.2

Re: No courses showing on admin page

Post by alfa24 »

I should be on your instance to help.
But first, you could provide some info about your server, such as PHP and mysql version.
Also Apache error.log could offer some hints.
I'm Jasmines, the One. If you need, you can contact me.

gianniteixeira
Newbie
Posts: 5
Joined: Wed May 26, 2021 4:21 pm

Re: No courses showing on admin page

Post by gianniteixeira »

alfa24 wrote:
Wed Aug 18, 2021 2:48 pm
I should be on your instance to help.
But first, you could provide some info about your server, such as PHP and mysql version.
Also Apache error.log could offer some hints.
Thank you, I will send you an attachment.
Last edited by gianniteixeira on Wed Aug 18, 2021 3:47 pm, edited 1 time in total.

alfa24
Senior Boarder
Posts: 1296
Joined: Fri Nov 24, 2017 8:45 am
Version: forma.lms 1.4.2

Re: No courses showing on admin page

Post by alfa24 »

What about Apache error.log?
I'd try to debug mysql for that safe mode and SQL mode, but server root privileges are needed.
You may find topics in the forums regarding sql_mode directive.
I'm Jasmines, the One. If you need, you can contact me.

gianniteixeira
Newbie
Posts: 5
Joined: Wed May 26, 2021 4:21 pm

Re: No courses showing on admin page

Post by gianniteixeira »

alfa24 wrote:
Wed Aug 18, 2021 3:21 pm
What about Apache error.log?
I'd try to debug mysql for that safe mode and SQL mode, but server root privileges are needed.
You may find topics in the forums regarding sql_mode directive.
I had a look at the Apache logs and i can't see anything out of the ordinary. There were a few errors but don't think anything related to this problem that i'm experiencing. Will try and have a look at that SQL mode. Thank you.

gianniteixeira
Newbie
Posts: 5
Joined: Wed May 26, 2021 4:21 pm

Re: No courses showing on admin page

Post by gianniteixeira »

Problem solved the SQL mode was wrong. It should be:

NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

Thanks for all your help.

alfa24
Senior Boarder
Posts: 1296
Joined: Fri Nov 24, 2017 8:45 am
Version: forma.lms 1.4.2

Re: No courses showing on admin page

Post by alfa24 »

You're welcome.
I'm Jasmines, the One. If you need, you can contact me.

Post Reply