Specials Block messed up

[tejas]

Hello All,

The stock Specials Block is messed up on a site I am working on. I have made no change to the code, and only to the display. It works perfectly fine on my local system but when installed on the server, displays some data that is definitely not a part of the backend.

The site is at - http://www.sandyspringsmusicstore.com/

If you see, the Specials page displays everything correctly. Only the Block is messed up.

Thanks.
-tejas

[tejas]

While we are at it, if someone could tell me how to change the password of databse without screwing up the Prestashop installation, that would be great too.

Thanks!

[tejas]

Can anyone help with this? Thanks!

[Tom_Rufener]

You can change the database password in your webhosting admin panel (webserver backend). Then, open your prestashop directory with an FTP client like Filezilla, enter the /config folder and open "settings.inc.php" with an editor of your choice (e.g. notepad++). Enter the new DB password ('_DB_PASSWD_'), save and re-upload the php file.

Careful, if you only have one single SQL user (ergo: one single SQL password) and other CMS like Joomla or Wordpress installed, make sure you edit their config files as well.

[Tom_Rufener]

Concerning the other issues:

There's a problem with the block itself, what about these static links (leading to 0,1,2, etc)? The specials block automatically (!) displays products with discounts on your homepage, it works fully dynamic, there's no need to "hard-code" product links.

If that doesn't help: Have you already entered products with a discount? Or is there a problem with friendly URLs or your .htaccess-file?

[tejas]

Thanks Tom. I figured the database password question earlier from one other thread.

Regarding the specials block - the products 1, 2, 3 etc are not hardcoded. Heck, they aren't even in the backend catalogue. They are the messed up part. I have lot of products with discounts, as you can see from the specials page itself. I replaced the code couple of times with fresh code as well, and no luck.