Re: Wrong URL in new Proposal The demo fails!!!!!

Using my Dolibarr
1

Hi,

I updated from 2.9 to 3.0 and I can’t create the new Proposal.

After mocking around looks like the URL for create a new proposal is

http://x.x.x.x/dolibarr/comm/addpropal.php?socid=4&action=create

But In the left hand menu it, the “Create new Proposal” redirects you to the url http://x.x.x.x/dolibarr/societe/societe.php?leftmenu=propals That shows the list of “3rd parties”

What file should I change for do a fix in my system?

Cheers
JD

2

To create a proposal, you must first select a third party. That’s why link go to societe.php.
Once you have click on “Customer” or “Prospect” link, you can create proposal for this third party.

3

The problem is that even in the online demo version I get:

olibarr has detected a technical error.
This is information that can help diagnostic:
Date: 20110603150313
Dolibarr: 3.1.0-alpha
Level of features: 0
PHP: 5.2.4-2ubuntu5.14
Server: Apache

Requested Url: /societe/soc.php?socid=36
Referer: http://demo.dolibarr.org/societe/societe.php?leftmenu=propals
Menu manager: eldy_backoffice.php

Database type manager: mysql
Request for last database access in error: SELECT s.rowid, s.nom as name, s.entity, s.ref_ext, s.ref_int, s.address, s.datec as datec, s.prefix_comm, s.price_level, s.tms as date_update, s.tel, s.fax, s.email, s.url, s.cp as zip, s.ville as town, s.note, s.client, s.fournisseur, s.siren, s.siret, s.ape, s.idprof4, s.capital, s.tva_intra, s.fk_typent as typent_id, s.fk_effectif as effectif_id, s.fk_forme_juridique as forme_juridique_code, s.code_client, s.code_fournisseur, s.code_compta, s.code_compta_fournisseur, s.parent, s.gencod, s.fk_departement, s.fk_pays, s.fk_stcomm, s.remise_client, s.mode_reglement, s.cond_reglement, s.tva_assuj, s.localtax1_assuj, s.localtax2_assuj, s.fk_prospectlevel, s.default_lang, s.import_key, s.status, fj.libelle as forme_juridique, e.libelle as effectif, p.code as pays_code, p.libelle as pays, d.code_departement as departement_code, d.nom as departement, st.libelle as stcomm, te.code as typent_code FROM llx_societe as s LEFT JOIN llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llx_c_pays as p ON s.fk_pays = p.rowid LEFT JOIN llx_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN llx_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN llx_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN llx_c_typent as te ON s.fk_typent = te.id WHERE s.rowid = 36
Return code for last database access in error: DB_ERROR_NOSUCHFIELD
Information for last database access in error: Unknown column ‘s.ref_int’ in ‘field list’

Message: Unknown column ‘s.ref_int’ in ‘field list’

4

On my Own server I get:
Dolibarr ha detectado un error técnico.
He aquí la información que podrá ayudar al diagnóstico:
Fecha: 20110603141208
Dolibarr: 3.0.0
Nivel de funciones: 0
PHP: 5.2.6-1+lenny10
Server: Apache/2.2.9 (Debian) PHP/5.2.6-1+lenny10 with Suhosin-Patch mod_perl/2.0.4 Perl/v5.10.0

Url solicitada: /dolibarr/comm/addpropal.php?leftmenu=propals&action=create
Referer: http://192.168.0.247/dolibarr/comm/propal.php?leftmenu=propals
Gestor de menú: eldy_backoffice.php

Tipo de gestor de base de datos: mysqli
Petición último acceso a la base de datos erróneo: Ninguna petición en error
Código devuelto último acceso a la base de datos erróneo: Ninguna petición en error
Información sobre el último acceso a la base de datos erróneo: Ninguna petición en error

5

Hi

I can’t get the proposals to work.

Even in the demo, if you go to new Proposal, click on a 3rd party you get an error.

For me at least, the proposals are central to my bussines, is nobody else getting this error?

is is information that can help diagnostic:
Date: 20110621195447
Dolibarr: 3.1.0-alpha
Level of features: 0
PHP: 5.2.4-2ubuntu5.14
Server: Apache

Requested Url: /societe/soc.php?socid=196
Referer: http://demo.dolibarr.org/societe/societe.php?leftmenu=propals
Menu manager: eldy_backoffice.php

Database type manager: mysql
Request for last database access in error: SELECT s.rowid, s.nom as name, s.entity, s.ref_ext, s.ref_int, s.address, s.datec as datec, s.prefix_comm, s.status, s.price_level, s.tms as date_update, s.tel, s.fax, s.email, s.url, s.cp as zip, s.ville as town, s.note, s.client, s.fournisseur, s.siren, s.siret, s.ape, s.idprof4, s.capital, s.tva_intra, s.fk_typent as typent_id, s.fk_effectif as effectif_id, s.fk_forme_juridique as forme_juridique_code, s.code_client, s.code_fournisseur, s.code_compta, s.code_compta_fournisseur, s.parent, s.gencod, s.fk_departement, s.fk_pays, s.fk_stcomm, s.remise_client, s.mode_reglement, s.cond_reglement, s.tva_assuj, s.localtax1_assuj, s.localtax2_assuj, s.fk_prospectlevel, s.default_lang, s.logo, s.import_key, fj.libelle as forme_juridique, e.libelle as effectif, p.code as pays_code, p.libelle as pays, d.code_departement as departement_code, d.nom as departement, st.libelle as stcomm, te.code as typent_code FROM llx_societe as s LEFT JOIN llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llx_c_pays as p ON s.fk_pays = p.rowid LEFT JOIN llx_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN llx_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN llx_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN llx_c_typent as te ON s.fk_typent = te.id WHERE s.rowid = 196
Return code for last database access in error: DB_ERROR_NOSUCHFIELD
Information for last database access in error: Unknown column ‘s.logo’ in ‘field list’

Message: Unknown column ‘s.logo’ in ‘field list’

6

Should be fixed now.

7

Hi,
What should I do on my local copy for fix it as well?

Cheers
JD