Log in | Register | Lost password

Bottom
Column 'pn_topicname' in field list is ambiguous
  • Posted: 04.10.2008, 23:16
     
    Converted
    rank:
    12
    registered:
     March 2009
    Status:
    offline
    last visit:
    Posts:
    0
    I am running pagesetter 6.3 on Zikula 1.0.2 and have uploaded all recently (last two yeras) changed files from http://elfisk.cvs.sourceforge.net/viewvc/elfisk/pagesetter/ and http://elfisk.cvs.sourceforge.net/viewvc/elfisk/topicaccess/

    After activating Topicaccess in Pagesetter I get this error (for users only, it does not occur when logged in as Admin):

    Code

    "getPubList" failed: Column 'pn_topicname' in field list is ambiguous while executing: ... pn_topicname ...


    Any suggestions?





    edited by: thilo, Oct 10, 2008 - 05:33 PM
    Top
  • Posted: 07.10.2008, 08:01
     
    Converted
    rank:
    12
    registered:
     March 2009
    Status:
    offline
    last visit:
    Posts:
    0
    After a lot of testing I think this error is related to the migration to MySQL 5. I now will try the hard tour and re-install pagesetter and re-import all its tables and do a lot of manual corrections.
    Top
  • Posted: 10.10.2008, 16:32
     
    Converted
    rank:
    12
    registered:
     March 2009
    Status:
    offline
    last visit:
    Posts:
    0
    No, it is a bug in pnuserapi.php on line 198 " $topicsColumn[topicname],"
    This line must be deleted and it works!
    Top

Template courtesy of Designs By Darren.