Timeline for PEAR_Exception: DB Error: no such field, while upgrading CiviCRM in Wordpress
Current License: CC BY-SA 4.0
12 events
when toggle format | what | by | license | comment | |
---|---|---|---|---|---|
Jul 14, 2022 at 20:49 | vote | accept | Joshua K | ||
Jul 13, 2022 at 17:22 | answer | added | Demerit | timeline score: 0 | |
Jul 13, 2022 at 16:24 | comment | added | Joshua K | Thank you @Demerit that fixed the issue. Perhaps the restore function I used when the upgrade failed was not restoring things as completely as I assumed. I was successfully able to run the entire upgrade process after dropping and re-creating the civicrm_queue table. | |
Jul 13, 2022 at 13:52 | comment | added | Demerit |
I don't know how it would be possible to have a 5.47 backup that had never gone past 5.48 that has a civicrm_queue table but doesn't have is_autorun. The only thing I can think is a sequence of failed upgrades that included some 5.48. Since you probably don't have anything in civicrm_queue, try drop table civicrm_queue , then create it using github.com/civicrm/civicrm-core/blob/… (leave out the utf8mb4 if your database is only utf8), then run the upgrade.
|
|
Jul 13, 2022 at 0:27 | comment | added | Joshua K | @Demerit I've updated this question and am hoping you'll have more input for me. Thanks! | |
Jul 12, 2022 at 23:56 | history | edited | Joshua K | CC BY-SA 4.0 |
added 164 characters in body
|
Jul 12, 2022 at 23:52 | history | edited | Joshua K | CC BY-SA 4.0 |
added 331 characters in body
|
Jul 11, 2022 at 16:05 | comment | added | Joshua K | Once the upgrade failed I reset both the filesystem and database back to where it was before I had started. So I'm back in 5.47.4. But I don't have a way to go back any farther than that. I see the civicrm_queue table. It was the first time I attempted this upgrade. | |
Jul 8, 2022 at 20:27 | comment | added | Demerit | If not, are you able to see from a backup what your civicrm_queue table looked like in 5.47? There should be a line in the backup file starting with CREATE TABLE civicrm_queue | |
Jul 8, 2022 at 20:25 | comment | added | Demerit | Is this a site where you tried the upgrade more than once? You can get that error if running thru the 5.48 steps again without doing a complete drop and restore from backup before rerunning. | |
S Jul 8, 2022 at 18:19 | review | First questions | |||
Jul 14, 2022 at 20:57 | |||||
S Jul 8, 2022 at 18:19 | history | asked | Joshua K | CC BY-SA 4.0 |