时间戳

首页 > 解决方案 > Revive Ad 无法升级

php - Revive Ad 无法升级

问题描述

我在将 Revive Ad 服务器从 4.1 升级到 5.0 时遇到问题。当我上传代码并打开升级页面时，我看到了错误。 在此处输入图像描述

在日志中我发现了这个记录：

    Attempting to detect an existing Openads (aka. phpAdsNew) installation...
PAN not detected
Attempting to detect an existing Openads (aka. Max Media Manager 0.1) installation...
MMM v0.1 not detected
Attempting to detect an existing Openads (aka. Max Media Manager 0.3) installation...
MMM v0.3 not detected
Attempting to detect an existing Revive Adserver installation...
schema file found: /var/www/html/etc/changes/schema_tables_core_621.xml
schema definition from cache TRUE
successfully parsed the schema
schema name: openads
schema version: 621
schema status: final
running integrity check
comparing database revive with schema /var/www/html/etc/changes/schema_tables_core_621.xml
column definition does not match: application_variable.name
table is not part of schema: banner_vast_element
table is not part of schema: data_bkt_a
table is not part of schema: data_bkt_a_var
table is not part of schema: data_bkt_c
table is not part of schema: data_bkt_m
table is not part of schema: data_bkt_r
table is not part of schema: data_bkt_vast_e
table is not part of schema: database_action
table is not part of schema: stats_vast
table is not part of schema: upgrade_action
to version: 621
timing: constructive
target database: revive
table prefix: rv_
successfully initialised DB Upgrade
verifying/creating constructive tasklist
checking field: rv_application_variable name
found field name
#! database integrity check detected problems with the database
#! 1 fields to change

不知道该怎么办，我需要升级我的 Revive 广告服务器。请帮帮我。

ps：高山，nginx，php 7.1，mysql 5.6

标签： phpmysqllinux

解决方案

我找到了解决该问题的方法。您需要更新数据库中的表。

ALTER TABLE `revive`.`rv_application_variable` 
CHANGE COLUMN `name` `name` VARCHAR(255) NOT NULL DEFAULT '' ;

推荐阅读