Database Error message

[bryan_muteti]

Hello Everyone,

Am I have an issue with my installation. I am getting this error when I visit the OJS URL"DB Error: Table ‘mrjourna_ojs488.sessions’ doesn’t exist". How do I rectify this?

Thanks

[israel.cefrin]

Hi @bryan_muteti

It looks like a similar issue on this thread

DB Error:... Doesn't exist Help

Hi @thatHman, Something seems to have deleted the sessions table in your database. I’m not sure what could have caused this. I would suggest restoring that table from backup. Depending on the cause of the issue, you may have other problems with your database too. Regards, Alec Smecher Public Knowledge Project Team

And this one too

Ojs2 Database error

Hi, the problem is really weird, because i put the ojs folder in the folder that gonna be shows in the web server and the show me the blank page, but when i try to “fix it” putting in the config.inic.php the information about the mysql server, i dont know whats happened and they show that error… If someone can give me a step by step file where that shows me whats its exactly what i need to post in this file… I really appreciate. Or some help for repair…

I think might be a server issue, but read @asmecher sugestion.

Best
Israel

[bryan_muteti]

I tried to upgrade and this is what I got am thinking of reinstalling it again. Is that a good option. Would running an older version be an issue?

[israel.cefrin]

Hi @bryan_muteti

Did you try upgrade from a 2.x to 3.x version?
Did you run “$ php tools/upgrade.php upgrade” ?

Running a non updated version is not advisable, cause there are security and functionality fixes on each release.

Israel

[bryan_muteti]

I will install afresh version 3.x its different from the previous any help on rebranding it or editing it?

[israel.cefrin]

As @ctgraham said in this thread

Upgrade from 2.4.8 to 3.0

Hello, I maintain 2.4.8 to OJS 3.0. Is it mandatory to upgrade firstly to 2.4.8.1 and then to 3.0? Thanks

You can upgrade to 3.0 from any of the 2.4.x releases. But an upgrade from OJS 2.0.x, 2.1.x, 2.2.x, or 2.3.x may requires a different approach.
If you are in some of these versions the best choice is upgrade first to a 2.4.x version and then to 3.x.

[bryan_muteti]

Thank you @israel.cefrin

[rindoherdianto]

I have the message like this " DB Error: Disk full (/tmp/#sql_7a3f_0.MAI); waiting for someone to free some space… (errno: 28 “No space left on device”)" what it suppose mean, please help me. Our journal cannot be running
Thanks

[asmecher]

Hi @rindoherdianto,

This is a MySQL error message. You’ll need to free up some space on your server to resolve it.

Regards,
Alec Smecher
Public Knowledge Project Team

[rindoherdianto]

Dear Mr. Alec
How should i do to clean & free up some space in my server

Thanks

[asmecher]

Hi @rindoherdianto,

That’s a general system administration task, and not really to do with OJS – I’m afraid that’s beyond the scope of this forum.

Regards,
Alec Smecher
Public Knowledge Project Team

[rindoherdianto]

I’m so sorry because of noob language and noob IT. another question. How if I erase all of logs files in logs directory? is that could clear some space and web
works properly?

[rindoherdianto]

i type this, now the website cannot apear anymore
“find /var/cache -type f -size +2048 -mount -exec ls -lad {} ; |sort -rnb -k 5|more”

“yum clean all”

i type this, now the website cannot appear anymore…