View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
06088 | Bug reports | Other | public | 2012-05-12 21:57 | 2012-05-28 15:12 |
Reporter | mars99 | Assigned To | c_schmitz | ||
Priority | high | Severity | partial_block | ||
Status | closed | Resolution | fixed | ||
Product Version | 2.00RC1 | ||||
Fixed in Version | 2.00RC2 | ||||
Summary | 06088: Saving a sub | ||||
Description | Saving a subquestion with the PostgreSQL backend results in the following error... PDOException SQLSTATE[42602]: Invalid name: 7 ERROR: invalid name syntax /usr/share/webapps/limesurvey2/framework/db/CDbConnection.php(535) 523 return $this->getSchema()->getCommandBuilder(); Stack Trace 330 else #2 77 $oMethod = new ReflectionMethod($this, $sDefault); #5 145 Yii::app()->session['redirectopage'] = Yii::app()->request->requestUri; #9 | ||||
Steps To Reproduce | 1.) Login in to the backend Only the first item is saved but the error occurs every time (if only one or multiple subquestions have to be saved). | ||||
Additional Information | There are more problems with PostgreSQL, so I have to assume it's more or less untested (additional reports will follow). As a general advice I suggest using transactions for all operations on all databases (I know that the MyISAM MySQL Backend doesn't support it) as data integrity is important and other databases including MySQL with the InnoDB backend support it. | ||||
Tags | No tags attached. | ||||
Bug heat | 4 | ||||
Complete LimeSurvey version number (& build) | 120510 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | |||||
Database type & version | PostgreSQL 9.1.3 | ||||
Server OS (if known) | Ubuntu 12.04 LTS (ARM) | ||||
Webserver software & version (if known) | lighttpd/1.4.28 | ||||
PHP Version | PHP5 (5.3.10-1*) | ||||
The full summary should have been: |
|
Fix committed to Yii branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=8475 |
|
Version 2.00RC2 released. |
|
Date Modified | Username | Field | Change |
---|---|---|---|
2012-05-12 21:57 | mars99 | New Issue | |
2012-05-12 21:59 | mars99 | Note Added: 18723 | |
2012-05-13 08:31 | c_schmitz | Assigned To | => c_schmitz |
2012-05-13 08:31 | c_schmitz | Status | new => assigned |
2012-05-15 21:28 | c_schmitz | Status | assigned => resolved |
2012-05-15 21:28 | c_schmitz | Fixed in Version | => 2.00RC2 |
2012-05-15 21:28 | c_schmitz | Resolution | open => fixed |
2012-05-15 21:30 | c_schmitz | Changeset attached | => LimeSurvey Yii 7afad535 |
2012-05-15 21:30 | c_schmitz | Note Added: 18770 | |
2012-05-28 15:12 | c_schmitz | Note Added: 18960 | |
2012-05-28 15:12 | c_schmitz | Status | resolved => closed |