To post a new support question, click the Post New Topic button below.
Current Version: 4.9.1 | Sytist Manual | Common  Issues | Feature Requests

Please log in or Create an account to post or reply to topics.
You will still receive notifications of replies to topics you are part of even if you do not subscribe to new topic emails.

Can't Access Database

P
142 posts
Tue May 30, 23 3:36 AM CST

Since yesterday I can't access the database I get this error: Service Unavailable

The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later.

The actual website works apart from the systist login page

I recently changed to the latest version and updated to php 8.1 but it was working for a few days after those changes and received a couple of orders.

I checked with my webs support and they can't see anything unusual

P
142 posts
Tue May 30, 23 3:57 AM CST

I think I found out the problem. I managed to get to the "orders" page using another browser and I noticed it is deleting old galleries/photos. I thought once you close the browser window it stopped but it seems stuck in that mode at present. I shut down my computer, cleared the browser cache but still I have the same problem. I tried clicking the "pause" button but the page doesn't load so it doesn't pause it.

16,216 posts (admin)
Tue May 30, 23 6:30 AM CST

It will stop when the browser is shut down once the current process completes. 

You can try to use the PHPMyAdmin in your hosting control panel, select your Sytist database, click the SQL tab, copy and paste the following line and click run to pause the delete queue:


UDPATE ms_history SET deletequeue_off='1'; 

Tim Grissett, DIA - PicturesPro.com
My Email Address: info@picturespro.com
P
142 posts
Tue May 30, 23 6:53 AM CST

Thanks Tim I will try that

P
142 posts
Tue Jun 13, 23 2:59 PM CST

Hi Tim, I tried that but I get this error:


Error

Static analysis:

2 errors were found during analysis.

  1. Unexpected beginning of statement. (near "UDPATE" at position 0)
  2. Unexpected beginning of statement. (near "ms_history" at position 7)

SQL query:  Copy

UDPATE ms_history SET deletequeue_off='1';

MySQL said: Documentation

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UDPATE ms_history SET deletequeue_off='1'' at line 1

16,216 posts (admin)
Wed Jun 14, 23 4:14 AM CST

Sorry, there was  a typo This is correct: 

UPDATE ms_history SET deletequeue_off='1';

Tim Grissett, DIA - PicturesPro.com
My Email Address: info@picturespro.com
6 total messages
Please log in or Create an account to post or reply to topics.
This post has been viewed 259 times
Category: Error
 
Loading more pages
Loading more pages

Sign up for email promotions.

Your information is safe with us and won't be shared.

Thank you for signing up!

 
©2003 - 2021 Grissett, LLC. All Rights Reserved.

By continuing to browse or by clicking Accept Cookies, you agree to the storing of cookies on your device necessary to provide you with the services available through our website.

    Accept   Privacy & Cookie Policy
Loading More Photos
Scroll To Top
Close Window
Loading
Close