WBCE CMS Forum

Slugger

Mitglied

Nach Update von 5.0.17 auf .18 Meldungen im errorlog

[01-Feb-2023 09:54:59 UTC] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF NOT EXISTS `tnl_body_text` TEXT NOT NULL' at line 1
[01-Feb-2023 09:54:59 UTC] ALTER TABLE `XXXXX_mod_tiny_newsletter_newsletters` ADD IF NOT EXISTS `tnl_body_text` TEXT NOT NULL
[01-Feb-2023 09:54:59 UTC] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF NOT EXISTS `tnl_template_data` TEXT NOT NULL' at line 1
[01-Feb-2023 09:54:59 UTC] ALTER TABLE `XXXXX_mod_tiny_newsletter_newsletters` ADD IF NOT EXISTS `tnl_template_data` TEXT NOT NULL
[01-Feb-2023 09:54:59 UTC] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF NOT EXISTS `tnl_min_active` TINYINT NOT NULL DEFAULT 0' at line 1
[01-Feb-2023 09:54:59 UTC] ALTER TABLE `XXXXX_mod_tiny_newsletter_newsletters` ADD IF NOT EXISTS `tnl_min_active` TINYINT NOT NULL DEFAULT 0
[01-Feb-2023 09:55:10 UTC] Duplicate column name 'position'
[01-Feb-2023 09:55:10 UTC] ALTER TABLE `XXXXX_mod_news_img_img` ADD `position` INT(11) NOT NULL DEFAULT '0' AFTER `post_id`
[01-Feb-2023 09:55:10 UTC] Unknown column 'resize' in 'NcPEm_mod_news_img_settings'
[01-Feb-2023 09:55:10 UTC] ALTER TABLE `XXXXX_mod_news_img_settings` ADD `resize_preview` VARCHAR(50) NULL AFTER `resize`, ADD `crop_preview` CHAR(1) NOT NULL DEFAULT 'N' AFTER `resize_preview`
[01-Feb-2023 09:55:10 UTC] Duplicate column name 'post_content'
[01-Feb-2023 09:55:10 UTC] ALTER TABLE `XXXXX_mod_news_img_settings` ADD COLUMN `post_content` TEXT NOT NULL AFTER `post_header`, ADD COLUMN `image_loop` TEXT NOT NULL AFTER `post_content`
[01-Feb-2023 09:55:10 UTC] Unknown column 'use_captcha' in 'NcPEm_mod_news_img_settings'
[01-Feb-2023 09:55:10 UTC] ALTER TABLE `XXXXX_mod_news_img_settings` ADD COLUMN `gallery` TEXT NOT NULL AFTER `use_captcha`
[01-Feb-2023 09:55:10 UTC] Duplicate column name 'content_block2'
[01-Feb-2023 09:55:10 UTC] ALTER TABLE `XXXXX_mod_news_img_posts` ADD COLUMN `content_block2` TEXT NOT NULL AFTER `content_long`
[01-Feb-2023 09:55:10 UTC] Duplicate column name 'block2'
[01-Feb-2023 09:55:10 UTC] ALTER TABLE `XXXXX_mod_news_img_settings` ADD COLUMN `block2` TEXT NOT NULL AFTER `footer`
[01-Feb-2023 09:55:10 UTC] Duplicate column name 'view_order'
[01-Feb-2023 09:55:10 UTC] ALTER TABLE `XXXXX_mod_news_img_settings` ADD COLUMN `view_order` INT NOT NULL DEFAULT '0' AFTER `post_loop`
[01-Feb-2023 09:55:10 UTC] Can't DROP 'commenting'; check that column/key exists
[01-Feb-2023 09:55:10 UTC] ALTER TABLE `XXXXX_mod_news_img_posts` DROP COLUMN `commenting`
[01-Feb-2023 09:55:10 UTC] Can't DROP 'comments_page'; check that column/key exists
[01-Feb-2023 09:55:10 UTC] ALTER TABLE `XXXXX_mod_news_img_settings` DROP COLUMN `comments_page`, DROP COLUMN `comments_header`, DROP COLUMN `comments_loop`, DROP COLUMN `comments_footer`, DROP COLUMN `commenting`, DROP COLUMN `use_captcha`, DROP COLUMN `resize`
[01-Feb-2023 09:55:10 UTC] Duplicate column name 'imgthumbsize'
[01-Feb-2023 09:55:10 UTC] ALTER TABLE `XXXXX_mod_news_img_settings` ADD COLUMN `imgthumbsize` VARCHAR(50) NULL DEFAULT NULL AFTER `gallery`, ADD COLUMN `imgmaxwidth` VARCHAR(50) NULL DEFAULT NULL AFTER `imgthumbsize`, ADD COLUMN `imgmaxheight` VARCHAR(50) NULL DEFAULT NULL AFTER `imgmaxwidth`, ADD COLUMN `imgmaxsize` VARCHAR(50) NULL DEFAULT NULL AFTER `imgmaxheight`
[01-Feb-2023 09:55:10 UTC] Unknown column 'bildname' in 'NcPEm_mod_news_img_img'
[01-Feb-2023 09:55:10 UTC] ALTER TABLE `XXXXX_mod_news_img_img` CHANGE COLUMN `bildname` `picname` VARCHAR(255) NOT NULL DEFAULT '' AFTER `id`, CHANGE COLUMN `bildbeschreibung` `picdesc` VARCHAR(255) NOT NULL DEFAULT '' AFTER `picname`
[01-Feb-2023 09:55:10 UTC] Can't DROP 'page_id'; check that column/key exists
[01-Feb-2023 09:55:10 UTC] ALTER TABLE `XXXXX_mod_news_img_posts` DROP COLUMN `page_id`
[01-Feb-2023 09:55:10 UTC] Can't DROP 'page_id'; check that column/key exists
[01-Feb-2023 09:55:10 UTC] ALTER TABLE `XXXXX_mod_news_img_groups` DROP COLUMN `page_id`
[01-Feb-2023 09:55:10 UTC] Can't DROP 'page_id'; check that column/key exists
[01-Feb-2023 09:55:10 UTC] ALTER TABLE `XXXXX_mod_news_img_settings` DROP COLUMN `page_id`
[01-Feb-2023 09:55:10 UTC] Duplicate column name 'use_second_block'
[01-Feb-2023 09:55:10 UTC] ALTER TABLE `XXXXX_mod_news_img_settings` ADD COLUMN `use_second_block` CHAR(1) NOT NULL DEFAULT 'N' AFTER `imgmaxsize`
[01-Feb-2023 09:55:10 UTC] Duplicate column name 'view'
[01-Feb-2023 09:55:10 UTC] ALTER TABLE `XXXXX_mod_news_img_settings` ADD COLUMN `view` VARCHAR(50) NOT NULL DEFAULT 'default' AFTER `use_second_block`
[01-Feb-2023 09:55:10 UTC] Duplicate column name 'mode'
[01-Feb-2023 09:55:10 UTC] ALTER TABLE `XXXXX_mod_news_img_settings` ADD COLUMN `mode` VARCHAR(50) NULL DEFAULT 'default' AFTER `view`
[01-Feb-2023 09:55:10 UTC] Duplicate column name 'show_settings_only_admins'
[01-Feb-2023 09:55:10 UTC] ALTER TABLE `XXXXX_mod_news_img_settings` ADD COLUMN `show_settings_only_admins` CHAR(1) NOT NULL DEFAULT 'N' AFTER `use_second_block`

Stand nach dem Update in der errorlog-Datei.

WBCE Version: 1.5.4 • Backend Version: 2.1.0 • PHP Version: 8.1.13

---

Hoster: ALL-INKL *** Grundsätzliche WBCE Konfig ***
WBCE: 1.5.4 • BE: 2.1.0 • PHP: 8.1.16 * 1. Projekt: FE: Simple responsive • BE: Argos * 2. Projekt: FE: hortal • BE: Argos * 3. Projekt: FE: WBCEZon • BE: Argos * 4. Projekt: FE: WBCETik • BE: Argos
Status Projekt 1-4:  OK

webbird

Administrator

Re: Nach Update von 5.0.17 auf .18 Meldungen im errorlog

Das dürfte aus der upgrade.php sein. Sollte nichts ausmachen.

---

Ich habe eine Amazon-Wishlist. Oder spende an das Projekt.
Ich kann, wenn ich will, aber wer will, dass ich muss, kann mich mal

florian

Administrator

Re: Nach Update von 5.0.17 auf .18 Meldungen im errorlog

Ich hatte das nur im NWI im WBCE-Repo gefixt, aber nicht im NWI-Repo. Ist jetzt korrigiert.
Ein Update ist nicht erforderlich, wenn schon zuvor auf 5.0.18 upgedatet wurde.

---

Code allein macht nicht glücklich. Jetzt spenden!