Jump to content
[MUST READ] Forum Rules ×

Denise Rose

Members
  • Posts

    2
  • Joined

  • Last visited

Denise Rose's Achievements

  1. 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?
  2. 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 ?
×
×
  • Create New...