Need help with coding - can't find the file were the error is coming from

[cowlickdesign]

Hello Zen-Cart community.

If you visit my site http://www.ipodresq.ca then proceed to click on one of two current categories an error is thrown when the categories products are to be shown.

first category: Free Diagnostic Testing
"http://www.ipodresq.ca/ipodresq/store/index.php?main_page=index&cPath=8"
second category: 3rd Generation Repair
"http://www.ipodresq.ca/ipodresq/store/index.php?main_page=index&cPath=9"

"1146 Table 'humapital.products_description' doesn't exist." Now im not too sure where I can find this file as I am not sure how the pages are built and what file to start with.

I know humapital should be replaced by store_ as its calling the wrong variable as it builds this page. It is trying to connect to the table were the descriptions are located. It should not be using my database username of humapital but the database prefix of store_.


Thanks in advance for anyones help and I hope I am clear enough. If not post and I'll get you more info.

P.S. I did install this template from:
http://www.templatemonster.com/zen-c...tes/10096.html

[Dehaw]

You'll find the details in the configuration files within includes -> configuration and admin -> includes -> configuration.

Hope this helps, let us know how you get on.

Dehaw

[masterblaster]

This template from templatemonster.com is quite buggy. I had to fix some things for a client of mine.

The database selection in this template doesn't support any prefixes. You A) install the template with no prefix or B) make it to use the correct prefix.

[Merlinpa1969]

humapital is the name of the database its looking for

products_description is the table

and there is NO prefix in this error,

take a look in your config files and see if the db prefix is defined

[cowlickdesign]

Thanks for the help so far.

I checked my config files and the database prefix is defined to the correct value, which is "store_".

masterblaster how would I install the template with the database prefix or how would I go and make it use the correct prefix?

I've been looking at the code and have no idea how the database query strings are built and where the come from.

Anyhelp of what to do would be greatly appreciated.

Thanks again,
Cowlick Design

[Merlinpa1969]

It looks like the problem is that the template is looking for a table that is HARD CODED. rather than using the defined table names.

You will probably want to look in the included files to see where they have this blunder....