Fork me on GitHub
Home
Menu
Last news
Screenshots
Online demo
Downloads
Documentation
Forum
Search
Addon Market
The foundation
Dolibarr plugins/addons...

More plugins/addons and tools on...
Banner

...the official market place for Dolibarr ERP/CRM...
Make a donation


SaaS Hosting

Opt for a simple and flexible...
Banner

...the official SaaS hosting of Dolibarr ERP/CRM...
Welcome, Guest
Please Login or Register.    Lost Password?

llx_product_subproduct missing.
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: llx_product_subproduct missing.
#16752
llx_product_subproduct missing. 1 Year, 6 Months ago Karma: 3
Hello,
Is there a reason why the llx_product_subproduct.sql file has been removed from htdocs/install/mysql/tables ?

(Version 2.9 beta)

I'm getting an error on htdocs/product/index.php


Type gestionnaire de base de données: mysqli

Requête dernier accès en base en erreur: SELECT p.rowid, p.label, p.price, p.ref, p.fk_product_type, p.envente, p.tms as datem FROM llx_product as p LEFT JOIN llx_product_subproduct as sp ON p.rowid = sp.fk_product_subproduct WHERE sp.fk_product_subproduct IS NULL AND p.entity = 1 ORDER BY p.tms DESC LIMIT 15

Code retour dernier accès en base en erreur: DB_ERROR_NOSUCHTABLE

Information sur le dernier accès en base en erreur: Table 'dolibarr29.llx_product_subproduct' doesn't exist


I initially thought that this table had been deprecated but product.class.php is still referring to it.

Have I overlooked something?

Thank you
LaMakina
Fresh Boarder
Posts: 16
graphgraph
User Offline Click here to see the profile of this user
Gender: Male ryounes Location: Anglet, France / Guadeloupe, F.W.I
The administrator has disabled public write access.
 
#16767
Re: llx_product_subproduct missing. 1 Year, 6 Months ago Karma: 121
A bug in the beta you have.
With last beta (last snapshot), you will have no more table llx_product_subproduct but llx_product_association and code you this last one.
eldy
Administrateur
Posts: 895
graph
User Offline Click here to see the profile of this user
Gender: Male Site web personnel eldy10 Location: Rueil Malmaison Birthday: 10/10
Dolibarr grade: Yoda.
Thanks to help the project by making a Paypal donation (credit card allowed) using the link available on left area of Home page: www.dolibarr.org
The administrator has disabled public write access.
 
#16789
Re:llx_product_subproduct missing. 1 Year, 6 Months ago Karma: 3
I see that llx_product_association has been added. Everything seems to be working fine.

I'm just noticing that the warning is still being displayed because the load_subproduct() function is still being called from product.class.php
LaMakina
Fresh Boarder
Posts: 16
graphgraph
User Offline Click here to see the profile of this user
Gender: Male ryounes Location: Anglet, France / Guadeloupe, F.W.I
The administrator has disabled public write access.
 
#16797
Re:llx_product_subproduct missing. 1 Year, 6 Months ago Karma: 121
Right.
This is a deprecated function that is not used anymore. Code will be removed.
eldy
Administrateur
Posts: 895
graph
User Offline Click here to see the profile of this user
Gender: Male Site web personnel eldy10 Location: Rueil Malmaison Birthday: 10/10
Dolibarr grade: Yoda.
Thanks to help the project by making a Paypal donation (credit card allowed) using the link available on left area of Home page: www.dolibarr.org
The administrator has disabled public write access.
 
Go to topPage: 1