Table 'products_description' doesn't exist

[wdh]

Hi,

I just upgraded the site http://dogdresshome.com/ from older verssion to new one 1.3.8 . The older verssion DB has the tables named simple like 'products' insteed of 'zen_products' .. So i removed the older database and then created new database through Fantastico. And then uploaded everything from my DB backup in each table.

Now the site is showing error :: 1146
The error i am getting is as follows ::

1146 Table 'dogdress_zc1.products_description' doesn't exist
in:
[SELECT products_description from products_description where products_id=1273]


Any one can help me to solve this problem?

This is i think very small issue.

Waiting for your suggession.

Thanks,
WDH

[gjh42]

I don't know that much about databases, but the 'zen_products' is the same table as 'products' except that it has had a prefix of 'zen_' added to it, presumably during the installation process. When you install manually, you have the choice of adding a prefix or not. There is no reason to add a prefix unless your Zen Cart will have to share a database with another application. Fantastico may not give you that choice - I wouldn't know.

Someone else will have to tell you how to fix the problem.

[DrByte]

Glenn's right.

If it's saying the table doesn't exist, then your database must be missing that table.
If all your tables have "zen_" prefixes, then your configure.php files need to have DB_PREFIX set to "zen_" to match the tables.
Or vice-versa.

[wdh]

Hi,.

Every thing is correct. All the DB tables has started with prefix "zen_" and also the config.php file also have the DB_PRIFIX setted to "zen_" . I am confused in this issue.

-WDH

[wdh]

[FONT="Verdana"]Hi,

I have solved the issue :: So i think to post the solve in this forum. Please note that if you have the following error ::

"1146 Table 'dogdress_zc1.products_description' doesn't exist
in: [SELECT products_description from products_description where products_id=xxxx]"

-Then
1. open the following file:: includes/template/<your template>/modules/new_products.php

2. Go to line No. 82. and change it to the following one...
$query = "SELECT products_description from `".TABLE_PRODUCTS_DESCRIPTION."` where products_id=".$new_products->fields['products_id']."";

3. open includes/template/<your template>/modules/specials_index.php and do required change in line no. 64 to

$query = "SELECT products_description from `zen_products_description` where products_id=".$specials_index->fields['products_id']."";

4. Open includes/template/<your template>/modules/featured_products.php and change line no 63. to
$query = "SELECT products_description from zen_products_description where products_id=".$featured_products->fields['products_id']."";



--I don't know either it will be helpfull for you or not.. but this is the only solution i have. Applying this now my site is up again.

Thanks,
WDH[/FONT]

[DrByte]

That's a very bad "solution", because it suggests that your data is scattered between multiple tables, and indicates that you may actually have other additional problems which you've not noticed yet.

I STRONGLY RECOMMEND THAT FUTURE READERS OF THIS THREAD IGNORE THE SUGGESTION ABOVE.

[wdh]

Hi,

That's a very bad "solution", because it suggests that your data is scattered between multiple tables, and indicates that you may actually have other additional problems which you've not noticed yet.

I STRONGLY RECOMMEND THAT FUTURE READERS OF THIS THREAD IGNORE THE SUGGESTION ABOVE.

Thanks Dr. Byte, Thanks for your post. I just want to know.. When you have no solution to solve a problem, then how can you put this type of language? may be in future other can solve following my solution. Bcoz, I have used the 3rd party template to implement the site into Zencart. So, if you have no solution, then beter not to say any ignore words.

It is working fine for me. And i posted bcoz, if it will help others. Nothing else.

Thanks a lots.
-WDH

[DrByte]

Thanks for sharing. It's useful to know what *you* had to do for *your* specific situation. And we do appreciate when people share their solutions for the hopeful benefit of others.

My point stands: You have data scattered amongst multiple tables in a format that does not match normal Zen Cart structure. You are likely to run into problems upgrading because if the next version you upgrade to has to make structural changes to your database tables, but you're using tables named using a different standard, the updates are not going to be properly applied to the tables where your data is actually stored.

If someone is having problems with their database but does not have the same exact situation as you, they could cause more damage by following the suggestions you made. Hence the warning I posted. Not that your solution is wrong. Just that it should not be one of the first things they try to do for attempting to fix a problem. It should be a last resort, if ever.

As for my having "no solution" to your problem ... I can't tell you exactly how to fix it. But I can tell you that you've apparently got some tables using one naming format, and others not. Fixing that will be the key to your situation. But, without taking a look personally at your database I can't tell you exactly what to do. I'll leave that up to you and your database guru if you have one.