domain cross talk...?

[prev] [thread] [next] [Date index for 2004/10/06]

--Apple-Mail-29-626447536
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=ISO-8859-1;
	format=flowed

I have 3 sites I now use CDBI with. Upon adding the 2nd site I had no=20
issue between the two sites. Now I have a third and I copied everything=20=

from the 2nd site to the original site as a starting point, including=20
my code for CDBI stuff, but then made the changes for the 3rd site. I=20
am confident that everything is pointing to its own, but now I get=20
messages like these:

error:=A0
DBD::mysql::st execute failed: Unknown column 'phone_1' in 'field list'=20=

[for Statement "SELECT username, password, group_id, create_date,=20
edit_date, first_name, last_name, company_id, email, phone_1, phone_2,=20=

last_login_date, address, city, state, zip
FROM users
WHERE id=3D?
"] at /usr/local/lib/perl5/site_perl/5.8.0/DBIx/ContextualFetch.pm line=20=

51.

context:=A0


...=A0

47:=A0
sub _untaint_execute {

48:=A0
  my $sth =3D shift;

49:=A0
  my $old_value =3D $sth->{Taint};

50:=A0
  $sth->{Taint} =3D 0;

51:=A0
  my $ret =3D $sth->SUPER::execute(@_);

52:=A0
  $sth->{Taint} =3D $old_value;

53:=A0
  return $ret;

54:=A0
}

55:=A0

...=A0

code stack:=A0
  /usr/local/lib/perl5/site_perl/5.8.0/DBIx/ContextualFetch.pm:51
  /usr/local/lib/perl5/site_perl/5.8.0/DBIx/ContextualFetch.pm:31
  /usr/local/lib/perl5/site_perl/5.8.0/DBIx/ContextualFetch.pm:86
  /usr/local/lib/perl5/site_perl/5.8.0/Class/DBI.pm:852
  /usr/local/lib/perl5/site_perl/5.8.0/Class/DBI.pm:839
  /usr/local/lib/perl5/site_perl/5.8.0/Class/Accessor.pm:350
  /home/webtree/home/www.pickoptions.com/html/o/siteMenu.mas:18
  /home/webtree/home/www.pickoptions.com/html/autohandler:52



So "phone_1" is in this database but not in the other. In the other it=20=

is just "phone". I don't know if there is some caching going on or=20
what. Can I turn that off? Any ideas?


Also, the other day I noticed a has_a attribute that pointed to a=20
user's company would switch to a different company. That was real=20
weird. I used Data::Dumper and everything was the exact same except the=20=

company_id attribute.

Any help is appreciated!

-Michael=

--Apple-Mail-29-626447536
Content-Transfer-Encoding: quoted-printable
Content-Type: text/enriched;
	charset=ISO-8859-1

I have 3 sites I now use CDBI with. Upon adding the 2nd site I had no
issue between the two sites. Now I have a third and I copied
everything from the 2nd site to the original site as a starting point,
including my code for CDBI stuff, but then made the changes for the
3rd site. I am confident that everything is pointing to its own, but
now I get messages like these:


=
<bold><fontfamily><param>Verdana</param><smaller>error:</smaller></fontfam=
ily></bold><fontfamily><param>Verdana</param><smaller>=A0

DBD::mysql::st execute failed: Unknown column 'phone_1' in 'field
list' [for Statement "SELECT username, password, group_id,
create_date, edit_date, first_name, last_name, company_id, email,
phone_1, phone_2, last_login_date, address, city, state, zip

FROM users

WHERE id=3D?

"] at /usr/local/lib/perl5/site_perl/5.8.0/DBIx/ContextualFetch.pm
line 51.


<bold>context:</bold>=A0



<bold>...</bold>=A0


<bold>47:</bold>=A0

sub _untaint_execute {


<bold>48:</bold>=A0

 my $sth =3D shift;


<bold>49:</bold>=A0

 my $old_value =3D $sth->{Taint};


<bold>50:</bold>=A0

 $sth->{Taint} =3D 0;


<bold>51:</bold>=A0

<color><param>FFFF,0000,0000</param> my $ret =3D
$sth->SUPER::execute(@_);</color>


<bold>52:</bold>=A0

 $sth->{Taint} =3D $old_value;


<bold>53:</bold>=A0

 return $ret;


<bold>54:</bold>=A0

}


<bold>55:</bold>=A0


<bold>...</bold>=A0


<bold>code stack:</bold>=A0

 /usr/local/lib/perl5/site_perl/5.8.0/DBIx/ContextualFetch.pm:51

 /usr/local/lib/perl5/site_perl/5.8.0/DBIx/ContextualFetch.pm:31

 /usr/local/lib/perl5/site_perl/5.8.0/DBIx/ContextualFetch.pm:86

 /usr/local/lib/perl5/site_perl/5.8.0/Class/DBI.pm:852

 /usr/local/lib/perl5/site_perl/5.8.0/Class/DBI.pm:839

 /usr/local/lib/perl5/site_perl/5.8.0/Class/Accessor.pm:350

 /home/webtree/home/www.pickoptions.com/html/o/siteMenu.mas:18

 /home/webtree/home/www.pickoptions.com/html/autohandler:52




</smaller></fontfamily>So "phone_1" is in this database but not in the
other. In the other it is just "phone". I don't know if there is some
caching going on or what. Can I turn that off? Any ideas?



Also, the other day I noticed a has_a attribute that pointed to a
user's company would switch to a different company. That was real
weird. I used Data::Dumper and everything was the exact same except
the company_id attribute.


Any help is appreciated!


-Michael=

--Apple-Mail-29-626447536--