Error to edit a record in Symfony

Question

Error to edit a record in Symfony

Navigation

#1 by (0 votes)
#2 by (0 votes)

0

I have a relationship between 2 tables Orders and Users and the information is displayed correctly.

Mapping Users:

BackendBundle\Entity\Users:
type: entity
table: users
id:
    id:
        type: integer
        nullable: false
        options:
            unsigned: false
        id: true
        column: ID
        generator:
            strategy: IDENTITY
fields:
    username:
        type: string
        nullable: true
        length: 50
        options:
            fixed: false
    yourname:
        type: string
        nullable: true
        length: 50
        options:
            fixed: false
    firstname:
        type: string
        nullable: true
        length: 150
        options:
            fixed: false
    lastname:
        type: string
        nullable: true
        length: 150
        options:
            fixed: false
    middlename:
        type: string
        nullable: true
        length: 10
        options:
            fixed: false
    address:
        type: string
        nullable: true
        length: 500
        options:
            fixed: false
    address2:
        type: string
        nullable: true
        length: 500
        options:
            fixed: false
    apartment:
        type: string
        nullable: true
        length: 50
        options:
            fixed: false
    pobox:
        type: string
        nullable: true
        length: 50
        options:
            fixed: false
    city:
        type: string
        nullable: true
        length: 150
        options:
            fixed: false
    state:
        type: string
        nullable: true
        length: 150
        options:
            fixed: false
    zipcode:
        type: string
        nullable: true
        length: 100
        options:
            fixed: false
    country:
        type: string
        nullable: true
        length: 255
        options:
            fixed: false
    countrycode:
        type: string
        nullable: true
        length: 2
        options:
            fixed: false
    phone:
        type: string
        nullable: true
        length: 150
        options:
            fixed: false
    fax:
        type: string
        nullable: true
        length: 150
        options:
            fixed: false
    email:
        type: string
        nullable: true
        length: 255
        options:
            fixed: false
    password:
        type: string
        nullable: true
        length: 50
        options:
            fixed: false
    company:
        type: string
        nullable: true
        length: 255
        options:
            fixed: false
    type:
        type: decimal
        nullable: true
        precision: 18
        scale: 0
    datein:
        type: datetime
        nullable: true
lifecycleCallbacks: {  }

Mapping Orders:

BackendBundle\Entity\Orders:
type: entity
table: orders
indexes:
    fk_order_user1_idx:
        columns:
            - user_id
id:
    orderid:
        type: integer
        nullable: false
        options:
            unsigned: false
        id: true
        column: OrderID
        generator:
            strategy: IDENTITY
fields:
    orderdate:
        type: datetime
        nullable: true
        column: OrderDate
    ordernumber:
        type: string
        nullable: true
        length: 50
        options:
            fixed: false
        column: OrderNumber
    customername:
        type: string
        nullable: true
        length: 250
        options:
            fixed: false
        column: CustomerName
    customeraddress:
        type: string
        nullable: true
        length: 500
        options:
            fixed: false
        column: CustomerAddress
    countrycode:
        type: string
        nullable: true
        length: 2
        options:
            fixed: false
        column: CountryCode
    shippingaddress:
        type: string
        nullable: true
        length: 500
        options:
            fixed: false
        column: ShippingAddress
    status:
        type: string
        nullable: true
        length: 50
        options:
            fixed: false
        column: Status
    subtotal:
        type: decimal
        nullable: true
        precision: 18
        scale: 2
        column: SubTotal
    shippingcost:
        type: decimal
        nullable: true
        precision: 18
        scale: 2
        column: ShippingCost
    tax:
        type: decimal
        nullable: true
        precision: 18
        scale: 2
        column: Tax
    discount:
        type: decimal
        nullable: true
        precision: 18
        scale: 2
        column: Discount
    totalorder:
        type: decimal
        nullable: true
        precision: 18
        scale: 2
        column: TotalOrder
    shippingcarrier:
        type: string
        nullable: true
        length: 50
        options:
            fixed: false
        column: ShippingCarrier
    shippingtype:
        type: string
        nullable: true
        length: 50
        options:
            fixed: false
        column: ShippingType
    shippingtrackingnumber:
        type: string
        nullable: true
        length: 50
        options:
            fixed: false
        column: ShippingTrackingNumber
    paymentmethod:
        type: string
        nullable: true
        length: 50
        options:
            fixed: false
        column: PaymentMethod
    paymentapproval:
        type: string
        nullable: true
        length: 100
        options:
            fixed: false
        column: PaymentApproval
    cc:
        type: string
        nullable: true
        length: 20
        options:
            fixed: false
        column: CC
    ccexp:
        type: string
        nullable: true
        length: 10
        options:
            fixed: false
        column: CCExp
    ccv:
        type: string
        nullable: true
        length: 10
        options:
            fixed: false
        column: CCV
    memo:
        type: string
        nullable: true
        length: 500
        options:
            fixed: false
        column: Memo
    sessionid:
        type: string
        nullable: true
        length: 50
        options:
            fixed: false
        column: SessionID
    discountcode:
        type: string
        nullable: true
        length: 50
        options:
            fixed: false
        column: DiscountCode
    hasshipgift:
        type: boolean
        nullable: true
        column: HasShipGift
    message:
        type: string
        nullable: true
        length: 300
        options:
            fixed: false
    imagen:
        type: integer
        nullable: true
        options:
            unsigned: false
    siteType:
        type: string
        nullable: true
        length: 50
        options:
            fixed: false
        column: site_type
    shippingname:
        type: string
        nullable: true
        length: 250
        options:
            fixed: false
        column: ShippingName
manyToOne:
    user:
        targetEntity: Users
        cascade: {  }
        fetch: LAZY
        mappedBy: null
        inversedBy: null
        joinColumns:
            user_id:
                referencedColumnName: id
        orphanRemoval: false
lifecycleCallbacks: {  }

I need to edit a record of orders so I put the following code in the list:

<td><a class="btn btn-primary" href="{{path('edit_orderlist',{ 'id': ordenes.orderid })}}">Edit</a></td>

But the moment it reaches the controller that I have with this code:

$em = $this->getDoctrine()->getManager();
    $orders_repo=$em->getRepository("BackendBundle:Orders");
    $order=$orders_repo->find($id);
    $form = $this->createForm(OrderType::class, $order);

Show me this error:

Could not resolve type of column "id" of class "BackendBundle \ Entity \ Users"

Orders has as primary key OrderId and Users as primary key id

Any ideas to solve this?

symfony3 symfony dql

asked by juanitourquiza 02.08.2017 в 19:24

source

2 answers

0

Hello juanitourquiza, make sure that in your doctrine xml files you have something like this:

AuthBundle \ Resources \ config \ doctrine \ Marking.orm.yml

Usuarios\AuthBundle\Entity\Marcacion:
type: entity
table: marcacion
id:
    id:
        type: integer
        nullable: false
        options:
            unsigned: false
        id: true
        generator:
            strategy: IDENTITY

and in the file: AuthBundle \ Resources \ config \ doctrine \ metadata \ orm \ Marking.orm.xml

<?xml version="1.0" encoding="utf-8"?>
<doctrine-mapping xmlns="http://doctrine-project.org/schemas/orm/doctrine-mapping" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://doctrine-project.org/schemas/orm/doctrine-mapping http://doctrine-project.org/schemas/orm/doctrine-mapping.xsd">
  <entity name="Marcacion" table="marcacion">
    <id name="id" type="integer" column="id">
      <generator strategy="IDENTITY"/>
    </id>

in both files it must indicate that the id is IDENTITY.

answered by 02.08.2017 в 21:16

ErrorException Array to string conversion - Error sending an array to a url does anyone know how to define the html2pdf favicon?

score 0 · Accepted Answer

After investigating and reading the different recommendations, the problem was in the .yml files of the tables and in the Entities, and I found this error even though the list looked good on the screen.

To verify this, create a testing environment and perform the import and creation of entities to check if there was an error.

So the code is:

//BackendBundle\Entity\Orders:
type: entity
table: orders
indexes:
    fk_Orders_Users_idx:
        columns:
            - Users_ID
......
manyToOne:
    users:
        targetEntity: Users
        cascade: {  }
        fetch: LAZY
        mappedBy: null
        inversedBy: null
        joinColumns:
            Users_ID:
                referencedColumnName: ID
        orphanRemoval: false
lifecycleCallbacks: {  }

Users.orm.yml remained the same as before

Another change is in the Entity Orders.php

/**
 * @var \BackendBundle\Entity\Users
 */
private $users;
.........
/**
 * Set users
 *
 * @param \BackendBundle\Entity\Users $users
 *
 * @return Orders
 */
public function setUsers(\BackendBundle\Entity\Users $users = null)
{
    $this->users = $users;

    return $this;
}

/**
 * Get users
 *
 * @return \BackendBundle\Entity\Users
 */
public function getUsers()
{
    return $this->users;
}

With these changes everything works fine.