[Unsolved] Products info, Product Name & Seo GONE [Unsolved]

[redfordnl]

Hello people!

 

Really amazing, I've almost finished my webshop and now I see that suddenly all product names are the same from a category, all seo fields are empty and als product info is. What happened? And how can I restore this please? I've tried to restore back-up database but no change. I've also made a while ago a back up from all FTP files, what files need to be restored for get back product name, product info and seo back?

 

Hope that someone can help me, took me me months to add all products 1 by 1...

 

Greetings, Nick

[tomerg3]

What version of PS are you using?

Did you actually enter a friendly URL for each product, or did you leave it to PS to populate.

Can you post a link to your site where we can see the issue?

 

All the product information is saved in the database (ps_product and ps_product_lang)

[redfordnl]

Hello Tomerg3,

 

Thanks for your response. Yes always let Prestashop made it do himself the Friendly URL, but never had problems with this before. I've made more website using prestashop but never problems with Friendly URL. My website page is http://www.sinzy.nl and then if you go to products you see that every (sub)category products have the same name and there is no product information anymore and backoffice you see that also the SEO fields are empty. The images are all good and also the price and quantity remained! Language in shop is also set to Dutch, so this is isn't the problem also... The version of Prestashop is 1.4.0.17. And yes, i manually add every product 1 by 1, didn't use any CSV import file or anything...

 

Thanks in advance!

 

 

Greetings Nick

[redfordnl]

Hello again,

 

I've set up a new database on my servers PHPadmin/MSQYL and run an back up of my webshop and product names, seo and product info is back but everything I've designed is gone.. Is it possible to take the two tables (ps_product and ps_lang) copy from old database and put it in existing database? and only this two tables, so everything stays remained how I've designed it now... Hope this can be fixed!

 

Greetings Nick

[tomerg3]

Yes, you can do that, try using phpMyAdmin to export those 2 tables (including content) and import them to the new shop.

[redfordnl]

Hello Tomerg3,

 

Tried to import the two tables, but with no succes. Products aren't changed or anything. I sure hope this can be fixed!

[tomerg3]

What do you mean by no success?

 

Are you sure those tables have the information you need?

 

Did you get any errors when you tried to import? Did it say the number of rows affected?

[redfordnl]

Hello again,

 

No i don't get any errors or something but the names of the products, information and seo are just changed.. I don't know what to do... what a bumper!

 

Can you please provide me totall list of tables must be changed?

 

Or can you maybe take a look if I give you login details?

[tomerg3]

Are you sure the backup you have of ps_prooduct and ps_product_lang contains the information you need?

[Guest aritali]

Post a link to the dump of those tables. I would like to see if the right information is in the database still, or if it overwrote everything to that one product.

[Guest aritali]

You know what, also post your product-list.tpl Since it only seems to be affecting the name and url, and not the pricing or the images. It could very well be you changed the array that spits the products out.

[redfordnl]

Hello thanks for your help guys!

 

@DesignHaus42:

 

Yes I also found this really strange that images and pricing are still good. I will post my product-list.tpl but what do you exactly want from my database?

 

{*

* 2007-2011 PrestaShop

*

* NOTICE OF LICENSE

*

* This source file is subject to the Academic Free License (AFL 3.0)

* that is bundled with this package in the file LICENSE.txt.

* It is also available through the world-wide-web at this URL:

* http://opensource.org/licenses/afl-3.0.php

* If you did not receive a copy of the license and are unable to

* obtain it through the world-wide-web, please send an email

* to [email protected] so we can send you a copy immediately.

*

* DISCLAIMER

*

* Do not edit or add to this file if you wish to upgrade PrestaShop to newer

* versions in the future. If you wish to customize PrestaShop for your

* needs please refer to http://www.prestashop.com for more information.

*

* @author PrestaShop SA <[email protected]>

* @copyright 2007-2011 PrestaShop SA

* @version Release: $Revision: 8290 $

* @license http://opensource.org/licenses/afl-3.0.php Academic Free License (AFL 3.0)

* International Registered Trademark & Property of PrestaShop SA

*}

 

{if isset($products)}

<!-- Products list -->

{assign var='liHeight' value=355}

{assign var='nbItemsPerLine' value=4}

{assign var='nbLi' value=$products|@count}

{assign var='nbLines' value=($nbLi/$nbItemsPerLine)|ceil}

{assign var='ulHeight' value=$nbLines*$liHeight}

{foreach from=$currencies key=k item=f_currency}

{if $id_currency_cookie == $f_currency.id_currency}

{assign var='symabolCurrency' value=$f_currency.sign}

{/if}

{/foreach}

<ul id="product_list" style="{$ulHeight}px" >

{foreach from=$products item=product name=products}

<li class="ajax_block_product {if $smarty.foreach.products.first}first_item{elseif $smarty.foreach.products.last}last_item{else}item{/if} {if $smarty.foreach.products.iteration%$nbItemsPerLine == 0}last_item_of_line{elseif $smarty.foreach.products.iteration%$nbItemsPerLine == 1}clear{/if} {if $smarty.foreach.products.iteration > ($smarty.foreach.products.total - ($smarty.foreach.products.total % $nbItemsPerLine))}last_line{/if}">

 

<a href="{$product.link|escape:'htmlall':'UTF-8'}" class="product_img_link" title="{$product.name|escape:'htmlall':'UTF-8'}"><img src="{$link->getImageLink($product.link_rewrite, $product.id_image, 'home')}" alt="{$product.legend|escape:'htmlall':'UTF-8'}" {if isset($homeSize)} width="{$homeSize.width}" height="{$homeSize.height}"{/if} /></a>

<h3>{if isset($product.new) && $product.new == 1}<span class="new">{l s='New'}</span>{/if}<a href="{$product.link|escape:'htmlall':'UTF-8'}" title="{$product.name|escape:'htmlall':'UTF-8'}">{$product.name|truncate:28:'...'|escape:'htmlall':'UTF-8'}</a></h3>

 

<div class="right_block">

<div class="left_price">

{if isset($product.on_sale) && $product.on_sale && isset($product.show_price) && $product.show_price && !$PS_CATALOG_MODE}<span class="on_sale">{l s='On sale!'}</span>

{elseif isset($product.reduction) && $product.reduction && isset($product.show_price) && $product.show_price && !$PS_CATALOG_MODE}<span class="discount">{l s='Reduced price!'}</span>{/if}

{if isset($product.online_only) && $product.online_only}<span class="online_only">{l s='Online only!'}</span>{/if}

{if $product.specific_prices.reduction_type == 'percentage'}

<p class="discount">{$product.specific_prices.reduction*100}{l s='% off' mod='homefeatured'}</p>

{/if}

{if $product.specific_prices.reduction_type == 'amount'}

<p class="discount">{$product.specific_prices.reduction|string_format:"%.2f"} {$symabolCurrency}</p>

{/if}

</div>

<div class="price_container">

{if (!$PS_CATALOG_MODE AND ((isset($product.show_price) && $product.show_price) || (isset($product.available_for_order) && $product.available_for_order)))}

{if $product.reduction}

<span class="old_price">

{displayWtPrice p=$product.price_without_reduction}

</span>

<p class="price">

{if !$priceDisplay}{convertPrice price=$product.price}{else}{convertPrice price=$product.price_tax_exc}{/if}

</p>

{else}

<p class="price">

{if !$priceDisplay}{convertPrice price=$product.price}{else}{convertPrice price=$product.price_tax_exc}{/if}

</p>

{/if}

{/if}

</div>

 

{if isset($product.available_for_order) && $product.available_for_order && !isset($restricted_country_mode)}<span class="availability">{if ($product.allow_oosp || $product.quantity > 0)}{l s='Available'}{else}{l s='Out of stock'}{/if}</span>{/if}

 

 

{if isset($comparator_max_item) && $comparator_max_item}

<p class="compare"><input type="checkbox" class="comparator" id="comparator_item_{$product.id_product}" value="comparator_item_{$product.id_product}" {if isset($compareProducts) && in_array($product.id_product, $compareProducts)}checked{/if}/> <label for="comparator_item_{$product.id_product}">{l s='Select to compare'}</label></p>

{/if}

</div>

</li>

{/foreach}

</ul>

<!-- /Products list -->

{/if}

 

 

@Tormerg3:

 

Yes I'm very sure, when I connect website to old database website front office looks are very different (no menu bar, no slider etc etc) but all products are normall again with information, seo and product name!

[Dh42]

Basically to know if the actual information is in the database, or if it has been overwritten.

[redfordnl]

Hello DesignHause42 and Tomerg3,

 

I have set up 2 databases in my control panel of my host company. One of them is running now with no product information, seo and product names. If I change "settings.inc.php" to other database I get my product information back, SEO is filled in again and product names are back. So how to combine this 2 databases that style stays the same and product information etc. is filled in again?

 

Greetings Nick

[tomerg3]

As I mentioned before, you will need to copy over ps_product and ps_product_lang from the "good" DB to the "bad" DB.

when you export it from the "good" DB, make sure you export structure + content, and add "drop table".