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.

Problem - New notes...
 
Notifications
Clear all

Problem - New notes don't appear anymore

12 Posts
2 Users
0 Reactions
6,084 Views
Damien
(@dnaton)
Posts: 248
Active Member
Topic starter
 
[#3777]

Hello,

Since version 5.5.4, I've got a problem with new notes on a ticket : I can write it, save it, but the text doesn't appear 🙁

The notes has #0 as id and is empty

When I try to supress the notes, I can't and have this error message :

It is the same, logged with Member profile or Admin Profile.

Can anyone help me ?

Thanks.

Damien


Regards,
Damien
-----------------------------------------------
.
ProjeQtOr v12.1.0 - Apache v2.4.56 - MariaDB v10.4.28 - PHP v8.2.4
Plugins installed : PersonalizedTranslation 1.6 - ScreenCustomization 7.2

 
Posted : 24 Oct 2016 13H03
babynus
(@babynus)
Posts: 14957
Main Contributor Admin
 

Try and clean browser cache.
(not only with F5, user parameters of browser to be sure)


 
Posted : 24 Oct 2016 13H33
Damien
(@dnaton)
Posts: 248
Active Member
Topic starter
 

Hello Babynus,

I have already do that.

The problem occurs after clearing cache (using Firefox, Opera)

Damien


Regards,
Damien
-----------------------------------------------
.
ProjeQtOr v12.1.0 - Apache v2.4.56 - MariaDB v10.4.28 - PHP v8.2.4
Plugins installed : PersonalizedTranslation 1.6 - ScreenCustomization 7.2

 
Posted : 24 Oct 2016 13H36
babynus
(@babynus)
Posts: 14957
Main Contributor Admin
 

Do you have errors on log file or in browser console ?


 
Posted : 24 Oct 2016 13H41
Damien
(@dnaton)
Posts: 248
Active Member
Topic starter
 

In console message, I have "Note insérée"

and nothing in log file

And the problem is maybe more "serious" that only notes.

I can't create a project anymore....I've got this message

For this last message, I tried directly in my PC, withe xampp, or in my environnement on network, it is the same.

I have many problems 🙁


Regards,
Damien
-----------------------------------------------
.
ProjeQtOr v12.1.0 - Apache v2.4.56 - MariaDB v10.4.28 - PHP v8.2.4
Plugins installed : PersonalizedTranslation 1.6 - ScreenCustomization 7.2

 
Posted : 24 Oct 2016 13H48
babynus
(@babynus)
Posts: 14957
Main Contributor Admin
 

Did you change something in your configuration ? PHP Version ? MySql version ?

How di you migrate to V5.5.4 ? (can you describe step by step ?)


 
Posted : 24 Oct 2016 13H52
Damien
(@dnaton)
Posts: 248
Active Member
Topic starter
 

On my PC, nothing has changed. On network, I need to ask my administrator but I'm quite sure nothing has changed this month.

To upgrade from 5.5.3 to 5.5.4, I have do the same than precedent uprgrade (I hope it is th right process)

Download new version and dezipp in a folder on my pc
Close ProjeQtor in Administration panel
Download the new version using Filezilla

Reopen Projeqtor (connecting as Admin)


Regards,
Damien
-----------------------------------------------
.
ProjeQtOr v12.1.0 - Apache v2.4.56 - MariaDB v10.4.28 - PHP v8.2.4
Plugins installed : PersonalizedTranslation 1.6 - ScreenCustomization 7.2

 
Posted : 24 Oct 2016 14H02
babynus
(@babynus)
Posts: 14957
Main Contributor Admin
 

And 5.5.3 was working fine ?


 
Posted : 24 Oct 2016 14H24
Damien
(@dnaton)
Posts: 248
Active Member
Topic starter
 

Hello Babynus,

Here is results from somes tests I've made yesterday and this morning.

I've tested the upgrade from a clean environnement (Projeqtor in version 5.3.3 with a few data) to the version 5.5.4.

It's ok : I can creat a note, a project, without error warning or problem.

But when I import in this "clean environnement" a dump from my "production Database" (which is in 5.5.4 too), I found again my problem :

1) I can't create a project or an activity, I've got this message

2) I can create a new note but it's appear with an #0 id and no text , and can't be erase, with this error message :

3) I can create a ticket

It's a "weird" behavion 🙁 and I don't understand what's happened : is my production database corrupted ? How can see that and fix that ?

It's really problematic today : I can't use my "production environnement" anymore : there ar to many errors :-(.

Another questions :
* what's happend if I restore on a 5.5.3 (or before) environnement a database from a 5.5.4 environnement : is it possible ?
* what's happend if I restore on a 5.5.4 environnement a database from a 5.5.3 environnement (or before): is it possible ?

Thanks for your help, I'm in a very difficult situation today 🙁

regards,
Damien


Regards,
Damien
-----------------------------------------------
.
ProjeQtOr v12.1.0 - Apache v2.4.56 - MariaDB v10.4.28 - PHP v8.2.4
Plugins installed : PersonalizedTranslation 1.6 - ScreenCustomization 7.2

 
Posted : 25 Oct 2016 16H35
babynus
(@babynus)
Posts: 14957
Main Contributor Admin
 

Very weird.

I can propose you to send us an anonymised dump of your database.
I'll send you a plugin that can do that.

About migration back and reverse :
if you restore a database with version code version, you may face some issue on fields that haver been renamed or changed. New ones will not cause issue. So you won't have problem of on just change patch level on same release from V5.5.x to V5.5.y. Note that then you'll get issues when you upgrade to latest version, as database changes have already been aplied, but you can do with it.


 
Posted : 25 Oct 2016 16H43
Damien
(@dnaton)
Posts: 248
Active Member
Topic starter
 

Thanks for your quickly answer.

What is an "anonymised dump of your database" ? How can I do that ?

No problem for me to send you if necessary a full version of my database.

By mail ?


Regards,
Damien
-----------------------------------------------
.
ProjeQtOr v12.1.0 - Apache v2.4.56 - MariaDB v10.4.28 - PHP v8.2.4
Plugins installed : PersonalizedTranslation 1.6 - ScreenCustomization 7.2

 
Posted : 25 Oct 2016 16H48
babynus
(@babynus)
Posts: 14957
Main Contributor Admin
 

After analysis of database, it seems Primary Key and AUTO_INCREMENT have disapeared on most (if not all) tables.
After fixing this, all seems correct.


 
Posted : 25 Nov 2016 17H07
Share:

Scroll to Top