hi everybody,
I have the following error.
this is the my db
CREATE TABLE event (id BIGINT AUTO_INCREMENT, personal_id BIGINT, type TINYINT NOT NULL, title VARCHAR(255) NOT NULL, description TEXT, date DATE NOT NULL,country_id BIGINT, zone_id BIGINT,place VARCHAR(255),occasion VARCHAR(255),itinerary VARCHAR(255), INDEX personal_id_idx (personal_id), PRIMARY KEY(id)) ENGINE = INNODB;
this is the Doctrine-event.class.php
class Event extends BaseEvent
{
public function getDataInArray()
{
$data= array();
$data['id'] = $this->id;
$data['personal_id'] = $this->personal_id;
$data['title']=$this->title;
$data['country_id']=$this->country_id;
$data['zone_id']=$this->zone_id;
$data['place']=$this->place;
$data['occasion']=$this->occasion;
$data['itinerary']=$this->itinerary;
$data['date']=$this->date;
$data['description']=$this->description;
return $data;
}
public function saveDataInArray($data)
{
$this->personal_id = $data['personal_id'];
$this->title=$data['title'];
$this->country_id=$data['country_id'];
$this->zone_id=$data['zone_id'];
$this->place = $data['place'];
$this->occasion=$data['occasion'];
$this->itinerary=$data['itinerary'];
$this->date=$data['date'];
$this->description=$data['description'];
$this->save();
}
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'e.country_id' in 'field list'. Failing Query: "SELECT e.id AS e__id, e.personal_id AS e__personal_id, e.type AS e__type, e.title AS e__title, e.country_id AS e__country_id, e.zone_id AS e__zone_id, e.place AS e__place, e.occasion AS e__occasion, e.itinerary AS e__itinerary, e.description AS e__description, e.date AS e__date FROM event e"
plz help me
