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

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19255
Website

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

 

Board footer