1.6.1.4 On Localhost Does Not Work

[techkoop]

hi

 

i have been searching to all the forums and communities. Everyone seems to have the same problem with 1.6.1.4. Tables do not exist,in the database, db-files do not have indexes,and simple apps like adding a product do not work in admin. 

 

Which version of prestashop 1.6 X should i install to work with a fresh and clean prestashop on localhost?

 

I prefer to manage my shop on local host and use c:/xampp package. 

 

i work with a 64 bit machine with windows 10 home and 16Gb RAM, i used ports 8000 and 8433 for apache, blocked 80 and 433 in skype to be sure of a good database creation. It didn't help.

 

The project is to get a shop suitable for one click upgrades.

 

It's first stage will contain 3300 products divided over  a lot of categories and with a lot of cool and comprehensive filters in the front end shop. Second stage will be over 50.000 products.

 

I am really a fan of prestashop since the possibilities are endless but with all these errors i do not now if its still the best platform for me. Please get me a clean and working admin with an errorfree database.

 

Greetz

 

techkoop.nl

 

 

 

 

[NemoPS]

Actually, I have a perfectly running 1.6.1.4 on my local WAMP.
I am assuming it has some conflict with XAMPP or its php/mysql versions

[notebookcentro]

Actually, I have a perfectly running 1.6.1.4 on my local WAMP.

I am assuming it has some conflict with XAMPP or its php/mysql versions

Hello, please could you indicate what the correct settings to finish installing prestashop 1.6.1.4, as unfortunately, does not pass me 34% I am using wampserver latest version. Thank you

[NemoPS]

On WAMP? For me, I just drag and drop, then install. I don't have any specific configuration so it's hard to guide you. What is your php/mysql version on the local server?

[notebookcentro]

MySQL ver 5.7.9

PHP ver 7.0

Apache ver 2.4.17

 

Hello, Thanks for your concern. I think the problem lies in the db_structure file, since I have made some modifications and allows me to skip that part of 34% but fails later repeating the mistake, but in another section. I am a newbie, but something I understand, by your experience, could you tell me if this part of the code is well?

 

SET SESSION sql_mode = '';

SET NAMES 'utf8';?CREATE TABLE `PREFIX_access` (

  `id_profile` int(10) unsigned NOT NULL,

  `id_tab` int(10) unsigned NOT NULL,

  `view` int(11) NOT NULL,

  `add` int(11) NOT NULL,

  `edit` int(11) NOT NULL,

  `delete` int(11) NOT NULL,

  PRIMARY KEY (`id_profile`,`id_tab`)

) ENGINE=ENGINE_TYPE DEFAULT CHARSET=utf8 COLLATION;

 

this symbol (?) in code is OK?

[selectshop.at]

XAMP on Windows 10 is buggy and don't work. Mamp is ok.

No, the "?" is not ok. Try to downgrade your mysql database and php vers. I didn't yet tried php7 but php versions 5.6.x, 5.4x are working well. MYSQL use version 5.5.x instead.

[notebookcentro]

OK, I will try what you say, although I did.

Would you be so kind as to share your db_structure file or code to compare with mine and see if I with the failure? Thank you for your comments. Regards!!

[selectshop.at]

Cannot tell you, cause this is a part of install.php. You should download the Prestashop package and verify on the /install folder the files there. I'm sure your php-version is replacing digits by another. There should be a " instead of ? Please check, or better: try to use the environment I've suggested. On this it is working, besides it does not make any sense to use latest technique, if you probably will not get a server with that technique (not on a shared hosting package  ). I presume you will move the shop afterwards to a live server, or not ?

 

AND please refrain form adding the same question in double. I moved the Spanish one to Spanish forum and the doblons I merged to your already added topics.

[NemoPS]

It might be php7, I heard it doesn't cope well with prestashop. Try with php 5.5 and mysql 5.5 as well

[azarian]

The cause of it is probably mysql 5.7, you should downgrade to mysql 5.5 and it will work probably work fine