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.
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
Offline
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.
Offline
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.
Offline