by Milhouse28 » Thu Mar 12, 2009 7:38 am
system_settings.db_schema_version is 1110, and this is the last value in upgrade_2.0.5.sql, so db should be up to date
however, we see following error in apache error log:
PHP Warning: mysql_num_rows(): supplied argument is not a valid MySQL
result resource in /srv/www/htdocs/vicidial/admin.php on line 1836
Going to admin.php, line 1836, I see that following query is being executed:
SELECT lead_filter_id,lead_filter_name,lead_filter_sql from vicidial_lead_filters order by lead_filter_id
when I try to execute that query manually in mysql, I get error that table "vicidial_lead_filters" doesn't exists. when I check the list of tables, I don't see it either