Project

General

Profile

Actions

Bug #21212

closed

Unable to create a page

Added by Sushil Bajimaya about 15 years ago. Updated about 6 years ago.

Status:
Closed
Priority:
Should have
Category:
-
Target version:
-
Start date:
2009-10-09
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
PHP Version:
4.3
Tags:
Complexity:
Is Regression:
Sprint Focus:

Description

While creating a page, I get the following error:
-------------------------------------------
2: SQL error: 'Out of range value adjusted for column 'storage_pid' at row 1' (pages:NEW4acf04d853cbc)
-------------------------------------------

I am a new user of typo3. I am using the latest version of typo3. How do I fix the problem?

My working environment is PHP 5.2.2, Apache 2.2 and MySQL 5

(issue imported from #M12163)


Related issues 2 (0 open2 closed)

Related to TYPO3 Core - Task #54883: Document that TYPO3 CMS is not compatible with MySQL strict modesClosedErnesto Baschny2014-01-09

Actions
Is duplicate of TYPO3 Core - Bug #20052: SQL error: 'Incorrect integer value: '' for column 'storage_pid' at row 1' (pages:NEW499d21cdec168)Rejected2009-02-19

Actions
Actions #1

Updated by Peter Beernink about 15 years ago

Looks like this issue is the same issue as 0010487.
Are you running MySQL in strict mode?
If so, you should be able to disable this adding
$TYPO3_CONF_VARS['SYS']['setDBinit'] = 'set SQL_MODE=\'STRICT_ALL_TABLES\';'
to you localconf.php file

Actions #2

Updated by Sushil Bajimaya about 15 years ago

Might be. I did default install of mysql. I haven't changed any values yet.

Actions #3

Updated by Niels Fröhling about 15 years ago

Duplicate of 0010487, confirmative.

Actions #4

Updated by Sushil Bajimaya about 15 years ago

Did that. Still get the same error.

Actions #5

Updated by Niels Fröhling about 15 years ago

Try 'SET SESSION sql_mode=\'\'', I don't think the above is enough. It's the fix of 0010487 in another way.

Actions #6

Updated by Sushil Bajimaya about 15 years ago

I worked now. Thanks for your help.

Actions #7

Updated by Peter Beernink about 15 years ago

My bad.
Should of course have been an empty SQL_MODE. I've copied this one from the conf which I used to try to reproduce the issue, and didn't empty out the variable..

Actions #8

Updated by Christian Kuhn about 15 years ago

Resolved as duplicate of #20052

Actions #9

Updated by Benni Mack about 6 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF