Re: [Slashcode-development] more 2.2.5 to cvs problems]

[Jesse H. <je...@op...>]

yesterday i tried my first stab at moving from 2.2.5 to cvs. i tried to
take some notes, explicitly focusing on filling in sql/mysql/upgrades and
i will post said notes on my user journal on slashcode.com shortly.

however i wanted to continue this thread, as it was also the primary
problem i ran into after upgrading. i had the same types of errors that
Eric D. describes. i also ran the command line cliff suggests below, and
on the admin user created with this new 2.3 install i received all of that
users info. however when i ran the same line on a uid that i imported from
the 2.2.5 site i get:

$VAR1 = undef;

looking through my heavily populated error log i can surmise that some of
the problems/errors may relate to zoo as my past userbase didn't have
information like the people column

also seeing erros like this:

DBD::mysql::db selectall_arrayref failed: You have an error in your SQL
syntax near '' at line 1
 at /usr/local/lib/perl/5.6.1/Slash/DB/Utility.pm line 408.
 [Thu Jun 13 01:30:44 2002] [error]

/users.pl:Slash::DB::MySQL:/usr/local/lib/perl/5.6.1/Slash/DB/MySQL.pm:5445:SELECT
name,value FROM
users_acl WHERE uid=
 [Thu Jun 13 01:30:44 2002] [error] Which was called
by:Apache::ROOTlearning_2eopenflows_2eorg::users_2epl:/usr/local/slash/site/learning.openflows.org
/htdocs/users.pl:733:SELECT name,value FROM users_acl WHERE uid=

as well as

DBD::mysql::st execute failed: You have an error in your SQL syntax near
'AND users_index.uid= AND
users_info.uid= AND users_hits.uid= AND users_comments.' at line 1 at
/usr/local/lib/perl/5.6.1/Slash/DB/Utility.pm line 351.
[Thu Jun 13 01:30:41 2002] [error]
/users.pl:Slash::DB::MySQL:/usr/local/lib/perl/5.6.1/Slash/DB/MySQL.pm:5432:SELECT
* FROM
users,users_index,users_info,users_hits,users_comments,users_prefs WHERE
users.uid= AND
users_index.uid= AND users_info.uid= AND users_hits.uid= AND
users_comments.uid= AND
users_prefs.uid=
[Thu Jun 13 01:30:41 2002] [error] Which was called
by:Apache::ROOTlearning_2eopenflows_2eorg::users_2epl:/usr/local/slash/site/learning.openflows.org
/htdocs/users.pl:733:SELECT * FROM
users,users_index,users_info,users_hits,users_comments,users_prefs
WHERE users.uid= AND users_index.uid= AND users_info.uid= AND
users_hits.uid= AND users_comments.uid=
AND users_prefs.uid=


anyhow, will keep on playing and will write up my notes shortly

jesse/laotan

  1:06pm  up 142 days,  4:43, 16 users,  load average: 0.21, 0.30, 0.19

On Sun, 2 Jun 2002, Clifton Wood wrote:

> On Friday 03 May 2002 17:13, Eric Dannewitz wrote:
> > yes, I have.
> >
> > The big problem seems to be users created before I updated the software.
> > They can't seem to login or anything. Nothing works right for them. Even
> > admin users.
> >
> > If you create a NEW user, then everything is great. Works fine. I'm
> > trying to figure out what is going on but nothing so far.........
>
> Weird.
>
> Try this, delete all of the cookies associated with your old users, then
> re-login to the site again.
>
> Just on a lark, could you show me what you get when you do the following:
>
> "perl -MSlash::Test=<your virtual user here> -le 'print
> Dumper($slashdb->getUser(2)'"
>
> - Cliff
>
> _______________________________________________________________
>
> Don't miss the 2002 Sprint PCS Application Developer's Conference
> August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm
>
> _______________________________________________
> Slashcode-development mailing list
> Sla...@li...
> https://lists.sourceforge.net/lists/listinfo/slashcode-development
>