Jørn Wildt

Hallo,

I just tried to fill my first Publication Typ with Content. It failed.

Using the New-Button causes the following error:

C:\xampp\htdocs\workspace\Postnuke\html\modules\pagesetter\pnuserapi.php(372): "getPubList" failed: 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 ' pg_revision, pg_online, ' at line 7 while executing: SELECT pn_pagesetter_pubdata1.pg_id, pn_pagesetter_pubdata1.pg_pid, pg_author, UNIX_TIMESTAMP(pg_created) as pg_created, pg_approvalState, , pg_revision, pg_online, pg_field1 FROM pn_pagesetter_pubdata1 LEFT JOIN ON pg_topic = LEFT JOIN pn_pagesetter_pubheader ON pg_tid = 1 AND pn_pagesetter_pubheader.pg_pid = pn_pagesetter_pubdata1.pg_pid WHERE pg_indepot = 0 ORDER BY pg_created DESC, pg_revision

I tried a new installation of pagesetter without any success.
I'm using Pagesetter 6.3.0, MySQL 5.0.37 and postnuke 0.8

Best regards
Peter