Hello Laurent, thanks for looking into this.
Le 15/01/2012 23:22, Laurent Destailleur (eldy) a écrit : … > For error > Information sur le dernier accès en base en erreur: Unknown column > 'fk_element' in 'where clause' > > It should not appears because the field is created by the > > 3.0.0-3.1.0.sql scripts My belief (I cannot test again as for now), is that as soon as a script has an error, rest of it is not used by upgrade process. So that, I launched it using following command on server: $ mysql -u mydbdolibarruser -p mydolibarrdatabase < 3.0.0-3.1.0.sql On each error, I modified concerned line and deleted previous lines, then launched above command again. As I had some errors in script on _previous_ lines that the one creating fk_element column, I /think/ IMHO, that such column was not created. > > Do you have this field fk_element into llx_acitoncomm table now ? > If not do you have a field note into llx_actioncomm ? > As of now, llx_actioncomm table contains both columns: note and fk_element. (Please see complete table description attached to this email.) Regards, -- Fernando Lagrange Demo-TIC - Outils En Ligne http://www.demo-tic.org Tél.: 06 63 16 30 47 (le jeudi après-midi) Mél.: [email protected] Jabber/XMPP: [email protected]
mysql> describe llx_actioncomm;
+---------------------+--------------+------+-----+-------------------+-----------------------------+
| Field | Type | Null | Key | Default | Extra
|
+---------------------+--------------+------+-----+-------------------+-----------------------------+
| id | int(11) | NO | PRI | NULL |
auto_increment |
| entity | int(11) | NO | | 1 |
|
| datep | datetime | YES | | NULL |
|
| datep2 | datetime | YES | | NULL |
|
| datea | datetime | YES | MUL | NULL |
|
| datea2 | datetime | YES | | NULL |
|
| fk_action | int(11) | YES | | NULL |
|
| label | varchar(128) | NO | | NULL |
|
| datec | datetime | YES | | NULL |
|
| tms | timestamp | NO | | CURRENT_TIMESTAMP | on
update CURRENT_TIMESTAMP |
| fk_user_author | int(11) | YES | | NULL |
|
| fk_user_mod | int(11) | YES | | NULL |
|
| fk_project | int(11) | YES | | NULL |
|
| fk_soc | int(11) | YES | MUL | NULL |
|
| fk_contact | int(11) | YES | MUL | NULL |
|
| fk_parent | int(11) | NO | | 0 |
|
| fk_user_action | int(11) | YES | | NULL |
|
| fk_user_done | int(11) | YES | | NULL |
|
| priority | smallint(6) | YES | | NULL |
|
| fulldayevent | smallint(6) | NO | | 0 |
|
| punctual | smallint(6) | NO | | 1 |
|
| percent | smallint(6) | NO | | 0 |
|
| location | varchar(128) | YES | | NULL |
|
| durationp | double | YES | | NULL |
|
| durationa | double | YES | | NULL |
|
| note | text | YES | | NULL |
|
| fk_element | int(11) | YES | | NULL |
|
| elementtype | varchar(16) | YES | | NULL |
|
| propalrowid | int(11) | YES | | NULL |
|
| fk_commande | int(11) | YES | | NULL |
|
| fk_facture | int(11) | YES | | NULL |
|
| fk_supplier_order | int(11) | YES | | NULL |
|
| fk_supplier_invoice | int(11) | YES | | NULL |
|
+---------------------+--------------+------+-----+-------------------+-----------------------------+
33 rows in set (0.00 sec)
signature.asc
Description: OpenPGP digital signature
_______________________________________________ Dolibarr-dev mailing list [email protected] https://lists.nongnu.org/mailman/listinfo/dolibarr-dev
