View Issue Details

This bug affects 1 person(s).
 6
IDProjectCategoryView StatusLast Update
04127Bug reportsInstallationpublic2010-02-23 20:55
Reporteraoliveira Assigned Toc_schmitz  
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Product Version1.87+ 
Fixed in Version1.87+ 
Summary04127: Upgrade to 1.87+ returns sql error and PHP Notice in index.php
Description

When upgrading from version 1.85 to 1.87+ (or 1.87RC5, also tried out) I get an sql error regaring two updates to the question_attributes table.
After login in as admin another error occurs : PHP notice regarding the common.php file.
Please check document attached with print-screens.

Additional Information

Machine has the following configuration:

LimeSurvey v.1.85plus
machine running MS Windows Server 2003 R2 with .net framework 2.0
PHP 5.3 and FastCGIIIS6

TagsNo tags attached.
Attached Files
Bug heat6
Complete LimeSurvey version number (& build)7670
I will donate to the project if issue is resolved
Browserie8
Database type & versionMS SQL 2008
Server OS (if known)MS Windows Server 2003
Webserver software & version (if known)iis
PHP Version5.5

Users monitoring this issue

There are no users monitoring this issue.

Activities

user372

2010-02-12 07:18

  ~11054

@ aoliveira: which build of LimeSurvey v1.87+ did you use for upgrade? ==> The latest stable plus release is build 8374 ==> can you reproduce the problem with this build?

aoliveira

aoliveira

2010-02-12 10:23

reporter   ~11062

I tried with build 8243 and 8366.
I will try to download the latest build and perform the migration. Will post results after. Thanks

aoliveira

aoliveira

2010-02-12 15:44

reporter   ~11065

HI,
I downloaded the last build 8374 and tried upgrading with no success.
I also tried a new installation from scracth (new website, new database)and also had the same error in tha admin page (PHP Notice: Undefined variable: updatecheckperiod in C:\Inetpub\wwwroot\limesurvey187plus-build8374-20100211\common.php on line 287 )
I even tried to hide the notice by changing PHP ini file replacing the line
error_reporting = E_ALL & ~E_DEPRECATED
with
error_reporting = E_ALL & ~E_DEPRECATED & ~E_NOTICE & ~E_WARNING

aoliveira

aoliveira

2010-02-12 15:58

reporter   ~11066

I think I have the solution ;-)

In file comon.php, the access to the variable updatelastcheck should be preceded by a '@' instead of a '$' which I suppose in PHP results in not raising an error if the variable is null...
if ($sourcefrom == "admin" && $buildnumber != "" && @updatecheckperiod>0 && @updatelastcheck<date_shift(date("Y-m-d H:i:s"), "Y-m-d H:i:s", "-".$updatecheckperiod." days"))
{
updatecheck();
}

So, I just replaced $updatelastcheck by @updatelastcheck and managed to access the admin area of the site and, in the globalseeting page, manage to check for updates...

Do you agree?

c_schmitz

c_schmitz

2010-02-13 01:41

administrator   ~11076

I am sorry, but your fix is bogus.
The upgrade errors can be safely ignored but need to be fixed

The notices are caused by an incorrect update - you did not replace config-
defaults.php with the new version.

aoliveira

aoliveira

2010-02-22 11:11

reporter   ~11144

Thanks for your feedback.
I was out last week so I could not answer you.
I tried to upgrade a minute ago (keeping the config-defaults.php file) but it is still missing one variable:
"PHP Notice: Undefined variable: debug in C:\Inetpub\wwwroot\limesurvey187plus-build8374-20100211\common.php on line 41 PHP Notice: Undefined variable: debug in C:\Inetpub\wwwroot\limesurvey187plus-build8374-20100211\common.php on line 46 "

c_schmitz

c_schmitz

2010-02-23 20:55

administrator   ~11161

Insert the line

$debug=0;

in your config.php.

Issue History

Date Modified Username Field Change
2010-02-11 13:21 aoliveira New Issue
2010-02-11 13:21 aoliveira Status new => assigned
2010-02-11 13:21 aoliveira Assigned To => user372
2010-02-11 13:21 aoliveira File Added: error upgrade limesurvey.docx
2010-02-11 13:21 aoliveira LimeSurvey build number => 7670
2010-02-11 13:21 aoliveira Browser => ie8
2010-02-11 13:21 aoliveira Database & DB-Version => MS SQL 2008
2010-02-11 13:21 aoliveira Operating System (Server) => MS Windows Server 2003
2010-02-11 13:21 aoliveira Webserver => iis
2010-02-11 13:21 aoliveira PHP Version => 5.5
2010-02-12 07:18 user372 Note Added: 11054
2010-02-12 07:18 user372 Status assigned => feedback
2010-02-12 10:23 aoliveira Note Added: 11062
2010-02-12 15:44 aoliveira Note Added: 11065
2010-02-12 15:58 aoliveira Note Added: 11066
2010-02-13 01:41 c_schmitz Note Added: 11076
2010-02-13 01:41 c_schmitz Status feedback => assigned
2010-02-13 01:41 c_schmitz Assigned To user372 => c_schmitz
2010-02-13 11:38 c_schmitz Status assigned => resolved
2010-02-13 11:38 c_schmitz Fixed in Version => 1.87+
2010-02-13 11:38 c_schmitz Resolution open => fixed
2010-02-18 18:19 c_schmitz Status resolved => closed
2010-02-22 11:11 aoliveira Note Added: 11144
2010-02-22 11:11 aoliveira Status closed => feedback
2010-02-22 11:11 aoliveira Resolution fixed => reopened
2010-02-23 20:55 c_schmitz Note Added: 11161
2010-02-23 20:55 c_schmitz Status feedback => closed
2010-02-23 20:55 c_schmitz Resolution reopened => fixed