Cloudlog OQRS not working, and QSO save issues

[DeveloperNeon]

I recently deployed cloudlog on my webserver, and Ive been having a couple issues.

My first issue occurs with the OQRS system. When visiting https://cloudlogurl.com/index.php/oqrs, everything seems to work as normal. Once you select your station and click proceed though, it brings you to a blank page. A gif has been attached below.

My second issue is with saving QSOs. Ive tried to do this with changing the mode, band, etc, and with using the default options that get set when the page loads. Whenever I try to save a QSO after entering the person's details (usually just the callsign and RST info) and try to click save QSO, it doesnt save. A gif has been attached below.

Am I doing anything wrong? Any input would be greatly appreaciated, as I would really like to use Cloudlog to its full potential.

Thanks,
KD9NSC

[R1BLH]

Is any useful information in the logs of the web server and database server?

[DeveloperNeon]

I'll check when I get back home

[DeveloperNeon]

Sorry for the late reply, there dont seem to be any useful logs.-

[AndreasK79]

Hi, update your country files under admin.

[DeveloperNeon]

https://mylog.tld/log/index.php/oqrs/get_station_info seems to be returning a 500 error, but my webserver logs dont show anything.

[DeveloperNeon]

I have finally gotten a log. It seems to be an issue with the SQL query.

ERROR - 2023-06-11 23:18:02 --> Query error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND COL_PROP_MODE != "SAT"' at line 1 - Invalid query: SELECT distinct LOWER(`COL_BAND`) as `COL_BAND` FROM `TABLE_HRD_CONTACTS_V01` WHERE station_id in () AND COL_PROP_MODE != "SAT"
ERROR - 2023-06-11 23:18:02 --> Severity: error --> Exception: Call to a member function result() on bool /var/www/web/log/application/models/Bands.php 327

It seems like the issue is that no station id is getting passed through.

[DeveloperNeon]

I fixed the initial issue (if iI remember to, Ill make a PR), but now Im stuck at the "enter your callsign" page. The function executed when the search button is pressed just returns undefined. When I try sending a post request to the page with the nessisary details, I get a 500 error. If anyone has any ideas, feel free to send them my way.

[DeveloperNeon]

I have managed to fix all the issues, and have created a pull request with everything that I did. You can find that pull request here. (#2193)

[AndreasK79]

@DeveloperNeon thanks. It does seem like something has broken OQRS. It was not very long time ago I did test it (and it worked). I tried your PR, but the result were the same.

I will take a look and see if I can figure out where everything went wrong.

[AndreasK79]

@DeveloperNeon just to add to it here. Your fix partially works. I have a fix that I think works now. It is based on your PR. I just need @phl0 to verify.