CiviCRM Community Forums (archive)

Hello everyone,

So I have been looking around the forums here and reading the documentation and essentially just want confirmation on something.

I upgraded to 3.2.4 and afterwards received this error:
DB Error: no such field

Database Error Code: Unknown column 'contact_civireport.is_deleted' in 'where clause', 1054This appears on my dashboard in place of the "Event Participant List Report"


And from what I can tell that is the only problem since the upgrade so far. So essentially I was just looking to get a few opinions on my options as the site that this is on is used by 200+ people of an organization. We are planning to make a full transition to Drupal anyways so I could take this as an opportunity to export all my custom data and import to a fresh civiCRM install. That does sound like a bit of work but the only other way I could see getting around this is if there is some "quick fix" to this error that anyone might know of.

Thoughts?

Hookay so here's what I got: I was following the instructions that Kurund linked and everything was going fine until step 6 on that page which reads

Now import your datafile.sql (taken from step1) again in the new database.

Code: [Select]

mysql -u username -p newdatabase < datafile.sql

I did this and after a while I got this error back:
SQL query:

--
-- Dumping data for table `civicrm_task_action_temp`
--
LOCK TABLES  `civicrm_task_action_temp` WRITE ;


MySQL said:

#1146 - Table 'myhost_blah.civicrm_task_action_temp' doesn't exist
So I went through my datafile.sql, that was created during step 1 of this process, found this query and deleted it and saved this as a separate file. Just to be safe I created another empty database and imported all three files successfully; the civicrm.mysql, customfieldsfile.sql and the datafile.sql (the one without the query to dump data from the civicrm_task_action_temp table).

Finally I come to my question, will CiviCRM still work if this table is omitted? (Slightly off topic but what does that table do?) I suppose I could attempt to do what I did with this temporary database to my working database but I'd like to see if this is even a viable option because I'd rather not break anything else :/

I am happy to report that everything seems to be working great! Thanks Kurund!