Zikula Community

• mesteele101
  
  

  • Rank: Helper
  • Registered: Sep 19, 2003
  • Last visit: May 25, 2010
  • Posts: 612

  Posted: Jul 08, 2011 - 06:59 AM

  I just noticed that I'm getting a LOT of these errors in the error.log of the root of my website.
  
  [08-Jul-2011 06:17:03] DB Error: Column 'pn_cat_id' in field list is ambiguous
  
  Anyone with an idea why?

  • 
  •  
• nestormateo
  
  

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

  Posted: Jul 09, 2011 - 10:57 AM

  Seems like two of your modules (or maybe an old one) has that field (pn_cat_id) on two different tables and there's a SQL query not clearly structured that is ambiguous querying that field.
  
  or maybe a custom script?
  
  --
  - Mateo T. -
  Mis principios... son mis fines

  • 
  •  
• mesteele101
  
  

  • Rank: Helper
  • Registered: Sep 19, 2003
  • Last visit: May 25, 2010
  • Posts: 612

  Posted: Jul 09, 2011 - 11:20 AM

  The below is the only entry in the complete Zikula folder in a file called Pntables.php, and is located in the root of my WebLinks folder?
  
  

  Code

  // Full table definition
      $pntable['links_categories'] = DBUtil::getLimitedTablename('links_categories');
      $pntable['links_categories_column']     = array ('cat_id'       => 'pn_cat_id',
                                                       'parent_id'    => 'pn_parent_id',
                                                       'title'        => 'pn_title',
                                                       'cdescription' => 'pn_description');

  
  
  
  
  Edited by mesteele101 on Jul 09, 2011 - 06:23 PM.

  • 
  •  
• mesteele101
  
  

  • Rank: Helper
  • Registered: Sep 19, 2003
  • Last visit: May 25, 2010
  • Posts: 612

  Posted: Jul 09, 2011 - 11:57 AM

  There was a newer version of Weblinks out so I just updated, and deleted the error log. We'll see how that goes?
  
  Thanks for pointing me into the right direction...

  • 
  •  
• mesteele101
  
  

  • Rank: Helper
  • Registered: Sep 19, 2003
  • Last visit: May 25, 2010
  • Posts: 612

  Posted: Jul 09, 2011 - 01:00 PM

  Over an hour and so far and there has been no error log created.

  • 
  •  
•  
•  

Users on-line

• 0 users

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