davek0974

The duplicate site AND the main site were created from the exact same installer package which was a backup of the original live site – this means both sites were originally 100% identical.

The ONLY difference is that the broken site has been upgraded to 4.2 and the good site is still 4.1.1

Its not just the gallery images, it has converted ALL pages, categories and products to blog posts – this is wrong.

When I do a restore, I create a brand new empty database and a fresh directory structure so all items are totally clean and identical.

I have no revisions and its not stuck in a loop, the fault is that every time i try to upgrade it wrecks the site and converts ALL products, pages, categories to posts and removes ALL media.

I am not using any caching software

During the last issue we had yesterday, we tried disabling all plugins, dropping to a default theme and doing a manual WP install, none of these worked.

I passed it to my host, they took a copy of one of my sites and tried an update and their reply is quoted here…..

Hi David,

It appears there may be a problem with the site’s database, but unfortunately I can’t troubleshoot the issue any further. However I have been able to gather some errors which may be of use if you provide them to www.remarpro.com support.

Updating from 4.1.1 through the WordPress dashboard to 4.2 (EN_GB version). I tried updating without making any changes then again with all the plugins disabled, but to no avail.

When using the update tool in the WordPress Dashboard it seems to complete but redirects to the ‘Database Update Required’ page at /wp-admin/upgrade.php. At this point if you check the front-end it all seems to be working okay and the site looks as normal.

However when navigating to wp-admin it redirects again to the ‘Database Update Required’ page. When clicking the button to ‘Update WordPress Database’ the following errors were printed on screen:

WordPress database error: [Table ‘ddmetalp1_wp.eHwwxpUrcategories’ doesn’t exist]
SELECT * FROM eHwwxpUrcategories ORDER BY cat_ID
WordPress database error: [Table ‘ddmetalp1_wp.eHwwxpUrpost2cat’ doesn’t exist]
SELECT post_id, category_id FROM eHwwxpUrpost2cat GROUP BY post_id, category_id
WordPress database error: [Table ‘ddmetalp1_wp.eHwwxpUrlinkcategories’ doesn’t exist]
SELECT cat_id, cat_name FROM eHwwxpUrlinkcategories
WordPress database error: [Unknown column ‘link_category’ in ‘field list’]
SELECT link_id, link_category FROM eHwwxpUrlinks

Following that, the Dashboard is working fine, but the database update has certainly caused some chaos to the site’s content, perhaps because it may have broken some plugins or otherwise corrupted the database. Additionally to the above errors, i’ve included an attachment of the PHP error log in a txt file which contains additional database errors which may help troubleshoot the issue.

Hopefully that will help debug if someone understands what it all means??? If you want a copy of the PHP error log let me know and i’ll make it available somehow.

Dave

Of course, here it is
failed test

It should look identical to this one
good site

I will not repair the broken site until the weekend for sake of the above links.

Thanks

soory, the only way i could get the sites running again was to restore them afted adding define (WP_UDATE_CORE, false) to the wp-config files to block the 4.1.2 update because it was being applied as soon as the sites were restored.

now i have an update controller plugin, should i remove that line???

after installing a update controller, do i need to remove the add-on line from wp-config?????

All back up and running ??

I have installed an update control plugin too.

I am not upgrading for a few days yet, even then it will be on my test site first.

Thanks for all the tips

this is tag-farming, i had domination site stats last week

they copy your analytics tag code, paste it into their site and you see their stats on your google page, you see the link, follow it and presto they get free traffic courtesy of you.

cant get rid of it, they change servers so filters are useless, i dropped google and moved to clicky.com

Yes, and i have asked them to edit the config file first and do a restore

I meant edit your own backup, but if you just need a WP4.1.1 install they are on this site somewhere, you neeed to do this

disable automatic updates in WordPress by adding this line of code in your wp-config.php file:

define( ‘WP_AUTO_UPDATE_CORE’, false );

This will disable all automatic WordPress updates.

It is the 4.1.2 update, edit a 4.1.1 backup to block updates and restore, all will be well again.

I am doing this now after proving it on an isolated server

I can confirm this 100% caused by 4.1.2

I now have an isolated Xampp apache server running on my laptop and i can install and run them in 4.1.1 and all are happy

as soon as i connect the laptop to the net, they update and fail to 4.1.2

i have asked my host to edit the installs to block auto updates and restore all my sites

IT IS THE UPDATE!!!

yes 4.1.1

i also did a manual install of the 4.1.1 but it didnt make any difference and ive just got the email telling me its been updated already to 4.1.2!!!!

dont know what else to try ??

It could also be tag-farming, I have suffered this, sites take your GA tag and paste it in their site, you see their stats and click on the link = traffic for them at no cost

the only way to rid it is to dump your GA code and start again, or go to a better stats app like clicky.com