Zikula Community

• **unknown user**
  
  

  • Rank: Helper
  • Registered: Mar 16, 2002
  • Last visit: May 18, 2010
  • Posts: 985

  Posted: Aug 22, 2010 - 09:14 PM

  I've encountered a strange problem, I've upgraded to 1.2.4 and I can't no longer log-in to my site.
  

  Code

  Sorry! Unrecognised user name or password. Please try again.

  
  Although in the database the nickname is there.
  I have a feeling the Profile module has something to do with it, but I just can't pinpoint it...
  

  Code

  Unknown column 'pn_prop_modname' in 'field list'

  
  is also a common error I get...
  
  - Igor

  • 
  •  
• **unknown user**
  
  

  • Rank: Helper
  • Registered: Mar 16, 2002
  • Last visit: May 18, 2010
  • Posts: 985

  Posted: Aug 22, 2010 - 09:22 PM

  Sorry, The title is not accurate, I first upgraded from 1.1.2 to 1.2.3 which went fine, it was after upgrading from 1.2.3 to 1.2.4 the problem appeared.
  
  - Igor

  • 
  •  
• **unknown user**
  
  

  • Rank: Helper
  • Registered: Mar 16, 2002
  • Last visit: May 18, 2010
  • Posts: 985

  Posted: Aug 24, 2010 - 02:49 AM

  1 Problem solved so far...
  it seems the upgrade deleted two columns in the table _PREFIX_user_property, the 'pn_prop_modname' and 'pn_prop_attribute_name', after adding them again with a back-up, the Profile module works OK.
  However I noticed on a fresh 1.2.4 install the table _user_property has no column 'pn_prop_modname' anymore.
  
  Logging still not working however...
  
  - Igor

  • 
  •  
• TkdAndi
  
  

  • Rank: Registered User
  • Registered: Aug 05, 2006
  • Last visit: May 28, 2009
  • Posts: 9

  Posted: Aug 24, 2010 - 09:15 AM

  Change the following code in the function pnVarValidate
  
  

  Code

  if ($type == 'uname') {
          // check for invalid characters
          if (preg_match('/[^\p{L}\p{N}_\.]/u', $var)) {
              return false;
          }
      }

  
  
  back to the one which is used for v1.2.3
  
  

  Code

  if ($type == 'uname') {
          // check for invalid characters
          if (strstr($var, chr(160)) || strstr($var, chr(173))) {
              return false;
          }
      }

  
  
  That worked for me.

  • 
  •  
• AllKnightAccess
  
  

  • Rank: Team Member
  • Registered: Mar 15, 2004
  • Last visit: May 26, 2010
  • Posts: 112

  Posted: Aug 24, 2010 - 06:54 PM

  Please report all bugs, so they can be properly tracked and addressed:
  
  http://code.zikula.org/core/newticket
  
  Also, read the post "Submitting Bug Report Tickets That Get Results":
  
  http://]http://blog.…Get-Results.71.html
  
  Thanks.

  • 
  •  
• **unknown user**
  
  

  • Rank: Helper
  • Registered: Mar 16, 2002
  • Last visit: May 18, 2010
  • Posts: 985

  Posted: Aug 24, 2010 - 09:53 PM

  TkdAndi

  Change the following code in the function pnVarValidate
  

  Code

  if ($type == 'uname') {
          // check for invalid characters
          if (strstr($var, chr(160)) || strstr($var, chr(173))) {
              return false;
          }
      }

  That worked for me.

  That did the trick indeed! Thank you, never occured to me to check there
  
  
  
  

  AllKnightAccess

  Please report all bugs, so they can be properly tracked and addressed:
  Thanks.

  I understand, but it takes ages to load just one page on the tracker, and now I got this when I try to log-in:
  

  Code

  Traceback (most recent call last):
  etc...

  and blank......
  
  - Igor

  • 
  •  
• thilowitt
  
  

  • Rank: Freshman
  • Registered: Dec 31, 1969
  • Last visit: Apr 13, 2010
  • Posts: 62

  Posted: Aug 24, 2010 - 11:34 PM

  Quote

  That did the trick indeed!

  
  In which file do we have to do the change?

  • 
  •  
• **unknown user**
  
  

  • Rank: Helper
  • Registered: Mar 16, 2002
  • Last visit: May 18, 2010
  • Posts: 985

  Posted: Aug 25, 2010 - 12:54 AM

  includes\pnAPI.php
  line 890
  
  - Igor

  • 
  •  
• thilowitt
  
  

  • Rank: Freshman
  • Registered: Dec 31, 1969
  • Last visit: Apr 13, 2010
  • Posts: 62

  Posted: Aug 25, 2010 - 02:58 AM

  It does not help in my case: no chance to log in!

  • 
  •  
• Herr.Vorragend
  
  

  • Rank: Team Member
  • Registered: Jul 15, 2004
  • Last visit: May 27, 2010
  • Posts: 277

  Posted: Aug 25, 2010 - 03:51 AM

  We have problems on support.zikula.de, too. The user "Petzi-Juist" cannot log in.

  • 
  •  
• TkdAndi
  
  

  • Rank: Registered User
  • Registered: Aug 05, 2006
  • Last visit: May 28, 2009
  • Posts: 9

  Posted: Aug 25, 2010 - 05:30 AM

  I created a ticket (#2502).

  • 
  •  
• Petzi-Juist
  
  

  • Rank: Developer
  • Registered: Jan 24, 2004
  • Last visit: Oct 21, 2009
  • Posts: 121

  Posted: Aug 25, 2010 - 05:41 AM

  Grrr....
  Can't login at the Cozi at the moment.
  Maybe it help someone to fix it...
  

  Code

  <?php
  $c = 'Petzi-Juist';
  echo "Petzi-Juist = ";
  echo preg_match('/[^\p{L}\p{N}_\.]/u', $c); // 1
  echo "< br />";
  $c = 'PetziJuist';
  echo "PetziJuist = ";
  echo preg_match('/[^\p{L}\p{N}_\.]/u', $c); // 0
  echo "< br />";
  $c = 'Petzi-Juist';
  echo "Petzi-Juist = ";
  echo preg_match('/[^\p{L}\p{N}_\.\-]/u', $c); // 0
  ?>

  
  
  Regards Petzi
  
  
  
  Edited by Petzi-Juist on Aug 25, 2010 - 06:46 PM.
  
  --
  Petzi-Juist :: ... welcome to my digital world ...

  • 
  •  
• **unknown user**
  
  

  • Rank: Helper
  • Registered: Mar 16, 2002
  • Last visit: May 18, 2010
  • Posts: 985

  Posted: Aug 25, 2010 - 09:32 PM

  thilowitt

  It does not help in my case: no chance to log in!

  
  I have no clue either then, but maybe you could try delete all files in
  pnRender/xxx_compiled
  pnRender/xxx_cache
  and delete the cookies for your site...
  Maybe, just maybe also empty your table .PREFIX._session_info
  
  - Igor

  • 
  •  
• rmburkhead
  
  

  • Rank: Team Member
  • Registered: Jun 10, 2008
  • Last visit: May 24, 2010
  • Posts: 43

  Posted: Aug 26, 2010 - 11:06 AM

  I am looking into Ticket #2502. I might have some questions for those of you who have run into this issue. I will be using the ticket to ask these questions, so if you have been affected, please monitor #2502 if possible.
  
  Petzi: The hyphen (a.k.a. the dash, the '-' character) was specifically discussed when we were determining what characters to allow. Unfortunately, the decision was made to not allow it—although we were "on the fence" about it. I will add it as a legal character either under #2502 or under a separate ticket depending on whether the actual root issue with #2502 affects 1.3 as well.
  
  --
  - Robert
  
  
  
  
  

  • 
  •  
• damon
  
  

  • Rank: Softmore
  • Registered: Dec 31, 1969
  • Last visit: May 25, 2010
  • Posts: 326

  Posted: Aug 26, 2010 - 03:18 PM

  rmburkhead

  The hyphen (a.k.a. the dash, the '-' character) was specifically discussed when we were determining what characters to allow.

  
  
  What characters are on the allowed list? I've got lots of users with either/both periods, dashes and maybe other punctuation type characters in their usernames.
  
  --
  Damon
  Catamaran Sailing at TheBeachcats.com

  • 
  •  
•  
•  

Users on-line

• eledril

This list is based on users active over the last 60 minutes.