bug VM 3.4.3.999 err 1052 Column 'category_parent_id' in field list is ambiguous

Started by 2dmaster, May 01, 2020, 07:53:44 AM

Previous topic - Next topic

2dmaster

err 1052 Column 'category_parent_id' in field list is ambiguous when try save categories by Ordeing -> Joomla.tableOrdering
at /administrator/index.php?option=com_virtuemart&view=category Admins page dead with error 1052 Column 'category_parent_id' in field list is ambiguous
why ? cant save ordering for categories.
and i not change sort ordering, i try update ordering, dead (

VM 3.6.11.1030 have this error only when i try export products or categories to csv. CSVI PRO 7.15 not work.. i think this error from virtuemart..
any solutions please ? i can send sql dump to you, say wats tables are needed

when i click save ordering in Categories, i have translated message whis wrong transate is error "Новый заказ сохранен" - is not product!!!! where bug!!!!!! pls help need tool for fix categories

why i see only first 1000 categories ? i have 1500 categories, i need save ordering for all maybe, its on page 2 (((


2dmaster

SELECT * FROM `_virtuemart_categories` WHERE 'category_parent_id'<1  not work i see all table ((



GJC Web Design

As you know 3.6.11.xxxxx are pre release test versions not intended for production

You say the problem is with  VM 3.6.11.1030 ( do u mean com_virtuemart.3.6.11.10300 from early April?)

we are now testing .10316 so the problem could well be already fixed.
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

2dmaster

i tested virtuemart 3.8.0.10319 not work too - Column 'category_parent_id' in field list is ambiguous.
Say me pls what is latest stable vm version? i cant find v .10316 where i can test it ?

AH

You said

Quotehave this error only when i try export products or categories to csv. CSVI PRO 7.15

Is this an issue when using VM or CSVI export
Regards
A

Joomla 4.4.5
php 8.1

2dmaster

Say me pls what is latest stable vm version? i cant find v .10316 where i can test it ?


2dmaster



pinochico

www.minijoomla.org  - new portal for Joomla!, Virtuemart and other extensions
XML Easy Feeder - feeds for FB, GMC,.. from products, categories, orders, users, articles, acymailing subscribers and database table
Virtuemart Email Manager - customs email templates
Import products for Virtuemart - from CSV and XML
Rich Snippets - Google Structured Data
VirtueMart Products Extended - Slider with products, show Others bought, Products by CF ID and others filtering products

jenkinhill

Kelvyn
Lowestoft, Suffolk, UK

Retired from forum life November 2023

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

2dmaster

im using VirtueMart 3.8.0 10319 but Column 'category_parent_id' in field list is ambiguous. its very old covid bug :) any fixes please ??

AH

No bug in release
Quotehave this error only when i try export products or categories to csv. CSVI PRO 7.15 not work..

So talk to csvi plugin developers as this looks like you are having an issue when you use it for exporting?
Regards
A

Joomla 4.4.5
php 8.1