Zend Framework

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.10.7
• Fix Version/s: 1.10.8
• Component/s: Zend_Db_Table
• Labels:

  None

Hi,

I've found bug in class Zend_Db_Table_Abstract in build sequence name with non-public schema.

When I try insert row to table pages in schema admin, I've got exception:

• Zend_Db_Statement_Exception
• SQLSTATE[3F000]: Invalid schema name: 7 ERROR: schema "admin"" does not exist

Exception occour on this query:
"SELECT NEXTVAL('"admin"""."""pages_pid_seq"')"

When I removed quoting it works.
Line 907-909 in Zend_Db_Table_Abstract:
$this->sequence = $this->_name . '' . $pkIdentity . '_seq';
if ($this->_schema) { $this->_sequence = $this->_schema . '.' . $this->_sequence; }

• Assignee:

  Ramon Henrique Ornelas

  Reporter:

  Marek Fiala

• Created:

  11/Aug/10 1:41 PM

  Updated:

  11/Aug/10 1:49 PM

  Resolved:

  11/Aug/10 1:49 PM