Project

General

Profile

Actions

Bug #15314

closed

can't add pages or content because adodb sequences are setup incorrectly

Added by Joerg Schoppet over 18 years ago. Updated over 17 years ago.

Status:
Closed
Priority:
Should have
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2005-12-28
Due date:
% Done:

0%

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

Description

Always if I try to add a page or content, nothing happens.
In the DBAL-DEBUG-LOG I found the following errors:

Number 1:

sqlError Column 'l18n_diffsource' cannot be null
typo3/alt_doc.php
INSERT INTO tt_content ( CType, starttime, endtime, layout, colPos, date, header_position, header_layout, text_align, text_face, text_size, text_color, imagewidth, imageheight, imageorient, imagecols, imagecaption_position, cols, recursive, menu_type, list_type, table_bgColor, table_border, table_cellspacing, table_cellpadding, spaceBefore, spaceAfter, section_frame, splash_layout, sectionIndex, sorting, pid, sys_language_uid, linkToTop, header, header_link, bodytext, rte_enabled, text_properties, hidden, fe_group, l18n_diffsource, tstamp ) VALUES ( 'text', '0', '0', '0', '0', '0', '', '0', '', '0', '0', '0', '0', '0', '8', '0', '', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '1', '256', '1', '0', '0', 'Test', '', '', '0', '0', '0', '', null, '1135769362' )

Number 2:

sqlError Column 'log_data' cannot be null
typo3/alt_doc.php
INSERT INTO sys_log ( userid, type, action, error, details_nr, details, log_data, tablename, recuid, IP, tstamp, event_pid, NEWid, workspace ) VALUES ( '1', '1', '1', '0', '10', 'Record \'%s\' (%s) was inserted on page \'%s\' (%s)', null, 'tt_content', '1570', '199.42.240.136', '1135769362', '0', 'NEW43b27708e0e9b', '0' )

In localconf.php I added the following dbal-lines:
$TYPO3_CONF_VARS['EXTCONF']['dbal']['handlerCfg'] = array(
'_DEFAULT' => array(
'type' => 'native',
),
);
$TYPO3_CONF_VARS['EXTCONF']['dbal']['debugOptions'] = array(
'enabled' => TRUE,
'printErrors' => TRUE,
'EXPLAIN' => 1,
'parseQuery' => 1,
'joinTables' => 1,
);

(issue imported from #M2106)


Related issues 4 (0 open4 closed)

Related to TYPO3 Core - Bug #15317: MySQL Error when installing sys_action with the extension manager in 4.0beta1ClosedKarsten Dambekalns2005-12-28

Actions
Related to TYPO3 Core - Bug #15364: SQL error creating a begroupClosedKarsten Dambekalns2006-01-05

Actions
Related to TYPO3 Core - Bug #15347: cannot add user or usergroups to fe or be (form is not saved)ClosedKarsten Dambekalns2006-01-03

Actions
Has duplicate TYPO3 Core - Bug #15507: Can't create new pagesClosed2006-01-26

Actions
Actions

Also available in: Atom PDF