SQL queries break Content Object creation

Wednesday 24 September 2003 8:54:35 am

The problem I am facing is one that I can't make much sense out of and I was hoping someone could enlighten me to my mistake. The Query works and returns the correct results however if I run the query
$class =& eZContentClass::fetch(19);
returns this:

ezcontentclass Object
(
[PersistentDataDirty] =>
[ID] =>
[Name] =>
[Identifier] =>
[ContentObjectName] =>
[Version] =>
[VersionCount] => 1
[CreatorID] =>
[ModifierID] =>
[Created] =>
[Modified] =>
[InGroups] =>
[AllGroups] =>
)

whereas if i fake, or remove, the query it creates the object correctly:

ezcontentclass Object
(
[PersistentDataDirty] =>
[ID] => 19
[Name] => Saved Report
[Identifier] => saved_report
[ContentObjectName] =>
[Version] => 0
[VersionCount] => 1
[CreatorID] => 14
[ModifierID] => 14
[Created] => 1059166776
[Modified] => 1064251143
[InGroups] =>
[AllGroups] =>
)

I attempted the query using the built in php mysql functions with the same result. I have also moved the query to after fetching the class but this doesn't help either.

The code follows:

$db =& new eZMySQLDB(array( 'server'=>'myserver',
'database'=>'mydatabase',
'user'=>'dbuser',
'password'=>'userspassword' ) );

$info = $db->arrayQuery("SELECT `Report`, `RunName`, `UserID` FROM `mytable` WHERE `RunID` = $RunID" );

$class =& eZContentClass::fetch(19); //my content class

...
(more code)

Thanks for the help!

Dave

Tuesday 27 July 2004 6:04:00 am

Same problem. No solution found.