Hi All

I've recently upgraded my server hardware and operating system, and have come across some weird problems which I first thought was the result of being hacked (discussed here). I soon realised that this wasn't the case, and narrowed the problem down to a problem the smarty caching system had with my theme (discussed here). I have since been able to determine that the problem was due to my theme being corrupt, and it must've become corrupt some time ago as I had to go back to a backup from 2 months ago to get a working version. The reason that this corruption never showed up earlier was due to my extensive use f the XOOPS caching system.

Anyway, that problem now seems to be sorted. However, I now have another one. It seems that I have a lot of double listings of items. In particlar double listings of recently online users in the online history block, double listings in the downloads and weblinks modules. Another thing I noticed is that these double listings only occur for items/users that were present prior to my upgrade. Any user/item added since the upgrade appear as normal.

I've tried going though the database line by line, and there are no double listings there, so I assumed it to be some sort of problem with the XOOPS caching system. I disabled all caching on modules and blocks, deleted everything in the template_c directory and tried refreshing the site but the double listings are still there. I turned the PHP Debug feature on, and just on loading the front page I'm given 4 warning messages saying the following;

Warning [PHP]: unlink(D:/path/to/xoops/cache\db%3Asystem_block_online.html): Permission denied in file D:\path\to\xoops\class\smarty\Smarty.class.php line 2059

I've tripple checked the permissions on the entire site directory and its contents and the IUSR_MACHINENAME user account used by IIS has read & write permissions to it all. The only difference I can see in the error abouve is that the first path has / to seperate the path, whereas the second path uses \. I'm close to wits end on this one, so if anyone could think of anything that I perhaps haven't tried I'd really appreciate it. Thanks.

I created a test XOOPS 2.0.4 website and restored the last backup I did before upgrading my server. This poplulated the test site with data from last month, but most importantly the data in the Online History, Downloads and Weblinks modules was no duplicated.

What I did then was export all tables and data from the live database to the test database, with exception to the Online History, Downloads and Weblinks tables. This updated the test site data to be identicle with the live database with exception to the problem modules.

I didn't care about loosing the online history block data, and hadn't made any updates to my weblinks module since the last clean backup, so there was no data loss there. However, I did loose 1 download which I had added the other day which I have since re-added.

I Never actually found what was causing it, but I'm 99% sure I have eliminated it. Talk about a crash course in advanced database management ! All in all I think I was pretty lucky to get out of it with only having to recreate one record.