[TYPO3] Can't add a new page
Bartlomiej Lekawski
bart.lek at gmail.com
Wed Mar 7 19:19:14 CET 2007
Hi,
I am having a lot of problems after installing Typo3 for the first
time. Firstly, I couldn't login to the backend, but after some time
I've found out that the problem was with MySQL strict mode and "NOT
NULL"'s in tables' definitions, so I got rid of some of them.
Right now I have a problem with adding a new page. There are non in
the page tree (just the "New Typo3 site"). When I try to add one, I
receive an SQL error: 'Out of range value adjusted for column
'storage_pid' at row 1' . After some testing I figured out that the
query being generated tries to set wrong values for some of the fields
in the 'pages' table. Is this a typo3 error, or does it have to do
with MySQL incompatibility? I've seen somewhere that there are
problems with version 5.
I have a clear installation of typo3 4.0.5 with the dummy package,
running on MySQL 5.0.27, PHP 5.2.0, IIS 6.0, Windows 2003.
The generated query:
insert into pages
(doktype, hidden, starttime, endtime, layout, urltype, lastUpdated,
newUntil, cache_timeout, shortcut_mode, module, perms_userid,
perms_groupid, perms_user, perms_group, perms_everybody, sorting, pid,
title, subtitle, nav_hide, TSconfig, storage_pid, l18n_cfg,
extendToSubpages, fe_group, no_search, alias, target, no_cache,
php_tree_stop, editlock, is_siteroot, crdate, cruser_id, tstamp)
VALUES
('1', '1', '0', '0', '0', '1', '0', '0', '0', '0', '', '1', '0', '31',
'27', '0', '256', '0', 'test', '', '0', '', '', '0', '0', '', '', '',
'', '', '', '', '' ,'1173283471', '1', '1173283471')
Current 'pages' table:
+-------------------+---------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default |
Extra |
+-------------------+---------------------+------+-----+---------+----------------+
| uid | int(11) | NO | PRI | NULL |
auto_increment |
| pid | int(11) | NO | MUL | 0 |
|
| t3ver_oid | int(11) | NO | MUL | 0 |
|
| t3ver_id | int(11) | NO | | 0 |
|
| t3ver_wsid | int(11) | NO | | 0 |
|
| t3ver_label | varchar(30) | YES | | NULL |
|
| t3ver_state | tinyint(4) | NO | | 0 |
|
| t3ver_stage | tinyint(4) | NO | | 0 |
|
| t3ver_count | int(11) | NO | | 0 |
|
| t3ver_tstamp | int(11) | NO | | 0 |
|
| t3ver_swapmode | tinyint(4) | NO | | 0 |
|
| t3_origuid | int(11) | NO | | 0 |
|
| tstamp | int(11) unsigned | NO | | 0 |
|
| sorting | int(11) unsigned | NO | | 0 |
|
| deleted | tinyint(4) unsigned | NO | | 0 |
|
| perms_userid | int(11) unsigned | NO | | 0 |
|
| perms_groupid | int(11) unsigned | NO | | 0 |
|
| perms_user | tinyint(4) unsigned | NO | | 0 |
|
| perms_group | tinyint(4) unsigned | NO | | 0 |
|
| perms_everybody | tinyint(4) unsigned | NO | | 0 |
|
| editlock | tinyint(4) unsigned | NO | | 0 |
|
| crdate | int(11) unsigned | NO | | 0 |
|
| cruser_id | int(11) unsigned | NO | | 0 |
|
| title | tinytext | YES | | NULL |
|
| doktype | tinyint(3) unsigned | NO | | 0 |
|
| TSconfig | blob | YES | | NULL |
|
| storage_pid | int(11) | NO | | 0 |
|
| is_siteroot | tinyint(4) | NO | | 0 |
|
| php_tree_stop | tinyint(4) | NO | | 0 |
|
| tx_impexp_origuid | int(11) | NO | | 0 |
|
| url | tinytext | YES | | NULL |
|
| hidden | tinyint(4) unsigned | NO | | 0 |
|
| starttime | int(11) unsigned | NO | | 0 |
|
| endtime | int(11) unsigned | NO | | 0 |
|
| urltype | tinyint(4) unsigned | NO | | 0 |
|
| shortcut | int(10) unsigned | NO | | 0 |
|
| shortcut_mode | int(10) unsigned | NO | | 0 |
|
| no_cache | int(10) unsigned | NO | | 0 |
|
| fe_group | varchar(100) | NO | | 0 |
|
| subtitle | tinytext | YES | | NULL |
|
| layout | tinyint(3) unsigned | NO | | 0 |
|
| target | varchar(20) | YES | | NULL |
|
| media | blob | YES | | NULL |
|
| lastUpdated | int(10) unsigned | NO | | 0 |
|
| keywords | text | YES | | NULL |
|
| cache_timeout | int(10) unsigned | NO | | 0 |
|
| newUntil | int(10) unsigned | NO | | 0 |
|
| description | text | YES | | NULL |
|
| no_search | tinyint(3) unsigned | NO | | 0 |
|
| SYS_LASTCHANGED | int(10) unsigned | NO | | 0 |
|
| abstract | text | YES | | NULL |
|
| module | varchar(10) | YES | | NULL |
|
| extendToSubpages | tinyint(3) unsigned | NO | | 0 |
|
| author | tinytext | YES | | NULL |
|
| author_email | varchar(80) | YES | | NULL |
|
| nav_title | tinytext | YES | | NULL |
|
| nav_hide | tinyint(4) | NO | | 0 |
|
| content_from_pid | int(10) unsigned | NO | | 0 |
|
| mount_pid | int(10) unsigned | NO | | 0 |
|
| mount_pid_ol | tinyint(4) | NO | | 0 |
|
| alias | varchar(32) | YES | MUL | NULL |
|
| l18n_cfg | tinyint(4) | NO | | 0 |
|
| fe_login_mode | tinyint(4) | NO | | 0 |
|
+-------------------+---------------------+------+-----+---------+----------------+
More information about the TYPO3-english
mailing list