DB_DataObject modifying table problem.
| From: | Tobias Carlsson | Date: | Thu, 23 Jan 2003 10:14:05 +0000 |
| Subject: | DB_DataObject modifying table problem. | ||
| Groups: | php.pear.general | ||
| Request: | Send a blank email to pear-general+get-3419@lists.php.net to get a copy of this message | ||
Hi
I've installed this package and tried it out and really want to use
it in my new project. I can fetch data but not modify any. Im using the
autogenerated sub classes and I cant get it to work. This is how Im doing
it:
require_once 'PEAR.php';
require_once 'DataObjects/Company.php';
$options = &PEAR::getStaticProperty('DB_DataObject','options');
$config = parse_ini_file('click.ini',TRUE);
$options = $config['DB_DataObject'];
$company = new DataObjects_Company;
$company->get('xuid', 1);
$company->xnumber_users=10;
$company->update();
I get the object and can print it out but the update method wont work and
that goes for all the modifying methods. Im using the mysql root account,
it has all the permissons on the database.
This is from my mysql.log (nothing from mysql.err):
030123 10:52:56 149 Connect root@localhost on
149 Init DB lightwave
149 Init DB lightwave
149 Query SELECT * FROM company WHERE xuid = 1
149 Quit
When I set debugging level to 5 I get this output:
sql QUERYUPDATE company SET xuid = 1 , wname = 'Test AB'.. and so on.
0 Disabling Update as you are in debug mode
My click.ini file looks like this:
[DB_DataObject]
database = mysql://root:mypassword@localhost/lightwave
schema_location = /var/www/DataObjects
class_location = /var/www/DataObjects
require_prefix = DataObjects/
class_prefix = DataObjects_
debug = 0
debug_ignore_updates = 0
production = 1
Does anyone see the fault Im doing here?
Thanks in advance.
Tobias Carlsson.......... tobias@restamus.se ......