well-wazh Posted January 6, 2020 Share Posted January 6, 2020 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. Link to comment Share on other sites More sharing options...
ruden Posted January 6, 2020 Share Posted January 6, 2020 Сheck https://github.com/osCommerce/oscommerce2/blob/de9e922377cbfd0678c9e4b9e8eb51123f3e230a/catalog/includes/database_tables.php#L59 define('TABLE_ZONES_TO_GEO_ZONES', 'zones_to_geo_zones'); Link to comment Share on other sites More sharing options...
well-wazh Posted January 6, 2020 Author Share Posted January 6, 2020 j'ai vérifié, c'est bien define('TABLE_ZONES_TO_GEO_ZONES', 'zones_to_geo_zones'); Link to comment Share on other sites More sharing options...
ruden Posted January 6, 2020 Share Posted January 6, 2020 Provide a link to this addon DPD Link to comment Share on other sites More sharing options...
well-wazh Posted January 6, 2020 Author Share Posted January 6, 2020 https://www.dpd.fr/documents/modules/readme_dpdfrance_woocommerce_eng.pdf Link to comment Share on other sites More sharing options...
ruden Posted January 6, 2020 Share Posted January 6, 2020 This add-on for Woocommerce!? For osCommerce https://apps.oscommerce.com/q=DPD Link to comment Share on other sites More sharing options...
well-wazh Posted January 6, 2020 Author Share Posted January 6, 2020 mauvais lien, c'est celui la : https://www.dpd.fr/documents/modules/readme_dpdfrance_oscommerce23.pdf Link to comment Share on other sites More sharing options...
ruden Posted January 6, 2020 Share Posted January 6, 2020 Write me a in private the FTP access, I'll see what the problem is. Link to comment Share on other sites More sharing options...
burt Posted January 6, 2020 Share Posted January 6, 2020 @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. Link to comment Share on other sites More sharing options...
well-wazh Posted January 6, 2020 Author Share Posted January 6, 2020 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 ... Link to comment Share on other sites More sharing options...
well-wazh Posted January 6, 2020 Author Share Posted January 6, 2020 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 !!! Link to comment Share on other sites More sharing options...
bonbec Posted January 6, 2020 Share Posted January 6, 2020 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 with OsC 2.2 since 2006 ... Link to comment Share on other sites More sharing options...
well-wazh Posted January 6, 2020 Author Share Posted January 6, 2020 3 minutes ago, bonbec said: 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 Bonjour, pas moi !!! le forum français est inaccessible .... comment faire ? Link to comment Share on other sites More sharing options...
bonbec Posted January 6, 2020 Share Posted January 6, 2020 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). with OsC 2.2 since 2006 ... Link to comment Share on other sites More sharing options...
well-wazh Posted January 6, 2020 Author Share Posted January 6, 2020 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 Link to comment Share on other sites More sharing options...
bonbec Posted January 6, 2020 Share Posted January 6, 2020 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 ? with OsC 2.2 since 2006 ... Link to comment Share on other sites More sharing options...
♥ecartz Posted January 6, 2020 Share Posted January 6, 2020 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. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.