Bug #21212
Unable to create a page
| Status: | Resolved | Start date: | 2009-10-09 | |
|---|---|---|---|---|
| Priority: | Should have | Due date: | ||
| Assigned To: | Christian Kuhn | % Done: | 0% |
|
| Category: | - | Spent time: | - | |
| Target version: | - | |||
| TYPO3 Version: | Is Regression: | |||
| PHP Version: | 4.3 | Sprint Focus: | ||
| Complexity: |
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
History
#1 Updated by Peter Beernink almost 6 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
#2 Updated by Sushil Bajimaya almost 6 years ago
Might be. I did default install of mysql. I haven't changed any values yet.
#3 Updated by Niels Fröhling almost 6 years ago
Duplicate of 0010487, confirmative.
#4 Updated by Sushil Bajimaya almost 6 years ago
Did that. Still get the same error.
#5 Updated by Niels Fröhling almost 6 years ago
Try 'SET SESSION sql_mode=\'\'', I don't think the above is enough. It's the fix of 0010487 in another way.
#6 Updated by Sushil Bajimaya almost 6 years ago
I worked now. Thanks for your help.
#7 Updated by Peter Beernink almost 6 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..
#8 Updated by Christian Kuhn almost 6 years ago
Resolved as duplicate of #20052