Relation "sq_suite_product" does not exist

(Dorian Borg) #1

Hi,

 

We were doing a test upgrade from version 3.26.6 to 3.26.7;

 

In the upgrade guide:

http://matrix.squiz.net/resources/upgrading/upgrade-3.28.6-to-3.28.7

 

It is menioned that database changes are required.

 

ALTER TABLE sq_suite_product ADD COLUMN knows_me_as VARCHAR(150); ALTER TABLE sq_suite_product ADD COLUMN sync_status VARCHAR(5);
ALTER TABLE sq_suite_product ADD COLUMN last_contacted TIMESTAMP WITH TIME ZONE DEFAULT NULL;

 

When running the sql command, the following error was returned:

ERROR:  relation "sq_suite_product" does not exist

 

 

Does anyone know what might be wrong?

 

We have continued with the installation process until 3.28.9 and no error have been encounter during installation or when using the backend or novigating the website..

 

We are using postgres.

 

thank you

Dorian

 

 

 

 

 

 

(Ashish Karelia) #2

Do  you have 'squiz_suite' packages under packages directory?

If the package was not installed before then the table wouldn't exist and thus the error on the DB.

 

Ash

(Dorian Borg) #3

Hi Asish,

 

I completely missed the heading.. I cause I neeed  a break yesterday at theat time :)

 

thank you

Dorian

(Dorian Borg) #4

Do  you have 'squiz_suite' packages under packages directory?

If the package was not installed before then the table wouldn't exist and thus the error on the DB.

 

Ash

 

Hi Ash,

 

This package needs to be installed or is an optional package?

 

Could you please point me to a link or provide me with a document contain information about this package?

 

Thank you

Dorian

(Ashish Karelia) #5

Its an optional package. You can read about it here.

If you don't need it then you wouldn't also need to run the update query on the db. 

(Dorian Borg) #6

Hi Ash,

 

Thank you for the provided information.

 

Dorian

(Ashish Karelia) #7

You are welcome!