No courses showing on admin page

[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.

[alfa24]

What kind of course did you create? Is it a classroom one?

[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.

[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.

[gianniteixeira]

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.

[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.

[gianniteixeira]

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]

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

NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

Thanks for all your help.

[alfa24]

You're welcome.