Upgrading to 1.6 by creating a subdomain and see what's happen when you install 1.6 over the old.

[jjjoseph]

I created a subdomain and transfer my site to it. Backup my database but when I try to restore it to the newly created database the uploading stop at ps_connections_page., which is way to big. I modified the PHP timing settings on my server but to no avail.

 

I want to keep at list 2 years of data. Actually I have from 2010. I want, hopping that it is enough, take out 2010 and 2011. Strangely (coincidence) 2012 start with ID_connections of 100,000, I want to delete from 1 to 100,000. I want to know the syntax to set the number of row to delete from 0 to 100,000. I went all over the net and all the examples in the tutorials for mysql were for a specific row. is it 1 to 100,000 or 1, 100,000 or 1...100,000 or ...? what is the correct syntax.

 

I hope in a next version that we will be able to keep more than a year in the stats and be able to choose which years to keep.

 

By the way If anything happens to my site right now I will not be able to restore the database because of it's size.

[jjjoseph]

DELETE FROM `ps_connections` WHERE `id_connections` <230000

 

I used this syntax and I reduced the database to 1 year and half.

 

I find out that it is better to use prestashop backup versus the one with cpanel.

Still have some problem with ps_pagenotfound table may have to delete it.

 

Well I keep trying to create an image of the site on a subdomain.

[jjjoseph]

I went to the error log in the root directory of the subdomain and I found a syntax error, corrected-it an now everything up. The only problem now is "We're sorry, but the Web address you entered is no longer available" when you click a product. I have seen that in the forum somewhere will look...

Edited May 26, 2014 by jjjoseph (see edit history)

[jjjoseph]

Generated a new .htaccess in the subdomain root by doing yes and no in friendly url and now everything is fine, ready to try to go to 1.6

Edited May 26, 2014 by jjjoseph (see edit history)