RE: [PEAR] DataObjects: Rows inserted in triplicate

OK, couple of things. I noticed an error in my manually created class. I had copy/pasted the code for the staticGet function, and forgotten to change the name of the table. I ran the generator, and it worked fine. I tested the generated class, and it is doing the same thing, but it doesn't seem to be creating the seq table anymore. -----Original Message----- From: Justin Patrin [mailto:papercrane@gmail.com] Sent: Tuesday, February 22, 2005 1:41 PM To: Sasha Sklar Cc: pear-general@lists.php.net Subject: Re: [PEAR] DataObjects: Rows inserted in triplicate On Tue, 22 Feb 2005 13:23:15 -0800, Sasha Sklar <Sasha.Sklar@craveonline.com> wrote: > Justin, > > Thanks for the info on running the generator. I'm going to give it a > try, although there is some resistance in my team to using the generated > classes. Not logical, I know, but that's work politics. The auto-gen classes are just as good as normal manual classes except they're automatic. :-) It only touches the auto-gen code, so as long as you put custom functions and such outside of the markers you're fine. > > We're using PHP 4.3.9. That is the entirety of the script, aside from > some html for formatting and the configuration code at the top. I'll > list that and my config file: > <snip> > I've noticed a weird table in the database which I did not create. It is > called test_seq. It contains a single row with a single field called id. > The id value is equal to the last id in test. If I remove the table and > run my script, it is regenerated. > > Any ideas? Ah....this is DB creating a sequence table because DB_DataObject thinks that this is a DB generated sequence. What DB backend are you using? Mysql? Is your ID set up as a auto incremented value? Do you have it set up as your primary key? > > -----Original Message----- > From: Justin Patrin [mailto:papercrane@gmail.com] > Sent: Tuesday, February 22, 2005 1:08 PM > To: Sasha Sklar > Cc: pear-general@lists.php.net > Subject: Re: [PEAR] DataObjects: Rows inserted in triplicate > > On Tue, 22 Feb 2005 12:33:52 -0800, Sasha Sklar > <Sasha.Sklar@craveonline.com> wrote: > > This is the issue: every insert I perform is generating 3 rows instead > > of 1. > > > > I'm using DataObjects with manually created classes, I can't use the > > generator do to permission issues. > > > > What permissions issues? If you can't run it via CLI for some reason > you can always run the generator from the web. Just set the > permissions on the class dir (and files) to 777. Here's a simple > script I use to update some of my DOs from the web: > > <?php > $_SERVER['argv'][1] = '/path/to/DataObject.ini'; > include('/path/to/PEAR/DB/DataObject/createTables.php'); > system('chmod 777 /path/to/DataObjects/*'); > ?> > > If you need more help, what's the output of the script you gave? Is > that the entirety of the script or is there more? What version of PHP > are you using? > -- Justin Patrin