Jump to content

MarcDieters

Members
  • Posts

    3
  • Joined

  • Last visited

Profile Information

  • First Name
    Marc
  • Last Name
    Dieters

MarcDieters's Achievements

Newbie

Newbie (1/14)

5

Reputation

  1. I have found the issue. To fix it, replace the following text in the db_structure.sql in \install\data CREATE TABLE `PREFIX_cart_product` ( `id_cart` int(10) unsigned NOT NULL, `id_product` int(10) unsigned NOT NULL, `id_address_delivery` int(10) UNSIGNED DEFAULT '0', `id_shop` int(10) unsigned NOT NULL DEFAULT '1', `id_product_attribute` int(10) unsigned DEFAULT NULL, `quantity` int(10) unsigned NOT NULL DEFAULT '0', `date_add` datetime NOT NULL, UNIQUE(`id_cart`,`id_product`,`id_product_attribute`,`id_address_delivery`), KEY `id_product_attribute` (`id_product_attribute`), KEY `id_cart_order` (`id_cart`, `date_add`, `id_product`, `id_product_attribute`) );​ After this change, I was able to complete the store creation.
  2. Same here, I also have this issue but no solution Could you explain 'there's an error with your database' some more ?
  3. Hi, I'm new to prestashop. I want to setup Presta on a Server 2012 R2 box. Here are the steps I took: - Installed IIS, PHP (used the Web Platform downloader) and MySQL. - Created a schema, a user and provided the user full permissions on the schema. - Created a website and copied the downloaded Presta files to the correct location. - Browsed to the website and followed the steps. At 12%, when the database is created the attached error occurs. SQL error on query All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead​ The database is filled with tables though, so it's not a permissions issue I think. The versions I use (all the latest that can be found). - MySQL: 5.7 - PHP 5.6.0 (5.3.28 is also installed). - Presta: 1.6.12. I don't have any experience with PHP / MySQL so I'm really stuck. Can anyone provide some guidance how I can get the site setup ? Thanks.
×
×
  • Create New...