yulman

I also reported the problem, but still I haven't found a solution, i can't upgrade to 3.2.x. https://github.com/revive-adserver/revive-adserver/issues/603

Hi, I have same problem (http://forum.revive-adserver.com/topic/1905-errors-upgrading-to-revive-32x/), i've been trying to find the reason that this happens but i can't find the solution.

Today, in a test environment, I've tested a fresh install of v3.2.1 and before installation i changed the config file to make the database pointed to the database of v3.1.0. Apparently it's running, but I don't know if there are any changes in the scheme of the database version between v3.1.0 and 3.2.0. I will continue testing in the test environment before passing it to the production environment.

Good Morning, I'm trying to upgrade from version 3.1.0 to 3.2.1 (also tried it with 3.2.0), but I get the following errors related to the database: Starting file-check for plugins... Plugin: openXBannerTypes - Unable to locate XML files Plugin: openXDeliveryLimitations - Unable to locate XML files Plugin: openX3rdPartyServers - Unable to locate XML files Plugin: openXReports - Unable to locate XML files Plugin: openXDeliveryCacheStore - Unable to locate XML files Plugin: openXMaxMindGeoIP - Unable to locate XML files Plugin: openXInvocationTags - Unable to locate XML files Plugin: openXDeliveryLog - Unable to locate XML files Plugin: openXAdditionalBannerTypes - Unable to locate XML files Plugin: openXDeliveryLogCountry - Unable to locate XML files Plugin: openXMaxMindModGeoIP - Unable to locate XML files Plugin: openXVideoAds - Unable to locate XML files Finished file-check for plugins Starting file-check for plugins... Finished file-check for plugins ========================================================================= 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/vhosts/###########################/httpdocs/revive-adserver-3.2.1/etc/changes/schema_tables_core_619.xml schema definition from cache TRUE successfully parsed the schema schema name: openads schema version: 619 schema status: final running integrity check comparing database adserverCP with schema /var/www/vhosts/###########################/httpdocs/revive-adserver-3.2.1/etc/changes/schema_tables_core_619.xml #! error getting database definition getTableConstraintDefinition table is missing: account_preference_assoc My config file: ;<?php exit; ?> ;*** DO NOT REMOVE THE LINE ABOVE *** [openads] installed=1 requireSSL=1 sslPort=443 [ui] enabled=1 applicationName= headerFilePath= footerFilePath= logoFilePath= headerForegroundColor= headerBackgroundColor= headerActiveTabColor= headerTextColor= gzipCompression=1 combineAssets=1 dashboardEnabled= hideNavigator= zoneLinkingStatistics=1 supportLink= [database] type=mysql host=localhost socket="/var/run/mysqld/mysqld.sock" port=3306 username=################## password=################## name=#################### persistent= mysql4_compatibility=1 protocol=tcp compress= ssl= capath= ca= [databaseCharset] checkComplete=1 clientCharset=latin1 [databaseMysql] statisticsSortBufferSize= [databasePgsql] schema= [webpath] admin="www.###########################/adserver/www/admin" delivery="www.###########################/adserver/www/delivery" deliverySSL="www.###########################/adserver/www/delivery" images="www.###########################/adserver/www/images" imagesSSL="www.###########################/adserver/www/images" [file] click="ck.php" conversionvars="tv.php" content="ac.php" conversion="ti.php" conversionjs="tjs.php" flash="fl.js" google="ag.php" frame="afr.php" image="ai.php" js="ajs.php" layer="al.php" log="lg.php" popup="apu.php" view="avw.php" xmlrpc="axmlrpc.php" local="alocal.php" frontcontroller="fc.php" singlepagecall="spc.php" spcjs="spcjs.php" xmlrest="ax.php" [store] mode=0 webDir="/var/www/vhosts/###########################/httpdocs/adserver/www/images" ftpHost= ftpPath= ftpUsername= ftpPassword= ftpPassive= [origin] type= host= port=80 script="/www/delivery/dxmlrpc.php" timeout=10 protocol=http [allowedBanners] sql= web=1 url=1 html=1 text=1 video=1 [delivery] cacheExpire=1200 cacheStorePlugin="deliveryCacheStore:oxCacheFile:oxCacheFile" cachePath= acls=1 aclsDirectSelection=1 obfuscate= execPhp= ctDelimiter=__ chDelimiter="," keywords= cgiForceStatusHeader= clicktracking= ecpmSelectionRate="0.9" enableControlOnPureCPM=1 [defaultBanner] imageUrl= [p3p] policies=1 compactPolicy="CUR ADM OUR NOR STA NID" policyLocation= [graphs] ttfDirectory= ttfName= [logging] adRequests= adImpressions=1 adClicks=1 trackerImpressions=1 reverseLookup= proxyLookup=1 defaultImpressionConnectionWindow= defaultClickConnectionWindow= ignoreHosts= ignoreUserAgents="Googlebot-Image/1.0|Googlebot/2.1|AhrefsBot/3.1|bingbot/2.0|YandexBot/3.0|VoilaBot BETA 1.2|googlebot|Googlebot-Mobile|Googlebot-Image|bingbot|slurp|msnbot|Adidxbot|blekkobot|teoma|ia_archiver|GingerCrawler|webmon|httrack|webcrawler|FAST-WebCrawler|FAST Enterprise Crawler|convera|biglotron|grub.org|UsineNouvelleCrawler|antibot|netresearchserver|speedy|fluffy|jyxobot|bibnum.bnf|findlink|exabot|gigabot|msrbot|seekbot|ngbot|panscient|yacybot|AISearchBot|IOI|ips-agent|tagoobot|MJ12bot|dotbot|woriobot|yanga|buzzbot|mlbot|yandex |purebot|Linguee Bot|Voyager|CyberPatrol|voilabot|baiduspider|citeseerxbot|spbot|twengabot|postrank|turnitinbot|scribdbot|page2rss|sitebot|linkdex|ezooms|mail\.ru|discobot|heritrix|findthatfile|europarchive.org|NerdByNature.Bot|sistrix crawler|ahrefsbot|Aboundex|domaincrawler|wbsearchbot|summify|ccbot|edisterbot|seznambot|ec2linkfinder|gslfbot|aihitbot|intelium_bot|facebookexternalhit|yeti|RetrevoPageAnalyzer|lb-spider|sogou|lssbot|careerbot|wotbox|wocbot|ichiro|DuckDuckBot|lssrocketcrawler|drupact|webcompanycrawler|acoonbot|openindexspider|gnam gnam spide|web-archive-net.com.bot|backlinkcrawler|coccoc|integromedb|content crawler spider|toplistbot|seokicks-robot|it2media-domain-crawler|ip-web-crawler.com" enforceUserAgents= blockAdClicksWindow=0 [maintenance] autoMaintenance= timeLimitScripts=1800 operationInterval=60 blockAdImpressions=0 blockAdClicks=0 channelForecasting= pruneCompletedCampaignsSummaryData= pruneDataTables=1 ecpmCampaignLevels="9|8|7|6" [priority] instantUpdate=1 defaultClickRatio="0.005" defaultConversionRatio="0.0001" randmax=2147483647 [performanceStatistics] defaultImpressionsThreshold=10000 defaultDaysIntervalThreshold=30 [table] prefix=ox_ type=MYISAM account_preference_assoc=account_preference_assoc account_user_assoc=account_user_assoc account_user_permission_assoc=account_user_permission_assoc accounts=accounts acls=acls acls_channel=acls_channel ad_category_assoc=ad_category_assoc ad_zone_assoc=ad_zone_assoc affiliates=affiliates affiliates_extra=affiliates_extra agency=agency application_variable=application_variable audit=audit banners=banners campaigns=campaigns campaigns_trackers=campaigns_trackers category=category channel=channel clients=clients data_intermediate_ad=data_intermediate_ad data_intermediate_ad_connection=data_intermediate_ad_connection data_intermediate_ad_variable_value=data_intermediate_ad_variable_value data_raw_ad_click=data_raw_ad_click data_raw_ad_impression=data_raw_ad_impression data_raw_ad_request=data_raw_ad_request data_raw_tracker_impression=data_raw_tracker_impression data_raw_tracker_variable_value=data_raw_tracker_variable_value data_summary_ad_hourly=data_summary_ad_hourly data_summary_ad_zone_assoc=data_summary_ad_zone_assoc data_summary_channel_daily=data_summary_channel_daily data_summary_zone_impression_history=data_summary_zone_impression_history images=images log_maintenance_forecasting=log_maintenance_forecasting log_maintenance_priority=log_maintenance_priority log_maintenance_statistics=log_maintenance_statistics password_recovery=password_recovery placement_zone_assoc=placement_zone_assoc preferences=preferences session=session targetstats=targetstats trackers=trackers tracker_append=tracker_append userlog=userlog users=users variables=variables variable_publisher=variable_publisher zones=zones [email] logOutgoing= headers= qmailPatch= fromName="################" fromAddress="########€@###########################" fromCompany="######################################" useManagerDetails= [log] enabled=1 methodNames= lineNumbers= type=file name="debug.log" priority=6 ident=OX paramsUsername= paramsPassword= fileMode=0644 [deliveryLog] enabled= name="delivery.log" fileMode=0644 priority=6 [cookie] permCookieSeconds=31536000 maxCookieSize=2048 [debug] logfile= production=1 sendErrorEmails= emailSubject="Error from Revive Adserver" email="[email protected]" emailAdminThreshold=3 errorOverride=1 showBacktrace= disableSendEmails= [var] prefix=OA_ cookieTest=ct cacheBuster=cb channel=source dest=oadest logClick=log n=n params=oaparams viewerId=OAID viewerGeo=OAGEO campaignId=campaignid adId=bannerid creativeId=cid zoneId=zoneid blockAd=OABLOCK capAd=OACAP sessionCapAd=OASCAP blockCampaign=OACBLOCK capCampaign=OACCAP sessionCapCampaign=OASCCAP blockZone=OAZBLOCK capZone=OAZCAP sessionCapZone=OASZCAP vars=OAVARS trackonly=trackonly openads=openads lastView=OXLIA lastClick=OXLCA blockLoggingClick=OXBLC fallBack=oxfb trace=OXTR [lb] enabled= type=mysql host=localhost port=3306 username= password= name= persistent= [sync] checkForUpdates=1 shareStack= [oacSync] protocol=https host="sync.revive-adserver.com" path="/xmlrpc.php" httpPort=80 httpsPort=443 [authentication] type=internal deleteUnverifiedUsersAfter=2419200 [geotargeting] type= showUnavailable= [pluginPaths] packages="/plugins/etc/" plugins="/plugins/" admin="/www/admin/plugins/" var="/var/plugins/" [pluginUpdatesServer] protocol=http host="code.openx.org" path="/openx/plugin-updates" httpPort=80 [pluginSettings] enableOnInstall=1 useMergedFunctions=1 [plugins] openXBannerTypes=1 openXDeliveryLimitations=1 openX3rdPartyServers=1 openXReports=1 openXDeliveryCacheStore=1 openXMaxMindGeoIP=1 openXInvocationTags=1 openXDeliveryLog=1 openXAdditionalBannerTypes=1 openXDeliveryLogCountry=1 openXMaxMindModGeoIP=1 openXVideoAds=1 [pluginGroupComponents] Client=1 Geo=1 Site=1 Time=1 oxReportsStandard=1 oxReportsAdmin=1 oxInvocationTags=1 oxDeliveryDataPrepare=1 oxLogClick=1 oxLogConversion=1 oxLogImpression=1 oxLogRequest=1 ox3rdPartyServers=1 openXHtmlAdsense=1 oxMaxMindGeoIP=1 oxHtml=1 oxText=1 oxCacheFile=1 oxMemcached=1 oxDeliveryGeo=1 oxLogCountry=1 oxMaxMindModGeoIP=1 vastInlineBannerTypeHtml=1 vastOverlayBannerTypeHtml=1 oxLogVast=1 vastServeVideoPlayer=1 videoReport=1 [audit] enabled=1 enabledForZoneLinking= [Client] sniff=1 [deliveryHooks] cacheStore="deliveryCacheStore:oxCacheFile:oxCacheFile|deliveryCacheStore:oxMemcached:oxMemcached" cacheRetrieve="deliveryCacheStore:oxCacheFile:oxCacheFile|deliveryCacheStore:oxMemcached:oxMemcached" preLog="deliveryDataPrepare:oxDeliveryDataPrepare:dataCommon|deliveryDataPrepare:oxDeliveryDataPrepare:dataPageInfo|deliveryDataPrepare:oxDeliveryDataPrepare:dataUserAgent|deliveryDataPrepare:oxDeliveryGeo:dataGeo" logClick="deliveryDataPrepare:oxDeliveryDataPrepare:dataCommon|deliveryDataPrepare:oxDeliveryGeo:dataGeo|deliveryLog:oxLogClick:logClick|deliveryLog:oxLogCountry:logClickCountry" logImpression="deliveryDataPrepare:oxDeliveryDataPrepare:dataCommon|deliveryDataPrepare:oxDeliveryGeo:dataGeo|deliveryLog:oxLogCountry:logImpressionCountry|deliveryLog:oxLogImpression:logImpression" logConversion="deliveryLog:oxLogConversion:logConversion" logConversionVariable="deliveryLog:oxLogConversion:logConversionVariable" logRequest="deliveryDataPrepare:oxDeliveryDataPrepare:dataCommon|deliveryLog:oxLogRequest:logRequest" postInit="deliveryLimitations:Client:initClientData" logImpressionVast="deliveryLog:oxLogVast:logImpressionVast" [oxCacheFile] cachePath= [oxMemcached] memcachedServers= memcachedExpireTime= [oxMaxMindGeoIP] geoipCountryLocation= geoipRegionLocation= geoipCityLocation= geoipAreaLocation= geoipDmaLocation= geoipOrgLocation= geoipIspLocation= geoipNetspeedLocation= [oxInvocationTags] isAllowedAdframe=1 isAllowedAdjs=1 isAllowedAdlayer=1 isAllowedAdview=0 isAllowedAdviewnocookies=1 isAllowedLocal=1 isAllowedPopup=0 isAllowedXmlrpc=0 [vastOverlayBannerTypeHtml] isVastOverlayAsTextEnabled=1 isVastOverlayAsSwfEnabled=1 isVastOverlayAsImageEnabled=1 isVastOverlayAsHtmlEnabled=1 [vastServeVideoPlayer] isAutoPlayOfVideoInOpenXAdminToolEnabled=0 [trim] 1= I followed the procedure step by step and in fact I have not had any problems with previous updates. Any idea what's going on?. I tried the upgrade also from 3.0.4, 3.0.5 and 3.0.6. Thanks.