I was using Linux a few years ago, but I had so many projects to support and everyone was using windows, I finally had to go back.
Ok -- I blew away helpDesk.db and recreated it. I used SQLite not ionSQL.. I still have too many problems with ionSQL. Actually ionSQL was an exercise to see how interactive I could make RB. I learned a lot, and after seeing all the possible problems, I really should write it again knowing what I know now.
In SQLite (NOT ionSQL) * I exported the heplDesk.db into a helpDesk.sql dump * I created a new helpDesk.db. * I opened it, and since it has no tables it shows only the db. But in the official SQLite docs you really can'd do much until you have a table. So I created a table called xxx * clicked the [query] button, and it opened a place to do queries. I pasted the helpDesk.sql dumped file into the query window and executed it. It created all the tables with data. * I dropped the xxx table.
No problem.. I want to know what's going on as well.
First: when you load the helpDesk DB with ionSQL or SQLite can you see the tables. Can you browse the xlate table?
The first thing the program helpDesk.bas does is open the database and read the xlate file. Since I'm not using Linux, I keep thinking there is something wrong in the program where I set up the path to the DB. If you look around line 20, I text Platform$ to see if it windows (if left Platform$,3 = "win") and set up the path for windows or not windows. Maybe you can load the program helpDesk.bas into RunBasic and put a couple lines after the path assignment around line 38 to see where it's assigned. print helpDeskDb$ ' should point to the database input xxx ' to stop the code I don't know if DefaultDir$ in linux has the slash "/" after it. If it does then I need to change the helpDeskDb$ assignment.
You might want to download the latest SQLite dll. Maybe there are some differences there.
If that all looks good; Can you open the helpDesk db with ionSQL or SQLite. If so can you see the tables? If you see the tables can you browse the xlate table? If that all works then load the database used by ionSQL or SQLite to keep track of the tables you used. Browse the table that holds all the databases. That table should have the location of your databases. See if the location looks like the location used with the helpDesk System.
Duh! Ok.. Is it starting to work? Only thing I don't understand is why is mine working. I'm using win/7 so I guess there is a difference in win/10. I'll have to check all my stuff and I bet I have the same error all over the place.
If you use it, the first thing you might want to do is change the xlate table where the fieldName = 'siteHdr'. That titles it for you. You may want to call it 'Customer Support' or something.
Let me know if you have other problems. Looks like more will pop up with win/10.