create after create or retrievemore mus doesnt work

[prev] [thread] [next] [Date index for 2004/07/20]

From: Teun van Eijsden
Subject: create after create or retrievemore mus doesnt work
Date: 08:45 on 20 Jul 2004
This is a multi-part message in MIME format.

------=_NextPart_000_0040_01C46E46.AA408E20
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


Hi all,

When i create a row in one table and then in another, it doesn't fill =
out all the values of the second create, only the primary key.
Below you'll find a listing of everything relevant (separated bij bold =
headers). Any pointers would be appreciated.

Teun van Eijsden
The Netherlands





MySQL DDL:

create table nodes (nid VARCHAR(255) PRIMARY KEY, author VARCHAR(255), =
date TIMESTAMP, content LONGBLOB, public TINYINT);
create table access (id INT AUTO_INCREMENT PRIMARY KEY, nid =
VARCHAR(255), uid VARCHAR(255), subscription TINYINT);
create table users (uid VARCHAR(255) PRIMARY KEY, email VARCHAR(255), =
employee TINYINT);



perl script:

#!/cadappl/bin/perl -w

use strict;
use Class::DBI;

DBI->trace(1 =3D> "/tmp/logfile"); # trace all the SQL code

package Doc::DBI;
use base 'Class::DBI';
Doc::DBI->connection('DBI:mysql:database=3Dhivedoc;host=3Dwebservername.c=
om', 'hive', '*****');

package Doc::Access;
use base 'Doc::DBI';
Doc::Access->table('access');
Doc::Access->columns(All =3D> qw/id nid uid subscription/);
Doc::Access->has_a(nid =3D> 'Doc::Node');

package Doc::Node;
use base 'Doc::DBI';
Doc::Node->table('nodes');
Doc::Node->columns(All =3D> qw/nid author date content public/);
Doc::Node->has_a(author =3D> 'Doc::User');
Doc::Node->has_many(access =3D> 'Doc::Access');

package Doc::User;
use base 'Doc::DBI';
Doc::User->table('users');
Doc::User->columns(All =3D> qw/uid email employee/);


package main;

#my $node =3D Doc::Node->create({nid =3D> "HomePage", author =3D> =
"eijsdent", content =3D> 'Silicon Hive rules', public =3D> 1});
my $node =3D Doc::Node->retrieve("HomePage");
print 'Author: .';
print $node->author;
print ".\n";

my $user =3D Doc::User->create({'uid' =3D> 'eijsdent', 'email' =3D> =
'jaap@xxxxx.xx', 'employee' =3D> 1});
#$user->update;
print 'Email: .';
print $user->email;
print ".\n";





Output:

./music.pl
Author: .eijsdent.
Use of uninitialized value in print at ./music.pl line 42.
Email: ..

in MySQL database:

select * from users;
+----------+-------+----------+
| uid      | email | employee |
+----------+-------+----------+
| eijsdent | NULL  |     NULL |
+----------+-------+----------+
1 row in set (0.00 sec)





SQL Trace Log:

    DBI 1.43-nothread default trace level set to 0x0/1 (pid 22839)
    -> =
DBI->connect_cached(DBI:mysql:database=3Dhivedoc;host=3Dwebdb.natlab.rese=
arch.philips.com, hive, ****)
    -> DBI->install_driver(mysql) for linux perl=3D5.006001 pid=3D22839 =
ruid=3D3982 euid=3D3982
       install_driver: DBD::mysql version 2.1026 loaded from =
/cadappl/perl/5.6.1/lib/site_perl/5.6.1/i686-linux/DBD/mysql.pm
    <- install_driver=3D DBI::dr=3DHASH(0x81dab2c)
    <- =
connect_cached('database=3Dhivedoc;host=3Dwebdb.natlab.research.philips.c=
om' 'hive' ...)=3D DBI::db=3DHASH(0x830f88c) at DBI.pm line 595
    <- STORE('RootClass' 'DBIx::ContextualFetch')=3D 1 at DBI.pm line =
628
       _set_isa([DBIx::ContextualFetch])
       DBIx::ContextualFetch::db::ISA skipped (already set to DBI::db)
       DBIx::ContextualFetch::st::ISA skipped (already set to DBI::st)
    <- STORE('RaiseError' 1)=3D 1 at DBI.pm line 642
    <- STORE('PrintError' 0)=3D 1 at DBI.pm line 642
    <- STORE('AutoCommit' 1)=3D 1 at DBI.pm line 642
 T  <- STORE('Taint' 1)=3D 1 at DBI.pm line 645
 T  <- FETCH('Taint')=3D 1 at DBI.pm line 645
 T  <- STORE('Username' 'hive')=3D 1 at DBI.pm line 645
 T  <> FETCH('Username')=3D 'hive' ('Username' from cache) at DBI.pm =
line 645
 T  <- STORE('FetchHashKeyName' 'NAME_lc')=3D 1 at DBI.pm line 645
 T  <> FETCH('FetchHashKeyName')=3D 'NAME_lc' ('FetchHashKeyName' from =
cache) at DBI.pm line 645
 T  <- STORE('ShowErrorStatement' 1)=3D 1 at DBI.pm line 645
 T  <- FETCH('ShowErrorStatement')=3D 1 at DBI.pm line 645
 T  <- STORE('dbi_connect_method' 'connect_cached')=3D 1 at DBI.pm line =
645
 T  <> FETCH('dbi_connect_method')=3D 'connect_cached' =
('dbi_connect_method' from cache) at DBI.pm line 645
 T  <- STORE('ChopBlanks' 1)=3D 1 at DBI.pm line 645
 T  <- FETCH('ChopBlanks')=3D 1 at DBI.pm line 645
    <- connect=3D DBIx::ContextualFetch::db=3DHASH(0x830f88c)
 T  <- STORE('dbi_connect_closure' CODE(0x830f934))=3D 1 at DBI.pm line =
665
 T  <- prepare_cached('SELECT nid
FROM   nodes
WHERE  nid =3D ?
')=3D ( DBIx::ContextualFetch::st=3DHASH(0x82e7a90) ) [1 items] at =
DBI.pm line 391
 T  <- FETCH('Active')=3D '' at DBI.pm line 1124
 T  <- FETCH('Taint')=3D 1 at ContextualFetch.pm line 49
    <- STORE('Taint' 0)=3D 1 at ContextualFetch.pm line 50
    <- execute('HomePage')=3D 1 at ContextualFetch.pm line 51
 T  <- STORE('Taint' 1)=3D 1 at ContextualFetch.pm line 52
 T  <- FETCH('NAME_lc')=3D [ 'nid' ] at DBI.pm line 1125
 T  <- bind_columns(SCALAR(0x831d50c))=3D 1 at DBI.pm line 1125
 T  <- fetchrow_arrayref=3D [ 'HomePage' ] row1 at ContextualFetch.pm =
line 59
 T  <- fetchrow_arrayref=3D undef row1 at ContextualFetch.pm line 59
 T  <- FETCH('Active')=3D 1 at DBI.pm line 316
 T  <- ping=3D 1 at DBI.pm line 316
 T  <- prepare_cached('SELECT content, author, date, public
FROM   nodes
WHERE  nid=3D?
')=3D DBIx::ContextualFetch::st=3DHASH(0x831d62c) at DBI.pm line 391
 T  <- FETCH('Taint')=3D 1 at ContextualFetch.pm line 49
    <- STORE('Taint' 0)=3D 1 at ContextualFetch.pm line 50
    <- execute('HomePage')=3D 1 at ContextualFetch.pm line 51
 T  <- STORE('Taint' 1)=3D 1 at ContextualFetch.pm line 52
 T  <- fetchrow_array=3D ( 'Silicon Hive rules' 'eijsdent' =
'20040720101349' '1' ) [4 items] row1 at ContextualFetch.pm line 87
 T  <- finish=3D 1 at ContextualFetch.pm line 88
 T  <- FETCH('Active')=3D 1 at DBI.pm line 316
 T  <- ping=3D 1 at DBI.pm line 316
 T  <- prepare_cached('INSERT INTO users (uid)
VALUES (?)
')=3D DBIx::ContextualFetch::st=3DHASH(0x832747c) at DBI.pm line 391
 T  <- FETCH('Taint')=3D 1 at ContextualFetch.pm line 49
    <- STORE('Taint' 0)=3D 1 at ContextualFetch.pm line 50
    <- execute('eijsdent')=3D 1 at ContextualFetch.pm line 51
 T  <- STORE('Taint' 1)=3D 1 at ContextualFetch.pm line 52
 T  <- FETCH('Active')=3D 1 at DBI.pm line 316
 T  <- ping=3D 1 at DBI.pm line 316
 T  <- prepare_cached('SELECT employee, email
FROM   users
WHERE  uid=3D?
')=3D DBIx::ContextualFetch::st=3DHASH(0x83277ac) at DBI.pm line 391
 T  <- FETCH('Taint')=3D 1 at ContextualFetch.pm line 49
    <- STORE('Taint' 0)=3D 1 at ContextualFetch.pm line 50
    <- execute('eijsdent')=3D 1 at ContextualFetch.pm line 51
 T  <- STORE('Taint' 1)=3D 1 at ContextualFetch.pm line 52
 T  <- fetchrow_array=3D ( undef undef ) [2 items] row1 at =
ContextualFetch.pm line 87
 T  <- finish=3D 1 at ContextualFetch.pm line 88
    <- disconnect_all=3D '' at DBI.pm line 674
!T  <- DESTROY(DBIx::ContextualFetch::st=3DHASH(0x83277ac))=3D undef =
during global destruction
!T  <- DESTROY(DBIx::ContextualFetch::st=3DHASH(0x832747c))=3D undef =
during global destruction
!T  <- DESTROY(DBIx::ContextualFetch::st=3DHASH(0x831d62c))=3D undef =
during global destruction
!T  <- DESTROY(DBIx::ContextualFetch::st=3DHASH(0x82e7a90))=3D undef =
during global destruction
!T  <- DESTROY(DBIx::ContextualFetch::db=3DHASH(0x830f88c))=3D undef =
during global destruction
!   <- DESTROY(DBI::dr=3DHASH(0x81dab2c))=3D (not implemented) during =
global destruction

------=_NextPart_000_0040_01C46E46.AA408E20
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1400" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Hi all,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>When i create a row in one table and =
then in=20
another, it doesn't fill out all the values of the second create, only =
the=20
primary key.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Below you'll find a listing of =
everything relevant=20
(separated bij bold headers). Any pointers would be =
appreciated.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Teun van Eijsden</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>The Netherlands</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2><STRONG>MySQL =
DDL:</STRONG></FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>create table nodes (nid VARCHAR(255) =
PRIMARY KEY,=20
author VARCHAR(255), date TIMESTAMP, content LONGBLOB, public=20
TINYINT);<BR>create table access (id INT AUTO_INCREMENT PRIMARY KEY, nid =

VARCHAR(255), uid VARCHAR(255), subscription TINYINT);<BR>create table =
users=20
(uid VARCHAR(255) PRIMARY KEY, email VARCHAR(255), employee=20
TINYINT);</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2><STRONG>perl =
script:</STRONG></FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>#!/cadappl/bin/perl -w</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>use strict;<BR>use =
Class::DBI;</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>DBI-&gt;trace(1 =3D&gt; =
"/tmp/logfile"); # trace all=20
the SQL code</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>package Doc::DBI;<BR>use base=20
'Class::DBI';<BR>Doc::DBI-&gt;connection('DBI:mysql:database=3Dhivedoc;ho=
st=3Dwebservername.com',=20
'hive', '*****');</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>package Doc::Access;<BR>use base=20
'Doc::DBI';<BR>Doc::Access-&gt;table('access');<BR>Doc::Access-&gt;column=
s(All=20
=3D&gt; qw/id nid uid subscription/);<BR>Doc::Access-&gt;has_a(nid =
=3D&gt;=20
'Doc::Node');</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>package Doc::Node;<BR>use base=20
'Doc::DBI';<BR>Doc::Node-&gt;table('nodes');<BR>Doc::Node-&gt;columns(All=
 =3D&gt;=20
qw/nid author date content public/);<BR>Doc::Node-&gt;has_a(author =
=3D&gt;=20
'Doc::User');<BR>Doc::Node-&gt;has_many(access =3D&gt;=20
'Doc::Access');</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>package Doc::User;<BR>use base=20
'Doc::DBI';<BR>Doc::User-&gt;table('users');<BR>Doc::User-&gt;columns(All=
 =3D&gt;=20
qw/uid email employee/);</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><BR><FONT face=3DArial size=3D2>package main;</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>#my $node =3D Doc::Node-&gt;create({nid =
=3D&gt;=20
"HomePage", author =3D&gt; "eijsdent", content =3D&gt; 'Silicon Hive =
rules', public=20
=3D&gt; 1});<BR>my $node =3D =
Doc::Node-&gt;retrieve("HomePage");<BR>print 'Author:=20
.';<BR>print $node-&gt;author;<BR>print ".\n";</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>my $user =3D =
Doc::User-&gt;create({'uid' =3D&gt;=20
'eijsdent', 'email' =3D&gt; </FONT><A =
href=3D"mailto:'jaap@xxxxx.xx'"><FONT=20
face=3DArial size=3D2>'jaap@xxxxx.xx'</FONT></A><FONT face=3DArial =
size=3D2>, 'employee'=20
=3D&gt; 1});<BR>#$user-&gt;update;<BR>print 'Email: .';<BR>print=20
$user-&gt;email;<BR>print ".\n";<BR></FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2><STRONG>Output:</STRONG></FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>./music.pl<BR>Author: .eijsdent.<BR>Use =
of=20
uninitialized value in print at ./music.pl line 42.<BR>Email: =
..</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2><STRONG>in MySQL =
database:</STRONG></FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>select * from users;</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>+----------+-------+----------+<BR>|=20
uid&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | email | employee=20
|<BR>+----------+-------+----------+<BR>| eijsdent | NULL&nbsp;=20
|&nbsp;&nbsp;&nbsp;&nbsp; NULL |<BR>+----------+-------+----------+<BR>1 =
row in=20
set (0.00 sec)<BR></DIV>
<DIV><BR></DIV></FONT>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2><STRONG>SQL Trace =
Log:</STRONG></FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;&nbsp; DBI 1.43-nothread =
default trace=20
level set to 0x0/1 (pid 22839)<BR>&nbsp;&nbsp;&nbsp; -&gt;=20
DBI-&gt;connect_cached(DBI:mysql:database=3Dhivedoc;host=3Dwebdb.natlab.r=
esearch.philips.com,=20
hive, ****)<BR>&nbsp;&nbsp;&nbsp; -&gt; DBI-&gt;install_driver(mysql) =
for linux=20
perl=3D5.006001 pid=3D22839 ruid=3D3982=20
euid=3D3982<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; install_driver: =
DBD::mysql=20
version 2.1026 loaded from=20
/cadappl/perl/5.6.1/lib/site_perl/5.6.1/i686-linux/DBD/mysql.pm<BR>&nbsp;=
&nbsp;&nbsp;=20
&lt;- install_driver=3D DBI::dr=3DHASH(0x81dab2c)<BR>&nbsp;&nbsp;&nbsp; =
&lt;-=20
connect_cached('database=3Dhivedoc;host=3Dwebdb.natlab.research.philips.c=
om' 'hive'=20
...)=3D DBI::db=3DHASH(0x830f88c) at DBI.pm line =
595<BR>&nbsp;&nbsp;&nbsp; &lt;-=20
STORE('RootClass' 'DBIx::ContextualFetch')=3D 1 at DBI.pm line=20
628<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
_set_isa([DBIx::ContextualFetch])<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
=20
DBIx::ContextualFetch::db::ISA skipped (already set to=20
DBI::db)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
DBIx::ContextualFetch::st::ISA=20
skipped (already set to DBI::st)<BR>&nbsp;&nbsp;&nbsp; &lt;- =
STORE('RaiseError'=20
1)=3D 1 at DBI.pm line 642<BR>&nbsp;&nbsp;&nbsp; &lt;- =
STORE('PrintError' 0)=3D 1 at=20
DBI.pm line 642<BR>&nbsp;&nbsp;&nbsp; &lt;- STORE('AutoCommit' 1)=3D 1 =
at DBI.pm=20
line 642<BR>&nbsp;T&nbsp; &lt;- STORE('Taint' 1)=3D 1 at DBI.pm line=20
645<BR>&nbsp;T&nbsp; &lt;- FETCH('Taint')=3D 1 at DBI.pm line =
645<BR>&nbsp;T&nbsp;=20
&lt;- STORE('Username' 'hive')=3D 1 at DBI.pm line 645<BR>&nbsp;T&nbsp; =
&lt;&gt;=20
FETCH('Username')=3D 'hive' ('Username' from cache) at DBI.pm line=20
645<BR>&nbsp;T&nbsp; &lt;- STORE('FetchHashKeyName' 'NAME_lc')=3D 1 at =
DBI.pm line=20
645<BR>&nbsp;T&nbsp; &lt;&gt; FETCH('FetchHashKeyName')=3D 'NAME_lc'=20
('FetchHashKeyName' from cache) at DBI.pm line 645<BR>&nbsp;T&nbsp; =
&lt;-=20
STORE('ShowErrorStatement' 1)=3D 1 at DBI.pm line 645<BR>&nbsp;T&nbsp; =
&lt;-=20
FETCH('ShowErrorStatement')=3D 1 at DBI.pm line 645<BR>&nbsp;T&nbsp; =
&lt;-=20
STORE('dbi_connect_method' 'connect_cached')=3D 1 at DBI.pm line=20
645<BR>&nbsp;T&nbsp; &lt;&gt; FETCH('dbi_connect_method')=3D =
'connect_cached'=20
('dbi_connect_method' from cache) at DBI.pm line 645<BR>&nbsp;T&nbsp; =
&lt;-=20
STORE('ChopBlanks' 1)=3D 1 at DBI.pm line 645<BR>&nbsp;T&nbsp; &lt;-=20
FETCH('ChopBlanks')=3D 1 at DBI.pm line 645<BR>&nbsp;&nbsp;&nbsp; &lt;- =
connect=3D=20
DBIx::ContextualFetch::db=3DHASH(0x830f88c)<BR>&nbsp;T&nbsp; &lt;-=20
STORE('dbi_connect_closure' CODE(0x830f934))=3D 1 at DBI.pm line=20
665<BR>&nbsp;T&nbsp; &lt;- prepare_cached('SELECT =
nid<BR>FROM&nbsp;&nbsp;=20
nodes<BR>WHERE&nbsp; nid =3D ?<BR>')=3D ( =
DBIx::ContextualFetch::st=3DHASH(0x82e7a90)=20
) [1 items] at DBI.pm line 391<BR>&nbsp;T&nbsp; &lt;- FETCH('Active')=3D =
'' at=20
DBI.pm line 1124<BR>&nbsp;T&nbsp; &lt;- FETCH('Taint')=3D 1 at =
ContextualFetch.pm=20
line 49<BR>&nbsp;&nbsp;&nbsp; &lt;- STORE('Taint' 0)=3D 1 at =
ContextualFetch.pm=20
line 50<BR>&nbsp;&nbsp;&nbsp; &lt;- execute('HomePage')=3D 1 at =
ContextualFetch.pm=20
line 51<BR>&nbsp;T&nbsp; &lt;- STORE('Taint' 1)=3D 1 at =
ContextualFetch.pm line=20
52<BR>&nbsp;T&nbsp; &lt;- FETCH('NAME_lc')=3D [ 'nid' ] at DBI.pm line=20
1125<BR>&nbsp;T&nbsp; &lt;- bind_columns(SCALAR(0x831d50c))=3D 1 at =
DBI.pm line=20
1125<BR>&nbsp;T&nbsp; &lt;- fetchrow_arrayref=3D [ 'HomePage' ] row1 at=20
ContextualFetch.pm line 59<BR>&nbsp;T&nbsp; &lt;- fetchrow_arrayref=3D =
undef row1=20
at ContextualFetch.pm line 59<BR>&nbsp;T&nbsp; &lt;- FETCH('Active')=3D =
1 at=20
DBI.pm line 316<BR>&nbsp;T&nbsp; &lt;- ping=3D 1 at DBI.pm line=20
316<BR>&nbsp;T&nbsp; &lt;- prepare_cached('SELECT content, author, date, =

public<BR>FROM&nbsp;&nbsp; nodes<BR>WHERE&nbsp; nid=3D?<BR>')=3D=20
DBIx::ContextualFetch::st=3DHASH(0x831d62c) at DBI.pm line =
391<BR>&nbsp;T&nbsp;=20
&lt;- FETCH('Taint')=3D 1 at ContextualFetch.pm line =
49<BR>&nbsp;&nbsp;&nbsp;=20
&lt;- STORE('Taint' 0)=3D 1 at ContextualFetch.pm line =
50<BR>&nbsp;&nbsp;&nbsp;=20
&lt;- execute('HomePage')=3D 1 at ContextualFetch.pm line =
51<BR>&nbsp;T&nbsp;=20
&lt;- STORE('Taint' 1)=3D 1 at ContextualFetch.pm line =
52<BR>&nbsp;T&nbsp; &lt;-=20
fetchrow_array=3D ( 'Silicon Hive rules' 'eijsdent' '20040720101349' '1' =
) [4=20
items] row1 at ContextualFetch.pm line 87<BR>&nbsp;T&nbsp; &lt;- =
finish=3D 1 at=20
ContextualFetch.pm line 88<BR>&nbsp;T&nbsp; &lt;- FETCH('Active')=3D 1 =
at DBI.pm=20
line 316<BR>&nbsp;T&nbsp; &lt;- ping=3D 1 at DBI.pm line =
316<BR>&nbsp;T&nbsp;=20
&lt;- prepare_cached('INSERT INTO users (uid)<BR>VALUES (?)<BR>')=3D=20
DBIx::ContextualFetch::st=3DHASH(0x832747c) at DBI.pm line =
391<BR>&nbsp;T&nbsp;=20
&lt;- FETCH('Taint')=3D 1 at ContextualFetch.pm line =
49<BR>&nbsp;&nbsp;&nbsp;=20
&lt;- STORE('Taint' 0)=3D 1 at ContextualFetch.pm line =
50<BR>&nbsp;&nbsp;&nbsp;=20
&lt;- execute('eijsdent')=3D 1 at ContextualFetch.pm line =
51<BR>&nbsp;T&nbsp;=20
&lt;- STORE('Taint' 1)=3D 1 at ContextualFetch.pm line =
52<BR>&nbsp;T&nbsp; &lt;-=20
FETCH('Active')=3D 1 at DBI.pm line 316<BR>&nbsp;T&nbsp; &lt;- ping=3D 1 =
at DBI.pm=20
line 316<BR>&nbsp;T&nbsp; &lt;- prepare_cached('SELECT employee,=20
email<BR>FROM&nbsp;&nbsp; users<BR>WHERE&nbsp; uid=3D?<BR>')=3D=20
DBIx::ContextualFetch::st=3DHASH(0x83277ac) at DBI.pm line =
391<BR>&nbsp;T&nbsp;=20
&lt;- FETCH('Taint')=3D 1 at ContextualFetch.pm line =
49<BR>&nbsp;&nbsp;&nbsp;=20
&lt;- STORE('Taint' 0)=3D 1 at ContextualFetch.pm line =
50<BR>&nbsp;&nbsp;&nbsp;=20
&lt;- execute('eijsdent')=3D 1 at ContextualFetch.pm line =
51<BR>&nbsp;T&nbsp;=20
&lt;- STORE('Taint' 1)=3D 1 at ContextualFetch.pm line =
52<BR>&nbsp;T&nbsp; &lt;-=20
fetchrow_array=3D ( undef undef ) [2 items] row1 at ContextualFetch.pm =
line=20
87<BR>&nbsp;T&nbsp; &lt;- finish=3D 1 at ContextualFetch.pm line=20
88<BR>&nbsp;&nbsp;&nbsp; &lt;- disconnect_all=3D '' at DBI.pm line =
674<BR>!T&nbsp;=20
&lt;- DESTROY(DBIx::ContextualFetch::st=3DHASH(0x83277ac))=3D undef =
during global=20
destruction<BR>!T&nbsp; &lt;-=20
DESTROY(DBIx::ContextualFetch::st=3DHASH(0x832747c))=3D undef during =
global=20
destruction<BR>!T&nbsp; &lt;-=20
DESTROY(DBIx::ContextualFetch::st=3DHASH(0x831d62c))=3D undef during =
global=20
destruction<BR>!T&nbsp; &lt;-=20
DESTROY(DBIx::ContextualFetch::st=3DHASH(0x82e7a90))=3D undef during =
global=20
destruction<BR>!T&nbsp; &lt;-=20
DESTROY(DBIx::ContextualFetch::db=3DHASH(0x830f88c))=3D undef during =
global=20
destruction<BR>!&nbsp;&nbsp; &lt;- DESTROY(DBI::dr=3DHASH(0x81dab2c))=3D =
(not=20
implemented) during global destruction<BR></DIV></FONT></BODY></HTML>

------=_NextPart_000_0040_01C46E46.AA408E20--


create after create or retrievemore mus doesnt work
Teun van Eijsden 08:45 on 20 Jul 2004

Generated at 11:34 on 01 Dec 2004 by mariachi v0.52