HOW to update local test version to live version?

[wisbin]

When I am done developing my prestashop on my local test server,
how do I get it all over to a new live version?

Do i make a new database with same name or just make new DB and import all test data?
What config files do I need to change? Is it the same as upgrading to a new version?

I have looked in the install online help, but only can find upgrade process instructions.

cheers

[prestabase]

Are you referring to migrating your shop to an online server so your store is public?

[wisbin]

Yes I want my store online. I am done building it on local server on my pc.

[prestabase]

You would do this by simply exporting your database as a sql file and uploading all of your content to a web hosting server. From within the control panel of the web hosting server you can import your sql file to create your database tables and bring your online store live.

[wisbin]

Yes i know how to import a DB backup/copy

But is there anything I should know with dealing the config files?

Like,
- database passwords
- employee accounts
- table names
- base directory

thanks

[prestabase]

No that should be left alone if you are going to the same type of databases as you currently use.

[wisbin]

Ok, i have done a new install of the new version 1.2.5.0 on my webserver.

All went well.

I added also a new database with same prefix as my local settings.

The version on my local server (developping/testing server) was 1.2.4.0

When I import my saved DB file (prestatshop.sql) into the new DB i get this error:

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

SQL query: 

-- -- Gegevens worden uitgevoerd voor tabel `ps_access` -- INSERT INTO `ps_access` (`id_profile`, `id_tab`, `view`, `add`, `edit`, `delete`) VALUES (1, 1, 1, 1, 1, 1), (1, 2, 1, 1, 1, 1), (1, 3, 1, 1, 1, 1), (1, 4, 1, 1, 1, 1), (1, 5, 1, 1, 1, 1), (1, 6, 1, 1, 1, 1), (1, 7, 1, 1, 1, 1), (1, 8, 1, 1, 1, 1), (1, 9, 1, 1, 1, 1), (1, 10, 1, 1, 1, 1), (1, 11, 1, 1, 1, 1), (1, 12, 1, 1, 1, 1), (1, 13, 1, 1, 1, 1), (1, 14, 1, 1, 1, 1), (1, 15, 1, 1, 1, 1), (1, 16, 1, 1, 1, 1), (1, 17, 1, 1, 1, 1), (1, 18, 1, 1, 1, 1), (1, 19, 1, 1, 1, 1), (1, 20, 1, 1, 1, 1), (1, 21, 1, 1, 1, 1), (1, 22, 1, 1, 1, 1), (1, 23, 1, 1, 1, 1), (1, 24, 1, 1, 1, 1), (1, 26, 1, 1, 1, 1), (1, 27, 1, 1, 1, 1), (1, 28, 1, 1, 1, 1), (1, 29, 1, 1, 1, 1), (1, 30, 1, 1, 1, 1), (1, 31, 1, 1, 1, 1), (1, 32, 1, 1, 1, 1), (1, 33, 1, 1, 1, 1), (1, 34, 1, 1, 1, 1), (1, 35, 1, 1, 1, 1), (1, 36, 1, 1, 1, 1), (1, 37, 1, 1, 1, 1), (1, 38, 1, 1, 1, 1), (1, 39, 1, 1, 1, 1), (1, 40, 1, 1, 1, 1), (1, 41, 1, 1, 1, 1), (1, 42, 1, 1, 1, 1[...] 

MySQL said:  
#1062 - Duplicate entry '1-1' for key 1

I have no idea if the new version and my old version conflict or am i missing something else?

thanks

[wisbin]

ok, i dropped all tables and imported my sql file again... now it worked.

[prestabase]

Great, if you google mysql error messages you will get a ton of answers.

[wisbin]

yeah thanks for all your help,
the problem is always a ton of answers
and to find the right one 8)

But i have still one more problem with this move from local to online server.

I have this category-tree-branch.tpl that gives me the category menu.
In there I use this code to add a dynamic cat.image to the menu. So i use the cat.image as a menu icon.

   {$node.name|escape:'htmlall':'UTF-8'} .....

This will give me per category menu an a#id hook to add the cat.image via css.

This worked all fine on my local server. Presta template rendered all cat.menu li-items with a different a#cat.name id.



The online version has the same file, same code, same images in place and the same css working.
But somehow the a#div cat.name is not rendered.




any ideas would be so welcome

thanks

[wisbin]

I can't login with none of my test clients accounts either.

It looks like something wrong with the authentication cookies too.

Maybe I should keep the live version also on 1.2.4 ...

I am out of ideas for these problems 8(