SuiteCRM Pull Request Party hosted by SalesAgility
Welcome, Guest
Username: Password: Remember me

TOPIC: Upgrade log file - MISSING IN DATABASE - Is this OK?

Upgrade log file - MISSING IN DATABASE - Is this OK? 6 months 1 week ago #75491

  • JamesPrivate
  • JamesPrivate's Avatar
  • Offline
  • New Member
  • Posts: 6
  • Karma: 0
It appears during upgrades, (pretty much anyone I've ever done) I get messages like this in Upgrade Log. Is this normal, and considered OK? In other words, the upgrade is successful? If so, is it really missing? Maybe it would be better stated that "NOT IN YET".

Or do I have a fundamental problem that needs addressed? The reason I am homing in on this is because I am having a helluva time going from 7.8.X to 7.10.X (or 7.9.X for that matter)

Emails are giving me a terrible fit, it seems to break no matter what I do or try. Anyway, first things first, is this MISSING message considered normal during an upgrade?


Snippet of Upgrade Log message below:

Tue, 11 Dec 2018 19:06:54 +0000 [UpgradeWizard] - Running sql:/* Table : outbound_email */
/*MISSING IN DATABASE - smtp_from_name - ROW*/
/*MISSING IN DATABASE - smtp_from_addr - ROW*/
ALTER TABLE outbound_email add COLUMN smtp_from_name varchar(255) NULL , add COLUMN smtp_from_addr varchar(255) NULL

Tue, 11 Dec 2018 19:06:55 +0000 [UpgradeWizard] - database repaire
Last Edit: 6 months 1 week ago by JamesPrivate.
The administrator has disabled public write access.

Upgrade log file - MISSING IN DATABASE - Is this OK? 6 months 1 week ago #75516

  • pgr
  • pgr's Avatar
  • Offline
  • Administrator
  • Posts: 10198
  • Thank you received: 1531
  • Karma: 352

the upgrade wizard detects it's missing, but supposedly runs that SQL to add the columns. So it should happen just once.

Please go in Admin / Repairs, run a Quick Repair and Rebuild, and scroll to the bottom. If there's a button to "sync vardefs with database", press it.

You can then check your database (with phpMyAdmin or similar) and see if those columns (smtp_from_name and smtp_from_addr) exist in your outbound_email table.

You can also rename (and later, delete it, if nothing bad happens) your upload/upgrades directory. This will clear any left-overs from previous broken upgrades.

My SuiteCRM In-depth blog.
Thank you for always stating your SuiteCRM version, checking your logs, reading the Docs, and searching before you ask!
The administrator has disabled public write access.
Time to create page: 0.024 seconds
Powered by Kunena Forum