Forum

5 errors encountere...
 
Notifications
Retirer tout

5 errors encountered during upgrade to 5.3.3

8 Posts
2 Utilisateurs
0 Reactions
7,598 Vu
(@briandlees)
Posts: 28
Active Member
Début du sujet
 
[#3460]

I have completely rebuilt my site and installed 5.3.3 from scratch. I have 5 errors encountered during the database upgrade to 5.3.3. They are all of the same format so I have only reproduced the logfile entries for the first error below. I am using OpenSuse LEAP 42.1, Apache2, Postgresql, PHP5.5.14. Any ideas please?

2016-06-11 21:48:38.158 ** ERROR ** Exception-[22P02] SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type numeric: ""
LINE 1: select * from parameter where idUser ='' and idProject is n...
^
2016-06-11 21:48:38.158 ** ERROR ** For query : select * from parameter where idUser ='' and idProject is null and parameterCode='editor'
2016-06-11 21:48:38.158 ** ERROR ** Strack trace :
2016-06-11 21:48:38.158 ** ERROR ** #0 Sql->query called at [/data/nfs/www/projeqtor/model/persistence/SqlElement.php:1740]
2016-06-11 21:48:38.158 ** ERROR ** #1 SqlElement->getSqlElementsFromCriteria called at [/data/nfs/www/projeqtor/model/Parameter.php:687]
2016-06-11 21:48:38.158 ** ERROR ** #2 Parameter->getUserParameter called at [/data/nfs/www/projeqtor/tool/projeqtor.php:2726]
2016-06-11 21:48:38.158 ** ERROR ** #3 getEditorType called at [/data/nfs/www/projeqtor/model/persistence/SqlElement.php:799]
2016-06-11 21:48:38.158 ** ERROR ** #4 SqlElement->insertSqlElement called at [/data/nfs/www/projeqtor/model/persistence/SqlElement.php:627]
2016-06-11 21:48:38.158 ** ERROR ** #5 SqlElement->saveSqlElement called at [/data/nfs/www/projeqtor/model/persistence/SqlElement.php:475]
2016-06-11 21:48:38.158 ** ERROR ** #6 SqlElement->save called at [/data/nfs/www/projeqtor/model/History.php:101]
2016-06-11 21:48:38.158 ** ERROR ** #7 History->store called at [/data/nfs/www/projeqtor/model/persistence/SqlElement.php:1001]
2016-06-11 21:48:38.159 ** ERROR ** #8 SqlElement->updateSqlElement called at [/data/nfs/www/projeqtor/model/persistence/SqlElement.php:621]
2016-06-11 21:48:38.159 ** ERROR ** #9 SqlElement->saveSqlElement called at [/data/nfs/www/projeqtor/model/persistence/SqlElement.php:475]
2016-06-11 21:48:38.159 ** ERROR ** #10 SqlElement->save called at [/data/nfs/www/projeqtor/model/UserMain.php:836]
2016-06-11 21:48:38.159 ** ERROR ** #11 UserMain->save called at [/data/nfs/www/projeqtor/db/maintenance.php:339]
2016-06-11 21:48:38.159 ** ERROR ** #12 include called at [/data/nfs/www/projeqtor/tool/loginCheck.php:52]
2016-06-11 21:48:38.166 ** ERROR ** Exception-[22P02] SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type numeric: ""


 
Posté : 12 Juin AM 01:066
(@babynus)
Posts: 14952
Membre Admin
 

I guess these errors are reported before db update starts.
If it is the case, don't care about them.


 
Posté : 12 Juin PM 13:066
(@briandlees)
Posts: 28
Active Member
Début du sujet
 

Thanks for the reply but I'm not sure whether they are before or after. I have attached the relevant portion of the log.


 
Posté : 12 Juin PM 14:066
(@babynus)
Posts: 14952
Membre Admin
 

Hi,

You faced specific PostgreSql issues.
We will work on this.
Recorded as Ticket #2131


 
Posté : 12 Juin PM 14:066
(@briandlees)
Posts: 28
Active Member
Début du sujet
 

Do you know whether there has been any progress please?


 
Posté : 28 Juin PM 22:066
(@babynus)
Posts: 14952
Membre Admin
 

This issue is fixed since V5.3.5.


 
Posté : 29 Juin AM 01:066
(@briandlees)
Posts: 28
Active Member
Début du sujet
 

Thanks. So do I simply install 5.3.5 on top of the failed 5.3.3 or do I need to start from scratch?


 
Posté : 29 Juin AM 02:066
(@babynus)
Posts: 14952
Membre Admin
 

Install 5.3.5 should be enough


 
Posté : 30 Juin AM 00:066
Share:
Retour en haut