http://www.ezpdo.net/forum EZPDO User Forums en http://backend.userland.com/rss http://www.ezpdo.net/forum/viewtopic.php?pid=3227#p3227 3227@http://www.ezpdo.net/forum Topic: PHP 5.3 fixes Message: Problems with PHP 5.3.1:Deprecated: Assigning the return value of new by reference is deprecated in /var/www/html/Artemis/bibliotecas/ezpdo/libs/pear/Log.php on line 116Fatal error: Method epQueryNode::__tostring() cannot take arguments in /var/www/html/Artemis/bibliotecas/ezpdo/src/query/epQueryParser.php on line 419 Mon, 15 Feb 2010 08:46:18 -0500 http://www.ezpdo.net/forum/viewtopic.php?pid=3223#p3223 3223@http://www.ezpdo.net/forum Topic: sortBy bug Message: Good catch, that's very useful. Indeed, thank you QBert, your fix works well. Mon, 12 Oct 2009 08:04:43 -0400 http://www.ezpdo.net/forum/viewtopic.php?pid=3219#p3219 3219@http://www.ezpdo.net/forum Topic: PHP 5.3 fixes Message: Some fixes needed to run ezpdo on PHP 5.3...src/query/epQueryParser.php Code:public function __toString() { need to remove the $indent parameter in the magic method __toString function as:"The __toString magic method can no longer accept arguments."http://ar.php.net/manual/en/migration53 … atible.phpsrc/base/epConfig.php Code:$options = parse_ini_file($cfg_file, true, INI_SCANNER_RAW); need to add INI_SCANNER_RAW to the parse_ini_file function. Wed, 02 Sep 2009 15:47:26 -0400 http://www.ezpdo.net/forum/viewtopic.php?pid=2948#p2948 2948@http://www.ezpdo.net/forum Topic: "has one" Relation not been resolved to an object Message: Hi @ all,first I wanna say, that im very happy about this framework, but i've got a little problem. I think it's no bug, but i didnt know where else to post it:I've a @orm has one ... relation in one of my table-classes. But when i got all of this objects from the db (with "$manager->find('from person');") there are all simple datatypes loaded, but my object-relation is not gettin resolved ("Notice: Trying to get property of non-object in D:\Server\xampp\htdocs\ezpdo\index.php on line 9").I'm gonna post all of my classes here. Please help me. I dont know what im doin wrong. Maybe im to stupid (i hope not)...Kind regardsMarkusTable-Classes:auto.php:/** * @orm oid(autoid) */class auto {    /**     *     * @orm integer     */    public $autoid;        /**     *     * @orm char(45)     */    public $name;        /**     * @orm has many person --> inverse(auto) tried with inverse also => same output     */    public $persons;} ------------------------------------------------------------person.php:/** * @orm oid(personid) */class person {    /**     *     * @orm integer     */    public $personid;        /**     *     * @orm char(45)     */    public $name;        /**     *     * @orm has one auto --> inverse(persons) tried with inverse also => same output     */    public $auto;}    ------------------------------------------index.php (page loaded in browser)require_once($_SERVER['DOCUMENT_ROOT']. '/lib/ezpdo/ezpdo_runtime.php');$manager = epManager::instance();$a = $manager->find('from person');foreach ($a as $p) {    echo $p->name .' drives a '. $p->auto->name;    echo '<br>';}-------------------------------------------browser output:Notice: Trying to get property of non-object in D:\Server\xampp\htdocs\ezpdo\index.php on line 9Hans drives aNotice: Trying to get property of non-object in D:\Server\xampp\htdocs\ezpdo\index.php on line 9Werner drives a ---------------------------------------------Database:Table "auto"autoid  |  name1            Ferrari2            Audi3            OpelTable "person"personid | name   | auto1              Hans      12              Werner  2Help would be great... Thu, 04 Jun 2009 15:36:42 -0400 http://www.ezpdo.net/forum/viewtopic.php?pid=2942#p2942 2942@http://www.ezpdo.net/forum Topic: datetime int(16) problem Message: Hello,I'm trying to insert in my sql database an integer with the orm definition : datetime.The problem is that in my database i can't insert an integer biger than 8 digits even if the table created by ezpdo has an  int(16) expecting receaving my UTC date.Thank you.  Efthymios Fri, 10 Apr 2009 09:49:50 -0400 http://www.ezpdo.net/forum/viewtopic.php?pid=2935#p2935 2935@http://www.ezpdo.net/forum Topic: foreign key Message: It looks like you are using an existing database, is this correct?  The "Cannot add or update a child row: a foreign key constraint fails" implies that you have existing data with foreign keys defined. Thu, 29 Jan 2009 12:00:43 -0500 http://www.ezpdo.net/forum/viewtopic.php?pid=2933#p2933 2933@http://www.ezpdo.net/forum Topic: foreign key Message: Hello every body,excuse me, my english is not perfect, i'm just trying. I want to insert something in a database with ezpdo but i have this error:Uncaught exception 'epExceptionDbAdodb' with message 'Cannot execute query: mysql error: [1452: Cannot add or update a child row: a foreign key constraint fails (`ehealth/ordonnance`, CONSTRAINT `FKAEDD7E5D2D11C006` FOREIGN KEY (`beneficiaire_id`) REFERENCES `beneficiaire` (`id`))] in EXECUTE("INSERT INTO `ordonnance` (`id`, `numordre`, `cle`, `date`, `cout`, `medecin_id`, `beneficiaire_id`, `utilisateur_login`, `offre_id`, `refconsult`, `etat`, `pharm`) VALUES (0, '6541098544', '', '21/01/2009', 0, '  medecin referent  Joel  Onomo', 'Anicet', '  medecin referent  Joel  Onomo', 0, '36', 0, '');") ' in C:\wamp\www\application gesdom\ezpdo\src\db\epDbAdodb.php:189 Stack trace: #0 C:\wamp\www\application gesdom\ezpdo\src\db\epDb.php(352): epDbAdodb->_execute('INSERT INTO `or...') #1 C:\wamp\www\application gesdom\ezpdo\src\db\epDbObject.php(1585): epDb->execute('INSERT INTO `or...') #2 C:\wamp\www\application gesdom\ezpdo\src\db\epDbObject.php(1226): epDbObject->_execute('INSERT INTO `or...') #3 C:\wamp\www\appl in C:\wamp\www\application gesdom\ezpdo\src\db\epDbAdodb.php on line 189Is it possible to for me to have a help please? Thu, 22 Jan 2009 06:34:24 -0500 http://www.ezpdo.net/forum/viewtopic.php?pid=2896#p2896 2896@http://www.ezpdo.net/forum Topic: sortBy bug Message: qbert wrote:I modified the code to get the result that I expect by changing the line 995: Code:if (($r = strcmp($va, $vb)) < 0) To: Code:if (($r = strcasecmp($va, $vb)) < 0) File: src/db/epDbObject.php Function: __sort($a, $b) I will be using this patch mean while..., but is there another way to get a case-insensitive sorting ?Thanks.QBert Good catch, that's very useful. Tue, 23 Sep 2008 12:21:37 -0400 http://www.ezpdo.net/forum/viewtopic.php?pid=2888#p2888 2888@http://www.ezpdo.net/forum Topic: removeAll not maintaining inverse relation Message: anyone experience this? Mon, 11 Aug 2008 22:37:15 -0400 http://www.ezpdo.net/forum/viewtopic.php?pid=2884#p2884 2884@http://www.ezpdo.net/forum Topic: removeAll not maintaining inverse relation Message: The code below is not maintaining the category inverse relationship, when I try to remove a category from an attorney (not posting the attorney id), it removes the category from the attorney, but not the attorney from the category.  Furthermore, when I readd the attorney to the category it adds another relationship so the attorney will show up twice.  Is this the way this method is supposed to behave?In Category class: Code: /** * @orm has many Attorney inverse(categories) */ public $attorneys; In Attorney Class: Code: /** * @orm has many Category inverse(attorneys) */ public $categories; Update Code: Code: // remove all categories $attorney->categories->removeAll(); // add POST'd categories foreach( $_POST['categories'] as $cat_id ) { $attorney->categories[] = $this->manager->get_category($cat_id); } // save changes $manager->commit($attorney); Thu, 17 Jul 2008 16:45:37 -0400 http://www.ezpdo.net/forum/viewtopic.php?pid=2878#p2878 2878@http://www.ezpdo.net/forum Topic: Query error with SQL "in" clause Message: I got this error when I tried to do this query:$m->find("FROM ProcessoSeletivo as p WHERE p.inscricoesCandidatos.oid in (?)",$arrayOid);Fatal error: Uncaught exception 'epExceptionDbPeardb' with message 'DB Error: no such field, query: SELECT DISTINCT `p`.* FROM `ProcessoSeletivo` AS `p` LEFT JOIN `_ez_relation_inscricaocandidato_processoseletivo` AS `_3` ON `_3`.var_a = 'inscricoesCandidatos' AND (`_3`.class_a = 'ProcessoSeletivo' AND `_3`.oid_a = `p`.`e_oid`) LEFT JOIN `InscricaoCandidato` AS `_2oid` ON `_3`.base_b = 'InscricaoCandidato' AND `_3`.class_b = 'InscricaoCandidato' AND `_3`.oid_b = `_2oid`.`e_oid` WHERE `_2oid`.`oid` in('5', '6', '7', '8', '9', '10')' in /var/www/html/Artemis/bibliotecas/ezpdo/src/db/epDbPeardb.php:178 Stack trace: #0 /var/www/html/Artemis/bibliotecas/ezpdo/src/db/epDb.php(352): epDbPeardb->_execute('SELECT DISTINCT...') #1 /var/www/html/Artemis/bibliotecas/ezpdo/src/db/epDbObject.php(1585): epDb->execute('SELECT DISTINCT...') #2 /var/www/html/Artemis/bibliotecas/ezpdo/src/db/epDbObject.php(894): epDbObject->_execute('SELECT DISTINCT...') #3 /var/www/html/Artemis/bibliotecas/ezpdo/src/db/epDbObject.php(871): epDbObject->_que in /var/www/html/Artemis/bibliotecas/ezpdo/src/db/epDbPeardb.php on line 178I managed this: the "WHERE `_2oid`.`oid` in('5', '6', '7', '8', '9', '10')" have an error at _2oid.oid. It should be _2oid.e_oid. I don't know why ezpdo is not changing oid for e_oid (as in my database). Any clues?Thanks in advice, this tool is amazing! Tue, 24 Jun 2008 10:36:29 -0400 http://www.ezpdo.net/forum/viewtopic.php?pid=2809#p2809 2809@http://www.ezpdo.net/forum Topic: Relation not saved when set in the constructor Message: Zaphod wrote:Does anybody know a workaround for my problem described here? I want to set the values in the Constructor. I'm having the same problem here! Thu, 31 Jan 2008 22:39:41 -0500 http://www.ezpdo.net/forum/viewtopic.php?pid=2799#p2799 2799@http://www.ezpdo.net/forum Topic: Can't connect to mysql server with pdo Message: what about you switch to use adodb? if that works, then it could be an issue with the dsn being translated to the pdo dsn format. -el Tue, 22 Jan 2008 19:42:39 -0500 http://www.ezpdo.net/forum/viewtopic.php?pid=2798#p2798 2798@http://www.ezpdo.net/forum Topic: Can't connect to mysql server with pdo Message: Hello,I'm trying to connect to mysql db (to run the books example)It works perfectly well with the option db_lib = adodbBut when I change it to db_lib = pdo It does not work anymore and I have the following error:Fatal error: Uncaught exception 'epExceptionDbPdo' with message 'Cannot connect db [mysql:dbname=ezpdotest;host=hostdb]: SQLSTATE[HY000] [2003] Can't connect to MySQL server on 'hostdb' (111)...The pb could be originated from the fact that I mention a port number in the default dsndefault_dsn = mysql://user:password@hostdv:3314/ezpdotest May be I have to change the default_dsn for PDO???Many many thanks for your helpBest regardsHatem Tue, 22 Jan 2008 05:58:49 -0500 http://www.ezpdo.net/forum/viewtopic.php?pid=2791#p2791 2791@http://www.ezpdo.net/forum Topic: can't connect to my oracle 10g XE db Message: I'm also very interested in making ezpdo works with oracle. Indeed, i work on a project that need to works on mySql or Oracle.I have seen in bugs part (task #196) that it needs to develop an epDbPortable specifique to oci8. but is that all??? Wed, 16 Jan 2008 10:51:45 -0500