Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

cannot record ticke...
 
Notifications
Clear all

cannot record tickets

9 Posts
2 Users
0 Reactions
7,654 Views
(@durou-c)
Posts: 468
Contributor
Topic starter
 
[#4790]

I have just a new problem to, I can't record a new ticket, Projector answer error contact your admin, show in log files...

what's wrong ?


 
Posted : 20 Nov 2017 19H24
(@babynus)
Posts: 14952
Member Admin
 

It seems you "manually" deleted tickets in the database.

I should write it in golden letters : never manually update database !!!
We build a framework to manage data, let it do the work.


 
Posted : 21 Nov 2017 12H05
(@durou-c)
Posts: 468
Contributor
Topic starter
 

I don't understand, I do not delete ticket manually in data base ? I just do a verification and optimized with PHPMYADMIN but no delete


 
Posted : 21 Nov 2017 12H14
(@babynus)
Posts: 14952
Member Admin
 

What do you call "I just do a verification and optimized"
What did you do ?


 
Posted : 21 Nov 2017 13H44
(@durou-c)
Posts: 468
Contributor
Topic starter
 

On PHPMYADMIN, you have fonction to select table and to "optimized" and "verify" table.


 
Posted : 21 Nov 2017 13H49
(@babynus)
Posts: 14952
Member Admin
 

I don't know what this process executes...
Can you provide and anonymlized dump of your database for analysis ?
(please use attached plugin)


 
Posted : 21 Nov 2017 13H58
(@durou-c)
Posts: 468
Contributor
Topic starter
 

extract 3Mo, I send you by email.


 
Posted : 21 Nov 2017 14H10
(@babynus)
Posts: 14952
Member Admin
 

You have 173 lines in table ticket with id up to 207, and you have 247 lines in table workelement referencing id of ticket up to 301.
Moreover, not corresponding items have some real work !
So sure you have a real mess in your database, and this was not done through application because :
- framework ensures concistency between table ticket and workelement
- application will never let you delete items with real work

I think the best for you is to retreive a backup and restore your database.


 
Posted : 21 Nov 2017 19H09
(@durou-c)
Posts: 468
Contributor
Topic starter
 

I am affraid because I have not backup of my database... how is it possible to repair it ?


 
Posted : 21 Nov 2017 19H17
Share:

Scroll to Top