Support Forum

I just applied the 0.763 patch to my test site, and core news now fails with an SQL error:

DB Error: getArticles: 1052: Column 'pn_counter' in field list is ambiguous

This is Mysql 5.0.22 , however global.sql_mode is set to 'MYSQL40';

Here is the full debug output:

(mysql): SELECT nuke_stories.pn_aid AS "aid", nuke_stories.pn_bodytext AS "bodytext", nuke_stories_cat.pn_themeoverride AS "catthemeoverride", nuke_stories.pn_catid AS "cid", nuke_stories_cat.pn_title AS "cattitle", nuke_stories.pn_comments AS "comments", nuke_stories.pn_counter AS "counter", nuke_stories.pn_hometext AS "hometext", nuke_stories.pn_informant AS "informant", nuke_stories.pn_notes AS "notes", nuke_stories.pn_sid AS "sid", nuke_stories.pn_themeoverride AS "themeoverride", pn_topicid AS "tid", nuke_stories.pn_time AS "time", nuke_stories.pn_title AS "title", pn_topicname AS "topicname", pn_topicimage AS "topicimage", pn_topictext AS "topictext", pn_counter AS "tcounter", nuke_stories.pn_time AS "unixtime", nuke_stories.pn_withcomm AS "withcomm", nuke_stories.pn_format_type AS "format_type" FROM nuke_stories LEFT JOIN nuke_stories_cat ON nuke_stories.pn_catid = nuke_stories_cat.pn_catid LEFT JOIN nuke_topics ON nuke_stories.pn_topic = pn_topicid WHERE (nuke_stories.pn_language='eng' OR nuke_stories.pn_language='') AND nuke_stories.pn_time LIKE '%2006-10-17%' AND nuke_stories.pn_ihome = 0 AND nuke_stories.pn_counter > 0 ORDER BY nuke_stories.pn_counter DESC LIMIT 0,1

1052: Column 'pn_counter' in field list is ambiguous

ADOConnection._Execute(SELECT nuke_stories.pn_aid AS "aid",
nuke_stories.pn_bodytext AS "bodytext",
nuke_stor..., false) % line 861, file: adodb.inc.php
ADOConnection.Execute(SELECT nuke_stories.pn_aid AS "aid",
nuke_stories.pn_bodytext AS "bodytext",
nuke_stor..., false) % line 492, file: adodb-mysql.inc.php
ADODB_mysql.SelectLimit(SELECT nuke_stories.pn_aid AS "aid",
nuke_stories.pn_bodytext AS "bodytext",
nuke_stor..., 1, 0) % line 124, file: funcs.php
getArticles(nuke_stories.pn_time LIKE '%2006-10-17%'
AND nuke_stories.pn_ihome = 0
..., nuke_stories.pn_counter DESC, 1) % line 73, file: big.php
blocks_big_block(Array[14]) % line 138, file: pnBlocks.php



edited by: ccandreva, Oct 25, 2006 - 09:51 PM

I have the same problem

remove /modules/Topics/pntable.php

-----
regards from germany
..::[PostNuke CMS]::.. ..::[SEO-Blog]::.. ..::[CMS Sicherheit]::..

It works. Thanks !

Here too. Thanks !

here three thanks!

Well by mistake i removed the other line and now its all going haywhere.. can you please tell m how to restore it.

-----
Data Recovery services
recupero dati

i guess you can replace the "corrupted" file(s) with clean one(s).

-----
- Mateo T. -
Mis principios... son mis fines