Flaze Posted July 6, 2021 Posted July 6, 2021 This support request is being escalated to our root admins.
roebie Posted July 7, 2021 Author Posted July 7, 2021 Thanks! Yes, it was archived. With the server taking quite some time to get upgraded, I eventually gave up checking every day. When the upgrade was finally ready, the account was archived. Anyway, there still seems to be a problem with the postgresql database. Are there any additional steps I or you should take?
Krydos Posted July 8, 2021 Posted July 8, 2021 Postgresql on Ricky is working fine for me. Can you be any more specific what you mean by "a problem"?
roebie Posted July 9, 2021 Author Posted July 9, 2021 A web page I have that shows data from my PostgreSQL database, now only shows a bunch of errors telling me that the scheme my tables are in doesn't exist. I'll try and have a look at it in the weekend, but you know the saying: so much to do and so little time :-) Warning: pg_query(): Query failed: ERROR: 3F000: schema "strips" does not exist LINE 4: strips.stripreeksen R ^ LOCATION: get_namespace_oid, namespace.c:2839 in /home/roebie/common/simpleDBAccessorPostgreSQL.php on line 14ERROR: 3F000: schema "strips" does not exist LINE 4: strips.stripreeksen R ^ LOCATION: get_namespace_oid, namespace.c:2839Warning: pg_num_rows() expects parameter 1 to be resource, null given in /home/roebie/common/simpleDBAccessorPostgreSQL.php on line 23
Krydos Posted July 9, 2021 Posted July 9, 2021 Interesting. You're the only person who has reported this so it seems like it's specific to just your one database. Perhaps try backing up the database, dropping it, and recreating it?
roebie Posted July 14, 2021 Author Posted July 14, 2021 I have checked. My database is completely empty. There are no more tables nor views. Somewhere between the start of the update of the Ricky server and now, something must have cleared my database. Is there any way to restore it?
roebie Posted July 19, 2021 Author Posted July 19, 2021 On 7/14/2021 at 10:04 AM, roebie said: I have checked. My database is completely empty. There are no more tables nor views. Somewhere between the start of the update of the Ricky server and now, something must have cleared my database. Is there any way to restore it? Anyone? Please?
Krydos Posted July 19, 2021 Posted July 19, 2021 Sorry, we've been pretty busy because of cPanel revoking our licenses. Later today you should receive an email explaining how to download your full backup.
roebie Posted July 27, 2021 Author Posted July 27, 2021 Hi Krydos, I haven't received that email yet. Is that normal?
Krydos Posted July 27, 2021 Posted July 27, 2021 8 minutes ago, roebie said: I haven't received that email yet. Is that normal? You unsubscribed from our emails so you'll never receive an email from us again, and that includes the backup emails. Would you like me to resubscribe you?
roebie Posted July 28, 2021 Author Posted July 28, 2021 Yes please. I can't even remember that I unsubscribed from your emails. A bit weird if I think about it, as I do get (some, maybe not all?) emails from you occasionally.
Recommended Posts