Moin,
nach dem Update bringt mir das HIP-Modul (WebNews) folgenden Fehler:
Error sql_query():
qry: select hid, sitename, description, content, headlinesurl, refresh, time, pos, count from _HIPTABLE_HEADLINES WHERE active='1' order by pos ASC
descr: Table 'xxx_yyyy_1._HIPTABLE_HEADLINES' doesn't exist ( mysql 1146 )
Error sql_num_rows():
descr: mysql_num_rows(): supplied argument is not a valid MySQL result resource
Error sql_fetch_row():
descr: mysql_fetch_row(): supplied argument is not a valid MySQL result resource
Das Update lief bis auf eine kleine Fehlermeldung (s.u.) durch. Der gemeldete Fehler war:
ERR: ALTER TABLE `mx_banner` ADD `alttext` varchar(200) default NULL;
Duplicate column name 'alttext'
ERR: INSERT INTO mx_banner_temp_2003_11_17_04_00_20( name, contact, email, login, passwd, extrainfo, imptotal, impmade, clicks, imageurl, clickurl, alttext, `date`, impressions, finish_clicks, datestart, dateend )
SELECT DISTINCTROW bch.name, bch.contact, bch.email, bch.login, bch.passwd, bch.extrainfo, bh.imptotal, bh.impmade, bh.clicks, bh.imageurl, bh.clickurl, bh.alttext, bh.date, bh.impmade, bh.clicks AS fc, bh.date, bh.dateend
FROM ( mx_bannerclient AS bch
LEFT JOIN mx_banner AS bh ON bch.cid = bh.cid )
ORDER BY bch.name, bh.imageurl
Unknown column 'bh.date' in 'field list'
Ideen? Rat? Lebensfreude?
Danke!
der Keks
