Jump to content
[MUST READ] Forum Rules ×

Regular Suspension events


Recommended Posts

Hello I am new here . I am still not being informed what is causing this and you are regularly suspending this site with a very verbose statement " You account is suspended because it reached the daily cpu/hits limit. It will be reactivated automatically after 24 hours of suspension  " This is not very informative and I would like to resolve this. Your sales team says this is working great and looks good but it is not operational yet one of the reasons is because of this issue. There is nothing on screen that accounts for this and when I run the site with the website open I see little more than 3% use on CPU. Can you explain what is causing this?

 
I note: 
Tue, Feb 6, 2024 at 8:15 PM - Suspended (24hrs)
Fri, Mar 1, 2024 at 2:17 PM Suspended (24hrs)
Sun, Mar 10, 2024 at 5:18 PM Suspended (24hrs)
Mar 25, 2024 at 4:20 PM Suspended (24hrs)
Mon, Apr 1, 2024 at 1:20 AM Suspended (24hrs)
5 days suspended in the range Feb 6th to 1st April 3 months.

As you can see from your email log I have repeatedly asked why this is occurring and am getting no reasonable answer so that this can be solved. Is there not some information you can provide ?
f91779aa1e8224739f75c255bb93a99a.png
Link to comment
Share on other sites

Posted (edited)

Could this be the reason  for Suspension event . I am trying to add and update  data to SQL could this be the reason I have to my only database it acually does not perform the update  idk.

PHP

$base64artwork = base64_encode($artwork);
try {
               $sql =  "INSERT INTO `played_songs` (`song`, `artist`, `album`, `length`, `bpm`,`genre`, `listeners`,`track_user_rating`,`track_user_num`,`comment`,`ImageBase64`,`lyrics`,`year`) VALUES ('$title','$artist', '$album', '$length', '$bpm',
'$genre','$listeners','0','0', '$comment','$base64artwork','','$year') ON DUPLICATE KEY UPDATE  `listeners`='$listeners'";

               $result= OpenPDO($conn,$sql,$_execute,"");
               
} 
try {
                $sql ="UPDATE `played_songs` SET `lyrics` = '$lyrics' WHERE datetime = (select max(datetime) FROM `played_songs`)";
                $result= OpenPDO($conn,$sql,$_execute,"");
             } catch(Exception $e) {
                //$result->rollBack();
                ReturnError($code, "An Error occurd updating record in SQL");
            }
}

But this doesn't seem to update  the last created record and the record string is to long to add it to the first/. I get 3% CPU use when its running so cannot understand why it falls over

 

I would point out this UPDATE `played_songs` SET `lyrics` = '$lyrics' WHERE datetime = (select max(datetime) FROM `played_songs`) works in the PHP Admin test so why not from PHP. I dont understand why it fails. Is there tech support here?

Edited by Denise Rose
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...