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
Database Creation
-
- STHS Owner / Propriétaire du STHS
- Posts: 14785
- Joined: Sat Oct 08, 2005 4:18 pm
- Location: Montreal, Canada
- Contact:
Re: Database Creation
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?
What version of Windows do you have? Did you try to create the SQLite database on another Windows computer?
-SimonT
Forum Administrator / Administrateur du Forum
STHS Owner / Propriètaire du STHS
English V2 & V3 Manual - Manuel V2 & V3 Français
Forum Administrator / Administrateur du Forum
STHS Owner / Propriètaire du STHS
English V2 & V3 Manual - Manuel V2 & V3 Français
Re: Database Creation
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
I haven't tried to create it on another computer as I don't have access to one at the moment.
M
Re: Database Creation
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.
-
- STHS Owner / Propriétaire du STHS
- Posts: 14785
- Joined: Sat Oct 08, 2005 4:18 pm
- Location: Montreal, Canada
- Contact:
Re: Database Creation
What file do you see in your output folder?
-SimonT
Forum Administrator / Administrateur du Forum
STHS Owner / Propriètaire du STHS
English V2 & V3 Manual - Manuel V2 & V3 Français
Forum Administrator / Administrateur du Forum
STHS Owner / Propriètaire du STHS
English V2 & V3 Manual - Manuel V2 & V3 Français
Re: Database Creation
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.
Re: Database Creation
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
-
- STHS Owner / Propriétaire du STHS
- Posts: 14785
- Joined: Sat Oct 08, 2005 4:18 pm
- Location: Montreal, Canada
- Contact:
Re: Database Creation
Exactly. Update to 8 and try again.
-SimonT
Forum Administrator / Administrateur du Forum
STHS Owner / Propriètaire du STHS
English V2 & V3 Manual - Manuel V2 & V3 Français
Forum Administrator / Administrateur du Forum
STHS Owner / Propriètaire du STHS
English V2 & V3 Manual - Manuel V2 & V3 Français