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

[McCarry, Frank]

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