Hi, I took a full system backup of a multisite environment before upgrading from Joomla 1.5.15 to 1.5.23. As it broke some things I asked the host to restore from that backup.

Now the main site works fine (aamembers.org.nz) but the two subdomains (aa.org.nz and aaconvention.org.nz) have a session database error.

jtablesession::Store Failed
DB function failed with error number 1146
Table 'aamember_joomla.aamain_session' doesn't exist SQL=INSERT INTO `aamain_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( 'a32002058cfa329400c01661fbbbea82','1303722839','','0','1','0' )

Any idea what this is about? I would of thought restore to same hosting setup/domain would of been fine?

This is a high profile live site so any help will be hugely appreciated! (I did test all this on another environment which was fine but unfortunately not so fine on the live environment)

I just resaved the slave site definitions within the master site multisites administration area and this resolved the issue - panic over

However, I am reconsidering upgrading from 1.5.15 due to this. Any thoughts on if this is a good idea or anything to watch out for as I did spot a few references to problems with 1.5.16 onwards.

If the table was missing, the fact that you performed an open/save in Jms Multi Sites has rebuild the missing tables using the rule present for the slave.

Perhaps you had shared the users and that all views where not restored.

yes the users are shared so sounds like what could of happened. Though I would leave topic here incase anyone else has similar trouble.