[Solved] Can't add products to shop.

[BallooningMarvelous]

Hi, I'd posted this elesewhere but I think it was the wrong forum.

I've had Prestashop for a while, but have never had any products. Now I am starting my business soon and I upgraded to the latest version, which went fine. I've added most of the modules and things I want, but now I want to add products.
But - whenever I add a product, no matter what the product or theme, It messes my FO and displays this message.

Table ‘balloo11_shop.pack’ doesn’t exist

SELECT COUNT as items FROM pack where id_product_pack = 11

balloo11_shop is my database, but I don't know much about these things. So I'm guessing it could be a problem with that.

I'd really like to get my shop up and running very soon, so I'd appreciate any help you could give.

I've attatched 2 images, one is my shop with no products added (the normal one)
The other is one with a product added (the messed up one)

Thanks!

[CYTechnologies]

Hello,

If you can gain access to your database by using a tool such as phpMyAdmin run the below code.

CREATE TABLE IF NOT EXISTS `pack` (
 `id_product_pack` int(10) unsigned NOT NULL,
 `id_product_item` int(10) unsigned NOT NULL,
 `quantity` int(10) unsigned NOT NULL DEFAULT '1',
 PRIMARY KEY (`id_product_pack`,`id_product_item`)
);

This should solve the issue your having. :-)

[BallooningMarvelous]

Hello,

If you can gain access to your database by using a tool such as phpMyAdmin run the below code.

CREATE TABLE IF NOT EXISTS `pack` (
 `id_product_pack` int(10) unsigned NOT NULL,
 `id_product_item` int(10) unsigned NOT NULL,
 `quantity` int(10) unsigned NOT NULL DEFAULT '1',
 PRIMARY KEY (`id_product_pack`,`id_product_item`)
);

This should solve the issue your having. :-)

Thanks, your a Genius!
It's been really frustrating me for ages, and now fixed!

Thanks alot!

[CYTechnologies]

My pleasure :-)

If you could edit your first post and put [solved] in the title so everyone knows its been fixed. Thanks!

[BallooningMarvelous]

My pleasure :-)

If you could edit your first post and put [solved] in the title so everyone knows its been fixed. Thanks!

No problem! Thanks once again