I dropped table query_results

#1

Hi,
I made a stupid thing,i dropped table query_results on postgres, i created this again with the primary key and foreign keys. but i have the next problem when i try to execute a query

Error running query: failed communicating with server. Please check your Internet connection and try again.

I suppose i need to configure something else

Any idea on how to solve this?

Thank you

#2

Check the server log for what is the actual error.

Did you reset the latest_query_data_id value in queries table?

1 Like
#3

Hello, arikfr, no Actually i didn’t create the “query_results_id_seq” , i just added this with

CREATE SEQUENCE query_results_id_seq;

ALTER TABLE query_results ALTER COLUMN id SET DEFAULT nextval(‘query_results_id_seq’);

and now it works , my queries are running well ,
thank you so much