Zikula Community

• craigh
  
  

  • Rank: Developer
  • Registered: Jun 16, 2003
  • Last visit: May 29, 2010
  • Posts: 1966

  Posted: Apr 07, 2009 - 11:50 PM

  I am working on 'customizing' a module I like and when visiting the 'user' pageas an anonymous (not logged in) user I get the following SQL error. I'm guessing it comes from possibly a permissions check or a pnUserGet... function, but I am having trouble tracking it down. I was hoping someone would recognize the SQL call and be able to point me in a direction. note: I can see the error in the where clause, but I need to know where to fix the code...
  
  

  Code

  You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '>= '1' ORDER BY ASC' at line 1
  select pn_prop_id AS "prop_id",pn_prop_label AS "prop_label",pn_prop_dtype AS "prop_dtype",pn_prop_length AS "prop_length",pn_prop_weight AS "prop_weight",pn_prop_validation AS "prop_validation" from nuke_user_property AS tbl where >= '1' order by ASC

  
  
  
  
  edited by: craigh, Apr 08, 2009 - 06:51 AM

  • 
  •  
• HalbrookTech
  
  

  • Rank: Developer
  • Registered: Dec 31, 1969
  • Last visit: Jun 01, 2010
  • Posts: 6859

  Posted: Apr 08, 2009 - 04:17 AM

  It's probably in the pnuserapi.php file. I believe that's usually where SQLs are built and run at least. What module is it?
  
  --
  Home Page | Find on Facebook | Follow on Twitter
  

  • 
  •  
• nestormateo
  
  

  • Rank: Team Member
  • Registered: Sep 06, 2006
  • Last visit: May 09, 2010
  • Posts: 2446

  Posted: Apr 08, 2009 - 11:13 AM

  Looks like Profile module
  and missing fields in the WHERE and ORDER BY clause...
  missing pntables, must load them before that SQL or something
  
  --
  - Mateo T. -
  Mis principios... son mis fines

  • 
  •  
• craigh
  
  

  • Rank: Developer
  • Registered: Jun 16, 2003
  • Last visit: May 29, 2010
  • Posts: 1966

  Posted: Apr 09, 2009 - 12:34 AM

  I agree, the profile module could be the culprit - or the difference between the old way (PN764) and the current way (ZK) of obtaining user information. I don't believe the SQL call is in my module (which I'm not naming on purpose ) I think what is happening is my old module (which I'm working on upgrading) is making a call with a pnUserGet... type function that now requires some arguments but is not being provided the appropriate arguments and so fails.
  
  I should mention that the call only fails when the page is visited as an ANONYMOUS user - logged in users do not have the error - so that tells me it is session-related or user related.... I've been searching on and off since I posted this, but still can't find it.... any other ideas?

  • 
  •  
•  
•  

Users on-line

• 0 users

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