Autor Luke
Datum 12.12.2006 15:00
Beiträge: Jepp, da kommen welche, ganz schön viele sogar, was ist da schief gelaufen?



modules/banners
Fehler in Feld datestart Tabelle opn_bannerfinish
--> Falscher not null Wert , sollte 1 sein

Fehler in Feld dateend Tabelle opn_bannerfinish
--> Falscher not null Wert , sollte 1 sein

ALTER TABLE opn_bannerfinish CHANGE datestart datestart NUMERIC (15,5) DEFAULT '0' NOT NULL;
ALTER TABLE opn_bannerfinish CHANGE dateend dateend NUMERIC (15,5) DEFAULT '0' NOT NULL;


SQL-ERROR [256] mysql error: [1146: Table 'usr_web2_1.opn_mediagallery_import_cats' doesn't exist] in EXECUTE("SHOW COLUMNS FROM opn_mediagallery_import_cats")
FOUND IN [include/opndb-errorhandler.php]
FOUND AT 220
SQL-ERROR [256] mysql error: [1146: Table 'usr_web2_1.opn_mediagallery_import_cats' doesn't exist] in EXECUTE("SHOW COLUMNS FROM opn_mediagallery_import_cats")
FOUND IN [include/opndb-errorhandler.php]
FOUND AT 220
SQL-ERROR [256] mysql error: [1146: Table 'usr_web2_1.opn_mediagallery_import_cats' doesn't exist] in EXECUTE("SHOW COLUMNS FROM opn_mediagallery_import_cats")
FOUND IN [include/opndb-errorhandler.php]
FOUND AT 220
SQL-ERROR [256] mysql error: [1146: Table 'usr_web2_1.opn_mediagallery_import_cats' doesn't exist] in EXECUTE("SHOW COLUMNS FROM opn_mediagallery_import_cats")
FOUND IN [include/opndb-errorhandler.php]
FOUND AT 220
SQL-ERROR [256] mysql error: [1146: Table 'usr_web2_1.opn_mediagallery_import_cats' doesn't exist] in EXECUTE("SHOW COLUMNS FROM opn_mediagallery_import_cats")
FOUND IN [include/opndb-errorhandler.php]
FOUND AT 220
SQL-ERROR [256] mysql error: [1146: Table 'usr_web2_1.opn_mediagallery_import_cats' doesn't exist] in EXECUTE("SHOW COLUMNS FROM opn_mediagallery_import_cats")
FOUND IN [include/opndb-errorhandler.php]
FOUND AT 220
SQL-ERROR [256] mysql error: [1146: Table 'usr_web2_1.opn_mediagallery_import_cats' doesn't exist] in EXECUTE("SHOW COLUMNS FROM opn_mediagallery_import_cats")
FOUND IN [include/opndb-errorhandler.php]
FOUND AT 220
SQL-ERROR [256] mysql error: [1146: Table 'usr_web2_1.opn_mediagallery_import_pics' doesn't exist] in EXECUTE("SHOW COLUMNS FROM opn_mediagallery_import_pics")
FOUND IN [include/opndb-errorhandler.php]
FOUND AT 220
SQL-ERROR [256] mysql error: [1146: Table 'usr_web2_1.opn_mediagallery_import_pics' doesn't exist] in EXECUTE("SHOW COLUMNS FROM opn_mediagallery_import_pics")
FOUND IN [include/opndb-errorhandler.php]
FOUND AT 220
SQL-ERROR [256] mysql error: [1146: Table 'usr_web2_1.opn_mediagallery_import_pics' doesn't exist] in EXECUTE("SHOW COLUMNS FROM opn_mediagallery_import_pics")
FOUND IN [include/opndb-errorhandler.php]
FOUND AT 220
Datenbanken überprüfen
modules/demo_poll_class
Es gibt kein Feld uid in der Tabelle opn_dpc_opn_poll_check

ALTER TABLE opn_dpc_opn_poll_check ADD uid INT (11) DEFAULT '0' NOT NULL;
modules/faq
Es gibt kein Feld uid in der Tabelle opn_faq_opn_poll_check

Es gibt kein Feld wdate in der Tabelle opn_faqanswer

ALTER TABLE opn_faq_opn_poll_check ADD uid INT (11) DEFAULT '0' NOT NULL;
ALTER TABLE opn_faqanswer ADD wdate NUMERIC (15,5) DEFAULT '0' NOT NULL;
modules/mediagallery
Es gibt kein Feld gallid in der Tabelle opn_mediagallery_import_cats

Es gibt kein Feld galloc in der Tabelle opn_mediagallery_import_cats

Es gibt kein Feld parent in der Tabelle opn_mediagallery_import_cats

Es gibt kein Feld isupdate in der Tabelle opn_mediagallery_import_cats

Es gibt kein Feld newcat in der Tabelle opn_mediagallery_import_cats

Es gibt kein Feld album in der Tabelle opn_mediagallery_import_cats

Es gibt kein Feld pic in der Tabelle opn_mediagallery_import_pics

Es gibt kein Feld newpic in der Tabelle opn_mediagallery_import_pics

ALTER TABLE opn_mediagallery_import_cats ADD gallid INT (11) DEFAULT '0' NOT NULL;
ALTER TABLE opn_mediagallery_import_cats ADD galloc LONGTEXT NOT NULL;
ALTER TABLE opn_mediagallery_import_cats ADD parent INT (11) DEFAULT '0' NOT NULL;
ALTER TABLE opn_mediagallery_import_cats ADD isupdate INT (11) DEFAULT '0' NOT NULL;
ALTER TABLE opn_mediagallery_import_cats ADD newcat INT (11) DEFAULT '0' NOT NULL;
ALTER TABLE opn_mediagallery_import_cats ADD album INT (11) DEFAULT '0' NOT NULL;
ALTER TABLE opn_mediagallery_import_pics ADD pic INT (11) DEFAULT '0' NOT NULL;
ALTER TABLE opn_mediagallery_import_pics ADD newpic INT (11) DEFAULT '0' NOT NULL

system/forum
Fehler in Feld config_value Tabelle opn_forum_config
--> Falsche Feldlänge 10, sollte 0 sein
--> Falscher Feldtype int, sollte text sein

ALTER TABLE opn_forum_config CHANGE config_value config_value TEXT NOT NULL;

system/user_images
Es gibt kein Feld images_css in der Tabelle opn_user_images_dat

ALTER TABLE opn_user_images_dat ADD images_css VARCHAR (250) DEFAULT '' NOT NULL;






Diese Seite drucken
Diese Seite schließen

Dieser Artikel kommt von: OpenPHPNuke - das Open Source CMS

http://www.openphpnuke.info/