Post by drochaid » Wed May 15, 2013 1:44 am

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

Newbie

Posts

Joined
Wed Jan 16, 2013 3:05 am

Post by cwswebdesign » Wed May 15, 2013 5:16 am

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

This account is inactive. Look for us under the name 'EvolveWebHosting' and contact us under that username.

Thanks!


User avatar
Active Member

Posts

Joined
Sun Dec 11, 2011 12:26 am
Location - USA

Post by drochaid » Wed May 15, 2013 5:46 am

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.

Newbie

Posts

Joined
Wed Jan 16, 2013 3:05 am

Post by rph » Wed May 15, 2013 8:15 am

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.

-Ryan


rph
Expert Member

Posts

Joined
Fri Jan 08, 2010 5:05 am
Location - Lincoln, Nebraska

Post by edgarcelso » Tue Oct 28, 2014 6:17 am

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

Newbie

Posts

Joined
Mon Dec 09, 2013 6:08 am

Post by cwswebdesign » Tue Oct 28, 2014 7:45 am

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

This account is inactive. Look for us under the name 'EvolveWebHosting' and contact us under that username.

Thanks!


User avatar
Active Member

Posts

Joined
Sun Dec 11, 2011 12:26 am
Location - USA

Post by edgarcelso » Wed Oct 29, 2014 9:38 am

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. :D

Newbie

Posts

Joined
Mon Dec 09, 2013 6:08 am
Who is online

Users browsing this forum: No registered users and 12 guests