campaign details display error

[DruRoland]

When I look at the details page of any campaign, all fields are blank, and, in /var/log/apache2/error_log I get this:
[Thu May 30 11:01:29 2013] [error] [client 10.0.0.40] PHP Warning: mysql_fetch_row() expects parameter 1 to be resource, boolean given in /srv/www/htdocs/vicidial/admin.php on line 21840, referer: http://dialer2.livecallconnect.com/vici ... gn_id=XXXX

This started happening after SVN update to latest.
Version: 2.8b0.5
SVN Version: 1985
DB Schema Version: 1350
DB Schema Update Date: 2013-05-28 12:41:22

[williamconley]

did you update the db?

[DruRoland]

Of course.
Specifically, I ran mysql -h sql.intern -u vicidbadmin -pXXXXXXXXXXXXXXX -force --database=asterisk < /usr/src/astguiclient/trunk/extras/upgrade_2.8.sql

[DruRoland]

I'm not sure where to go from here. That error isn't exactly very descriptive. I'm guessing the preceding SELECT statement bombs, returning 0 instead of an array?

[DruRoland]

Running the SELECT statement directly produces this:
ERROR 1054 (42S22): Unknown column 'survey_wait_sec' in 'field list'

So, I'm missing a column. upgrade_2.8.sql doesn't mention that column, but upgrade_2.6.sql does: ALTER TABLE vicidial_campaigns ADD survey_wait_sec TINYINT(3) default '10';

I ran the ALTER TABLE, and everything's working again now, though I'm very confused as to how I've been able to upgrade/restart/mess with campaigns/etc all this time.

[DomeDan]

You need to run the upgrade_2.6.sql before upgrade_2.8.sql when upgrading from 2.4
as recently mentioned here http://www.vicidial.org/VICIDIALforum/v ... 989#p99989