Kryptronic Software Support Forum
You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.
#1 06-20-2019 12:33:43
- stanforrest
- Member
- From: California
- Registered: 02-13-2003
- Posts: 73
SQL error with update to 9.0.3 from 9.0.2
I got the following error in the post raw database updates
A problem was encountered while executing the SQL statement submitted. The error was reported as: The MySQL extension encountered a problem submitting an SQL statement. MySQL reported the error as: Unknown column 'googlebase_color' in 'field list'. The following SQL statement was submitted: UPDATE ecom_prod SET googlebase_color=REPLACE(googlebase_color, ', ', ' / '), googlebase_size=REPLACE(googlebase_size, ', ', ' / '), xcatparent=''
Please advise
Stan Forrest
Digital Magic Show
Offline
#2 06-20-2019 13:01:45
- stanforrest
- Member
- From: California
- Registered: 02-13-2003
- Posts: 73
Re: SQL error with update to 9.0.3 from 9.0.2
Hopefully this worked.
I went into PHP myAdMIn and added two colums to the ecom_prod table
googlebase_color
googlebase_size
Then ran the mySQL statement in the RAW Database Admin and the SQL statement ran successfully.
Stan Forrest
Digital Magic Show
Offline
#3 06-21-2019 07:16:18
Re: SQL error with update to 9.0.3 from 9.0.2
That statement will fail if you don't have the Google Shopping Feed extension module installed. It's not a problem. Also, you adding those columns is not a problem, but they'll be unused so you could remove them if you like.
Nick Hendler
Offline