[contribution] B2Bsuite beta 0.5 (MS2)

[BluEdoG]

Rilasciata la beta 5 di B2Bsuite.
Per chi ha installato la versione 04 nel pacchetto troverà il file upgrade.txt che indica dove mettere mano all'installazione precedente.

In questa versione sono stati corretti i bachi relativi a:
Elenco dei gruppi clienti nella schermata clienti
Ora l'assegnazione al gruppo puo' essere resettata
La sezione offerte è stata migliorata, si puo' cambiare gruppo cliente direttamente nell'offerta senza cancellarla.

Come sempre se riscontratre bug o feedback riportateli in questo thread,
Grazie per la collaborazione portata sino ad ora

per il download
http://xoomer.virgilio.it/bluedog/b2bsuite

[garba72]

Ciao, ho fatto l'upgrade a b2b beta 5 e mi propone questo errore (che mi proponeva anche la beta 4).

Lato negozio sulla barra a destra in alto esce questa scritta:
1054 - Unknown column 'customers_group_id' in 'field list'
select customers_group_id from customers where customers_id = ''
[TEP STOP]

Lato Admin --> clienti:
1054 - Unknown column 'c.customers_group_id' in 'field list'
select distinct c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_group_id, a.entry_company, c.customers_email_address, a.entry_country_id from customers c left join address_book a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id order by c.customers_lastname, c.customers_firstname limit 0, 20


Credo di aver correttamente seguito le istruzioni per l'installazione.

Ciao
Garba

[BluEdoG]

hai caricato il file b2bsuite.sql tramite phpmyadmin?

[XPfrik]

Sorry cause I will write in english. I can read italian, but i can not write in your lang.

Problem continue with categories. Error I get is:

Unknown column '2_57' in 'where clause'

select discount from groups_to_categories where customers_group_id = 1 and categories_id=2_57

I have tried to find error, and here is what I know:
- error you get just with articles which are in sub-categories. If article is in parent category everything goes smoth. As I look further it is the category path problem (with subcategory you get numbers like 2_57 for category path, value in database in just int - so this value want fit in it).

Do you have any sugestion?

BTW - thanks for the creat contribution.

[BluEdoG]

Unknown column '2_57' in 'where clause'
.

Hi XPfrik,
this is a big problem ...
usually i dont use sub sub categories, and i haven't see this bug..
I investigate to solve it....

[BluEdoG]

Ok i've got the solution
at line 747 into categories.php change the line with

Codice: Seleziona tutto

$query_discount = tep_db_query("select discount from " . TABLE_GROUPS_TO_CATEGORIES . " where customers_group_id = " . $customers_group['customers_group_id'] ." and categories_id=" . $current_category_id ."");

Pls reply me if this is ok or not, thx!

[garba72]

hai caricato il file b2bsuite.sql tramite phpmyadmin?

Si, ho caricato dalla phpmyadmin, click su Finestra della query, importa files e impotato b2b....sql. ho visto le che tabelle dell'sql di ecommerce da 46 sono diventate 47.

Grazie

[garba72]

hai caricato il file b2bsuite.sql tramite phpmyadmin?

Si, ho caricato dalla phpmyadmin, click su Finestra della query, importa files e impotato b2b....sql. ho visto le che tabelle dell'sql di ecommerce da 46 sono diventate 47.

Grazie

[BluEdoG]

dovevano aumentare di 3 non di una, qualche cosa è andato storto.

[XPfrik]

Ok i've got the solution
at line 747 into categories.php change the line with

Codice: Seleziona tutto

$query_discount = tep_db_query("select discount from " . TABLE_GROUPS_TO_CATEGORIES . " where customers_group_id = " . $customers_group['customers_group_id'] ." and categories_id=" . $current_category_id ."");

Pls reply me if this is ok or not, thx!

it works. Big thx.
But I have discovered another small (I think) problem. Now, everything is ok - prices in the form are ok - but in the preview -- prices for the grups are all 0.0000. Solution???

[XPfrik]

To clarify my upper post-

action=new_product_preview - this give ok prices (everything is calculated as it should be)

action=new_product_preview&read=only - this one show all prices of grups like 0,0000.

[BluEdoG]

ok - prices in the form are ok - but in the preview -- prices for the grups are all 0.0000. Solution???

I know the problem, i haven't found a great solution.
But in my sites the problem is only when i override the rate system, not in rate mode.

[BluEdoG]

Yes i know also in read only session. In reports when you click into product not see anything but give an error
I'm trying to solve this, but i haven't found a good solution for 3 view modes (update - preview - readonly).