CONTENIDO Forum

Setup was unable to execute SQL. MySQL-Error: 1054, MySQL-Message: Unknown column 'published' in 'where clause', SQL-Statements:
UPDATE con_art_lang SET published=lastmodified, publishedby=modifiedby WHERE online=1 and published="0000-00-00 00:00:00"

[07-Nov-2005 14:18:26] /cms/front_content.php?idcat=25 MySQL error 1054: Unknown column 'fieldname' in 'field list'
SELECT idmetatype, metatype, fieldtype, maxlength, fieldname
FROM con_meta_type
[07-Nov-2005 14:18:26] /cms/front_content.php?idcat=25 next_record called with no query pending.
[07-Nov-2005 14:18:26] /cms/front_content.php?client=1&idcat=90&idart=340〈=1&error=1 MySQL error 1054: Unknown column 'fieldname' in 'field list'
SELECT idmetatype, metatype, fieldtype, maxlength, fieldname
FROM con_meta_type
[07-Nov-2005 14:18:26] /cms/front_content.php?client=1&idcat=90&idart=340〈=1&error=1 next_record called with no query pending.
[07-Nov-2005 14:18:57] /cms/front_content.php?idcat=8 MySQL error 1054: Unknown column 'fieldname' in 'field list'
SELECT idmetatype, metatype, fieldtype, maxlength, fieldname
FROM con_meta_type
[07-Nov-2005 14:18:57] /cms/front_content.php?idcat=8 next_record called with no query pending.
[07-Nov-2005 14:19:50] /contenido/main.php?area=con&frame=4&idcat=23&idtpl=24&contenido=0b16a348652ef874b3c7b988fa4edf1b MySQL error 1054: Unknown column 'a.published' in 'field list'
SELECT
a.idart AS idart,
a.idlang AS idlang,
a.idartlang AS idartlang,
a.title AS title,
c.idcat AS idcat,
c.is_start AS is_start,
c.idcatart AS idcatart,
a.idtplcfg AS idtplcfg,
a.published AS published,
a.online AS online,
a.created AS created,
a.lastmodified AS lastmodified,
a.timemgmt AS timemgmt,
a.datestart AS datestart,
a.dateend AS dateend,
a.artsort AS artsort,
a.locked AS locked
FROM
con_art_lang AS a,
con_art AS b,
con_cat_art AS c
WHERE
a.idlang = '1' AND
a.idart = b.idart AND
b.idclient = '1' AND
b.idart = c.idart AND
c.idcat = '23'
[07-Nov-2005 14:19:50] /contenido/main.php?area=con&frame=4&idcat=23&idtpl=24&contenido=0b16a348652ef874b3c7b988fa4edf1b next_record called with no query pending.
[07-Nov-2005 14:19:58] /contenido/main.php?area=con_editart&frame=4&action=con_newart&idcat=23&contenido=0b16a348652ef874b3c7b988fa4edf1b MySQL error 1054: Unknown column 'fieldname' in 'field list'
SELECT idmetatype, metatype, fieldtype, maxlength, fieldname
FROM con_meta_type
[07-Nov-2005 14:19:58] /contenido/main.php?area=con_editart&frame=4&action=con_newart&idcat=23&contenido=0b16a348652ef874b3c7b988fa4edf1b next_record called with no query pending.
[07-Nov-2005 14:20:02] /contenido/main.php?area=con_editart&frame=4&action=con_saveart&contenido=0b16a348652ef874b3c7b988fa4edf1b MySQL error 1054: Unknown column 'published' in 'field list'
INSERT INTO
con_art_lang (
idartlang,
idart,
idlang,
title,
pagetitle,
summary,
artspec,
created,
lastmodified,
author,
published,
publishedby,
online,
redirect,
redirect_url,
external_redirect,
artsort,
timemgmt,
datestart,
dateend,
status,
time_move_cat,
time_target_cat,
time_online_move
) VALUES (
'341',
'341',
'1',
'test',
'',
'',
'',
'2005-11-07 14:19:58',
'2005-11-07 14:19:58',
'sysadmin',
'',
'',
'',
'0',
'0',
'0',
'',
'0',
'',
'',
'0',
'0',
'1',
'0')
[07-Nov-2005 14:20:02] /contenido/main.php?area=con_editart&frame=4&action=con_saveart&contenido=0b16a348652ef874b3c7b988fa4edf1b MySQL error 1054: Unknown column 'fieldname' in 'field list'
SELECT idmetatype, metatype, fieldtype, maxlength, fieldname
FROM con_meta_type
[07-Nov-2005 14:20:02] /contenido/main.php?area=con_editart&frame=4&action=con_saveart&contenido=0b16a348652ef874b3c7b988fa4edf1b next_record called with no query pending.
[07-Nov-2005 14:20:02] /contenido/main.php?area=con_editart&frame=4&action=con_saveart&contenido=0b16a348652ef874b3c7b988fa4edf1b MySQL error 1054: Unknown column 'fieldname' in 'field list'
SELECT idmetatype, metatype, fieldtype, maxlength, fieldname
FROM con_meta_type
[07-Nov-2005 14:20:02] /contenido/main.php?area=con_editart&frame=4&action=con_saveart&contenido=0b16a348652ef874b3c7b988fa4edf1b next_record called with no query pending.

saschar hat geschrieben:Sollte an der Website weitermachen und habe nun aber leider keine Artikel mehr, um da weiter zu machen...