Download only the changed files from 0.9.8 to 1.0.0: DDSC 1.0 upgrade patch

Upload and overwrite all the files from the patch to your current installation.

The DDSC upgrade goes in 3 step:

1. backup existing database and project files
2. install the new version of DDSC
3. restore the database records and project files

Make a backup of your current install and more specificaly a backup of the vhosts/

  cp -r sitecreator/vhosts/ bkp/

Export the users information from the database. With the MySQL command line:

 mysqldump -ct --extended-insert=FALSE -p dragdropsitecreator projects users db_ftp   > ddsc_old.sql

If you want to use the same database you will need to delete or rename the current tables.

ALTER TABLE `category` RENAME `categorybkp` ;
ALTER TABLE `db_ftp` RENAME `db_ftpbkp` ;
ALTER TABLE `ftp_servers` RENAME `ftp_serversbkp` ;
ALTER TABLE `pkg_sources` RENAME `pkg_sourcesbkp` ;
ALTER TABLE `projects` RENAME `projectsbkp` ;
ALTER TABLE `resellers` RENAME `resellersbkp` ;
ALTER TABLE `sitetemplate` RENAME `sitetemplatebkp` ;
ALTER TABLE `users` RENAME `usersbkp` ;
ALTER TABLE `emailtemplate` RENAME `emailtemplate` ;

Third install the new version of DDSC in a clean directory

After intalling the new version of DDSC we restor the files and database data.

Restore the vhosts/ files

 cp -r /bkp/vhosts/ sitecreator/

Import the user information in the new database.

 mysql -p newdragdropsitecreator < ddsc_old.sql

Regenerate your license key. Login at http://www.dragdropsitecreator.com/ and re-generate your license key to replace the 2 free users license. The license key file is .ht_keyfile.inc.php

The new version of DDSC assume that all the project names are lower case. if its not the case you can update them using this sql command

UPDATE projects SET projectname=lcase(projectname);

If your running a very old version of PageBuilder or use different ip addresses you may need to upgrade the PageBuilder.

Setup a plan that will have access to: “Add or upgrade packages” Then in software packages add the pagebuilder package to the list of software for that plan.

Then set all the users with that plan.

Once the user log in they will have to go to Options, software / update and click upgrade in front of the pagebuilder.

If your are running a new license key with a different ip address you will need to copy your main license key .ht_keyfile.inc.php in all your projects event folders: vhosts/projectname/events/.ht_keyfile.inc.php

Also if you upgrade from a old version you will need to upgrade your users PAS library. From your sitecreator folder:

  cp -rf pas/sitetemplate/pas vhost/user_project/

There is currently no automated upgrade script. Because there is not standard process. Bellow some guideline on how to upgrade your version of DragDrop Sitecreator.

Download the latest version of DragDrop Sitecreator

  wget http://www.dragdropsitecreator.com/release/dragdropsitecreator.tar.gz

unzip it in a temporary directory

  cd /tmp/
  tar -zxvf dragdropsitecreator.tar.gz

change directory to the where you have the sitecreator folder and backup the old sitecreator

  mv sitecreator/www sitecreator/www.bkp
  mv sitecreator/admin sitecreator/admin.bkp
  mv sitecreator/pas sitecreator/pas.bkp

Then copy the new DragDrop Sitecreator files

  cp -r /tmp/sitecreator/www sitecreator/
  cp -r /tmp/sitecreator/admin sitecreator/
  cp -r /tmp/sitecreator/pas sitecreator

Last the the files permissions, you need the tmp, package, projects, to be writable by the web server. In general the web server user and group are apache or nobody.

 chgrp apache sitecreator/www/passitemanager/tmp
 chgrp apache sitecreator/www/passitemanager/package
 chgrp apache sitecreator/www/passitemanager/projects

 chmod g+w sitecreator/www/passitemanager/tmp
 chmod g+w sitecreator/www/passitemanager/package
 chmod g+w sitecreator/www/passitemanager/projects

If there is a upgrade_from_x.x.sql that apply to your upgrade version, import the sql file in your mysql database

 mysql dradropsitecreator < upgrade_from_x.x.sql