Post by JosepManel » Wed Jul 26, 2017 1:47 am

Hi,

Updading the opencart version from 1.5.4 to 3.0.2 the following error message is shown:

Error Code(0): Error: Unknown table 'boomlapop_com.blpshopaffiliate_activity'
Error No: 1051
DROP TABLE `blpshopaffiliate_activity` in C:\xampp\htdocs\shop\system\library\db\mysqli.php on line 40


Despite that error the installation is finishing succesfully bu I am no sure if everything is correct in the new installation. According to the message I assume that the fact that one expected table that has to be dropped (affiliate_activity) and is not found is not a problem for the installation but I need to be sure.

Thanks in advance for any help.

Newbie

Posts

Joined
Fri Jul 21, 2017 1:34 am

Post by pm-netti » Sun Aug 20, 2017 2:19 am

JosepManel wrote:
Wed Jul 26, 2017 1:47 am
Hi,

Updading the opencart version from 1.5.4 to 3.0.2 the following error message is shown:

Error Code(0): Error: Unknown table 'boomlapop_com.blpshopaffiliate_activity'
Error No: 1051
DROP TABLE `blpshopaffiliate_activity` in C:\xampp\htdocs\shop\system\library\db\mysqli.php on line 40


Despite that error the installation is finishing succesfully bu I am no sure if everything is correct in the new installation. According to the message I assume that the fact that one expected table that has to be dropped (affiliate_activity) and is not found is not a problem for the installation but I need to be sure.

Thanks in advance for any help.
File install/model/upgrade/1009.php lines 57-59:

Code: Select all

                       if (!$affiliate_query->num_rows) {
				$this->db->query("DROP TABLE `" . DB_PREFIX . "affiliate_activity`");
			}
			
change to:

Code: Select all

                       if ($affiliate_query->num_rows) {
				$this->db->query("DROP TABLE `" . DB_PREFIX . "affiliate_activity`");
			}
			
and lines 63-65;

Code: Select all

			if (!$affiliate_query->num_rows) {			
				$this->db->query("DROP TABLE `" . DB_PREFIX . "affiliate_login`");
			}
			
change to:

Code: Select all

			if ($affiliate_query->num_rows) {			
				$this->db->query("DROP TABLE `" . DB_PREFIX . "affiliate_login`");
			}
			

User avatar
Active Member

Posts

Joined
Sat Apr 07, 2012 11:22 pm
Location - Kittilä, Finland
Who is online

Users browsing this forum: No registered users and 91 guests