how to reinstall from backup?

[Lana77]

Hi all,

After failed add-on install I am trying to reinstall from backup database and getting this error:

 

1146 - Table 'vfshrvh_osc1.whos_online' doesn't exist

 

delete from whos_online where time_last_click < '1263043797'

 

 

 

How do I get back to previous view of my site prior to failed add-on install? Does it involve anything more than just hitting 'reinstall' twice?

 

many thanks,

 

Lana

[♥mdtaylorlrim]

Hi all,

After failed add-on install I am trying to reinstall from backup database and getting this error:

 

1146 - Table 'vfshrvh_osc1.whos_online' doesn't exist

 

delete from whos_online where time_last_click < '1263043797'

 

 

 

How do I get back to previous view of my site prior to failed add-on install? Does it involve anything more than just hitting 'reinstall' twice?

 

many thanks,

 

Lana

Add ons do not affect the database in a negative way. That is, they seldom, if ever, remove a column from the db. Therefore, there is no reason to do any database restore after a failed add on. You should only need to restore the few files changed that the add on altered.

 

Just ftp up your files backup prior to the add on. Or, reading the install document of the add on, ftp up only those files that it altered.

 

However, whois_online is a valid table for a stock osc so you may have other problems. The table prefix 'vfshrvh_osc1' does that appear on every table in your database? Can you browse you db with phpMyAdmin? Does it appear that all your tables are there? Do they all have that same prefix? Is that table there? Maybe you can create it by hand, although backups have the 'delete if exist' conditional then create the table from fresh..

 

Is it possible that your store is online at the time you are attempting a restore?

[Lana77]

Add ons do not affect the database in a negative way. That is, they seldom, if ever, remove a column from the db. Therefore, there is no reason to do any database restore after a failed add on. You should only need to restore the few files changed that the add on altered.

 

Just ftp up your files backup prior to the add on. Or, reading the install document of the add on, ftp up only those files that it altered.

 

However, whois_online is a valid table for a stock osc so you may have other problems. The table prefix 'vfshrvh_osc1' does that appear on every table in your database? Can you browse you db with phpMyAdmin? Does it appear that all your tables are there? Do they all have that same prefix? Is that table there? Maybe you can create it by hand, although backups have the 'delete if exist' conditional then create the table from fresh..

 

Is it possible that your store is online at the time you are attempting a restore?

 

Hi,

I restored the altered files back, still shows the same error. The table prefix 'vfshrvh_osc1' does not appear on every table in my database. I can browse my db with phpMyAdmin. All tables are there except 'whos_online', they do not have that same prefix. I can create new table by hand, but I do not know what number of fields it requires, and other input parameters.

Do you have any suggestions?

thanks

[Lana77]

Hi,

I restored the altered files back, still shows the same error. The table prefix 'vfshrvh_osc1' does not appear on every table in my database. I can browse my db with phpMyAdmin. All tables are there except 'whos_online', they do not have that same prefix. I can create new table by hand, but I do not know what number of fields it requires, and other input parameters.

Do you have any suggestions?

thanks

 

Already fixed it - found this db on local drive and copied the table from there.

thanks

Lana