hi, jon, i got error sql notification when i tried to upgrade the latest version, i could not apply the patch, but there was not problem when i upgraded the csseo, below is the error message:
SQL errors:
[13-Jan-2014 00:10:55] (shop: 13-Jan-2014 03:10:55) SQL error:
Site :
https://www.personalizedgiftsmall.com
Remote IP : 66.249.66.46
Logged as :
SQL query : SELECT
if(e.allow_comments=0,0,e.comments_count) as comments_count,
c.category,e.entryid,e.categoryid,e.subject,e.body ,e.synopsis,e.date,e.expiry,e.views,e.allow_commen ts,e.login,e.status,e.authorid
FROM
wcm_cms_entries as e,
wcm_cms_categories as c
WHERE
e.categoryid=c.categoryid AND e.categoryid IN (4) AND c.status!='0' AND e.status='1' AND e.date < 1389571855 AND (e.expiry = '0' OR e.expiry > 1389571855) ORDER BY
date DESC LIMIT 0, 3
Error code : 1054
Description : Unknown column 'e.authorid' in 'field list'
Request URI: /cdseopro.php
Backtrace:
/home/iphoneca/public_html/include/func/func.db.php:320
/home/iphoneca/public_html/include/func/func.db.php:217
/home/iphoneca/public_html/include/func/func.db.php:516
/home/iphoneca/public_html/modules/xcms/xcms_func.php:0
/home/iphoneca/public_html/modules/xcms/xcms_customer_init.php:57
/home/iphoneca/public_html/auth.php:126
/home/iphoneca/public_html/cdseopro.php:11
i also submitted the support ticket last week, the ticket number is WCM #KYT-645-39534, thanks
albert