Database error 1146 - Table doesn't exist

Post Reply
marietjie_short
Posts: 14
Joined: 31 Oct 2016, 11:09
Name: Marietjie Short
Location: South Africa, Johannesburg
Company Name: Watermark Auditors
Contact:

Database error 1146 - Table doesn't exist

Post 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!
User avatar
support
Site Admin
Posts: 6215
Joined: 19 Oct 2014, 18:22
Name: Sergey Kharchishin
Location: Russia, Evpatoriya

Re: Database error 1146 - Table doesn't exist

Post by support »

Hi

which version of product to you use?

where do you see this error? on which page? can you provide screenshot, please?
marietjie_short
Posts: 14
Joined: 31 Oct 2016, 11:09
Name: Marietjie Short
Location: South Africa, Johannesburg
Company Name: Watermark Auditors
Contact:

Re: Database error 1146 - Table doesn't exist

Post 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 451 times

I even tried creating a new entity named projects - but it is still the same error
User avatar
support
Site Admin
Posts: 6215
Joined: 19 Oct 2014, 18:22
Name: Sergey Kharchishin
Location: Russia, Evpatoriya

Re: Database error 1146 - Table doesn't exist

Post 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?
marietjie_short
Posts: 14
Joined: 31 Oct 2016, 11:09
Name: Marietjie Short
Location: South Africa, Johannesburg
Company Name: Watermark Auditors
Contact:

Re: Database error 1146 - Table doesn't exist

Post 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'
User avatar
support
Site Admin
Posts: 6215
Joined: 19 Oct 2014, 18:22
Name: Sergey Kharchishin
Location: Russia, Evpatoriya

Re: Database error 1146 - Table doesn't exist

Post 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...
Post Reply