We use browser cookies for a number of reasons, such as keeping the YourSites website reliable and secure, personalising content, and to analyse how our site is used.



Blog

There is a bug in Akeeba Backup (most recently confirmed in version 6.5.1) which can cause the restoration of a backup of your YourSites server to fail. It has been reported (see the akeeba support ticket) and hopefully the issue will soon be resolved.

Whilst the bug exists if you do need to restore a backup then you will need to undertake a special process to allow the database data to be restored.

  1. Start restoration process but STOP when you get to the database restore step
  2. Use FTP and a file editor to examine the files in installation/sql/ called sites.s[i]nn[/i] in these are the table creation and insertion queries
  3. Find text that includes the text

    "GENERATED ALWAYS"

    It should appear in at most 2 files. For example
    `extnauthorurl` varchar(200) GENERATED ALWAYS AS (if(length(`manifest_cache`),ifnull(json_unquote(json_extract(`manifest_cache`,'$.authorUrl')),''),'')) VIRTUAL,
    

    You will need to edit each of these to remove the GENERATED ALWAYS ... VIRTUAL part. e.g.
    `extnauthorurl` varchar(200) GENERATED ALWAYS AS (if(length(`manifest_cache`),ifnull(json_unquote(json_extract(`manifest_cache`,'$.authorUrl')),''),'')) VIRTUAL,
    
    becomes
    `extnauthorurl` varchar(200),
    
    This should affect the declaration of up to 6 fields

    #__ysts_sites -> certinfo, cachesize, dbsize, tmpsize
    #__ysts_extensions -> extnauthor, extnauthorurl

    This will allow the restoration to complete.
  4. You now need to make sure you are using YourSites version 1.7.4 (or later). Upgrade now if you haven't already.
  5. We now need to allow YourSites to restore the table columns we broke in step 3 in order to restore the backup. We do this by removing them from the database using the following SQL commands - YourSites will automatically recreate them

    
    alter table #__ysts_sites drop column certinfo;
    alter table #__ysts_sites drop column cachesize;
    alter table #__ysts_sites drop column dbsize;
    alter table #__ysts_sites drop column tmpsize;
    
    alter table #__ysts_extensions drop column extnauthor;
    alter table #__ysts_extensions drop column extnauthorurl;
    
  6. Go to YourSites in the backend - first time you load may take a couple of minutes for the data to repopuplate.

Version 1.5.0 of YourSites is a Big Milestone

You can now manage your WordPress/ClassicPress sites alongside your Joomla sites.

We have implemented exciting new features in version 1.6 of YourSites

Perhaps most excitingly you can now set site specific backup times - you can set a schedule of backups, monthly, weekly or daily selecting specific dates/days and time(s) and we include suggested cronjob interval information on the config page.

One of the issues that our users encounter in making the transition to YourSites from the myJoomla online service - is cleaning up the database tables left behind when uninstalling the myJoomla plugin from their client sites.

YourSites version 1.1.0 includes a few security enhancements - these are summarised below.

Elmination of Timed PHP Hash Comparisons

YourSites version 1.1.0 improves the way we validate calls from the YourSites server to the client sites so as to avoid a theoretical timing attack (see http://php.net/manual/en/function.hash-hmac.php#111435). This risk was, however, negligible in version 1.0.0 since each hash was only used once (see below for more detail) and due to the high variability of timing of web requests.

Version 1.4.4 introduces 3 security enhancements to YourSites

The security of your data with YourSites is always at the top of our minds. We are therefore pleased to introduce some security enhancements in YourSites version 1.4.4. These address completely theoretical security risks in versions 1.4.3 and earlier.

In addition to these security enhancements we have added a new documentation article all about how to make your YourSites server/configuration as secure are possible. See Setting up a Secure YourSites Server for more detail.

Love us? Review us!

We love every single one of our users, without you YourSites simply couldn't happen! So we would love a review at the Joomla! JED so we can let others know about us too, please take a minute to write a review:

https://extensions.joomla.org/extension/yoursites-manager/

If you feel you have something negative to say, we would implore you to speak to us first, as we really really don't want anyone to be unhappy!

STAY CONNECTED