Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

1

ProgrammingError: ERREUR: erreur de syntaxe sur ou près de « analyse » LINE 1: COMMENT ON COLUMN analyse."name" IS 'pat'

By
sanaa tayb
on 5/25/13, 5:27 PM 2,724 views

Hello , plz i need your help : here is my module :

analyse.py

from openerp import addons 
from osv import fields, osv
import time

class analyse(osv.osv):
    _name='analyse'
    _description='fiche danalyse du patient'

    _columns={
        'name' : fields.char('pat', size=34 ,required=True),
    }
analyse()

and here is my XML file :

analyse.xml

<?xml version="1.0" encoding="utf-8"?>
<openerp>
    <data>
    <record model="ir.ui.view" id="analyse_tree_view">
        <field name="name">analyse.tree</field>
        <field name="model">analyse</field>
        <field name="type">tree</field>
        <field name="arch" type="xml">
            <tree string="Analyse" version="7.0">
                <field name="name" />
            </tree>
        </field>
    </record>

    <record model="ir.ui.view" id="analyse_form_view">
        <field name="name">analyse.form</field>
        <field name="model">analyse</field>
        <field name="type">form</field>
        <field name="arch" type="xml">
            <form string="Analyse" version="7.0">
                <group colspan="4" col="4" string=" Fiche d'analyse">
                    <field name="name" />
                </group>
            </form>
        </field>
    </record>

    <record model="ir.actions.act_window" id="analyse_form_1">
        <field name="name">analyse</field>
        <field name="res_model">analyse</field>
        <field name="view_type">form</field>
        <field name="view_mode">tree,form</field>
    </record>

    <menuitem id="analys" name="Analyse"  parent="menu_patients_parent1" action="analyse_form_1" sequence="3"/>
    </data>
</openerp>

PS: menu_patients_parent1 , refers to a parents created in another .XML file , befor i added the analyse.py and analyse.XML the module worked just fine , but now while installing i get the following error :

ProgrammingError: ERREUR: erreur de syntaxe sur ou près de « analyse » LINE 1: COMMENT ON COLUMN analyse."name" IS 'pat'

2

Borni DHIFI

--Borni DHIFI--
5102
| 6 8 9
Tunis, Tunisia
--Borni DHIFI--

Techno Functional Consultant Odoo(OpenERP) 

http://www.linkedin.com/in/borni

Skype : dhifi.borni

Borni DHIFI
On 5/26/13, 12:10 PM

Hi,

ERROR: syntax error at or near "analyse"

analyse is a reserved keyword in in Postgresql. that's why you have encountered some problem.

so to resolved this problem change _name='analyse' to other name for example _name='my_analyse'.

Thanks.

thank you very much it Did work :)

sanaa tayb
on 5/26/13, 3:55 PM

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 5/25/13, 5:27 PM
Seen: 2724 times
Last updated: 3/16/15, 8:10 AM