Quote:
Originally Posted by yowstar
I am getting the following SQL error after applying the most recent update for popup anywhere version 4.5.5
SQL query : SELECT * FROM xcart_popups, xcart_popups_settings WHERE xcart_popups.popup_id = xcart_popups_settings.popup_id AND 1 AND type <> 'minicart_bar' AND whom_to_show IN ('A', 'N') AND is_enabled = 'Y' AND ((xcart_popups.start_date <= 1373042373 AND xcart_popups.end_date >= 1373042373) OR (xcart_popups_settings.when_to_show = 'C')) ORDER BY xcart_popups.position
Error code : 1054
Description : Unknown column 'xcart_popups.start_date' in 'where clause'
Request URI: /error_message.php
Backtrace:
/include/func/func.db.php:309
l/include/func/func.db.php:209
/include/func/func.db.php:489
/modules/Popup_Anywhere/func.php:302
/modules/Popup_Anywhere/func.php:493
/include/common.php:117
/error_message.php:48
|
This SQL error means that there are no two new fields in 'xcart_popups' table.
It would be great if you can have a look at 'xcart_popups' table via PhpMyAdmin or mysql console. You need to check if 'start_date' and 'end_date' are presented in it.
If columns are in table then it is required to clear the cache: in admin area via 'Tools -> Maintance -> Clear templates/X-Cart cache' or by removing content from '<xcart_dir>/var/cache' directory.
If columns are not in the table then it is required to apply 'sql/popup_anywhere_patch_upgrade_v10_v110.sql' patch from unpacked module distributive is applied via Admin -> Patch/Upgrade Center, 'Apply SQL-patch' section and then clear the cache.
If you cannot check 'xcart_popups' columns please firstly try to clear the cache. Usually it's the main reason of such issues.
Please do not apply 'sql/popup_anywhere_patch_upgrade_v10_v110.sql' once again if you've already applied it to the store.