MantisBT - v2.0 Release (Closed)
View Issue Details
0000506v2.0 Release (Closed)[All Projects] Generalpublic2010-07-06 07:482010-07-09 05:28
Reporterlaussetdelon 
Assigned To 
PriorityimmediateSeveritycrashReproducibilityalways
StatusclosedResolutionfixed 
PlatformOSOS Version
Product Version 
Target VersionFixed in Version 
Summary0000506: Upgrade from 1.2.0 to 2.0
DescriptionTrying to upgrade I get the message after logging in.


ERROR: /var/www/project/classes/w2p/Database/Query.class.php(1115) : query failed(SELECT sysval_value FROM ((`sysvals` AS sysvals)) WHERE sysval_value_id = ) - error was: 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 '' at line 1
Backtrace:
0 /var/www/project/classes/w2p/Database/Query.class.php:1115 dprint()
1 /var/www/project/classes/w2p/Database/Query.class.php:1357 exec()
2 /var/www/project/classes/ui.class.php:246 loadResult()
3 /var/www/project/style/w2p-snowball/header.php:123 getTZAwareTime()
4 /var/www/project/index.php:267 require()
TagsNo tags attached.
related to 0000503closed caseydk v2.1 Release (Closed) Some users pref TIMEZONE incorrect after upgrade to 2.0 
Attached Filesjpg sysvlas.jpg (170,218) 1969-12-31 16:00
https://bugs.web2project.net/file_download.php?file_id=102&type=bug
jpg

jpg sysvals2.jpg (151,360) 1969-12-31 16:00
https://bugs.web2project.net/file_download.php?file_id=103&type=bug
jpg

jpg sysvals3.jpg (154,287) 1969-12-31 16:00
https://bugs.web2project.net/file_download.php?file_id=104&type=bug
jpg

jpg sysvals4.jpg (168,570) 1969-12-31 16:00
https://bugs.web2project.net/file_download.php?file_id=105&type=bug
jpg

jpg sysvals5.jpg (161,787) 1969-12-31 16:00
https://bugs.web2project.net/file_download.php?file_id=106&type=bug
jpg

jpg sysvals6.jpg (167,063) 1969-12-31 16:00
https://bugs.web2project.net/file_download.php?file_id=107&type=bug
jpg

jpg sysvals11.jpg (191,436) 1969-12-31 16:00
https://bugs.web2project.net/file_download.php?file_id=108&type=bug
jpg

Notes
(0001113)
caseydk   
2010-07-06 12:37   
Before attempting to upgrade, please try switching back to the base theme.

Based on this - http://web2project.net/forums/viewtopic.php?t=2321 - that may make some things simpler.
(0001122)
laussetdelon   
2010-07-08 00:29   
I changed my theme on the source release. Then disconnect
Upgrade then same error

ERROR: /var/www/project/classes/w2p/Database/Query.class.php(1115) : query failed(SELECT sysval_value FROM ((`sysvals` AS sysvals)) WHERE sysval_value_id = ) - error was: 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 '' at line 1
Backtrace:
0 /var/www/project/classes/w2p/Database/Query.class.php:1115 dprint()
1 /var/www/project/classes/w2p/Database/Query.class.php:1357 exec()
2 /var/www/project/classes/ui.class.php:246 loadResult()
3 /var/www/project/style/web2project/header.php:123 getTZAwareTime()
4 /var/www/project/index.php:267 require()
(0001123)
laussetdelon   
2010-07-08 00:41   
see sysvals table attached
(0001125)
caseydk   
2010-07-08 09:01   
Check out r1230 for this one. I've patched it and added some useful warning/notice messages.
(0001127)
laussetdelon   
2010-07-09 03:34   
Still the error displayed but, links to Upgrade Timezone and Release are displayed and usable.
Considered as closed
(0001128)
caseydk   
2010-07-09 05:28   
Fixed, will be Closed with 2.0.1.

Issue History
2010-07-06 07:48laussetdelonNew Issue
2010-07-06 12:34caseydkRelationship addedrelated to 0000503
2010-07-06 12:37caseydkNote Added: 0001113
2010-07-06 12:40caseydkCategorySystem Admin => Core Infrastructure
2010-07-06 21:36caseydkPrioritynormal => immediate
2010-07-08 00:29laussetdelonNote Added: 0001122
2010-07-08 00:40laussetdelonFile Added: sysvlas.jpg
2010-07-08 00:41laussetdelonNote Added: 0001123
2010-07-08 00:54laussetdelonFile Added: sysvals2.jpg
2010-07-08 00:56laussetdelonFile Added: sysvals3.jpg
2010-07-08 00:56laussetdelonFile Added: sysvals4.jpg
2010-07-08 00:57laussetdelonFile Added: sysvals5.jpg
2010-07-08 00:57laussetdelonFile Added: sysvals6.jpg
2010-07-08 00:57laussetdelonFile Added: sysvals11.jpg
2010-07-08 09:01caseydkNote Added: 0001125
2010-07-08 09:01caseydkStatusnew => feedback
2010-07-09 03:34laussetdelonNote Added: 0001127
2010-07-09 05:28caseydkNote Added: 0001128
2010-07-09 05:28caseydkStatusfeedback => closed
2010-07-09 05:28caseydkResolutionopen => fixed