Problem with viewing product in admin post-upgrade

I have just upgraded from v1.5.4.1 to 1.5.5.1 which appears to have gone well - apart from the page it redirected to on completion "not existing". Regardless, the admin section shows the correct version number and almost everything seems to work fine that I've tested - the front end appears to be unaffected too.

What I'm not able to do is edit a product on the admin side. I get a blank white page with no code when viewing the page source. The following error is registered in the logs consistently each time I try. References to my db blanked with [DB] and the filesystem path with [PATH] of course.

2013-05-14 18:40:27 - PHP Notice: Error: Table '[DB].gjf3s_product_filter' doesn't exist<br />Error No: 1146<br />SELECT * FROM gjf3s_product_filter WHERE product_id = '54' in [PATH]/system/database/mysql.php on line 50

I can create a new product fine, but then viewing that creates the same error. I have tried re-running the upgrade with no change. All suggestions gratefully received. I have full filesystem and db backups if necessary.

Calum

Your database is missing the table mentioned in your error code. That looks like a product filter extension you had installed on your previous site?

DL

The only extensions I have are for a Google Checkout payment module and a vqmod to keep all categories open on the front end. Both appear to be working and are current versions.

I've noticed the addition of filters since upgrading - is it possible the upgrade process didn't add the required tables to the DB?

Calum.

Your upgrade has not completed successfully for some reason so the required database changes have not been made. If I had to make a wild guess I'd say the script is timing out or you're running out of resources on the server. So I'd start by trying to run the upgrade on a local machine and seeing what happens. If you have a nice host you can alternatively ask them to temporarily increase your max_execution_time and memory_limit.

I have the same problem, when i upgrade the files what should be a successful page is a blank page

when i try to edit the product
2014-10-27 21:56:20 - PHP Notice: Error: Table 'chipink.product_filter' doesn't exist<br />Error No: 1146<br />SELECT * FROM product_filter WHERE product_id = '1796' in /var/www/vhosts/chipink.pt/httpdocs/system/database/mysql.php on line 50

when i try to go to filter
2014-10-27 22:09:27 - PHP Notice: Error: Table 'chipink.filter_group' doesn't exist<br />Error No: 1146<br />SELECT COUNT(*) AS total FROM `filter_group` in /var/www/vhosts/chipink.pt/httpdocs/system/database/mysql.php on line 50

when i try to go to edit client
2014-10-27 22:10:43 - PHP Notice: Error: Table 'chipink.customer_ban_ip' doesn't exist<br />Error No: 1146<br />SELECT COUNT(*) AS total FROM `customer_ban_ip` WHERE `ip` = '85.138.112.232' in /var/www/vhosts/chipink.pt/httpdocs/system/database/mysql.php on line 50

when i buy a product
2014-10-27 22:11:52 - PHP Notice: Undefined index: currency in /var/www/vhosts/chipink.pt/httpdocs/catalog/controller/payment/multibanco.php on line 40
2014-10-27 22:11:52 - PHP Notice: Undefined index: value in /var/www/vhosts/chipink.pt/httpdocs/catalog/controller/payment/multibanco.php on line 40
2014-10-27 22:11:52 - PHP Notice: Undefined index: currency in /var/www/vhosts/chipink.pt/httpdocs/catalog/controller/payment/multibanco.php on line 41
2014-10-27 22:11:52 - PHP Notice: Undefined index: value in /var/www/vhosts/chipink.pt/httpdocs/catalog/controller/payment/multibanco.php on line 41
2014-10-27 22:11:52 - PHP Notice: Error: Table 'chipink.customer_ban_ip' doesn't exist<br />Error No: 1146<br />SELECT * FROM `customer_ban_ip` WHERE ip = '188.37.151.105' in /var/www/vhosts/chipink.pt/httpdocs/system/database/mysql.php on line 50

when i buy a product with bank transfer
2014-10-27 22:14:54 - PHP Notice: Error: Table 'chipink.customer_ban_ip' doesn't exist<br />Error No: 1146<br />SELECT * FROM `customer_ban_ip` WHERE ip = '188.37.151.105' in /var/www/vhosts/chipink.pt/httpdocs/system/database/mysql.php on line 50


can someone please help me?
the upgrade is from 1.5.3.1 to 1.5.6

edgarcelso wrote:I have the same problem, when i upgrade the files what should be a successful page is a blank page

when i try to edit the product
2014-10-27 21:56:20 - PHP Notice: Error: Table 'chipink.product_filter' doesn't exist<br />Error No: 1146<br />SELECT * FROM product_filter WHERE product_id = '1796' in /var/www/vhosts/chipink.pt/httpdocs/system/database/mysql.php on line 50

when i try to go to filter
2014-10-27 22:09:27 - PHP Notice: Error: Table 'chipink.filter_group' doesn't exist<br />Error No: 1146<br />SELECT COUNT(*) AS total FROM `filter_group` in /var/www/vhosts/chipink.pt/httpdocs/system/database/mysql.php on line 50

when i try to go to edit client
2014-10-27 22:10:43 - PHP Notice: Error: Table 'chipink.customer_ban_ip' doesn't exist<br />Error No: 1146<br />SELECT COUNT(*) AS total FROM `customer_ban_ip` WHERE `ip` = '85.138.112.232' in /var/www/vhosts/chipink.pt/httpdocs/system/database/mysql.php on line 50

when i buy a product
2014-10-27 22:11:52 - PHP Notice: Undefined index: currency in /var/www/vhosts/chipink.pt/httpdocs/catalog/controller/payment/multibanco.php on line 40
2014-10-27 22:11:52 - PHP Notice: Undefined index: value in /var/www/vhosts/chipink.pt/httpdocs/catalog/controller/payment/multibanco.php on line 40
2014-10-27 22:11:52 - PHP Notice: Undefined index: currency in /var/www/vhosts/chipink.pt/httpdocs/catalog/controller/payment/multibanco.php on line 41
2014-10-27 22:11:52 - PHP Notice: Undefined index: value in /var/www/vhosts/chipink.pt/httpdocs/catalog/controller/payment/multibanco.php on line 41
2014-10-27 22:11:52 - PHP Notice: Error: Table 'chipink.customer_ban_ip' doesn't exist<br />Error No: 1146<br />SELECT * FROM `customer_ban_ip` WHERE ip = '188.37.151.105' in /var/www/vhosts/chipink.pt/httpdocs/system/database/mysql.php on line 50

when i buy a product with bank transfer
2014-10-27 22:14:54 - PHP Notice: Error: Table 'chipink.customer_ban_ip' doesn't exist<br />Error No: 1146<br />SELECT * FROM `customer_ban_ip` WHERE ip = '188.37.151.105' in /var/www/vhosts/chipink.pt/httpdocs/system/database/mysql.php on line 50


can someone please help me?
the upgrade is from 1.5.3.1 to 1.5.6

Look into the post above you from RPH and then look in phpMyAdmin to see if these tables are actually there still.

DL

cwswebdesign,

thank you for remenber me the tables, i went to phpMyAdmin and i made the tables that were missing, it was more than 10

right now it's working good.