[TYPO3-dev] Help MYSQL5.0 error when trying to insert first page using exec_INSERTquery.

[ries van Twisk]

Do you happen to run mysql in strict mode?

Ries
On Jan 28, 2008, at 5:49 AM, McCarry, Frank wrote:

> Hi,
>
> I've subscribed to your mail list and have submitted this ticket but  
> it
> was not added to the dev typo3 mail list. Is there another part of the
> registration process I need to do?
>
> This is my email address I subscribed with fmccarry at atg.com
>
> Thanks
> Frank.
>
>
> ________________________________
>
> From: McCarry, Frank
> Sent: Friday, January 25, 2008 4:15 PM
> To: 'typo3-dev at lists.netfielders.de'
> Subject: Help MYSQL5.0 error when trying to insert first page using
> exec_INSERTquery.
>
>
> System:-
> TYPO3 4.1.5
> MySQL 5.0
> Windows XP
> PHP 5.2
> Apache 2.2
> Downloaded test site 'dummy-4.1.5'
>
> Issue:-
> When trying to create my first page into dummy-4.1.5 (root home page)
> using 'Create new page' I got an insert to DB failed error. I know  
> what
> the error is;Typo3 has defaulted the value for storage_pid to be ''
> instead of 0. I have checked and this, 0, is the default in the  
> database
> for this field and it is also defined to allow nulls.
>
> What I want to know is;
> How do I get Typo3 to use the correct default for the field  
> storage_pid?
>
> caller t3lib_DB::exec_INSERTquery
> ERROR Incorrect integer value: '' for column 'storage_pid' at row 1
> lastBuiltQuery INSERT INTO pages
> (
> doktype 
> ,hidden,starttime,endtime,layout,urltype,lastUpdated,newUntil,cac
> he_timeout 
> ,shortcut_mode,module,perms_userid,perms_groupid,perms_user,pe
> rms_group 
> ,perms_everybody,sorting,pid,no_search,title,alias,target,no_ca
> che 
> ,subtitle,nav_hide,TSconfig,php_tree_stop,editlock,storage_pid,is_sit
> eroot,l18n_cfg,extendToSubpages,fe_group,crdate,cruser_id,tstamp
> ) VALUES (
> '1 
> ','1','0','0','0','1','0','0','0','0','','1','1','31','27','0','256','
> 0 
> ','0 
> ','home','','','0','home','0','','0','0','','1','0','0','','1201214
> 664','1','1201214664'
> )
> debug_backtrace SC_alt_doc->processData //
> t3lib_TCEmain->process_datamap // t3lib_TCEmain->insertDB //
> t3lib_DB->exec_INSERTquery // t3lib_DB->debug
>
>
> _______________________________________________
> TYPO3-dev mailing list
> TYPO3-dev at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-dev

--
Ries van Twisk
Freelance TYPO3 Developer
email: ries at vantwisk.nl
web:   http://www.rvantwisk.nl/
skype: callto://r.vantwisk
Phone: + 1 810-476-4193