Jørn Wildt
Dealing with Zikula and other interesting stuff
Is pagesetter 6.3.0 PHP 5.2.x compliant? (Incorrect integer value)
-
- 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