Error during settings - "Configurar propiedades de aplicaciones" / "Application properties settings"

Oriol Cantarell Sala

Hi community,

 

I've a doubt with a problem that I have when I was configuring my jira server instance.

 

I saw the jira logs and I've shown that it gives an mysql syntax error, but in fact when searching the table that specific DAO (like you can see in exception it firs tries GenericDAO and GenericHelperDAO) was trying to find data, the table hasn't be created on the db.

In fact database exists and has lots of tables (I think the majority) but not the projects table.

 

So waiting for your response (like if you give my the code for create projects table or another solution).

if you want logs ask me

Sorry If I attach something that I can't or I've done something bad

 

sorry for all what i tried without modifying nothing was to see what it occurs

 

can you help me? sorry for say some knowledge

Nic Brough -Adaptavist-

If a table is missing from your Jira database, then there's something fundamentally wrong with the setup of the database or connection to it, and you have a Jira that is probably too damaged to work properly.  Creating a new table is not going to help, you've already lost too much data.

In fact, I wouldn't be looking at the database though.  It might be that the database is damaged, but errors related to reading it could be caused by a lot of other things.

You have offered to provide the logs - that is exactly what we need here.  Can you paste in the error message you are seeing, along with a chunk of the lines preceeding it in the log and anything that might be related just after?