move cscart site

Store Builder Questions
1

Hi,



my customer has a site and I need to move it to a new host.



I downloaded a copy of their site. I uploaded both to a new site.



Next I opened /cscart/config.local.php and changed the following:

$config['db_name'] = 'XXXXX'; ← inserted new dbname

$config['db_user'] = 'XXXXX'; ← inserted new dbuser

$config['db_password'] = 'XXXXX'; ← said password, but I tried adding the new password. Where else is the pw actually stored?

and

$config['http_host'] = 'test.XXXX.com';

$config['http_path'] = '/cscart';

$config['https_host'] = 'test.XXXX.com';

$config['https_path'] = '/cscart';



On the current host, its installed as XXX Sex - Free Porn Videos at XXX.com, but I'd rather use XXX.com, dropping the path cscart. No problems with that? At the same time, does anyone have any URL rewriting handy for redirecting older test.XXXX.com/cart to test.XXXX.com URLs?.



Next, I went to upload the database and I get the error:

Error



SQL query:



–

– Dumping data for table acal_calendars

–

INSERT INTO acal_calendars ( calendar_id , user_id , calendar_name , calendar_description , calendar_color , calendar_active )

VALUES ( 1, 1, 'My Calendar', '', 1, 1 ) ;



MySQL said: Documentation

#1062 - Duplicate entry '1' for key 'PRIMARY'



I seem to be advised to run mysql db repair utilities on the site, but they can be a bit harmful. Any other advice on this problem?



Should I get a blank cscart db, upload that, then write over it with the working site?

2

Hello, till!



The correct instructions of moving CS-Cart installation to another server may be found here:

3

[quote name='orangegirl' timestamp='1319604430' post='124566']

Hello, till!



The correct instructions of moving CS-Cart installation to another server may be found here:



CS-Cart Documentation — CS-Cart 4.15.x documentation

[/quote]



Thanks for that link.



I went with a little bit of column A and a little bit of column B.



Column A: copied the website over to bnew host, unpacked it etc.



Column B: used the internal dbase backup in the live install, and copied that into the new host via ssl and mysql.



I did have a couple more questions for the forum.


  1. How do you disable .html suffix on pages? Its pretty much redundant these days.



    2)Tweaks? How scary/fun are these?


$config['tweaks'] = array (
'js_compression' => false, // enables compession to reduce size of javascript files
'check_templates' => true, // disables templates checking to improve template engine speed
'inline_compilation' => true, // compiles nested templates in one file
'anti_csfr' => false, // protect forms from CSFR attacks (experimental)
'disable_ajax_preload' => false, // used to disable ajax preload for speed-up admin area
);



If these do speed up the site, any serious risk flipping these on?



TIA,



till

4

Oh and should I clear all the caches?



One other point. The site would put up pages fine when I installed it in exactly the same path as before:

http//domain.com/cscart/



But when I copied it all to the web root, and edited the config.local.php to say:

// Host and directory where the software is installed on no-secure server
$config['http_host'] = 'test.domain.com';
$config['http_path'] = '';



It now just gives me an internal server error? Any idea what else it might be?



TIA,



till

5

Ok, bit quiet in here, but does anyone use rewriting so that the pages appear to come from http://domain.com/path/to/product instead of http://domain.com/cscart/path/to/product?

6

Clear your cache. You should be able to find appropriate rewrite rules by doing a Google search.