VirtueMart Forum

VirtueMart 2 + 3 + 4 => General Questions => Topic started by: 2dmaster on May 01, 2020, 07:53:44 AM

Title: bug VM 3.4.3.999 err 1052 Column 'category_parent_id' in field list is ambiguous
Post by: 2dmaster on May 01, 2020, 07:53:44 AM
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 (((

Title: Re: bug VM 3.4.3.999 err 1052 Column 'category_parent_id' in field list is ambiguous
Post by: 2dmaster on May 01, 2020, 08:10:18 AM
SELECT * FROM `_virtuemart_categories` WHERE 'category_parent_id'<1  not work i see all table ((
Title: Re: bug VM 3.4.3.999 err 1052 Column 'category_parent_id' in field list is ambiguous
Post by: 2dmaster on May 03, 2020, 18:15:59 PM
any help pls ?? where all ?
Title: Re: bug VM 3.4.3.999 err 1052 Column 'category_parent_id' in field list is ambiguous
Post by: 2dmaster on May 06, 2020, 21:47:11 PM
Why no help on forum arghh
Title: Re: bug VM 3.4.3.999 err 1052 Column 'category_parent_id' in field list is ambiguous
Post by: GJC Web Design on May 06, 2020, 23:43:15 PM
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.
Title: Re: bug VM 3.4.3.999 err 1052 Column 'category_parent_id' in field list is ambiguous
Post by: 2dmaster on May 07, 2020, 15:38:40 PM
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 ?
Title: Re: bug VM 3.4.3.999 err 1052 Column 'category_parent_id' in field list is ambiguous
Post by: AH on May 07, 2020, 15:51:48 PM
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
Title: Re: bug VM 3.4.3.999 err 1052 Column 'category_parent_id' in field list is ambiguous
Post by: 2dmaster on May 07, 2020, 16:44:23 PM
Say me pls what is latest stable vm version? i cant find v .10316 where i can test it ?
Title: Re: bug VM 3.4.3.999 err 1052 Column 'category_parent_id' in field list is ambiguous
Post by: AH on May 07, 2020, 16:48:23 PM
http://dev.virtuemart.net/projects/virtuemart/files
Title: Re: bug VM 3.4.3.999 err 1052 Column 'category_parent_id' in field list is ambiguous
Post by: 2dmaster on May 07, 2020, 18:00:02 PM
problem not solved.. GJC Web Design can you say solutions pls ??
Title: Re: bug VM 3.4.3.999 err 1052 Column 'category_parent_id' in field list is ambiguous
Post by: 2dmaster on May 07, 2020, 21:43:37 PM
whats solutions please ???
Title: Re: bug VM 3.4.3.999 err 1052 Column 'category_parent_id' in field list is ambiguous
Post by: pinochico on May 07, 2020, 21:51:19 PM
down to VM 3.6.10 :D
Title: Re: bug VM 3.4.3.999 err 1052 Column 'category_parent_id' in field list is ambiguous
Post by: jenkinhill on May 07, 2020, 23:22:47 PM
The stable update  com_virtuemart.3.8.0.10319  is now available.   http://virtuemart.net/news/500-release-of-virtuemart-3-8-and-covid-support-campaign
Title: Re: bug VM 3.4.3.999 err 1052 Column 'category_parent_id' in field list is ambiguous
Post by: 2dmaster on May 08, 2020, 11:08:19 AM
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 ??
Title: Re: bug VM 3.4.3.999 err 1052 Column 'category_parent_id' in field list is ambiguous
Post by: AH on May 08, 2020, 11:13:22 AM
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?
Title: Re: bug VM 3.4.3.999 err 1052 Column 'category_parent_id' in field list is ambiguous
Post by: 2dmaster on May 08, 2020, 12:25:34 PM
i see this bug from csvi 7.0 to csvi 7.15 why you crash virtuemart and CSVI ?????
Title: Re: bug VM 3.4.3.999 err 1052 Column 'category_parent_id' in field list is ambiguous
Post by: Jörgen on May 08, 2020, 13:03:38 PM
Why not try CSVI 16.1 ?

Jörgen @ Kreativ Fotografi
Title: Re: bug VM 3.4.3.999 err 1052 Column 'category_parent_id' in field list is ambiguous
Post by: 2dmaster on May 08, 2020, 13:18:41 PM
i see all changelogs of CSVI, no any information abouts this bug resolved
Title: Re: bug VM 3.4.3.999 err 1052 Column 'category_parent_id' in field list is ambiguous
Post by: Jörgen on May 08, 2020, 13:26:42 PM
It is not my time, your call. You seem to be alone with this so far.

Jörgen @ Kreativ Fotografi
Title: Re: bug VM 3.4.3.999 err 1052 Column 'category_parent_id' in field list is ambiguous
Post by: Milbo on May 08, 2020, 13:33:46 PM
Quote from: 2dmaster on May 01, 2020, 07:53:44 AM
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.

100% fixed on vm3.8 ! 100%. It comes quite likely from csvi
Title: Re: bug VM 3.4.3.999 err 1052 Column 'category_parent_id' in field list is ambiguous
Post by: 2dmaster on May 08, 2020, 15:27:06 PM
VM have very much bugs.. i can create product with ID=0, without language,, without name and sku......
whats happen in 3.8 ?????
Title: Re: bug VM 3.4.3.999 err 1052 Column 'category_parent_id' in field list is ambiguous
Post by: pinochico on May 08, 2020, 15:59:38 PM
QuoteVM have very much bugs.. i can create product with ID=0, without language,, without name and sku......

Sure?

- without language? - without which language you can create manually product in administration? EN table is default after install and another language table is created after you setup right well joomla. Not before  - this is admin mistake
- without name? - yes, if you don't create right sentences for content language in Joomla - this is admin mistake
- without sku? - sure is sku is required for creating product?

I don't think so.
I think you use CSVI for creating products by import and ther only send info how CSVI not function with new version Virtuemart or I'm wrong :)

Have you contacted Roland yet??

Title: Re: bug VM 3.4.3.999 err 1052 Column 'category_parent_id' in field list is ambiguous
Post by: 2dmaster on May 08, 2020, 16:07:30 PM
no they didnt support me i not have active license for CSVI.. maybe you try ?
Title: Re: bug VM 3.4.3.999 err 1052 Column 'category_parent_id' in field list is ambiguous
Post by: pinochico on May 08, 2020, 16:10:20 PM
Sure.

For extensions we don't have, we extend the subscription every year so that we have paid support and new versions.
CSVI is one of them, although we also use our own applications for import.
Title: Re: bug VM 3.4.3.999 err 1052 Column 'category_parent_id' in field list is ambiguous
Post by: AH on May 08, 2020, 20:30:45 PM
Quoteno they didnt support me i not have active license for CSVI.. maybe you try ?

Dont be so ignorant - pay for the product and get support

I doubt people here will support Rolands product for you for free
Title: Re: bug VM 3.4.3.999 err 1052 Column 'category_parent_id' in field list is ambiguous
Post by: 2dmaster on May 09, 2020, 17:46:39 PM
so new bug: i create from tool !С product..
so i have 19500 products, bu bug in this tool, not correct sql i think, i create product 19501 without name, price, category, sku, manufacturer, but its product have 19500 children products... how ???? and ID 0...
so not fixed in vm 3.8 latest
Title: Re: bug VM 3.4.3.999 err 1052 Column 'category_parent_id' in field list is ambiguous
Post by: pinochico on May 09, 2020, 18:07:59 PM
To 2dmaster:

Sorry but I don't understand what do you write and want still. You dont send any picture, only say "its bug, its bug, hurry up VM DEV, fix it!!!"
I don't understand what is "!C", I don't understand why is problem in VM, then you use 3d party extensions?

Pls read this info and write your problem again:
http://forum.virtuemart.net/index.php?topic=144845.0
Title: Re: bug VM 3.4.3.999 err 1052 Column 'category_parent_id' in field list is ambiguous
Post by: pinochico on May 09, 2020, 18:12:41 PM
Is your invisible e-shop without a tracked URL a commercial project and you use your developer?

Or are you just installing programs and then looking for help in this forum?
Title: Re: bug VM 3.4.3.999 err 1052 Column 'category_parent_id' in field list is ambiguous
Post by: AH on May 09, 2020, 18:18:47 PM
OK - this topic is clearly not a core VM issue.

I am closing this thread - 2dm, seek help for your plugins or third party code from the developers of that code.