General sql error

Razuna v2 Legacy Self-Hosted
1

Oops, something really strange happened here.
Please copy the error message below and send it to your administrator
who will help resolve the problem. Thank you.
Error:

General SQL Error

2

Please mention your razuna version and type of database and include the error message so we can debug it. The error logs can be found under Administration>Logs>Errors
Best
Harkirat

3

1.6.5
i can’t get into admin area

here is link to catalina.log
http://gsdc.ca/serge/catalina.txt

4

That is not the correct log to look at. If you have access to the backend the logs can be found at tomcat/webapps/razuna/WEB-INF/bluedragon/work/temp/rtelogs
Please mention the database and also include the URL of your DAM.
BestHarkirat

5

http://gsdc.ca/serge/bderror-latest.html

see the error. not sure why it can’t connect all of a sudden?

6

We can’t help you much with this. Look into your database and that it can handle the connections properly. In my experience you should tune your MySQL setup from time to time as more files are being added to Razuna.

7

is there a way i can point to another database?

8

Razuna supports H2, MySQL and MS SQL.

9

What i meant was. How can i point to another database?

10

I don’t understand what you mean with “point to another database”. You don’t want to use MySQL anymore? As mentioned, we support H2 or MS SQL instead. How to migrate is described here http://wiki.razuna.com/pages/viewpage.action?pageId=13238290

11

Ok i optimized my tables and now i can get the login screen but i get this error now.
application.razuna.show_recent_updates doesn’t exist.

12

Restart the server, clear your browser cache and remove cookies. Then it will work.