View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - db inconsitent between versions because of errors in sql - ProjeQtOr
 
 

db inconsitent between versions because of errors in sql

More
09 Dec 2017 10:30 - 09 Dec 2017 10:56 #1 by diri
db inconsitent between versions because of errors in sql was created by diri
Hi,

while upgrading an installation (installed in Dec 2016, constant automatic updates to recent version) update encounters 25 significant errors. I performed updates with distributed sql files starting with v4.0 by hand. Those files follow syntax of mysql.

Those sql files are full of errors. Especially wrong comment markers ('==text', '=== text') are found very often which aren't detected by maintenance scripts. Related sql statements fail for this.

I recommend to introduce a check for proper db structure ASAP to help keeping updated installations up to date and to ensure new installations are really working.

edit:
2017-04-18 05:07:00.822 ===== TRACE ===== =====================================
2017-04-18 05:07:00.822 ===== TRACE =====
2017-04-18 05:07:00.822 ===== TRACE ===== DataBase actual Version = V6.1.3
2017-04-18 05:07:00.822 ===== TRACE ===== ProjeQtOr actual Version = V6.2.0
2017-04-18 05:07:00.822 ===== TRACE =====
2017-04-18 05:07:00.822 ===== TRACE ===== =====================================
2017-04-18 05:07:00.822 ===== TRACE =====
2017-04-18 05:07:00.822 ===== TRACE ===== VERSION V6.2.0
2017-04-18 05:07:00.822 ===== TRACE =====
...
2017-04-18 05:07:01.452 ===== TRACE ===== Table "${prefix}budgetelement" altered.
2017-04-18 05:07:01.452 ===== TRACE =====
2017-04-18 05:07:01.452 ===== TRACE ===== DATABASE UPDATED
2017-04-18 05:07:01.452 ===== TRACE ===== WITH NO ERROR
2017-04-18 05:07:01.452 ===== TRACE =====
2017-04-18 05:07:01.579 ===== TRACE ===== =====================================
2017-04-18 05:07:01.579 ===== TRACE =====
2017-04-18 05:07:01.579 ===== TRACE ===== DATABASE UPDATE COMPLETED TO VERSION V6.2.0
2017-04-18 05:07:01.579 ===== TRACE =====
2017-04-18 05:07:01.579 ===== TRACE ===== =====================================
2017-04-18 05:07:01.579 ===== TRACE =====
2017-04-18 05:07:06.415 ===== TRACE ===== NEW CONNECTED USER 'xyz'
2017-04-18 05:07:14.930 ===== TRACE ===== Cron started at 18/04/2017 05:07:14
2017-04-18 05:27:40.086 ***** ERROR ***** [V6.2.0] ERROR *****
2017-04-18 05:27:40.086 ***** ERROR ***** [V6.2.0] on file '/tool/html.php' at line (389)
2017-04-18 05:27:40.086 ***** ERROR ***** [V6.2.0] cause = get_class() called without object from outside a class
2017-04-18 05:30:10.834 ***** ERROR ***** [V6.2.0] ERROR *****
2017-04-18 05:30:10.834 ***** ERROR ***** [V6.2.0] on file '/tool/html.php' at line (389)
2017-04-18 05:30:10.834 ***** ERROR ***** [V6.2.0] cause = get_class() called without object from outside a class
2017-04-18 05:30:41.021 ***** ERROR ***** [V6.2.0] Exception-[42000] SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'nameChecklistable = 'Activity'' at line 1
2017-04-18 05:30:41.021 ***** ERROR ***** [V6.2.0] For query : select * from ${prefix}joblistdefinition where (${prefix}activity.idProject not in (0) or ${prefix}activity.idProject is null ) and (${prefix}activity.idProject not in (0) or ${prefix}activity.idProject is null or (${prefix}activity.idResource='1') ) and (${prefix}activity.idProject not in (0) or ${prefix}activity.idProject is null or (${prefix}activity.idUser='1') ) and idProject in (0, 1)nameChecklistable = 'Activity'
2017-04-18 05:30:41.021 ***** ERROR ***** [V6.2.0] Strack trace :
2017-04-18 05:30:41.021 ***** ERROR ***** [V6.2.0] #0 Sql->query called at [/model/persistence/SqlElement.php:1943]
2017-04-18 05:30:41.021 ***** ERROR ***** [V6.2.0] #1 SqlElement->getSqlElementsFromCriteria called at [/report/joblist.php:80]
2017-04-18 05:34:18.229 ===== TRACE ===== DISCONNECTED USER 'xyz'

updating 6.2.5 to 6.3.0
first line
***** ERROR ***** [V6.2.5] Error on SqlElement to get 'idLanguage' for Class 'User' : field 'idLanguage' not found in Database.
/edit

Current log:
2017-12-08 05:38:42.991 ***** ERROR ***** [V6.4.4] Error on SqlElement to get 'idLanguage' for Class 'User' : field 'idLanguage' not found in Database.
2017-12-08 05:38:43.125 ***** ERROR ***** [V6.4.4] Error on SqlElement to get 'idLanguage' for Class 'User' : field 'idLanguage' not found in Database.
2017-12-08 05:38:43.135 ===== TRACE =====
2017-12-08 05:38:43.135 ===== TRACE ===== =====================================
2017-12-08 05:38:43.135 ===== TRACE =====
2017-12-08 05:38:43.135 ===== TRACE ===== DataBase actual Version = V6.4.4
2017-12-08 05:38:43.135 ===== TRACE ===== ProjeQtOr actual Version = V6.5.0
2017-12-08 05:38:43.135 ===== TRACE =====
2017-12-08 05:38:43.136 ===== TRACE ===== =====================================
2017-12-08 05:38:43.136 ===== TRACE =====
2017-12-08 05:38:43.136 ===== TRACE ===== VERSION V6.5.0
2017-12-08 05:38:43.136 ===== TRACE =====
2017-12-08 05:38:43.146 ===== TRACE ===== 1 lines inserted into table "${prefix}checklistable".
2017-12-08 05:38:43.203 ===== TRACE ===== Table "${prefix}ticket" altered.
2017-12-08 05:38:43.238 ===== TRACE ===== Table "${prefix}delay" altered.
2017-12-08 05:38:43.254 ===== TRACE ===== 1 lines inserted into table "${prefix}reportparameter".
2017-12-08 05:38:43.269 ===== TRACE ===== 1 lines inserted into table "${prefix}report".
2017-12-08 05:38:43.282 ===== TRACE ===== 1 lines inserted into table "${prefix}habilitationreport".
2017-12-08 05:38:43.283 ===== TRACE ===== 7 lines inserted into table "${prefix}reportparameter".
2017-12-08 05:38:43.287 ===== TRACE ===== 2 lines inserted into table "${prefix}report".
2017-12-08 05:38:43.290 ===== TRACE ===== 4 lines inserted into table "${prefix}habilitationreport".
2017-12-08 05:38:43.291 ===== TRACE ===== 4 lines inserted into table "${prefix}habilitationreport".
2017-12-08 05:38:43.292 ===== TRACE ===== 3 lines inserted into table "${prefix}reportparameter".
2017-12-08 05:38:43.294 ===== TRACE ===== 3 lines inserted into table "${prefix}reportparameter".
2017-12-08 05:38:43.336 ===== TRACE ===== Table "${prefix}billline" altered.
2017-12-08 05:38:43.359 ===== TRACE ===== Table "${prefix}ticket" altered.
2017-12-08 05:38:43.361 ===== TRACE ===== 1 lines inserted into table "${prefix}report".
2017-12-08 05:38:43.362 ===== TRACE ===== 4 lines inserted into table "${prefix}habilitationreport".
2017-12-08 05:38:43.363 ===== TRACE ===== 2 lines inserted into table "${prefix}reportparameter".
2017-12-08 05:38:43.399 ===== TRACE ===== Table "${prefix}statusmail" altered.
2017-12-08 05:38:43.412 ===== TRACE ===== 2 lines inserted into table "${prefix}today".
2017-12-08 05:38:43.457 ===== TRACE ===== Table "${prefix}indicatordefinition" altered.
2017-12-08 05:38:43.472 ===== TRACE ===== Table "${prefix}statusmail" altered.
2017-12-08 05:38:43.483 ===== TRACE ===== 3 lines inserted into table "${prefix}menu".
2017-12-08 05:38:43.493 ===== TRACE ===== 24 lines inserted into table "${prefix}habilitation".
2017-12-08 05:38:43.538 ===== TRACE ===== Table "${prefix}testcase" altered.
2017-12-08 05:38:43.560 ===== TRACE ===== Table "${prefix}testcase" altered.
2017-12-08 05:38:43.577 ===== TRACE ===== Table "${prefix}statusmail" altered.
2017-12-08 05:38:43.591 ===== TRACE ===== Table "${prefix}delay" altered.
2017-12-08 05:38:43.612 ===== TRACE ===== Table "${prefix}indicatordefinition" altered.
2017-12-08 05:38:43.614 ===== TRACE ===== 1 lines inserted into table "${prefix}parameter".
2017-12-08 05:38:43.642 ===== TRACE ===== Table "${prefix}projecthistory" altered.
2017-12-08 05:38:43.666 ===== TRACE ===== Table "${prefix}projecthistory" altered.
2017-12-08 05:38:43.668 ===== TRACE ===== 1 lines updated into table "${prefix}report".
2017-12-08 05:38:43.669 ===== TRACE ===== 1 lines updated into table "${prefix}report".
2017-12-08 05:38:43.670 ===== TRACE ===== 1 lines updated into table "${prefix}reportparameter".
2017-12-08 05:38:43.690 ===== TRACE ===== Table "${prefix}indicatordefinition" altered.
2017-12-08 05:38:43.709 ===== TRACE ===== Table "${prefix}indicatordefinition" altered.
2017-12-08 05:38:43.710 ***** ERROR ***** [V6.4.4] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'a.${prefix}delivery' doesn't exist
2017-12-08 05:38:43.710 ***** ERROR ***** [V6.4.4] For query : ALTER TABLE `${prefix}delivery` ADD COLUMN `idProductVersion` INT(12) UNSIGNED DEFAULT NULL;
2017-12-08 05:38:43.710 ***** ERROR ***** [V6.4.4] Strack trace :
2017-12-08 05:38:43.710 ***** ERROR ***** [V6.4.4] #0 Sql->query called at [/db/maintenanceFunctions.php:71]
2017-12-08 05:38:43.710 ***** ERROR ***** [V6.4.4] #1 runScript called at [/db/maintenance.php:108]
2017-12-08 05:38:43.710 ***** ERROR ***** [V6.4.4] #2 include called at [/tool/loginCheck.php:135]
2017-12-08 05:38:43.711 ===== TRACE =====
2017-12-08 05:38:43.711 ===== TRACE ===== Error # 1 => SQL error while executing maintenance query for version V6.5.0 (see above message)
2017-12-08 05:38:43.711 ===== TRACE =====
2017-12-08 05:38:43.711 ===== TRACE ===== *************************************************
2017-12-08 05:38:43.711 ===== TRACE =====
2017-12-08 05:38:43.712 ***** ERROR ***** [V6.4.4] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'a.${prefix}delivery' doesn't exist
2017-12-08 05:38:43.712 ***** ERROR ***** [V6.4.4] For query : ALTER TABLE `${prefix}delivery` ADD COLUMN `idStatus` INT(12) UNSIGNED DEFAULT NULL;
2017-12-08 05:38:43.712 ***** ERROR ***** [V6.4.4] Strack trace :
2017-12-08 05:38:43.712 ***** ERROR ***** [V6.4.4] #0 Sql->query called at [/db/maintenanceFunctions.php:71]
2017-12-08 05:38:43.712 ***** ERROR ***** [V6.4.4] #1 runScript called at [/db/maintenance.php:108]
2017-12-08 05:38:43.712 ***** ERROR ***** [V6.4.4] #2 include called at [/tool/loginCheck.php:135]
2017-12-08 05:38:43.712 ===== TRACE =====
2017-12-08 05:38:43.712 ===== TRACE ===== Error # 2 => SQL error while executing maintenance query for version V6.5.0 (see above message)
2017-12-08 05:38:43.712 ===== TRACE =====
2017-12-08 05:38:43.712 ===== TRACE ===== *************************************************
2017-12-08 05:38:43.712 ===== TRACE =====
2017-12-08 05:38:43.713 ***** ERROR ***** [V6.4.4] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'a.${prefix}delivery' doesn't exist
2017-12-08 05:38:43.713 ***** ERROR ***** [V6.4.4] For query : ALTER TABLE `${prefix}delivery` ADD COLUMN `handled` INT(1) UNSIGNED DEFAULT '0';
2017-12-08 05:38:43.713 ***** ERROR ***** [V6.4.4] Strack trace :
2017-12-08 05:38:43.713 ***** ERROR ***** [V6.4.4] #0 Sql->query called at [/db/maintenanceFunctions.php:71]
2017-12-08 05:38:43.713 ***** ERROR ***** [V6.4.4] #1 runScript called at [/db/maintenance.php:108]
2017-12-08 05:38:43.713 ***** ERROR ***** [V6.4.4] #2 include called at [/tool/loginCheck.php:135]
2017-12-08 05:38:43.713 ===== TRACE =====
2017-12-08 05:38:43.713 ===== TRACE ===== Error # 3 => SQL error while executing maintenance query for version V6.5.0 (see above message)
2017-12-08 05:38:43.713 ===== TRACE =====
2017-12-08 05:38:43.713 ===== TRACE ===== *************************************************
2017-12-08 05:38:43.713 ===== TRACE =====
2017-12-08 05:38:43.714 ***** ERROR ***** [V6.4.4] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'a.${prefix}delivery' doesn't exist
2017-12-08 05:38:43.714 ***** ERROR ***** [V6.4.4] For query : ALTER TABLE `${prefix}delivery` ADD COLUMN `handledDateTime` DATETIME DEFAULT NULL;
2017-12-08 05:38:43.714 ***** ERROR ***** [V6.4.4] Strack trace :
2017-12-08 05:38:43.714 ***** ERROR ***** [V6.4.4] #0 Sql->query called at [/db/maintenanceFunctions.php:71]
2017-12-08 05:38:43.714 ***** ERROR ***** [V6.4.4] #1 runScript called at [/db/maintenance.php:108]
2017-12-08 05:38:43.714 ***** ERROR ***** [V6.4.4] #2 include called at [/tool/loginCheck.php:135]
2017-12-08 05:38:43.714 ===== TRACE =====
2017-12-08 05:38:43.714 ===== TRACE ===== Error # 4 => SQL error while executing maintenance query for version V6.5.0 (see above message)
2017-12-08 05:38:43.714 ===== TRACE =====
2017-12-08 05:38:43.714 ===== TRACE ===== *************************************************
2017-12-08 05:38:43.714 ===== TRACE =====
2017-12-08 05:38:43.715 ***** ERROR ***** [V6.4.4] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'a.${prefix}delivery' doesn't exist
2017-12-08 05:38:43.715 ***** ERROR ***** [V6.4.4] For query : ALTER TABLE `${prefix}delivery` ADD COLUMN `done` INT(1) UNSIGNED DEFAULT '0';
2017-12-08 05:38:43.715 ***** ERROR ***** [V6.4.4] Strack trace :
2017-12-08 05:38:43.715 ***** ERROR ***** [V6.4.4] #0 Sql->query called at [/db/maintenanceFunctions.php:71]
2017-12-08 05:38:43.715 ***** ERROR ***** [V6.4.4] #1 runScript called at [/db/maintenance.php:108]
2017-12-08 05:38:43.715 ***** ERROR ***** [V6.4.4] #2 include called at [/tool/loginCheck.php:135]
2017-12-08 05:38:43.715 ===== TRACE =====
2017-12-08 05:38:43.715 ===== TRACE ===== Error # 5 => SQL error while executing maintenance query for version V6.5.0 (see above message)
2017-12-08 05:38:43.715 ===== TRACE =====
2017-12-08 05:38:43.715 ===== TRACE ===== *************************************************
2017-12-08 05:38:43.715 ===== TRACE =====
2017-12-08 05:38:43.716 ***** ERROR ***** [V6.4.4] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'a.${prefix}delivery' doesn't exist
2017-12-08 05:38:43.716 ***** ERROR ***** [V6.4.4] For query : ALTER TABLE `${prefix}delivery` ADD COLUMN `doneDateTime` DATETIME DEFAULT NULL;
2017-12-08 05:38:43.716 ***** ERROR ***** [V6.4.4] Strack trace :
2017-12-08 05:38:43.716 ***** ERROR ***** [V6.4.4] #0 Sql->query called at [/db/maintenanceFunctions.php:71]
2017-12-08 05:38:43.716 ***** ERROR ***** [V6.4.4] #1 runScript called at [/db/maintenance.php:108]
2017-12-08 05:38:43.716 ***** ERROR ***** [V6.4.4] #2 include called at [/tool/loginCheck.php:135]
2017-12-08 05:38:43.716 ===== TRACE =====
2017-12-08 05:38:43.716 ===== TRACE ===== Error # 6 => SQL error while executing maintenance query for version V6.5.0 (see above message)
2017-12-08 05:38:43.716 ===== TRACE =====
2017-12-08 05:38:43.716 ===== TRACE ===== *************************************************
2017-12-08 05:38:43.716 ===== TRACE =====
2017-12-08 05:38:43.717 ***** ERROR ***** [V6.4.4] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'a.${prefix}delivery' doesn't exist
2017-12-08 05:38:43.717 ***** ERROR ***** [V6.4.4] For query : ALTER TABLE `${prefix}delivery` ADD COLUMN `idleDateTime` DATETIME DEFAULT NULL;
2017-12-08 05:38:43.717 ***** ERROR ***** [V6.4.4] Strack trace :
2017-12-08 05:38:43.717 ***** ERROR ***** [V6.4.4] #0 Sql->query called at [/db/maintenanceFunctions.php:71]
2017-12-08 05:38:43.717 ***** ERROR ***** [V6.4.4] #1 runScript called at [/db/maintenance.php:108]
2017-12-08 05:38:43.717 ***** ERROR ***** [V6.4.4] #2 include called at [/tool/loginCheck.php:135]
2017-12-08 05:38:43.717 ===== TRACE =====
2017-12-08 05:38:43.717 ===== TRACE ===== Error # 7 => SQL error while executing maintenance query for version V6.5.0 (see above message)
2017-12-08 05:38:43.717 ===== TRACE =====
2017-12-08 05:38:43.717 ===== TRACE ===== *************************************************
2017-12-08 05:38:43.717 ===== TRACE =====
2017-12-08 05:38:43.718 ***** ERROR ***** [V6.4.4] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'a.${prefix}delivery' doesn't exist
2017-12-08 05:38:43.718 ***** ERROR ***** [V6.4.4] For query : ALTER TABLE `${prefix}delivery` ADD COLUMN `cancelled` INT(1) UNSIGNED DEFAULT '0';
2017-12-08 05:38:43.718 ***** ERROR ***** [V6.4.4] Strack trace :
2017-12-08 05:38:43.718 ***** ERROR ***** [V6.4.4] #0 Sql->query called at [/db/maintenanceFunctions.php:71]
2017-12-08 05:38:43.718 ***** ERROR ***** [V6.4.4] #1 runScript called at [/db/maintenance.php:108]
2017-12-08 05:38:43.718 ***** ERROR ***** [V6.4.4] #2 include called at [/tool/loginCheck.php:135]
2017-12-08 05:38:43.718 ===== TRACE =====
2017-12-08 05:38:43.718 ===== TRACE ===== Error # 8 => SQL error while executing maintenance query for version V6.5.0 (see above message)
2017-12-08 05:38:43.718 ===== TRACE =====
2017-12-08 05:38:43.718 ===== TRACE ===== *************************************************
2017-12-08 05:38:43.718 ===== TRACE =====
2017-12-08 05:38:43.719 ***** ERROR ***** [V6.4.4] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'a.${prefix}delivery' doesn't exist
2017-12-08 05:38:43.719 ***** ERROR ***** [V6.4.4] For query : ALTER TABLE `${prefix}delivery` CHANGE `idDeliverableType` `idDeliveryType` INT(12) UNSIGNED DEFAULT NULL;
2017-12-08 05:38:43.719 ***** ERROR ***** [V6.4.4] Strack trace :
2017-12-08 05:38:43.719 ***** ERROR ***** [V6.4.4] #0 Sql->query called at [/db/maintenanceFunctions.php:71]
2017-12-08 05:38:43.719 ***** ERROR ***** [V6.4.4] #1 runScript called at [/db/maintenance.php:108]
2017-12-08 05:38:43.719 ***** ERROR ***** [V6.4.4] #2 include called at [/tool/loginCheck.php:135]
2017-12-08 05:38:43.719 ===== TRACE =====
2017-12-08 05:38:43.719 ===== TRACE ===== Error # 9 => SQL error while executing maintenance query for version V6.5.0 (see above message)
2017-12-08 05:38:43.719 ===== TRACE =====
2017-12-08 05:38:43.719 ===== TRACE ===== *************************************************
2017-12-08 05:38:43.719 ===== TRACE =====
2017-12-08 05:38:43.720 ===== TRACE ===== 1 lines inserted into table "${prefix}menu".
2017-12-08 05:38:43.722 ===== TRACE ===== 1 lines inserted into table "${prefix}habilitation".
2017-12-08 05:38:43.744 ===== TRACE ===== Table "${prefix}ticket" altered.
2017-12-08 05:38:43.745 ===== TRACE ===== 0 lines updated into table "${prefix}ticket".
2017-12-08 05:38:43.760 ===== TRACE ===== Table "${prefix}statusmail" altered.
2017-12-08 05:38:43.773 ===== TRACE ===== Table "${prefix}indicatordefinition" altered.
2017-12-08 05:38:43.790 ===== TRACE ===== Table "${prefix}indicatordefinition" altered.
2017-12-08 05:38:43.833 ===== TRACE ===== Table "${prefix}requirement" altered.
2017-12-08 05:38:43.850 ===== TRACE ===== Index "requirementPriority" created.
2017-12-08 05:38:43.851 ===== TRACE ===== 1 lines inserted into table "${prefix}report".
2017-12-08 05:38:43.852 ===== TRACE ===== 1 lines inserted into table "${prefix}habilitationreport".
2017-12-08 05:38:43.853 ===== TRACE ===== 5 lines inserted into table "${prefix}reportparameter".
2017-12-08 05:38:43.854 ===== TRACE ===== 1 lines inserted into table "${prefix}report".
2017-12-08 05:38:43.856 ===== TRACE ===== 1 lines inserted into table "${prefix}habilitationreport".
2017-12-08 05:38:43.858 ===== TRACE ===== 4 lines inserted into table "${prefix}reportparameter".
2017-12-08 05:38:43.859 ===== TRACE ===== 1 lines inserted into table "${prefix}report".
2017-12-08 05:38:43.860 ===== TRACE ===== 1 lines inserted into table "${prefix}habilitationreport".
2017-12-08 05:38:43.861 ===== TRACE ===== 5 lines inserted into table "${prefix}reportparameter".
2017-12-08 05:38:43.862 ===== TRACE ===== 1 lines inserted into table "${prefix}report".
2017-12-08 05:38:43.864 ===== TRACE ===== 1 lines inserted into table "${prefix}habilitationreport".
2017-12-08 05:38:43.865 ===== TRACE ===== 5 lines inserted into table "${prefix}reportparameter".
2017-12-08 05:38:43.886 ===== TRACE ===== Table "${prefix}testcase" altered.
2017-12-08 05:38:43.916 ===== TRACE ===== Table "${prefix}testsession" altered.
2017-12-08 05:38:43.924 ===== TRACE ===== Table "${prefix}versionlanguage" created.
2017-12-08 05:38:43.924 ***** ERROR ***** [V6.4.4] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'a.${prefix}productlanguage' doesn't exist
2017-12-08 05:38:43.924 ***** ERROR ***** [V6.4.4] For query : ALTER TABLE `${prefix}productlanguage` ADD `scope` varchar(100) DEFAULT NULL;
2017-12-08 05:38:43.924 ***** ERROR ***** [V6.4.4] Strack trace :
2017-12-08 05:38:43.924 ***** ERROR ***** [V6.4.4] #0 Sql->query called at [/db/maintenanceFunctions.php:71]
2017-12-08 05:38:43.924 ***** ERROR ***** [V6.4.4] #1 runScript called at [/db/maintenance.php:108]
2017-12-08 05:38:43.925 ***** ERROR ***** [V6.4.4] #2 include called at [/tool/loginCheck.php:135]
2017-12-08 05:38:43.925 ===== TRACE =====
2017-12-08 05:38:43.925 ===== TRACE ===== Error # 10 => SQL error while executing maintenance query for version V6.5.0 (see above message)
2017-12-08 05:38:43.925 ===== TRACE =====
2017-12-08 05:38:43.925 ===== TRACE ===== *************************************************
2017-12-08 05:38:43.925 ===== TRACE =====
2017-12-08 05:38:43.932 ===== TRACE ===== Table "${prefix}versioncontext" created.
2017-12-08 05:38:43.933 ***** ERROR ***** [V6.4.4] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'a.${prefix}productcontext' doesn't exist
2017-12-08 05:38:43.933 ***** ERROR ***** [V6.4.4] For query : ALTER TABLE `${prefix}productcontext` ADD `scope` varchar(100) DEFAULT NULL;
2017-12-08 05:38:43.933 ***** ERROR ***** [V6.4.4] Strack trace :
2017-12-08 05:38:43.933 ***** ERROR ***** [V6.4.4] #0 Sql->query called at [/db/maintenanceFunctions.php:71]
2017-12-08 05:38:43.933 ***** ERROR ***** [V6.4.4] #1 runScript called at [/db/maintenance.php:108]
2017-12-08 05:38:43.933 ***** ERROR ***** [V6.4.4] #2 include called at [/tool/loginCheck.php:135]
2017-12-08 05:38:43.933 ===== TRACE =====
2017-12-08 05:38:43.933 ===== TRACE ===== Error # 11 => SQL error while executing maintenance query for version V6.5.0 (see above message)
2017-12-08 05:38:43.933 ===== TRACE =====
2017-12-08 05:38:43.933 ===== TRACE ===== *************************************************
2017-12-08 05:38:43.933 ===== TRACE =====
2017-12-08 05:38:43.933 ***** ERROR ***** [V6.4.4] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'a.${prefix}productlanguage' doesn't exist
2017-12-08 05:38:43.933 ***** ERROR ***** [V6.4.4] For query : UPDATE `${prefix}productlanguage` SET `scope`='ProductVersion'
WHERE NOT exists (select 'x' from `${prefix}product` p where p.id=`${prefix}productlanguage`.idProduct);
2017-12-08 05:38:43.933 ***** ERROR ***** [V6.4.4] Strack trace :
2017-12-08 05:38:43.934 ***** ERROR ***** [V6.4.4] #0 Sql->query called at [/db/maintenanceFunctions.php:71]
2017-12-08 05:38:43.934 ***** ERROR ***** [V6.4.4] #1 runScript called at [/db/maintenance.php:108]
2017-12-08 05:38:43.934 ***** ERROR ***** [V6.4.4] #2 include called at [/tool/loginCheck.php:135]
2017-12-08 05:38:43.934 ===== TRACE =====
2017-12-08 05:38:43.934 ===== TRACE ===== Error # 12 => SQL error while executing maintenance query for version V6.5.0 (see above message)
2017-12-08 05:38:43.934 ===== TRACE =====
2017-12-08 05:38:43.934 ===== TRACE ===== *************************************************
2017-12-08 05:38:43.934 ===== TRACE =====
2017-12-08 05:38:43.935 ***** ERROR ***** [V6.4.4] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'a.${prefix}productlanguage' doesn't exist
2017-12-08 05:38:43.935 ***** ERROR ***** [V6.4.4] For query : UPDATE `${prefix}productlanguage` SET `scope`='Product'
WHERE NOT exists (select 'x' from `${prefix}version` v where v.id=`${prefix}productlanguage`.idProduct);
2017-12-08 05:38:43.935 ***** ERROR ***** [V6.4.4] Strack trace :
2017-12-08 05:38:43.935 ***** ERROR ***** [V6.4.4] #0 Sql->query called at [/db/maintenanceFunctions.php:71]
2017-12-08 05:38:43.935 ***** ERROR ***** [V6.4.4] #1 runScript called at [/db/maintenance.php:108]
2017-12-08 05:38:43.935 ***** ERROR ***** [V6.4.4] #2 include called at [/tool/loginCheck.php:135]
2017-12-08 05:38:43.935 ===== TRACE =====
2017-12-08 05:38:43.935 ===== TRACE ===== Error # 13 => SQL error while executing maintenance query for version V6.5.0 (see above message)
2017-12-08 05:38:43.935 ===== TRACE =====
2017-12-08 05:38:43.935 ===== TRACE ===== *************************************************
2017-12-08 05:38:43.935 ===== TRACE =====
2017-12-08 05:38:43.946 ===== TRACE ===== 0 lines deleted from table "${prefix}tempupdate".
2017-12-08 05:38:43.952 ***** ERROR ***** [V6.4.4] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'a.${prefix}productlanguage' doesn't exist
2017-12-08 05:38:43.953 ***** ERROR ***** [V6.4.4] For query : INSERT INTO `${prefix}tempupdate` (id, idOther)
select v.id, pl.idLanguage
from `${prefix}version` v, `${prefix}product` p, `${prefix}productlanguage` pl
where v.idProduct=p.id and p.id=pl.idProduct and pl.scope!='ProductVersion';
2017-12-08 05:38:43.953 ***** ERROR ***** [V6.4.4] Strack trace :
2017-12-08 05:38:43.953 ***** ERROR ***** [V6.4.4] #0 Sql->query called at [/db/maintenanceFunctions.php:71]
2017-12-08 05:38:43.953 ***** ERROR ***** [V6.4.4] #1 runScript called at [/db/maintenance.php:108]
2017-12-08 05:38:43.953 ***** ERROR ***** [V6.4.4] #2 include called at [/tool/loginCheck.php:135]
2017-12-08 05:38:43.953 ===== TRACE =====
2017-12-08 05:38:43.953 ===== TRACE ===== Error # 14 => SQL error while executing maintenance query for version V6.5.0 (see above message)
2017-12-08 05:38:43.953 ===== TRACE =====
2017-12-08 05:38:43.953 ===== TRACE ===== *************************************************
2017-12-08 05:38:43.953 ===== TRACE =====
2017-12-08 05:38:43.953 ***** ERROR ***** [V6.4.4] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'a.${prefix}productlanguage' doesn't exist
2017-12-08 05:38:43.953 ***** ERROR ***** [V6.4.4] For query : UPDATE `${prefix}productlanguage` SET `scope`='Product'
where `scope` is null and idProduct not in (select id FROM `${prefix}tempupdate` tmp where tmp.idOther=`${prefix}productlanguage`.idLanguage );
2017-12-08 05:38:43.953 ***** ERROR ***** [V6.4.4] Strack trace :
2017-12-08 05:38:43.953 ***** ERROR ***** [V6.4.4] #0 Sql->query called at [/db/maintenanceFunctions.php:71]
2017-12-08 05:38:43.953 ***** ERROR ***** [V6.4.4] #1 runScript called at [/db/maintenance.php:108]
2017-12-08 05:38:43.953 ***** ERROR ***** [V6.4.4] #2 include called at [/tool/loginCheck.php:135]
2017-12-08 05:38:43.954 ===== TRACE =====
2017-12-08 05:38:43.954 ===== TRACE ===== Error # 15 => SQL error while executing maintenance query for version V6.5.0 (see above message)
2017-12-08 05:38:43.954 ===== TRACE =====
2017-12-08 05:38:43.954 ===== TRACE ===== *************************************************
2017-12-08 05:38:43.954 ===== TRACE =====
2017-12-08 05:38:43.954 ===== TRACE ===== 0 lines deleted from table "${prefix}tempupdate".
2017-12-08 05:38:43.955 ***** ERROR ***** [V6.4.4] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'a.${prefix}productlanguage' doesn't exist
2017-12-08 05:38:43.955 ***** ERROR ***** [V6.4.4] For query : INSERT INTO `${prefix}versionlanguage` (`idVersion`, `scope`, `idLanguage`, `creationDate`, `idUser`, `idle`)
select `idProduct`, `scope`, `idLanguage`, `creationDate`, `idUser`, `idle`
from `${prefix}productlanguage`
where `scope`='ProductVersion';
2017-12-08 05:38:43.955 ***** ERROR ***** [V6.4.4] Strack trace :
2017-12-08 05:38:43.955 ***** ERROR ***** [V6.4.4] #0 Sql->query called at [/db/maintenanceFunctions.php:71]
2017-12-08 05:38:43.955 ***** ERROR ***** [V6.4.4] #1 runScript called at [/db/maintenance.php:108]
2017-12-08 05:38:43.955 ***** ERROR ***** [V6.4.4] #2 include called at [/tool/loginCheck.php:135]
2017-12-08 05:38:43.955 ===== TRACE =====
2017-12-08 05:38:43.955 ===== TRACE ===== Error # 16 => SQL error while executing maintenance query for version V6.5.0 (see above message)
2017-12-08 05:38:43.955 ===== TRACE =====
2017-12-08 05:38:43.955 ===== TRACE ===== *************************************************
2017-12-08 05:38:43.955 ===== TRACE =====
2017-12-08 05:38:43.955 ***** ERROR ***** [V6.4.4] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'a.${prefix}productlanguage' doesn't exist
2017-12-08 05:38:43.955 ***** ERROR ***** [V6.4.4] For query : DELETE FROM `${prefix}productlanguage` where `scope`='ProductVersion';
2017-12-08 05:38:43.955 ***** ERROR ***** [V6.4.4] Strack trace :
2017-12-08 05:38:43.955 ***** ERROR ***** [V6.4.4] #0 Sql->query called at [/db/maintenanceFunctions.php:71]
2017-12-08 05:38:43.955 ***** ERROR ***** [V6.4.4] #1 runScript called at [/db/maintenance.php:108]
2017-12-08 05:38:43.956 ***** ERROR ***** [V6.4.4] #2 include called at [/tool/loginCheck.php:135]
2017-12-08 05:38:43.956 ===== TRACE =====
2017-12-08 05:38:43.956 ===== TRACE ===== Error # 17 => SQL error while executing maintenance query for version V6.5.0 (see above message)
2017-12-08 05:38:43.956 ===== TRACE =====
2017-12-08 05:38:43.956 ===== TRACE ===== *************************************************
2017-12-08 05:38:43.956 ===== TRACE =====
2017-12-08 05:38:43.956 ***** ERROR ***** [V6.4.4] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'a.${prefix}productlanguage' doesn't exist
2017-12-08 05:38:43.956 ***** ERROR ***** [V6.4.4] For query : UPDATE `${prefix}productlanguage` SET `scope`=(select `scope` from `${prefix}product` p where p.id=`${prefix}productlanguage`.idProduct) where `scope`='Product';
2017-12-08 05:38:43.956 ***** ERROR ***** [V6.4.4] Strack trace :
2017-12-08 05:38:43.956 ***** ERROR ***** [V6.4.4] #0 Sql->query called at [/db/maintenanceFunctions.php:71]
2017-12-08 05:38:43.956 ***** ERROR ***** [V6.4.4] #1 runScript called at [/db/maintenance.php:108]
2017-12-08 05:38:43.956 ***** ERROR ***** [V6.4.4] #2 include called at [/tool/loginCheck.php:135]
2017-12-08 05:38:43.957 ===== TRACE =====
2017-12-08 05:38:43.957 ===== TRACE ===== Error # 18 => SQL error while executing maintenance query for version V6.5.0 (see above message)
2017-12-08 05:38:43.957 ===== TRACE =====
2017-12-08 05:38:43.957 ===== TRACE ===== *************************************************
2017-12-08 05:38:43.957 ===== TRACE =====
2017-12-08 05:38:43.958 ===== TRACE ===== 0 lines updated into table "${prefix}versionlanguage".
2017-12-08 05:38:43.958 ***** ERROR ***** [V6.4.4] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'a.${prefix}productcontext' doesn't exist
2017-12-08 05:38:43.958 ***** ERROR ***** [V6.4.4] For query : UPDATE `${prefix}productcontext` SET `scope`='ProductVersion'
WHERE NOT exists (select 'x' from `${prefix}product` p where p.id=`${prefix}productcontext`.idProduct);
2017-12-08 05:38:43.958 ***** ERROR ***** [V6.4.4] Strack trace :
2017-12-08 05:38:43.958 ***** ERROR ***** [V6.4.4] #0 Sql->query called at [/db/maintenanceFunctions.php:71]
2017-12-08 05:38:43.958 ***** ERROR ***** [V6.4.4] #1 runScript called at [/db/maintenance.php:108]
2017-12-08 05:38:43.958 ***** ERROR ***** [V6.4.4] #2 include called at [/tool/loginCheck.php:135]
2017-12-08 05:38:43.958 ===== TRACE =====
2017-12-08 05:38:43.958 ===== TRACE ===== Error # 19 => SQL error while executing maintenance query for version V6.5.0 (see above message)
2017-12-08 05:38:43.958 ===== TRACE =====
2017-12-08 05:38:43.958 ===== TRACE ===== *************************************************
2017-12-08 05:38:43.958 ===== TRACE =====
2017-12-08 05:38:43.959 ***** ERROR ***** [V6.4.4] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'a.${prefix}productcontext' doesn't exist
2017-12-08 05:38:43.959 ***** ERROR ***** [V6.4.4] For query : UPDATE `${prefix}productcontext` SET `scope`='Product'
WHERE NOT exists (select 'x' from `${prefix}version` v where v.id=`${prefix}productcontext`.idProduct);
2017-12-08 05:38:43.959 ***** ERROR ***** [V6.4.4] Strack trace :
2017-12-08 05:38:43.959 ***** ERROR ***** [V6.4.4] #0 Sql->query called at [/db/maintenanceFunctions.php:71]
2017-12-08 05:38:43.959 ***** ERROR ***** [V6.4.4] #1 runScript called at [/db/maintenance.php:108]
2017-12-08 05:38:43.959 ***** ERROR ***** [V6.4.4] #2 include called at [/tool/loginCheck.php:135]
2017-12-08 05:38:43.959 ===== TRACE =====
2017-12-08 05:38:43.959 ===== TRACE ===== Error # 20 => SQL error while executing maintenance query for version V6.5.0 (see above message)
2017-12-08 05:38:43.959 ===== TRACE =====
2017-12-08 05:38:43.959 ===== TRACE ===== *************************************************
2017-12-08 05:38:43.959 ===== TRACE =====
2017-12-08 05:38:43.960 ===== TRACE ===== 0 lines deleted from table "${prefix}tempupdate".
2017-12-08 05:38:43.960 ***** ERROR ***** [V6.4.4] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'a.${prefix}productcontext' doesn't exist
2017-12-08 05:38:43.960 ***** ERROR ***** [V6.4.4] For query : INSERT INTO `${prefix}tempupdate` (id, idOther)
select v.id, pl.idContext
from `${prefix}version` v, `${prefix}product` p, `${prefix}productcontext` pl
where v.idProduct=p.id and p.id=pl.idProduct and pl.scope!='ProductVersion';
2017-12-08 05:38:43.960 ***** ERROR ***** [V6.4.4] Strack trace :
2017-12-08 05:38:43.960 ***** ERROR ***** [V6.4.4] #0 Sql->query called at [/db/maintenanceFunctions.php:71]
2017-12-08 05:38:43.960 ***** ERROR ***** [V6.4.4] #1 runScript called at [/db/maintenance.php:108]
2017-12-08 05:38:43.960 ***** ERROR ***** [V6.4.4] #2 include called at [/tool/loginCheck.php:135]
2017-12-08 05:38:43.960 ===== TRACE =====
2017-12-08 05:38:43.960 ===== TRACE ===== Error # 21 => SQL error while executing maintenance query for version V6.5.0 (see above message)
2017-12-08 05:38:43.960 ===== TRACE =====
2017-12-08 05:38:43.960 ===== TRACE ===== *************************************************
2017-12-08 05:38:43.960 ===== TRACE =====
2017-12-08 05:38:43.961 ***** ERROR ***** [V6.4.4] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'a.${prefix}productcontext' doesn't exist
2017-12-08 05:38:43.961 ***** ERROR ***** [V6.4.4] For query : UPDATE `${prefix}productcontext` SET `scope`='Product'
where `scope` is null and idProduct not in (select id FROM `${prefix}tempupdate` tmp where tmp.idOther=`${prefix}productcontext`.idContext );
2017-12-08 05:38:43.961 ***** ERROR ***** [V6.4.4] Strack trace :
2017-12-08 05:38:43.961 ***** ERROR ***** [V6.4.4] #0 Sql->query called at [/db/maintenanceFunctions.php:71]
2017-12-08 05:38:43.961 ***** ERROR ***** [V6.4.4] #1 runScript called at [/db/maintenance.php:108]
2017-12-08 05:38:43.961 ***** ERROR ***** [V6.4.4] #2 include called at [/tool/loginCheck.php:135]
2017-12-08 05:38:43.961 ===== TRACE =====
2017-12-08 05:38:43.961 ===== TRACE ===== Error # 22 => SQL error while executing maintenance query for version V6.5.0 (see above message)
2017-12-08 05:38:43.961 ===== TRACE =====
2017-12-08 05:38:43.961 ===== TRACE ===== *************************************************
2017-12-08 05:38:43.961 ===== TRACE =====
2017-12-08 05:38:43.962 ===== TRACE ===== 0 lines deleted from table "${prefix}tempupdate".
2017-12-08 05:38:43.962 ***** ERROR ***** [V6.4.4] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'a.${prefix}productcontext' doesn't exist
2017-12-08 05:38:43.962 ***** ERROR ***** [V6.4.4] For query : INSERT INTO `${prefix}versioncontext` (`idVersion`, `scope`, `idContext`, `creationDate`, `idUser`, `idle`)
select `idProduct`, `scope`, `idContext`, `creationDate`, `idUser`, `idle`
from `${prefix}productcontext`
where `scope`='ProductVersion';
2017-12-08 05:38:43.962 ***** ERROR ***** [V6.4.4] Strack trace :
2017-12-08 05:38:43.962 ***** ERROR ***** [V6.4.4] #0 Sql->query called at [/db/maintenanceFunctions.php:71]
2017-12-08 05:38:43.962 ***** ERROR ***** [V6.4.4] #1 runScript called at [/db/maintenance.php:108]
2017-12-08 05:38:43.962 ***** ERROR ***** [V6.4.4] #2 include called at [/tool/loginCheck.php:135]
2017-12-08 05:38:43.962 ===== TRACE =====
2017-12-08 05:38:43.962 ===== TRACE ===== Error # 23 => SQL error while executing maintenance query for version V6.5.0 (see above message)
2017-12-08 05:38:43.962 ===== TRACE =====
2017-12-08 05:38:43.962 ===== TRACE ===== *************************************************
2017-12-08 05:38:43.962 ===== TRACE =====
2017-12-08 05:38:43.963 ***** ERROR ***** [V6.4.4] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'a.${prefix}productcontext' doesn't exist
2017-12-08 05:38:43.963 ***** ERROR ***** [V6.4.4] For query : DELETE FROM `${prefix}productcontext` where `scope`='ProductVersion';
2017-12-08 05:38:43.963 ***** ERROR ***** [V6.4.4] Strack trace :
2017-12-08 05:38:43.963 ***** ERROR ***** [V6.4.4] #0 Sql->query called at [/db/maintenanceFunctions.php:71]
2017-12-08 05:38:43.963 ***** ERROR ***** [V6.4.4] #1 runScript called at [/db/maintenance.php:108]
2017-12-08 05:38:43.963 ***** ERROR ***** [V6.4.4] #2 include called at [/tool/loginCheck.php:135]
2017-12-08 05:38:43.963 ===== TRACE =====
2017-12-08 05:38:43.963 ===== TRACE ===== Error # 24 => SQL error while executing maintenance query for version V6.5.0 (see above message)
2017-12-08 05:38:43.963 ===== TRACE =====
2017-12-08 05:38:43.963 ===== TRACE ===== *************************************************
2017-12-08 05:38:43.963 ===== TRACE =====
2017-12-08 05:38:43.964 ***** ERROR ***** [V6.4.4] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'a.${prefix}productcontext' doesn't exist
2017-12-08 05:38:43.964 ***** ERROR ***** [V6.4.4] For query : UPDATE `${prefix}productcontext` SET `scope`=(select `scope` from `${prefix}product` p where p.id=`${prefix}productcontext`.idProduct) where `scope`='Product';
2017-12-08 05:38:43.964 ***** ERROR ***** [V6.4.4] Strack trace :
2017-12-08 05:38:43.964 ***** ERROR ***** [V6.4.4] #0 Sql->query called at [/db/maintenanceFunctions.php:71]
2017-12-08 05:38:43.964 ***** ERROR ***** [V6.4.4] #1 runScript called at [/db/maintenance.php:108]
2017-12-08 05:38:43.964 ***** ERROR ***** [V6.4.4] #2 include called at [/tool/loginCheck.php:135]
2017-12-08 05:38:43.964 ===== TRACE =====
2017-12-08 05:38:43.964 ===== TRACE ===== Error # 25 => SQL error while executing maintenance query for version V6.5.0 (see above message)
2017-12-08 05:38:43.964 ===== TRACE =====
2017-12-08 05:38:43.964 ===== TRACE ===== *************************************************
2017-12-08 05:38:43.964 ===== TRACE =====
2017-12-08 05:38:43.965 ===== TRACE ===== 0 lines updated into table "${prefix}versioncontext".
2017-12-08 05:38:43.965 ===== TRACE =====
2017-12-08 05:38:43.965 ===== TRACE ===== DATABASE UPDATED
2017-12-08 05:38:43.965 ===== TRACE ===== WITH 25 ERRORS
2017-12-08 05:38:43.965 ===== TRACE =====
2017-12-08 05:38:43.990 ===== TRACE ===== Create delivery types from deliverable types
2017-12-08 05:38:44.119 ***** ERROR ***** [V6.4.4] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'a.${prefix}delivery' doesn't exist
2017-12-08 05:38:44.119 ***** ERROR ***** [V6.4.4] For query : desc ${prefix}delivery
2017-12-08 05:38:44.119 ***** ERROR ***** [V6.4.4] Strack trace :
2017-12-08 05:38:44.119 ***** ERROR ***** [V6.4.4] #0 Sql->query called at [/model/persistence/SqlElement.php:3254]
2017-12-08 05:38:44.119 ***** ERROR ***** [V6.4.4] #1 SqlElement->getFormatList called at [/model/persistence/SqlElement.php:2835]
2017-12-08 05:38:44.119 ***** ERROR ***** [V6.4.4] #2 SqlElement->getDataType called at [/model/persistence/SqlElement.php:2223]
2017-12-08 05:38:44.119 ***** ERROR ***** [V6.4.4] #3 SqlElement->getSqlElementsFromCriteria called at [/db/maintenance.php:613]
2017-12-08 05:38:44.119 ***** ERROR ***** [V6.4.4] #4 include called at [/tool/loginCheck.php:135]
2017-12-08 05:38:44.120 ***** ERROR ***** [V6.4.4] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'a.${prefix}delivery' doesn't exist
2017-12-08 05:38:44.120 ***** ERROR ***** [V6.4.4] For query : select * from ${prefix}delivery where ${prefix}delivery.idDeliveryType='125' and ${prefix}delivery.scope = 'Delivery'
2017-12-08 05:38:44.120 ***** ERROR ***** [V6.4.4] Strack trace :
2017-12-08 05:38:44.120 ***** ERROR ***** [V6.4.4] #0 Sql->query called at [/model/persistence/SqlElement.php:2260]
2017-12-08 05:38:44.120 ***** ERROR ***** [V6.4.4] #1 SqlElement->getSqlElementsFromCriteria called at [/db/maintenance.php:613]
2017-12-08 05:38:44.120 ***** ERROR ***** [V6.4.4] #2 include called at [/tool/loginCheck.php:135]
2017-12-08 05:38:44.127 ***** ERROR ***** [V6.4.4] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'a.${prefix}delivery' doesn't exist
2017-12-08 05:38:44.127 ***** ERROR ***** [V6.4.4] For query : select * from ${prefix}delivery where ${prefix}delivery.idDeliveryType='126' and ${prefix}delivery.scope = 'Delivery'
2017-12-08 05:38:44.127 ***** ERROR ***** [V6.4.4] Strack trace :
2017-12-08 05:38:44.127 ***** ERROR ***** [V6.4.4] #0 Sql->query called at [/model/persistence/SqlElement.php:2260]
2017-12-08 05:38:44.127 ***** ERROR ***** [V6.4.4] #1 SqlElement->getSqlElementsFromCriteria called at [/db/maintenance.php:613]
2017-12-08 05:38:44.127 ***** ERROR ***** [V6.4.4] #2 include called at [/tool/loginCheck.php:135]
2017-12-08 05:38:44.134 ***** ERROR ***** [V6.4.4] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'a.${prefix}delivery' doesn't exist
2017-12-08 05:38:44.134 ***** ERROR ***** [V6.4.4] For query : select * from ${prefix}delivery where ${prefix}delivery.idDeliveryType='127' and ${prefix}delivery.scope = 'Delivery'
2017-12-08 05:38:44.134 ***** ERROR ***** [V6.4.4] Strack trace :
2017-12-08 05:38:44.134 ***** ERROR ***** [V6.4.4] #0 Sql->query called at [/model/persistence/SqlElement.php:2260]
2017-12-08 05:38:44.134 ***** ERROR ***** [V6.4.4] #1 SqlElement->getSqlElementsFromCriteria called at [/db/maintenance.php:613]
2017-12-08 05:38:44.134 ***** ERROR ***** [V6.4.4] #2 include called at [/tool/loginCheck.php:135]
2017-12-08 05:38:44.135 ***** ERROR ***** [V6.4.4] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'a.${prefix}productlanguage' doesn't exist
2017-12-08 05:38:44.135 ***** ERROR ***** [V6.4.4] For query : select * from ${prefix}productlanguage where scope is null
2017-12-08 05:38:44.135 ***** ERROR ***** [V6.4.4] Strack trace :
2017-12-08 05:38:44.135 ***** ERROR ***** [V6.4.4] #0 Sql->query called at [/model/persistence/SqlElement.php:2260]
2017-12-08 05:38:44.135 ***** ERROR ***** [V6.4.4] #1 SqlElement->getSqlElementsFromCriteria called at [/db/maintenance.php:623]
2017-12-08 05:38:44.135 ***** ERROR ***** [V6.4.4] #2 include called at [/tool/loginCheck.php:135]
2017-12-08 05:38:44.135 ***** ERROR ***** [V6.4.4] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'a.${prefix}productcontext' doesn't exist
2017-12-08 05:38:44.135 ***** ERROR ***** [V6.4.4] For query : select * from ${prefix}productcontext where scope is null
2017-12-08 05:38:44.135 ***** ERROR ***** [V6.4.4] Strack trace :
2017-12-08 05:38:44.135 ***** ERROR ***** [V6.4.4] #0 Sql->query called at [/model/persistence/SqlElement.php:2260]
2017-12-08 05:38:44.135 ***** ERROR ***** [V6.4.4] #1 SqlElement->getSqlElementsFromCriteria called at [/db/maintenance.php:649]
2017-12-08 05:38:44.136 ***** ERROR ***** [V6.4.4] #2 include called at [/tool/loginCheck.php:135]
2017-12-08 05:38:44.323 ===== TRACE ===== =====================================
2017-12-08 05:38:44.323 ===== TRACE =====
2017-12-08 05:38:44.323 ===== TRACE ===== 25 ERRORS DURING UPDATE TO VERSION V6.5.0
2017-12-08 05:38:44.323 ===== TRACE =====
2017-12-08 05:38:44.323 ===== TRACE ===== =====================================
2017-12-08 05:38:44.323 ===== TRACE =====
2017-12-08 05:38:47.970 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idLanguage' for Class 'User' : field 'idLanguage' not found in Database.
2017-12-08 05:38:48.116 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idLanguage' for Class 'User' : field 'idLanguage' not found in Database.
2017-12-08 05:38:48.133 ===== TRACE ===== NEW CONNECTED USER 'xyz'
2017-12-08 05:38:55.515 ===== TRACE ===== Cron started at 08/12/2017 05:38:55
2017-12-08 05:43:45.930 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idLanguage' for Class 'User' : field 'idLanguage' not found in Database.
2017-12-08 05:43:45.931 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idLanguage' for Class 'User' : field 'idLanguage' not found in Database.
2017-12-08 05:43:45.933 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idLanguage' for Class 'User' : field 'idLanguage' not found in Database.
2017-12-08 05:43:45.934 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idLanguage' for Class 'User' : field 'idLanguage' not found in Database.
2017-12-08 05:43:45.936 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idLanguage' for Class 'User' : field 'idLanguage' not found in Database.
2017-12-08 05:43:45.938 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idLanguage' for Class 'User' : field 'idLanguage' not found in Database.
2017-12-08 05:43:45.940 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idLanguage' for Class 'User' : field 'idLanguage' not found in Database.
2017-12-08 05:43:45.956 ***** ERROR ***** [V6.5.0] Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'idle' in 'field list'
2017-12-08 05:43:45.956 ***** ERROR ***** [V6.5.0] For query : update ${prefix}note set idle='1' where refType='Audit' and refId=101
2017-12-08 05:43:45.956 ***** ERROR ***** [V6.5.0] Strack trace :
2017-12-08 05:43:45.956 ***** ERROR ***** [V6.5.0] #0 Sql->query called at [/model/persistence/SqlElement.php:1450]
2017-12-08 05:43:45.956 ***** ERROR ***** [V6.5.0] #1 SqlElement->updateSqlElement called at [/model/persistence/SqlElement.php:923]
2017-12-08 05:43:45.956 ***** ERROR ***** [V6.5.0] #2 SqlElement->saveSqlElement called at [/model/persistence/SqlElement.php:619]
2017-12-08 05:43:45.956 ***** ERROR ***** [V6.5.0] #3 SqlElement->save called at [/model/Audit.php:210]
2017-12-08 05:43:45.956 ***** ERROR ***** [V6.5.0] #4 Audit->finishSession called at [/tool/saveDataToSession.php:66]
2017-12-08 05:43:45.979 ===== TRACE ===== DISCONNECTED USER 'xyz'
2017-12-08 05:43:51.756 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idLanguage' for Class 'User' : field 'idLanguage' not found in Database.
2017-12-08 05:43:51.891 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idLanguage' for Class 'User' : field 'idLanguage' not found in Database.
2017-12-08 05:43:51.916 ===== TRACE ===== NEW CONNECTED USER 'xyz'
2017-12-08 06:10:35.941 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idLanguage' for Class 'User' : field 'idLanguage' not found in Database.
2017-12-08 06:10:35.943 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idLanguage' for Class 'User' : field 'idLanguage' not found in Database.
2017-12-08 06:10:35.944 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idLanguage' for Class 'User' : field 'idLanguage' not found in Database.
2017-12-08 06:10:35.946 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idLanguage' for Class 'User' : field 'idLanguage' not found in Database.
2017-12-08 06:10:35.948 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idLanguage' for Class 'User' : field 'idLanguage' not found in Database.
2017-12-08 06:10:35.949 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idLanguage' for Class 'User' : field 'idLanguage' not found in Database.
2017-12-08 06:10:35.951 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idLanguage' for Class 'User' : field 'idLanguage' not found in Database.
2017-12-08 06:10:35.963 ***** ERROR ***** [V6.5.0] Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'idle' in 'field list'
2017-12-08 06:10:35.963 ***** ERROR ***** [V6.5.0] For query : update ${prefix}note set idle='1' where refType='Audit' and refId=102
2017-12-08 06:10:35.963 ***** ERROR ***** [V6.5.0] Strack trace :
2017-12-08 06:10:35.963 ***** ERROR ***** [V6.5.0] #0 Sql->query called at [/model/persistence/SqlElement.php:1450]
2017-12-08 06:10:35.963 ***** ERROR ***** [V6.5.0] #1 SqlElement->updateSqlElement called at [/model/persistence/SqlElement.php:923]
2017-12-08 06:10:35.963 ***** ERROR ***** [V6.5.0] #2 SqlElement->saveSqlElement called at [/model/persistence/SqlElement.php:619]
2017-12-08 06:10:35.963 ***** ERROR ***** [V6.5.0] #3 SqlElement->save called at [/model/Audit.php:210]
2017-12-08 06:10:35.963 ***** ERROR ***** [V6.5.0] #4 Audit->finishSession called at [/tool/saveDataToSession.php:66]
2017-12-08 06:10:35.977 ===== TRACE ===== DISCONNECTED USER 'xyz'
2017-12-08 06:10:41.058 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idLanguage' for Class 'User' : field 'idLanguage' not found in Database.
2017-12-08 06:10:41.193 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idLanguage' for Class 'User' : field 'idLanguage' not found in Database.
2017-12-08 06:10:41.208 ===== TRACE ===== NEW CONNECTED USER 'xyz'
2017-12-08 06:10:45.248 ===== TRACE ===== Cron started at 08/12/2017 06:10:45
2017-12-08 06:14:03.823 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idLanguage' for Class 'User' : field 'idLanguage' not found in Database.
2017-12-08 06:14:03.824 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idLanguage' for Class 'User' : field 'idLanguage' not found in Database.
2017-12-08 06:14:03.825 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idLanguage' for Class 'User' : field 'idLanguage' not found in Database.
2017-12-08 06:14:03.826 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idLanguage' for Class 'User' : field 'idLanguage' not found in Database.
2017-12-08 06:14:03.827 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idLanguage' for Class 'User' : field 'idLanguage' not found in Database.
2017-12-08 06:14:03.828 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idLanguage' for Class 'User' : field 'idLanguage' not found in Database.
2017-12-08 06:14:03.829 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idLanguage' for Class 'User' : field 'idLanguage' not found in Database.
2017-12-08 06:14:03.838 ***** ERROR ***** [V6.5.0] Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'idle' in 'field list'
2017-12-08 06:14:03.838 ***** ERROR ***** [V6.5.0] For query : update ${prefix}note set idle='1' where refType='Audit' and refId=103
2017-12-08 06:14:03.838 ***** ERROR ***** [V6.5.0] Strack trace :
2017-12-08 06:14:03.838 ***** ERROR ***** [V6.5.0] #0 Sql->query called at [/model/persistence/SqlElement.php:1450]
2017-12-08 06:14:03.838 ***** ERROR ***** [V6.5.0] #1 SqlElement->updateSqlElement called at [/model/persistence/SqlElement.php:923]
2017-12-08 06:14:03.838 ***** ERROR ***** [V6.5.0] #2 SqlElement->saveSqlElement called at [/model/persistence/SqlElement.php:619]
2017-12-08 06:14:03.838 ***** ERROR ***** [V6.5.0] #3 SqlElement->save called at [/model/Audit.php:210]
2017-12-08 06:14:03.838 ***** ERROR ***** [V6.5.0] #4 Audit->finishSession called at [/tool/saveDataToSession.php:66]
2017-12-08 06:14:03.848 ===== TRACE ===== DISCONNECTED USER 'xyz'
2017-12-08 06:14:09.050 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idLanguage' for Class 'User' : field 'idLanguage' not found in Database.
2017-12-08 06:14:09.193 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idLanguage' for Class 'User' : field 'idLanguage' not found in Database.
2017-12-08 06:14:09.209 ===== TRACE ===== NEW CONNECTED USER 'xyz'
2017-12-08 06:14:44.299 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idLanguage' for Class 'User' : field 'idLanguage' not found in Database.
2017-12-08 06:14:44.300 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idLanguage' for Class 'User' : field 'idLanguage' not found in Database.
2017-12-08 06:14:44.301 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idLanguage' for Class 'User' : field 'idLanguage' not found in Database.
2017-12-08 06:14:44.302 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idLanguage' for Class 'User' : field 'idLanguage' not found in Database.
2017-12-08 06:14:44.303 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idLanguage' for Class 'User' : field 'idLanguage' not found in Database.
2017-12-08 06:14:44.304 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idLanguage' for Class 'User' : field 'idLanguage' not found in Database.
2017-12-08 06:14:44.305 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idLanguage' for Class 'User' : field 'idLanguage' not found in Database.
2017-12-08 06:14:44.312 ***** ERROR ***** [V6.5.0] Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'idle' in 'field list'
2017-12-08 06:14:44.312 ***** ERROR ***** [V6.5.0] For query : update ${prefix}note set idle='1' where refType='Audit' and refId=104
2017-12-08 06:14:44.312 ***** ERROR ***** [V6.5.0] Strack trace :
2017-12-08 06:14:44.312 ***** ERROR ***** [V6.5.0] #0 Sql->query called at [/model/persistence/SqlElement.php:1450]
2017-12-08 06:14:44.312 ***** ERROR ***** [V6.5.0] #1 SqlElement->updateSqlElement called at [/model/persistence/SqlElement.php:923]
2017-12-08 06:14:44.312 ***** ERROR ***** [V6.5.0] #2 SqlElement->saveSqlElement called at [/model/persistence/SqlElement.php:619]
2017-12-08 06:14:44.312 ***** ERROR ***** [V6.5.0] #3 SqlElement->save called at [/model/Audit.php:210]
2017-12-08 06:14:44.313 ***** ERROR ***** [V6.5.0] #4 Audit->finishSession called at [/tool/saveDataToSession.php:66]
2017-12-08 06:14:44.323 ===== TRACE ===== DISCONNECTED USER 'xyz'
2017-12-08 06:15:46.421 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idLanguage' for Class 'User' : field 'idLanguage' not found in Database.
2017-12-08 06:15:46.555 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idLanguage' for Class 'User' : field 'idLanguage' not found in Database.
2017-12-08 06:15:46.568 ===== TRACE ===== NEW CONNECTED USER 'xyz'
2017-12-08 06:43:13.224 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idLanguage' for Class 'User' : field 'idLanguage' not found in Database.
2017-12-08 06:43:13.225 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idLanguage' for Class 'User' : field 'idLanguage' not found in Database.
2017-12-08 06:43:13.226 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idLanguage' for Class 'User' : field 'idLanguage' not found in Database.
2017-12-08 06:43:13.227 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idLanguage' for Class 'User' : field 'idLanguage' not found in Database.
2017-12-08 06:43:13.228 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idLanguage' for Class 'User' : field 'idLanguage' not found in Database.
2017-12-08 06:43:13.229 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idLanguage' for Class 'User' : field 'idLanguage' not found in Database.
2017-12-08 06:43:13.230 ***** ERROR ***** [V6.5.0] Error on SqlElement to get 'idLanguage' for Class 'User' : field 'idLanguage' not found in Database.
2017-12-08 06:43:13.238 ***** ERROR ***** [V6.5.0] Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'idle' in 'field list'
2017-12-08 06:43:13.238 ***** ERROR ***** [V6.5.0] For query : update ${prefix}note set idle='1' where refType='Audit' and refId=105
2017-12-08 06:43:13.238 ***** ERROR ***** [V6.5.0] Strack trace :
2017-12-08 06:43:13.238 ***** ERROR ***** [V6.5.0] #0 Sql->query called at [/model/persistence/SqlElement.php:1450]
2017-12-08 06:43:13.238 ***** ERROR ***** [V6.5.0] #1 SqlElement->updateSqlElement called at [/model/persistence/SqlElement.php:923]
2017-12-08 06:43:13.238 ***** ERROR ***** [V6.5.0] #2 SqlElement->saveSqlElement called at [/model/persistence/SqlElement.php:619]
2017-12-08 06:43:13.238 ***** ERROR ***** [V6.5.0] #3 SqlElement->save called at [/model/Audit.php:210]
2017-12-08 06:43:13.238 ***** ERROR ***** [V6.5.0] #4 Audit->finishSession called at [/tool/saveDataToSession.php:66]
2017-12-08 06:43:13.250 ===== TRACE ===== DISCONNECTED USER 'xyz'

cu, diri
Last edit: 09 Dec 2017 10:56 by diri.
The topic has been locked.
More
09 Dec 2017 12:20 #2 by babynus
Replied by babynus on topic db inconsitent between versions because of errors in sql

installed in Dec 2016, constant automatic updates to recent version

I performed updates with distributed sql files starting with v4.0 by hand.

I don't understand.
Did you use "automaitc" migration or did you run scripts "by hand" ?

Those sql files are full of errors.

All scripts run like a charm, without any issue, through migration process.

Especially wrong comment markers ('==text', '=== text') are found very often

I don't find any.
All "==" have correct comment marker "--" at start of line.

Related sql statements fail for this

No they don't (if run through migration process)

I recommend to introduce a check for proper db structure

Our migration process, executing each script step by step, ensures that db structure is always the same, whatever version you come from and you go to.
So we don't feel any need for this.

ASAP

For us, asap will be 2040 or later. We won't actually concentrate on this, as we have more urgent things in the roadmap.
And if you need this sooner, maybe concider contribuing : either do it yourself and post your work, contact us to sponsor these devs (we'll then review priority of the feature)

to help keeping updated installations up to date and to ensure new installations are really working

Once again ,our migration process ensures this.

Table "${prefix}budgetelement" altered

That means you defined prefix for tables as ' ${prefix}' ?
I would have guessed MySql would reject this ...

Error on SqlElement to get 'idLanguage' for Class 'User' : field 'idLanguage' not found in Database.

Some errors on object User during migration process are "normal". You connect with new object structure but database is not latered yet.
These errors have no impact on migration process.

Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'a.${prefix}delivery' doesn't exist
2017-12-08 05:38:43.710 ***** ERROR ***** [V6.4.4] For query : ALTER TABLE `${prefix}delivery` ADD COLUMN `idProductVersion` INT(12) UNSIGNED DEFAULT NULL;

Ha, I was sure prefix starting with $ would lead to error....
But it does not seem to be the soure of issue. These is a 'a.' before ${prefix} and I cannot guess where it comes from... unless 'a' is the name of your database ? ! ?
Or maybe migration to V6.3.0 had errors you did not notice (log is not shown here)

My advice would be :
1) change this ugly prefix to someting more "conventioanl" ("text_" or nothing"). You'll have to rename all tables but will win on consistency.
2) compare your strcuture with brand new db installed correctly, from scratch.
We don't have automatic process for this, here is a hint : with phpMyAdmin, export both db into scripts (only strucutre, no data)
and compare script...
Babynus
Administrator of ProjeQtOr web site
The topic has been locked.
More
11 Dec 2017 05:17 - 11 Dec 2017 06:05 #3 by diri
Replied by diri on topic db inconsitent between versions because of errors in sql
What you call ugly is original code from delivered sql files:
INSERT INTO `${prefix}workflow` (id,name, description, idle, workflowUpdate) VALUES
(1,'Default','Default workflow with just logic constraints.
Anyone can change status.',0,'[ ]'),
(2,'Simple','Simple workflow with limited status.
Anyone can change status.',0,'[ ]'),
(3,'External validation','Elaborated workflow with internal team treatment and external validation.',0,'[ ]'),
(4,'External acceptation & validation','Elaborated workflow with external acceptation, internal team treatment and external validation.',0,'[ ]');

What I posted here is invalidated to keep private data private.

Related to comments ...
Try to run following sql in mysql (replace ${prefix} with real prefix):

--ADD BY TABARY Marc - 2017-06-06 - USE OR NOT ORGANIZATION BUDGETELEMENT
INSERT INTO `${prefix}parameter` (`parameterCode`, `parameterValue`) VALUES ('useOrganizationBudgetElement', 'NO');
DELETE FROM `${prefix}columnselector` WHERE `objectClass` = 'Organization';
DELETE FROM `${prefix}filter` WHERE `refType` = 'Organization';
--END ADD BY TABARY Marc - 2017-06-06 - USE OR NOT ORGANIZATION BUDGETELEMENT

Check your parser in maintenance*php files as well. It SHOULD skip comments but, especially statements like this example have caused issues in db. Otherwise there should have been many more error messages when running sql manually.

And:
After first installation all upgrades have been performed by your software in automatic mode. Reason to run those sql statements by hand are errors quoted from log. There have been a lot of statements since v4.0 which didn't cause an error (even "create table" statements!). Therefor the automatic process is error prune to some extend Otherwise it couldn't give a message about missing field or even a missing table in db.

edit:
"a" is db name which is written to log file.

Errors in logs started after upgrade to 6.2 without error message in sql (see quote above). I quoted all errors found in log files. Log from upgrading 6.4.4 to 6.5.0 is complete log. In reality there have been missing tables and data.

cu, diri
Last edit: 11 Dec 2017 06:05 by diri.
The topic has been locked.
More
11 Dec 2017 17:43 #4 by babynus
Replied by babynus on topic db inconsitent between versions because of errors in sql

What you call ugly is original code from delivered sql files:
INSERT INTO `${prefix}workflow` (id,name, description, idle, workflowUpdate) VALUES

This is code of script that is not expected to be run manually..
Maintenance process repaces ${prefix} with corresponding string...

Try to run following sql in mysql (replace ${prefix} with real prefix):
--ADD BY TABARY Marc - 2017-06-06 - USE OR NOT ORGANIZATION BUDGETELEMENT
INSERT INTO `${prefix}parameter` (`parameterCode`, `parameterValue`) VALUES ('useOrganizationBudgetElement', 'NO');
DELETE FROM `${prefix}columnselector` WHERE `objectClass` = 'Organization';
DELETE FROM `${prefix}filter` WHERE `refType` = 'Organization';
--END ADD BY TABARY Marc - 2017-06-06 - USE OR NOT ORGANIZATION BUDGETELEMENT

All works fine B)

Check your parser in maintenance*php files as well. It SHOULD skip comments but, especially statements like this example have caused issues in db. Otherwise there should have been many more error messages when running sql manually.

mantenance.php is tested on each version, for migration and for first install.
No issue.

Otherwise there should have been many more error messages when running sql manually.

Once aign, you MUST NOT run scripts ma,nually.
They are not designed for this, and any manual operations may be source of issue (source of most issues is beetween chair and keyboard)

.

After first installation all upgrades have been performed by your software in automatic mode. Reason to run those sql statements by hand are errors quoted from log. There have been a lot of statements since v4.0 which didn't cause an error (even "create table" statements!). Therefor the automatic process is error prune to some extend Otherwise it couldn't give a message about missing field or even a missing table in db.

But if first install was done manually, it is sure source of errors.

"a" is db name which is written to log file.

DB name=a and prefix=${prefix} :silly:
Babynus
Administrator of ProjeQtOr web site
Attachments:
The topic has been locked.
More
12 Dec 2017 05:55 - 12 Dec 2017 05:58 #5 by diri
Replied by diri on topic db inconsitent between versions because of errors in sql
Why do you try to call other people stupid?

Evolution of installation mentioned:
1. Copy files to server
2. run install
3. run automatic updates
4. get errors

In case you miss it:
Some people are clever enough to understand to not to post private data in a public forum and to use $something in public postings.
Some people being not so clever don't understand this and refuse to understand that there are existing errors.

I can only shake head. Pick your own nose first.
Last edit: 12 Dec 2017 05:58 by diri.
The topic has been locked.
More
12 Dec 2017 10:04 #6 by babynus
Replied by babynus on topic db inconsitent between versions because of errors in sql

Why do you try to call other people stupid?

I really don't.
I just try and focus on showing that what doesn't work on your side really works fine on standard use.
When I see log file

"2017-12-08 05:38:43.203 ===== TRACE ===== Table "${prefix}ticket" altered."

I guess there is somethong wrong in definition of prefix a
(prefix is not a private data, so I cannot imagine you changed log file to replace real prefix with ${prefix}
Babynus
Administrator of ProjeQtOr web site
The topic has been locked.
Moderators: babynus, protion
Time to create page: 0.074 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.

Login Form