Page 1 of 1

Database error 1146 - Table doesn't exist

Posted: 31 Oct 2016, 11:16
by marietjie_short
I need to start creating the enities for my client's website - however every time I want to load a new project I get the following error:

Database Error: 1146 - Table 'watermar_ruko.app_entity_' doesn't exist
Query: select e.* from app_entity_ e where e.id>0 order by e.id
Page: /auditmanagement/index.php?module=items/form&path=21


When I look in the database, there are several 'app_entity_' tables. 1, and 21-30. Is there an error with the database, or with the query?

I want to buy the extension today, but am hesitant until I can fix this problem. I do not want to start messing around in the database if there is an easier solution.

Can you please advise urgently!

Re: Database error 1146 - Table doesn't exist

Posted: 31 Oct 2016, 12:31
by support
Hi

which version of product to you use?

where do you see this error? on which page? can you provide screenshot, please?

Re: Database error 1146 - Table doesn't exist

Posted: 31 Oct 2016, 12:48
by marietjie_short
Hi there,

I am using 1.7.2

It is on the actual project page:
db error.docx
(202.21 KiB) Downloaded 489 times

I even tried creating a new entity named projects - but it is still the same error

Re: Database error 1146 - Table doesn't exist

Posted: 31 Oct 2016, 12:54
by support
1. so this error happens when you add new project, right?
2. this is new installation?
3. can you add new user for example?
4. did you delete any entities before?
5. does project Entity have fields with type Entity?

Re: Database error 1146 - Table doesn't exist

Posted: 31 Oct 2016, 13:01
by marietjie_short
* Yes it is a new installation
* I can add new users
* I couldn't check the other entities yet, since they are all "inside" the projects
* Yes it is when I want to add a project
* No there is no field named 'entity'

Re: Database error 1146 - Table doesn't exist

Posted: 31 Oct 2016, 13:14
by support
since this is new installation can you give me admin access in private message and I will check

in general this is not standard situation and I think this is just some code not 100% loaded or something else like this...