From: Eric D. <eri...@ja...> - 2002-05-03 21:13:22
|
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......... i18n wrote: >I still get the list but I am still using Bender but .... > >Have you checked the contents of the DB directly in the appropriate tables to compare all field values between the old and new IDs? maybe there is an unexpected difference. > >Barry > >At 01:08 PM 5/3/2002 -0700, you wrote: > > >>Ok, some things have stablized. The thing that is driving me nuts is that my usual user id, 2, doesn't work at all. I log in with the password, and nothing works. No admin menus. The "Page generated by a flock of geeze" thing has a () next to it. It is messed up. >> >>However, if I create a NEW user, and give it admin rights, it works fine........... >> >>Am I missing something? Does anyone still get this list? >> >> > > >_______________________________________________________________ > >Have big pipes? SourceForge.net is looking for download mirrors. We supply >the hardware. You get the recognition. Email Us: ban...@so... >_______________________________________________ >Slashcode-development mailing list >Sla...@li... >https://lists.sourceforge.net/lists/listinfo/slashcode-development > > -- ----- Bureaucrats cut red tape, lengthwise Eric Dannewitz - Adventurer, saxophonist, good-timer (crook? quite possibly), clarinetist, manic self-publicist, part-time flautist(flutist?), macintosher, and often thought to be completely out to lunch. http://www.jazz-sax.com -- ----- Bureaucrats cut red tape, lengthwise Eric Dannewitz - Adventurer, saxophonist, good-timer (crook? quite possibly), clarinetist, manic self-publicist, part-time flautist(flutist?), macintosher, and often thought to be completely out to lunch. http://www.jazz-sax.com |
From: Clifton W. <cl...@sl...> - 2002-06-03 02:27:56
|
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 |
From: Eric D. <eri...@ja...> - 2002-06-03 02:37:13
|
Again, this was over a month ago. I did do that, and it made no difference. I would be user (). I ended up purging the user database, and keeping the uids of people who submitted comments. 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 > > -- ----- Bureaucrats cut red tape, lengthwise Eric Dannewitz - Adventurer, saxophonist, good-timer (crook? quite possibly), clarinetist, manic self-publicist, part-time flautist(flutist?), macintosher, and often thought to be completely out to lunch. http://www.jazz-sax.com |
From: Jesse H. <je...@op...> - 2002-06-13 17:09:56
|
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 > |