Jump to content

Search the Community

Showing results for tags 'database'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • Using and Managing Revive Adserver
    • Documentation
    • Using Revive Adserver
    • Managing Revive Adserver
    • Bugs
  • Advanced Topics
    • Performance, Scalability, and Reliability
    • For Developers
  • Revive Adserver Community
    • Revive Adserver Project News and Announcements
    • Feature Requests
    • Plugins
    • Requests for Consulting
    • Off Topic

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


Website URL

Found 13 results

  1. I have an insert which is failing in lib/pear/DB/DataObject.php here: $this->raiseError("insert:No table definition for {$this->__table}", DB_DATAOBJECT_ERROR_INVALIDCONFIG); return false; Never mind about the source of the error for now, I'm working on that (fixed). The issue is that I didn't see this error until I hunted it down by cut and destroy. The code in question returned false and continued otherwise silently. So, my question is whether my config is insufficient to call attention to this error, or is something else going on inside Revive which stops the error from being propagated out. In my php.ini I have, although nothing appears in the apache error logs, or in php_errors.log either: error_reporting = E_ALL display_errors = On log_errors = On error_log = php_errors.log In my Revive config I have, although nothing appears in the var/debug.log (and yes, it's writable). [log] enabled=1 type=file name="debug.log" Following dumping information manually to screen, I found the DB_DATAOBJECT_ERROR_INVALIDCONFIG call, however, without this: Nothing appears on screen, or in any logging/debug file. Excuse me for showing my ignorance, but perhaps there is a simple flag I'm missing, or someone has some helpful pointers here...?
  2. I am trying to install revive on my Centos 7, php 5.6,Mysql 5.5.47 server and I cannot get passed the " Installing database... " message on the screen. Verified the database , passwords, and rights . Any tip will be appreciated. Thanks David
  3. I need to change my database server and in doing so throws me the following error: MDB2_Error::setFetchMode() Previously I changed my configuration file by placing the IP address of my new server
  4. Hi, So I was just taking a look at my database and I notice that I have mixed table prefixes (rv_ and ox_), pressumably left over from earlier incarnations of the software. Are these legacy tables (ox_) still needed? I also notice many tables with random looking names, what about those? Thank you! Hugh --- ox_z_0c8971a0b5a2778d ox_z_0e7b287c4b1d5f0f ox_z_00bcfceb4d6ed89d ox_z_00e11daab9ca1b87 ox_z_04483be74f999d25 ox_z_0493d1cfbdb8d7e2 ox_z_08d49b0f4db2ec7c ox_z_1a800d9a5be064ce ox_z_1c2471cdd657fa01 ox_z_1eefb8cf5b89cfbc ox_z_1fbcb5a9d38d93a2 ox_z_2a945cff93bf5ad2 ox_z_2ad232fa61039438 ox_z_2b272788b0859cc0 ox_z_2ebb71db636955ad ox_z_2f5d547e628f7008 ox_z_3b5775767e310205 ox_z_3bef635ffd969b9f ox_z_3ca45a3158b76e9a ox_z_3cba5b6385915d4e ox_z_3cc483d585ef85f8 ox_z_3dbd0dc3489c7ff9 ox_z_3f4011c60eb981c1 ox_z_3fbf86047ad9f177 ox_z_4bc3ae3a06118a4c ox_z_4d8f252c87fcaee0 ox_z_4da5ebe57c5c7be2 ox_z_4dafb742007d9334 ox_z_4e2cf58903fed1ff ox_z_4f6d0a53851e819f ox_z_4ffd588e022f7cf8 ox_z_6c17f17086aef1bc ox_z_6f907754f88e9ffa ox_z_6fe724ba223500cc ox_z_7ec93bf3128ece77 ox_z_8afb1fee18e3e2fe ox_z_8fdc9e97cabae9e4 ox_z_9a2fbcbf505c3773 ox_z_9a59b2e75310f416 ox_z_9abddd92a7ec4326 ox_z_9cdbe7e156a86c2d ox_z_9e01a84f0c19555f ox_z_9e4b3016d3991460 ox_z_9f3e4cedd2ec689b ox_z_12b98db357dffac0 ox_z_12c30ee5abe808c8 ox_z_12c3139c5f1137ea ox_z_18fc0867532daea5 ox_z_24da407661bc3705 ox_z_24e12246eda864b7 ox_z_25f82ef19cd328dc ox_z_32da93de7f08b7a8 ox_z_38ebafc47d8dd8b7 ox_z_46bc080f8a8d2e04 ox_z_46d7b13b0d0617f9 ox_z_46db72e48ca8f928 ox_z_47f1d3cd8d825801 ox_z_59e1a00ce0caa621 ox_z_63a83a722e7a1e04 ox_z_65a3a61f28718269 ox_z_65e6cb08af9540c4 ox_z_69f65efda385d531 ox_z_70c36c95e2fb5b0e ox_z_80b86c49c5de1b3a ox_z_80dcb0634aaf3baf ox_z_81eaccae48a38a5f ox_z_82e6ead548956119 ox_z_86de5d27cd0ffbe5 ox_z_88a07ce51ab881f5 ox_z_89b04c821ba8b192 ox_z_208bb4d199a0b2fc ox_z_219ebbdfedaf9dd4 ox_z_324c91920f1d0f26 ox_z_339b6c04f9e8e7c8 ox_z_410a7e49d61496e7 ox_z_423ec6ef884d4d23 ox_z_474b2696270e08f6 ox_z_564a0de39c39862f ox_z_577b95da121de2a9 ox_z_587f82ba9e067a7a ox_z_589fc9fb38dae79b ox_z_590e48a6e0254e8b ox_z_710ac226f8c4ccce ox_z_754edce619092962 ox_z_819a02ce38b104e3 ox_z_834ac545c62cb236 ox_z_897ddacacc1badb9 ox_z_1550f84650368f35 ox_z_2371fe7412886e73 ox_z_3223fcfdf8507731 ox_z_7866c05800faab41 ox_z_8324d370c642a403 ox_z_8558f4bdc88ad0cb ox_z_9139aeb1ac683005 ox_z_9356a42a08f41f62 ox_z_9643e1ff5c306a33 ox_z_15756a42d30c9282 ox_z_73974f3b992e4ff7 ox_z_82372af34844a13f ox_z_82814ebde6927a16 ox_z_98766ea65e0f9666 ox_z_106663fe5db44788 ox_z_462198c677d808c1 ox_z_497436d60c1241a5 ox_z_505332ee3c14c76a ox_z_848332f5139dda5b ox_z_3357956df9241ea1 ox_z_8398194ff6b96b75 ox_z_8430851b4e430ed7 ox_z_12799713ab52913e ox_z_13641853d917939f ox_z_950233040ea0884c ox_z_6099864825fff13b ox_z_4343295906255e2a ox_z_a0057b6dedd75f1b ox_z_a06ac48ee50cb3fd ox_z_a3cbc1ce6ffae7c5 ox_z_a4a51916e5c57042 ox_z_a4fc92de36e46fce ox_z_a7b7c1b235af3ca2 ox_z_a63a75f8342288e8 ox_z_a30700c069748b0c ox_z_a926267fec40510c ox_z_aa84bfc53d9a576b ox_z_ac596b3f662ae0f3 ox_z_ace167e56692ec29 ox_z_adbeda6de8d8ad1e ox_z_ae8ca05cebead72f ox_z_ae46b97e643532b2 ox_z_af9d8ffe16b689d3 ox_z_afed419e66a4076f ox_z_b09ba15222835c42 ox_z_b2dc6ad178afe11d ox_z_b8b6f2ccfdd085bf ox_z_b12e41e52f7b2dd6 ox_z_baaa32c624ff5ef5 ox_z_bb759c382c6b7496 ox_z_bb1935c4321256a1 ox_z_bbc1a461fea7d312 ox_z_bc785cfd75311a0c ox_z_bcfcacdd2be24473 ox_z_bdccad37266e167f ox_z_bfda4785fabc30f6 ox_z_c07fef68576107c6 ox_z_c08e3aaa09c77c5b ox_z_c4d7c2a856cf3fb8 ox_z_c74b8db08a99a9c6 ox_z_c643d4d4bedfbfcd ox_z_c6041eac4fca1044 ox_z_cb6bc86aa72c3dee ox_z_cc761bad06059061 ox_z_cc809dbc75ab9b91 ox_z_cdb25bb7270b5b7b ox_z_cee678195cde4f82 ox_z_d5b1a9951cf8ef64 ox_z_d8f5e47b932442b9 ox_z_d232e5fc388be530 ox_z_d573dd2d9015aa5e ox_z_d783fe4a459b035a ox_z_d3802de896e65a9b ox_z_db1b36be96c912c8 ox_z_dbc6372462ed3109 ox_z_dc58491b918a6d6d ox_z_df843c299256185f ox_z_e2ec12b0289f997c ox_z_e275219e756bc930 ox_z_e685715cab57552a ox_z_ea4dcbb5785536a5 ox_z_ef9115718fd43b11 ox_z_f96a7928bc0c0e5b ox_z_f863e24532106989 ox_z_f2457d8ecf14e33a ox_z_f984737a6b9c8e6a ox_z_fbb624a532ff6254 ox_z_fbe9d430be8fa343 ox_z_fc4e0a1eb9287d6d
  5. I just did a hotcopy of the old DB on top of the new v3.2.4. Getting this: You are currently using Revive Adserver v3.2.4 (warning: database is stamped as v3.x.x) I know, I know, I didn't follow exactly the upgrade procedure (too complicated in fact). Is there a problem with this?
  6. 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@example.com" 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.
  7. Hello, I am trying to install Revive Adserver 3.2.2: I did exactly like mentionned : Created a database on my Cpanel VPS Launch the install from the folder and agree to terms. Then comes the database data. I tripled checked that the data was correct, then click, then back to the same form, and again and again. Var folder is 777, don't know what to do more... Tried various browsers, same issue. Server is WHM/CPanel VPS with Apache 2.4.8 and PHP 5.6. MariaDB 10.0.23 Any help would be appreciated Stephanie
  8. I move my site to another server and I keep getting a database error when trying to log in. I updated the config file for the new database and and uploaded the db to the sql server.
  9. My Revive installation stopped counting stats all of a sudden the other day. The reason was quite simple, one of the Mysql tables (<prefix>_data_intermediate_ad) was broken (and the var/debug.log grows quite fast). Here's how to fix, in case someone else runs into the same issue: mysqlcheck -uroot -p <revive_database> --repair
  10. I have been advised to change the password on my SQL database, in hopes of securing it (in case the hacker managed to snag that information). However, I can't seem to get the password to update. I've gone into phpMyAdmin inside my cPanel, and tried setting a new password. Then I changed the password in the config.php file. But I can't log in with the new password; however, the old password continues to work. I've tried setting up a new user with a new password, while removing the old user. After updating the config file, I couldn't log in with the new info, but I could still log in with the old info. I tried deleting the old user completely. After updating the config file, I still couldn't log in with the new info, but I could still log in with the old info. I tried importing the old database into a new database (with a new name), and creating a new user with a new password for the new database. After updating the config file, I couldn't log in with the new info, but I could still log in with the old info. What the frick am I doing wrong? Thank you. Eliz.
  11. Can we ever delete the old data from rv_data_intermediate_ad? I am hoping that this raw data is summed up to the hourly table so we can then delete old data from this one. Is that true? Can we get rid of old data in this table without harm? Please advise.
  12. Hi, i'm use openX / Revive for many year. One of the websites with a lot of traffic is getting some issues. A quick database backup is at this moment 5GB+.... most of this data is in de the table: -ox_data_intermediate_ad (2.8GB) - ox_data_summary_ad_hourly (1.4GB) the question is, is there a possibility to optimize or cleanup this tables so the data isnt stored for years etc? a solution would be great. ps at this moment im using version: Revive Adserver v3.0.2 . ps2: there is also an error shown on the update page that it isnt possible to catch data if there is a new version.
  13. Hey, So I successfully managed to get logging working after upgrading to 3.0.0 from an old OpenX installation, and it was running for a few days. I then saw the upgrade to 3.0.2 and went through the incredibly laborious process of upgrading, only to discover after a few days that it wasn't logging statistics any more! So I disabled and re-enabled the plugins, uploading the zips from a fresh copy of 3.0.2. Today I discovered that when I disabled the plugin Revive dropped the old statistics tables. Deleted my data! So then I recreated the tables and it seems to be logging data. So, first I would assume that an ad delivery system should have logging built in. Then, when I disable a plugin I don't want my data deleted. Ever! It seems like a lot of people have had problems with upgrade and logging. I would hope that the next version should have an automatic upgrade, and not break all the plugins. I can't afford to have missing statistics either, since we depend on that for billing clients. Josh
×
×
  • Create New...