Jump to content
well-wazh

1146 - Table '***********.table_zones_to_geo_zones' doesn't exist

Recommended Posts

Bonjour,

Après l'ajout du module de livraison DPD sur ma version 2.3, j'ai ce message d'erreur et je ne trouve pas d'ou vient le problème.

1146 - Table '*****.table_zones_to_geo_zones' doesn't exist

select zone_id from TABLE_ZONES_TO_GEO_ZONES where geo_zone_id = '2' and zone_country_id = '73' order by zone_id


La table existe bien pourtant !

Merci pour votre aide.

Share this post


Link to post
Share on other sites
Posted (edited)

Provide a link to this addon DPD

Edited by ruden

Share this post


Link to post
Share on other sites

Write me a in private the FTP access, I'll see what the problem is.

Share this post


Link to post
Share on other sites
Posted (edited)

@well-wazh
Ne donnez jamais accès à votre site à quelqu'un que vous ne connaissez pas ou en qui vous n'avez pas absolument confiance.

Never give out your access details to anyone you do not know or do not have absolute confidence in.

http://www.oscommerce-fr.info/forum/ is the francophone osCommerce.

Edited by burt

Help shape the future of Phoenix; join the Phoenix Club

Share this post


Link to post
Share on other sites
2 hours ago, ruden said:

Write me a in private the FTP access, I'll see what the problem is.

Désolé, mais je ne préfère pas ...

Share this post


Link to post
Share on other sites
2 hours ago, burt said:

@well-wazh
Ne donnez jamais accès à votre site à quelqu'un que vous ne connaissez pas ou en qui vous n'avez pas absolument confiance.

Never give out your access details to anyone you do not know or do not have absolute confidence in.

http://www.oscommerce-fr.info/forum/ is the francophone osCommerce.

Impossible de créer un compte sur le forum francais !!!

Share this post


Link to post
Share on other sites
Posted (edited)

Bonjour, Hello,

Ici on écrit en anglais ...

Here we write in English ...

http://www.oscommerce-fr.info/forum/index.php?showtopic=71803&pid=372599&st=0&#entry372599

Edited by bonbec

Get the latest Responsive osCommerce CE (community edition) here .

(Live   : OsC 2.2, php 5.4 & UTF-8  |  Local : Phoenix for future shop)

Share this post


Link to post
Share on other sites

It is true, it is impossible to register on the French forum because of a security code bug. C'est vrai, il est impossible de s'inscrire sur le forum français à cause d'un bug du code de sécurité.

If you want help here, write in English (google translator can be your friend) . Si tu veux de l'aide ici, il faut écrire en anglais (google translator peut être ton ami).


Get the latest Responsive osCommerce CE (community edition) here .

(Live   : OsC 2.2, php 5.4 & UTF-8  |  Local : Phoenix for future shop)

Share this post


Link to post
Share on other sites
5 minutes ago, bonbec said:

It is true, it is impossible to register on the French forum because of a security code bug. C'est vrai, il est impossible de s'inscrire sur le forum français à cause d'un bug du code de sécurité.

If you want help here, write in English (google translator can be your friend) . Si tu veux de l'aide ici, il faut écrire en anglais (google translator peut être ton ami).

Ok, thank's

Share this post


Link to post
Share on other sites
7 hours ago, well-wazh said:

j'ai vérifié, c'est bien define('TABLE_ZONES_TO_GEO_ZONES', 'zones_to_geo_zones');

There is a file database_tables.php in catalog and another in admin. Are you sure you have placed the define in the correct database_tables.php?

Il y a un fichier database_tables.php dans catalog et un autre dans admin. Es-tu sûr d'avoir placé le define dans le bon database_tables.php ?


Get the latest Responsive osCommerce CE (community edition) here .

(Live   : OsC 2.2, php 5.4 & UTF-8  |  Local : Phoenix for future shop)

Share this post


Link to post
Share on other sites

If you look in the code, you will see something like

" . TABLE_ZONES_TO_GEO_ZONES . "

Just replace that (including the quotes) with

zones_to_geo_zones

So it looks something like

tep_db_query("select zone_id from zones_to_geo_zones where geo_zone_id = '"

Obviously there would be more code before and after that. 

The database table defines were removed from the catalog side and are being removed from admin.  But some Apps still do things the old way. 


Always back up before making changes.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×