Database Creation

[hfnhl]

Hi All

I seem to be having trouble getting my sim to create the initial database of my league as we transition to the dynamic web pages. I've followed the instructions in the manual (and double checked it and the settings in the sim)

It keeps giving me the following error.



This error occurs on output.

unable to open database file - System.Data.SQLite

I have the dll file in the same folder as the sim program, and in the output directory and anywhere else I could think of.

It won't give me an initial database to upload.

Do I need to create a database on the server side first? What do I call it? there just doesn't seem to be any information in the FAQ or on the forums.

Help please

Matthew

[SimonT]

You don't need to create database on server side or anything.

What version of Windows do you have? Did you try to create the SQLite database on another Windows computer?

[hfnhl]

I'm running Windows 11 inside parallels on a Mac.

I haven't tried to create it on another computer as I don't have access to one at the moment.

M

[hfnhl]

I fixed part of the problem by altering the path - I no longer get any errors on output but I still don't see a database.

[SimonT]

What file do you see in your output folder?

[hfnhl]

I managed to work it out - it had to do with the parallels sharing of the Mac folders. The sim would not output the database to a shared folder. However, once I changed the output location to a native Windows folder, it output the database and the full set of php files.

[hfnhl]

What file do you see in your output folder?

I see the HFNHL-STHS.bin (db file)

I am still having some trouble, maybe my php isn't up to date?

http://hfnhl.org/2024/dynamic/phpinfo.php

EDIT: Yes, I'm on 7.4 updating on the server side to 8 per the manual

[SimonT]

Exactly. Update to 8 and try again.

[hfnhl]

Exactly. Update to 8 and try again.

Yup, this was it. Working now thank you.