Solution To Install Theme Without .zip File Way

[cristianfpg]

hi everyone

 

i install prestashop in a free server, works fine

 

i try to use a new theme and the server doesnt receive zip files ( free version )

 

any solution? u.u

[tdr170]

From the back office Preferences, Themes you can import the theme zip here or are you saying this is what you can not do.

 

The only other way is to upload the theme to the themes folder but you would then have to have good knowledge of the database as you would need to manually add the theme to the ps_theme and ps_theme_meta.

[cristianfpg]

 

change default bootstrap with my theme, its ok

 

product per page, columns, i can modify later in backoffice i think

 

 

but ps_theme_meta... what is this?

[tdr170]

You do not need to change it just add as ID 2 and give the same settings as default theme. 

 

Upload the theme to the themes folder should have 2 folder inside the themes folder when done.

 

/themes/

   default-bootstrap

   your new theme

 

Before Proceeding BACK UP YOUR DATABASE.

 

Now just use the database tables I have included copy and paste, use SQL from top menu paste into text area and click go this will over wright the tables adding the new theme and directory.

You will need to change the second line that says your-new-theme to the name of your theme be exact here. (in red)

If you changed your database prefix ps_ then you will need to change each instance of that.

Copy everything including the --

 

--

-- Table structure for table `ps_theme`

--

 

DROP TABLE IF EXISTS `ps_theme`;

CREATE TABLE IF NOT EXISTS `ps_theme` (

  `id_theme` int(11) NOT NULL AUTO_INCREMENT,

  `name` varchar(64) NOT NULL,

  `directory` varchar(64) NOT NULL,

  `responsive` tinyint(1) NOT NULL DEFAULT '0',

  `default_left_column` tinyint(1) NOT NULL DEFAULT '0',

  `default_right_column` tinyint(1) NOT NULL DEFAULT '0',

  `product_per_page` int(10) unsigned NOT NULL,

  PRIMARY KEY (`id_theme`)

) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

 

--

-- Dumping data for table `ps_theme`

--

 

INSERT INTO `ps_theme` (`id_theme`, `name`, `directory`, `responsive`, `default_left_column`, `default_right_column`, `product_per_page`) VALUES

(1, 'default-bootstrap', 'default-bootstrap', 1, 1, 0, 12),

(2, 'your-new-theme', 'your-new-theme', 1, 1, 0, 12);

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Now for the Meta just copy and paste this as you did with above code. (change nothing)

 

--

-- Table structure for table `ps_theme_meta`

--

 

DROP TABLE IF EXISTS `ps_theme_meta`;

CREATE TABLE IF NOT EXISTS `ps_theme_meta` (

  `id_theme_meta` int(11) NOT NULL AUTO_INCREMENT,

  `id_theme` int(11) NOT NULL,

  `id_meta` int(10) unsigned NOT NULL,

  `left_column` tinyint(1) NOT NULL DEFAULT '1',

  `right_column` tinyint(1) NOT NULL DEFAULT '1',

  PRIMARY KEY (`id_theme_meta`),

  UNIQUE KEY `id_theme_2` (`id_theme`,`id_meta`),

  KEY `id_theme` (`id_theme`),

  KEY `id_meta` (`id_meta`)

) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=78 ;

 

--

-- Dumping data for table `ps_theme_meta`

--

 

INSERT INTO `ps_theme_meta` (`id_theme_meta`, `id_theme`, `id_meta`, `left_column`, `right_column`) VALUES

(1, 1, 1, 0, 0),

(2, 1, 2, 1, 0),

(3, 1, 3, 0, 0),

(4, 1, 4, 0, 0),

(5, 1, 5, 1, 0),

(6, 1, 6, 1, 0),

(7, 1, 7, 0, 0),

(8, 1, 8, 1, 0),

(9, 1, 9, 1, 0),

(10, 1, 10, 0, 0),

(11, 1, 11, 0, 0),

(12, 1, 12, 0, 0),

(13, 1, 13, 0, 0),

(14, 1, 14, 0, 0),

(15, 1, 15, 0, 0),

(16, 1, 16, 0, 0),

(17, 1, 17, 0, 0),

(18, 1, 18, 0, 0),

(19, 1, 19, 0, 0),

(20, 1, 20, 0, 0),

(21, 1, 21, 0, 0),

(22, 1, 22, 1, 0),

(23, 1, 23, 0, 0),

(24, 1, 24, 0, 0),

(25, 1, 25, 0, 0),

(26, 1, 26, 0, 0),

(27, 1, 28, 1, 0),

(28, 1, 29, 0, 0),

(29, 1, 27, 0, 0),

(30, 1, 30, 0, 0),

(31, 1, 31, 0, 0),

(32, 1, 32, 0, 0),

(33, 1, 33, 0, 0),

(34, 1, 34, 0, 0),

(35, 1, 36, 1, 0),

(36, 1, 37, 1, 0),

(37, 1, 38, 1, 0),

(38, 1, 39, 1, 0),

(39, 2, 1, 1, 0),

(40, 2, 2, 1, 0),

(41, 2, 3, 1, 0),

(42, 2, 4, 1, 0),

(43, 2, 5, 1, 0),

(44, 2, 6, 1, 0),

(45, 2, 7, 1, 0),

(46, 2, 8, 1, 0),

(47, 2, 9, 1, 0),

(48, 2, 10, 1, 0),

(49, 2, 11, 1, 0),

(50, 2, 12, 1, 0),

(51, 2, 13, 0, 0),

(52, 2, 14, 1, 0),

(53, 2, 15, 1, 0),

(54, 2, 16, 1, 0),

(55, 2, 17, 1, 0),

(56, 2, 18, 1, 0),

(57, 2, 19, 1, 0),

(58, 2, 20, 1, 0),

(59, 2, 21, 1, 0),

(60, 2, 22, 1, 0),

(61, 2, 23, 1, 0),

(62, 2, 24, 0, 0),

(63, 2, 25, 1, 0),

(64, 2, 26, 0, 0),

(65, 2, 28, 1, 0),

(66, 2, 29, 1, 0),

(67, 2, 27, 1, 0),

(68, 2, 30, 1, 0),

(69, 2, 31, 1, 0),

(70, 2, 34, 1, 0),

(71, 2, 36, 1, 0),

(72, 2, 33, 1, 0),

(73, 2, 32, 1, 0),

(74, 2, 37, 1, 0),

(75, 2, 38, 1, 0),

(76, 2, 39, 1, 0),

(77, 2, 35, 1, 0);

 

 

 

Let me know how it goes.

Edited January 26, 2016 by tdr170 (see edit history)

[cristianfpg]

ok, the new theme appears enable in my backoffice, but when i refresh my shop with this theme selected, bum... error 500,

 

return the old theme and the shop works again...

 

i think those are 3 additional rows (36-38) in ps_theme_meta

 

what do you think about this?

[tdr170]

Not sure the tables above were taken straight from my database where I have 2 themes installed Maybe the new theme is not complete or some info you entered is wrong.

Can you post the name of the theme, Unzip the zip file to your computer and look in the themes folder for the name its not always the same as the zip name.

 

Check this and let me know, Also post the tables as I did so I can have a look after your sure of the name.

[cristianfpg]

the theme is: http://www.prestabrain.com/tf-demo/?theme=gentshop

 

demo 2

 

the unzip directory name is pf_gentshop, its ok

[tdr170]

Post your 2 tables as I did above so I can view them, maybe there is an error your missing.

Also when you look in the folder are all the files there.

After enabling the theme regenerate your .htaccess file, Preferences, SEO & URLs turn friendly urls and save back on and save and see if it works.

 

 

When I get a second here today I will test this on my test site and see if I can find why it does not work maybe I missed something.

[tdr170]

OK so I found one more thing inside the config folder is an xml folder and then a themes folder inside this themes folder should be a copy of the themes xml file which you should find in the unzipped file.

The file should be named config.xml rename the file to the themes name .xml and upload the this folder and try again to enable the theme and view.

 

pf_gentshop.xml

[cristianfpg]

same thing, definitely i must use my own server to do test

 

hey dude thanks for your time, it is a great exercise for me, really appreciate it