Log in | Register | Lost password

Bottom
Is pagesetter 6.3.0 PHP 5.2.x compliant? (Incorrect integer value)
  • Posted: 08.05.2007, 15:38
     
    Converted
    rank:
    12
    registered:
     March 2009
    Status:
    offline
    last visit:
    Posts:
    0
    I just recently moved my site from a development server to a production server. The transfer appears to be ok until I tried to add or update a pub type. If I try and change the fields for a pub type I get an error similar to this:

    Quote

    D:\...DirectoryPath...\modules\pagesetter\pnadminapi.php(756): "pagesetterCreateFieldType" failed: Incorrect integer value: '' for column 'pg_istitle' at row 1 while executing: INSERT INTO pn__pagesetter_pubfields ( pn__pagesetter_pubfields.pg_tid, pn__pagesetter_pubfields.pg_name, pn__pagesetter_pubfields.pg_title, pn__pagesetter_pubfields.pg_description, pn__pagesetter_pubfields.pg_type, pn__pagesetter_pubfields.pg_typedata, pn__pagesetter_pubfields.pg_istitle, pn__pagesetter_pubfields.pg_ispageable, pn__pagesetter_pubfields.pg_issearchable, pn__pagesetter_pubfields.pg_ismandatory, pn__pagesetter_pubfields.pg_lineno) VALUES ( '33', 'text', 'Text', 'Text', '2', '', '', '0', '1', '1', '1' )


    The only differences I can see from my dev to prod server is the versions of php and mysql. The dev server has MySql 5.0.27 and PHP 5.1.6. The production server is running MySql 5.0.37 and 5.2.2 PHP.

    I ran into some issues related to PHP 5.2 with logging in to my pn site, but found a fix for that on the pn forums. Just curious if this is another issue with PHP 5.2.x and/or pn7.6.2

    Thanks,
    shane



    edited by: studioforty5, May 08, 2007 - 04:39 PM
  • Posted: 08.05.2007, 20:00
     
    Converted
    rank:
    12
    registered:
     March 2009
    Status:
    offline
    last visit:
    Posts:
    0
    Apparently I didn't have the latest 6.3.0 release. The version I was using didn't have the bugfix for Incorrect integer.

    Downloaded latest release uploaded the files and all is well.

Template courtesy of Designs By Darren.