UnamWebPanel icon indicating copy to clipboard operation
UnamWebPanel copied to clipboard

database error

Open RikosDev opened this issue 1 year ago • 38 comments

so its me again iam getting this error now image it has the write perms and everything

RikosDev avatar Feb 06 '24 17:02 RikosDev

You would need to check the error log for that, you can also try the UnamWebPanel 1.8.0 BETA: UnamWebPanel 1.8.0 BETA2.zip which is technically finished, I'm just waiting to see if some testers find any bugs.

UnamSanctam avatar Feb 06 '24 17:02 UnamSanctam

just getting error cus it can't write in database even tho it has perms

ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66 ENDPOINT ERROR: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, LINE: 66

RikosDev avatar Feb 06 '24 18:02 RikosDev

Those might be old errors, but if they are new ones then the database isn't actually writable at the moment, recheck the permissions again.

UnamSanctam avatar Feb 06 '24 18:02 UnamSanctam

Those might be old errors, but if they are new ones then the database isn't actually writable at the moment, recheck the permissions again.

image its allowed

RikosDev avatar Feb 06 '24 18:02 RikosDev

And what about the db folder and unamwebpanel.db file?

UnamSanctam avatar Feb 06 '24 18:02 UnamSanctam

And what about the db folder and unamwebpanel.db file?

yes

RikosDev avatar Feb 06 '24 18:02 RikosDev

And if you remove the error log then the same error starts appearing?

UnamSanctam avatar Feb 06 '24 18:02 UnamSanctam

gotta wait sometime now

RikosDev avatar Feb 06 '24 18:02 RikosDev

error 500. I don't like the web.config code

<httpProtocol>
      <customHeaders>
        <add name="X-Robots-Tag" value="noindex, nofollow" />
      </customHeaders>
    </httpProtocol>

if you delete this piece, the panel starts. and configuration changes are not saved.

Demon4u avatar Feb 06 '24 19:02 Demon4u

Aha, you're using IIS, haven't tested it yet. That part is to tell search engines not to crawl and index the pages.

UnamSanctam avatar Feb 06 '24 19:02 UnamSanctam

In IIS, the error sounds like: the "httpprotocol" configuration section cannot be read due to a missing section declaration

Demon4u avatar Feb 06 '24 19:02 Demon4u

I think it should be in the system.webServer and not the system.web section, can you try with this?

<?xml version="1.0" encoding="UTF-8"?>
<configuration>
  <system.web>
    <globalization requestEncoding="utf-8" responseEncoding="utf-8"/>
  </system.web>
  <system.webServer>
    <httpProtocol>
      <customHeaders>
        <add name="X-Robots-Tag" value="noindex, nofollow"/>
      </customHeaders>
    </httpProtocol>
  </system.webServer>
  <location path="db">
    <system.web>
      <authorization>
        <deny users="*"/>
      </authorization>
    </system.web>
  </location>
</configuration>

UnamSanctam avatar Feb 06 '24 19:02 UnamSanctam

I think it should be in the system.webServer and not the system.web section, can you try with this?

<?xml version="1.0" encoding="UTF-8"?>
<configuration>
  <system.web>
    <globalization requestEncoding="utf-8" responseEncoding="utf-8"/>
  </system.web>
  <system.webServer>
    <httpProtocol>
      <customHeaders>
        <add name="X-Robots-Tag" value="noindex, nofollow"/>
      </customHeaders>
    </httpProtocol>
  </system.webServer>
  <location path="db">
    <system.web>
      <authorization>
        <deny users="*"/>
      </authorization>
    </system.web>
  </location>
</configuration>

Yes, it worked.

Demon4u avatar Feb 06 '24 19:02 Demon4u

Yes, it worked.

Great, thanks for reporting the problem.

UnamSanctam avatar Feb 06 '24 19:02 UnamSanctam

when changing the configuration

Because that's incorrect JSON. Something like { "test": true } should work.

UnamSanctam avatar Feb 06 '24 19:02 UnamSanctam

I wrote it wrong. she writes that it is saved, but when the page is refreshed, it is empty again

Demon4u avatar Feb 06 '24 19:02 Demon4u

I wrote it wrong. she writes that it is saved, but when the page is refreshed, it is empty again

Hmm it's working for me, do you get any errors in your console? Could be some difference due to IIS.

UnamSanctam avatar Feb 06 '24 19:02 UnamSanctam

Screenshot_1 Moreover, when adding a new configuration, it appears, but also without parameters

There are no errors in the console

Demon4u avatar Feb 06 '24 19:02 Demon4u

Are there any error logs anywhere? Like inside UNAM_LIB\Logs? I will have to set up an IIS server later and test I guess.

UnamSanctam avatar Feb 06 '24 19:02 UnamSanctam

Are there any error logs anywhere? Like inside UNAM_LIB\Logs? I will have to set up an IIS server later and test I guess.

No, there is no error in any log

Demon4u avatar Feb 06 '24 19:02 Demon4u

No, there is no error in any log

Alright, then I guess I'll have to set up an IIS server later to test when I have the time.

UnamSanctam avatar Feb 06 '24 19:02 UnamSanctam

No, there is no error in any log

Alright, then I guess I'll have to set up an IIS server later to test when I have the time.

I opened the database file and saw that all the configurations are there, and if the worker chooses a new configuration, then it works. Although the configuration options panel itself is empty

Demon4u avatar Feb 06 '24 20:02 Demon4u

I opened the database file and saw that all the configurations are there, and if the worker chooses a new configuration, then it works. Although the configuration options panel itself is empty

Hmm, I just installed IIS and set up the web panel, the configuration page is working fine for me. Are you sure that you're using the UnamWebPanel 1.8.0 BETA2 that I sent previously in this issue?

UnamSanctam avatar Feb 06 '24 21:02 UnamSanctam

Hmm, I just installed IIS and set up the web panel, the configuration page is working fine for me. Are you sure that you're using the UnamWebPanel 1.8.0 BETA2 that I sent previously in this issue?

Yes, that's what I installed

Demon4u avatar Feb 06 '24 21:02 Demon4u

I opened the database file and saw that all the configurations are there, and if the worker chooses a new configuration, then it works. Although the configuration options panel itself is empty

Hmm, I just installed IIS and set up the web panel, the configuration page is working fine for me. Are you sure that you're using the UnamWebPanel 1.8.0 BETA2 that I sent previously in this issue?

I use the one in release page

RikosDev avatar Feb 06 '24 21:02 RikosDev

Yes, that's what I installed

Then that's strange, does the same happen with this one: UnamWebPanel 1.8.0 BETA3.zip?

I use the one in release page

Yes that's fine @Demon4u is testing the Beta of the next version.

UnamSanctam avatar Feb 06 '24 21:02 UnamSanctam

Yes, that's what I installed

Then that's strange, does the same happen with this one: UnamWebPanel 1.8.0 BETA3.zip?

I use the one in release page

Yes that's fine @Demon4u is testing the Beta of the next version.

Gonna try this one tomorrow

RikosDev avatar Feb 06 '24 21:02 RikosDev

Yes, that's what I installed

Then that's strange, does the same happen with this one: UnamWebPanel 1.8.0 BETA3.zip?

I use the one in release page

Yes that's fine @Demon4u is testing the Beta of the next version.

Beta3 - everything is fine!

Demon4u avatar Feb 06 '24 22:02 Demon4u

Beta3 - everything is fine!

Alright great! Thank you for the tests and reports! I'm probably planning on releasing it today.

UnamSanctam avatar Feb 06 '24 22:02 UnamSanctam

Beta3 - everything is fine!

Alright great! Thank you for the tests and reports! I'm probably planning on releasing it today.

Hello. When will BETA3 be released and available?

Brovkines avatar Feb 08 '24 04:02 Brovkines