[TYPO3-german] MySQL Fehler nach Installation]

[Roland Schmid]

Hallo Bernd,

> versuch doch mal herauszufinden was da schief läuft:
> Im Install-Tool unter '5 All Configuration':
> [sqlDebug]
> Boolean. If set, then database queries that fails are outputted in 
> browser. For development.
> [SYS][sqlDebug] = 1


das habe ich gemacht.
Verstehe nicht ganz, was mit "unbekannte Spalte" gemeint ist

Gruss Roland


...und erhalte diese Ausgabe:

caller
t3lib_DB::exec_SELECTquery

ERROR
Unknown column 'pages.hidden' in
'where clause'

lastBuiltQuery
SELECT
pages.uid,sys_domain.redirectTo,sys_domain.prepend_params
FROM pages,sys_domain
WHERE
pages.uid=sys_domain.pid
AND sys_domain.hidden=0
AND
(sys_domain.domainName='192.224.218.87' OR sys_domain.domainName='192.224.218.87/') AND pages.deleted=0 AND pages.hidden=0 AND (pages.starttime<=1202072151) AND (pages.endtime=0 OR pages.endtime>1202072151) AND NOT(pages.t3ver_state=1) AND pages.doktype<200 AND (pages.fe_group='' OR pages.fe_group IS NULL OR pages.fe_group='0' OR (pages.fe_group LIKE '%,0,%' OR pages.fe_group LIKE '0,%' OR pages.fe_group LIKE '%,0' OR pages.fe_group='0') OR (pages.fe_group LIKE '%,-1,%' OR pages.fe_group LIKE '-1,%' OR pages.fe_group LIKE '%,-1' OR pages.fe_group='-1'))
LIMIT 1

debug_backtrace
require // tslib_fe->determineId //
tslib_fe->fetch_the_id //
tslib_fe->findDomainRecord //
t3lib_pageSelect->getDomainStartPage // t3lib_DB->exec_SELECTquery // t3lib_DB->debug


Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL
result resource in /var/www/typo3_src-4.1.5/t3lib/class.t3lib_db.php on
line 796
caller
t3lib_DB::exec_SELECTquery

ERROR
Unknown column 'pages.hidden' in
'where clause'

lastBuiltQuery
SELECT *
FROM pages
WHERE
pid=0 AND pages.deleted=0 AND
pages.hidden=0 AND
(pages.starttime<=1202072151) AND
(pages.endtime=0 OR
pages.endtime>1202072151) AND
NOT(pages.t3ver_state=1) AND
pages.doktype<200 AND
(pages.fe_group='' OR pages.fe_group
IS NULL OR pages.fe_group='0' OR
(pages.fe_group LIKE '%,0,%' OR
pages.fe_group LIKE '0,%' OR
pages.fe_group LIKE '%,0' OR
pages.fe_group='0') OR
(pages.fe_group LIKE '%,-1,%' OR
pages.fe_group LIKE '-1,%' OR
pages.fe_group LIKE '%,-1' OR
pages.fe_group='-1'))
ORDER BY sorting
LIMIT 1

debug_backtrace
require // tslib_fe->determineId //
tslib_fe->fetch_the_id //
t3lib_pageSelect->getFirstWebPage //
t3lib_DB->exec_SELECTquery //
t3lib_DB->debug

caller
t3lib_DB::exec_SELECTquery

ERROR
Unknown column 'hidden' in 'field
list'

lastBuiltQuery
SELECT
uid,title,doktype,php_tree_stop,t3ver_id,t3ver_state,t3ver_wsid,t3ver_swapmode,hidden,starttime,endtime,fe_group,module,extendToSubpages,is_siteroot,alias,shortcut,shortcut_mode,mount_pid,mount_pid_ol,nav_hide,url
FROM pages
WHERE
pid='0' AND pages.deleted=0 AND 1=1 
ORDER BY sorting

debug_backtrace
SC_alt_db_navframe->main //
webPageTree->getBrowsableTree //
webPageTree->getTree //
t3lib_treeView->getDataInit //
t3lib_DB->exec_SELECTquery //
t3lib_DB->debug