Hallo,
bei mir wird im Backend folgendes unterhalb des Backends im Klartext angezeigt, außerdem kann ich die Website nicht in der Frontendansicht anzeigen lassen, obwohl ich veröffentlichte Seiten/Artikel habe (Stylesheet und Layout sind natürlich auch definiert etc.), insgesamt werden 33 Felder angezeigt...
PHP-Code:
Array
(
[0] => Array
(
[0] => SELECT * FROM tl_session WHERE hash='d7c68280a9385a4e125fbb9d9f4d629beb5f1334' AND name='BE_USER_AUTH'
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_session
[type] => system
[possible_keys] => hash
[key] =>
[key_len] =>
[ref] =>
[rows] => 1
[Extra] =>
)
)
[1] => Array
(
[0] => SELECT * FROM tl_user WHERE id='1'
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_user
[type] => system
[possible_keys] => PRIMARY
[key] =>
[key_len] =>
[ref] =>
[rows] => 1
[Extra] =>
)
)
[2] => Array
(
[0] => SELECT * FROM tl_user_group WHERE id=NULL AND disable!=1 AND (start='' OR start<1256119181) AND (stop='' OR stop>1256119181) LIMIT 0,1
[1] => 0 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] =>
[type] =>
[possible_keys] =>
[key] =>
[key_len] =>
[ref] =>
[rows] =>
[Extra] => Impossible WHERE noticed after reading const tables
)
)
[3] => Array
(
[0] => UPDATE tl_session SET tstamp=1256119181 WHERE sessionID='5d6420cf5eb4beeef7725ec221b695e8'
[1] => 0 rows affected
)
[4] => Array
(
[0] => SELECT * FROM tl_style_sheet WHERE id='6' LIMIT 0,1
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_style_sheet
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)
)
[5] => Array
(
[0] => SELECT * FROM tl_style WHERE pid='6' AND invisible!=1 ORDER BY sorting
[1] => 19 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_style
[type] => ref
[possible_keys] => pid
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 16
[Extra] => Using where; Using filesort
)
)
[6] => Array
(
[0] => INSERT INTO tl_log (tstamp, source, action, username, text, func, ip, browser) VALUES(1256119181, 'BE', 'CRON', 'webmaster', 'Generated style sheet "modules.css"', 'StyleSheets updateStyleSheet()', '84.159.167.46', 'Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.0; WOW64; Trident/4.0; GTB6; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; .NET CLR 3.5.21022; .NET CLR 3.5.30729; .NET CLR 3.0.30729)')
[1] => 1 rows affected
)
[7] => Array
(
[0] => DELETE FROM tl_style WHERE NOT EXISTS (SELECT * FROM tl_style_sheet WHERE tl_style.pid = tl_style_sheet.id)
[1] => 0 rows affected
)
[8] => Array
(
[0] => SHOW COLUMNS FROM `tl_style`
[1] => 44 rows affected
)
[9] => Array
(
[0] => SELECT DISTINCT(category) FROM tl_style WHERE pid='6'
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_style
[type] => ref
[possible_keys] => pid
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 16
[Extra] => Using where; Using temporary
)
)
[10] => Array
(
[0] => SELECT COUNT(*) AS total FROM tl_style WHERE pid='6'
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_style
[type] => ref
[possible_keys] => pid
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 16
[Extra] => Using index
)
)
[11] => Array
(
[0] => SELECT * FROM tl_style_sheet WHERE id='6' LIMIT 0,1
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_style_sheet
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)
)
[12] => Array
(
[0] => SELECT MAX(tstamp) AS tstamp FROM tl_style WHERE pid='6'
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_style
[type] => ref
[possible_keys] => pid
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 16
[Extra] =>
)
)
[13] => Array
(
[0] => SELECT * FROM tl_style WHERE pid='6' ORDER BY sorting LIMIT 0,30
[1] => 19 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_style
[type] => ref
[possible_keys] => pid
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 16
[Extra] => Using where; Using filesort
)
)
[14] => Array
(
[0] => SELECT COUNT(*) AS total FROM tl_style WHERE pid='6'
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_style
[type] => ref
[possible_keys] => pid
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 16
[Extra] => Using index
)
)
)
Hat jmd vielleicht ne Idee?
Lesezeichen