Jump to content

Problem With The Database


Recommended Posts

Heya folks,

 

recently some customers reported errors with the Revive Adserver, providing me with screenshots like this

https://drive.google.com/file/d/0B_nxS34MJR2BbDFVRlNhcmc0U1k/edit?usp=sharing

Using the workbench, i can verify that the table is broken. What really strange is, that if i want to start the table maintenance, the workbench tells me that oa_data_intermediate_ad is a view and not a table anymore.

I restored a database from an old snapshot and there it says that oa_data_intermediate_ad is a table. So what do to now? And yeah, my daily backup wasnt working properly after upgrading the db, dooh. So restoring the table from an backup is unfortunately not an option. :(

 

thanks in advance and sorry for my 'its not my first language' english,

 

pxl-rene

Link to comment
Share on other sites

Hey Eliza, thanks for the advice.

 

This is what i already tried in the meantime, but i wasn't able to use the table maintenance because it didn't even show me the 'oa_data_intermediate_ad' in the table column, but in the view column, like i stated in the entry post.

 

I launched a snapshot of the last working day, dumped the table and reimported it into the live database. But it would be nice, to have a better workaround for this or even prevent things like that in the future..

 

greetings,

 

pxl_rene.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.



×
×
  • Create New...