Zen Cart Logo
Forums / General Questions / HELP - Table 'C251393_zencart.products' doesn't exist

HELP - Table 'C251393_zencart.products' doesn't exist

Locked

Views: 1,368

Results 1 to 20 of 20
This thread is locked. New replies are disabled.
19 Nov 2009, 4:59 PM
#1
kobra8 avatar

kobra8

Zen Follower

Join Date:
Mar 2009
Location:
Serbia
Posts:
350
Plugin Contributions:
0

HELP - Table 'C251393_zencart.products' doesn't exist

Hi, guys, I set up shop to have all I need, now only to insert products.

Products are virtual, and when add *. zip file for downloading and choose the product in the cart, instead to go on the next page in cart I get the message:

Table 'C251393_zencart.products' doesn't exist

BIG PROBLEM, HELP I do not know what to do do :no:

https://www.kavanali.com

19 Nov 2009, 5:52 PM
#2
kobra8 avatar

kobra8

Zen Follower

Join Date:
Mar 2009
Location:
Serbia
Posts:
350
Plugin Contributions:
0

Re: HELP - Table 'C251393_zencart.products' doesn't exist

In mySQL I have the Таble: zen_products :frusty:

20 Nov 2009, 6:25 PM
#3
kobra8 avatar

kobra8

Zen Follower

Join Date:
Mar 2009
Location:
Serbia
Posts:
350
Plugin Contributions:
0

Re: HELP - Table 'C251393_zencart.products' doesn't exist

I have in MySql DB
C251393_zencart

end have table
zen_products

When I installed ZC I could to set up a virtual product that was a month ago, and now I can not!!
I get the message that we missing
Table 'C251393_zencart.products' doesn't exist

:frusty:

If someone can at least send me who had a similar problem.

20 Nov 2009, 7:49 PM
#4
kobra8 avatar

kobra8

Zen Follower

Join Date:
Mar 2009
Location:
Serbia
Posts:
350
Plugin Contributions:
0

Re: HELP - Table 'C251393_zencart.products' doesn't exist

When I bay virtual product I geting mesage:

Table 'C251393_zencart.products' doesn't exist

I have in MaSql

Database: C251393_zencart
Table: zen_products

Is it posible thet dot (.) not a (_) is the problem :blush:

C251393_zencart.products

may need to be

C251393_zencart_products

How to change the point is that instead of empty space?

21 Nov 2009, 11:17 PM
#5
kobra8 avatar

kobra8

Zen Follower

Join Date:
Mar 2009
Location:
Serbia
Posts:
350
Plugin Contributions:
0

Re: HELP - Table 'C251393_zencart.products' doesn't exist

Hi, guys, I set up shop to have all I need, now only to insert products.

Products are virtual, and when add *. zip file for downloading and choose the product in the cart, instead to go on the next page in cart I get the message:

Table 'C251393_zencart.products' doesn't exist

BIG PROBLEM, HELP I do not know what to do do :(

https://www.kavanali.com

21 Nov 2009, 11:31 PM
#6
kobra8 avatar

kobra8

Zen Follower

Join Date:
Mar 2009
Location:
Serbia
Posts:
350
Plugin Contributions:
0

Re: HELP - Table 'C251393_zencart.products' doesn't exist

Hi, guys, I do not know where to put my problem so I put here because the issue is similar.

I set up shop to have all I need, now only to insert products.

Products are virtual, and when add *. zip file for downloading and choose the product in the cart, instead to go on the next page in cart I get the message:

Table 'C251393_zencart.products' doesn't exist

BIG PROBLEM, HELP I do not know what to do do

https://www.kavanali.com

21 Nov 2009, 11:35 PM
#7
kobra8 avatar

kobra8

Zen Follower

Join Date:
Mar 2009
Location:
Serbia
Posts:
350
Plugin Contributions:
0

Re: HELP - Table 'C251393_zencart.products' doesn't exist

Hi, guys, I do not know where to put my problem so I put here because the issue is similar.

I set up shop to have all I need, now only to insert products.

Products are virtual, and when add *. zip file for downloading and choose the product in the cart, instead to go on the next page in cart I get the message:

Table 'C251393_zencart.products' doesn't exist

BIG PROBLEM, HELP I do not know what to do do

https://www.kavanali.com

22 Nov 2009, 5:02 PM
#8
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: HELP - Table 'C251393_zencart.products' doesn't exist

What is happening is that your database table for Products is called:
zen_products

But the code is referencing it as:
products

You need to check if the code or your database tables are in error ...

Do all of your tables start with:
zen_

If you look at the two configure.php files on the server:
/includes/configure.php
/admin/includes/configure.php

are the Prefixes defined with:
define('DB_PREFIX', '');

or are they defined with:
define('DB_PREFIX', 'zen_');

or something else?

23 Nov 2009, 8:42 AM
#9
kobra8 avatar

kobra8

Zen Follower

Join Date:
Mar 2009
Location:
Serbia
Posts:
350
Plugin Contributions:
0

Re: HELP - Table 'C251393_zencart.products' doesn't exist

Hi Ajeh, the Prefixes are defined with:
define('DB_PREFIX', 'zen_');

23 Nov 2009, 3:50 PM
#10
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: HELP - Table 'C251393_zencart.products' doesn't exist

That error message is referencing the tables without the prefix ...

23 Nov 2009, 4:03 PM
#11
kobra8 avatar

kobra8

Zen Follower

Join Date:
Mar 2009
Location:
Serbia
Posts:
350
Plugin Contributions:
0

Re: HELP - Table 'C251393_zencart.products' doesn't exist

Yes Ajeh, hay to solve thet problem.
Thet in shop can have virtual product?

How to check if the code or database tables are in error?
BIG PROBLEM, I do not know what to do!

24 Nov 2009, 12:32 PM
#12
kobra8 avatar

kobra8

Zen Follower

Join Date:
Mar 2009
Location:
Serbia
Posts:
350
Plugin Contributions:
0

Re: HELP - Table 'C251393_zencart.products' doesn't exist

Heloo... Ajeh, please can you help or can you please tell my ho can help to solve problem, thenks. :blush:

24 Nov 2009, 3:46 PM
#13
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: HELP - Table 'C251393_zencart.products' doesn't exist

Can you access your Zen Cart Admin?

Can you edit the Product?

Or do you get errors in the Admin too?

24 Nov 2009, 3:53 PM
#14
kobra8 avatar

kobra8

Zen Follower

Join Date:
Mar 2009
Location:
Serbia
Posts:
350
Plugin Contributions:
0

Re: HELP - Table 'C251393_zencart.products' doesn't exist

I can access to Zen Cart Admin.

I can edit the Product.

I don't get errors in the Admin too.

I only get mesage errors when in shop wants to bay download product.

24 Nov 2009, 7:07 PM
#15
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: HELP - Table 'C251393_zencart.products' doesn't exist

You have this product setup as a music product ... is there a reason?

What happens if you add another Product as Product General ... does it work?

25 Nov 2009, 8:38 AM
#16
kobra8 avatar

kobra8

Zen Follower

Join Date:
Mar 2009
Location:
Serbia
Posts:
350
Plugin Contributions:
0

Re: HELP - Table 'C251393_zencart.products' doesn't exist

When setup as a music product I get thet mesage:
Table 'C251393_zencart.products' doesn't exist

When I setup as a Product General - when in shop get in thet product I geting mesage in small windows: Error: Das xajax Javascript file konnte nicht includiert werden. Vieleicht ist die URL falsch?
URL: ajax/xajax_js/xajax.jss

End when I want to bay I get the same mesage:
Table 'C251393_zencart.products' doesn't exist

25 Nov 2009, 8:18 PM
#17
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: HELP - Table 'C251393_zencart.products' doesn't exist

I really am not sure what is your precise problem with this ...

It could be the code or the database tables or something else ...

You might want to post in the Commercial Help Wanted for additional help on this ...

25 Nov 2009, 9:46 PM
#18
kobra8 avatar

kobra8

Zen Follower

Join Date:
Mar 2009
Location:
Serbia
Posts:
350
Plugin Contributions:
0

Re: HELP - Table 'C251393_zencart.products' doesn't exist

Ajeh I em precise my problem, when i wont to bay virtual product (download product) I can't becouse when I put thet product in basket end clik I geeting mesage:
Table 'C251393_zencart.products' doesn't exist

:frusty:

Where in ZC file or code can I see hay menage ZC with virtual product, product with download opcion end DB?

Thenks, Ajeh.

26 Nov 2009, 12:12 AM
#19
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: HELP - Table 'C251393_zencart.products' doesn't exist

Without sitting down and going through all of your code and your database tables I cannot tell what is wrong with your site from what you are describing ...

I would really post something in the Commercial Help Wanted as this can be a very time consuming issue to resolve and it is too difficult to guess at on the forum ...

29 Nov 2009, 2:13 PM
#20
kobra8 avatar

kobra8

Zen Follower

Join Date:
Mar 2009
Location:
Serbia
Posts:
350
Plugin Contributions:
0

Re: HELP - Table 'C251393_zencart.products' doesn't exist

:clap: :clap: :clap:

I solve the problem!

I simple delete contribution: attributes_modelnumbers_0-1BETA

End now I can sell virtual product :D