can someone help with more pics 2.0.5

[FSS]

Has anyone got any ideas? I give up.(almost!).

1) When I add a new product, and then add it to 'specials', the image will not show up in the 'specials' module on the index page. Yet they will show up in 'specials' info box and specials.php page.

 

***clue; (which apparently does me no good!) if I add a product to 'specials' and (I believe), it is a product that was in the database before adding 'more pics', the image will show up in 'specials' module?

 

2) When I add a new product, and then add it to 'featured products' (product spotlight), the image will not show up in the module, or the info box, or the featured.php page.

 

I have changed more code in more files than I can remember. I hope someone can help me!

http://firststopsecurity.com/store/index.php

[♥geoffreywalton]

Add a new product and compare the records crested with on installed before you installed new pics.

 

Are the names of the images recorded correctly?

[FSS]

Add a new product and compare the records crested with on installed before you installed new pics.

 

Are the names of the images recorded correctly?

Hi Geoffrey...I'm sorry, I don't know what you mean by 'the records crested with...'

[FSS]

Hi Geoffrey...I'm sorry, I don't know what you mean by 'the records crested with...'

Yikes..I'm a little slow I think. I had my wife take a look and she figures you miss spelled 'created' and that makes sense. Where do I find these records though? In catalog/images?

Edited February 14, 2009 by FSS

[♥geoffreywalton]

Add a new product and compare the records created with one installed before you installed new pics.

 

and I am a little too careless with my speeloinks :-)

 

After you work out the 2 mistakes it makes more sense. The answer is:-

 

You need to look in the database

 

1) Go to your ISPs admin area for your site.

 

2) Click on the icon for Database administration or Mysql, then find the link for phpmyadmin, it might be hidden away at the bottom but not on all admin sites. If you can’t find this, please consult your ISP's help desk.

 

3) In some cases, you may have to choose which database your OSC tables are located on. If this is the case, please choose using the dropdown box.

 

4) Click on "SQL" on the navigation bar.

 

5) Enter/paste your SQL in the textbox provided or, if you have a file containing the sql commands, click on Import and follow the on screen prompts.

 

6) For both methods click "Go"..

 

7) If all goes well, your SQL query will run successfully

 

For another explanation see:-

 

http://www.oscommerce.com/forums/index.php?sho...dmin+mysql+code