|
Post by meerkat on Apr 10, 2018 9:42:46 GMT -5
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.
So it has a new db, and I'm able to use it.
Do you still have the problem with the DB??
Dan
|
|
metro
Full Member
Posts: 180
|
Post by metro on Apr 10, 2018 12:58:44 GMT -5
It's 2am here I'll check it out tomorrow Thanks for taking a look at it
EDIT:
system starts fine now Dan do you get an error when clicking on either of these buttons Ticket Ticket Log Customer Translate tables (xlate)
I'm getting
sorry to be a pain
Laurie
PS I have downloaded the new helpDesk.zip and still get the missing table error, but it does exist when I use DB Browser
|
|
|
Post by meerkat on Apr 11, 2018 5:46:26 GMT -5
g'day Laurie!
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.
Thanks for the help.. Dan
|
|
metro
Full Member
Posts: 180
|
Post by metro on Apr 11, 2018 7:01:32 GMT -5
Back again I have a windows version of runbasic and Linux too So print helpDeskDb$ gives.....
Linux path = /home/laurie/rb101/projects/helpDesk_project/data/helpDesk.db
on Win10 Laptop path = C:\rbp101\projects\helpDesk_project\data\helpDesk.db
I can't see anything wrong there.
I'll keep looking, it doesn't make sense.
|
|
|
Post by meerkat on Apr 11, 2018 7:12:19 GMT -5
Doesn't make sense to me either.
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.
Got to be a answer somewhare?? I hope!
|
|
metro
Full Member
Posts: 180
|
Post by metro on Apr 11, 2018 7:22:44 GMT -5
Ok getting somewhere fixed in ticket.bas
projectDir$ = "helpDesk_project" if left$(Platform$,3) = "win" then helpDeskDb$ = DefaultDir$ + "\projects\helpDesk_project\data\helpDesk.db" incdir$ = DefaultDir$ + "\projects\" + projectDir$ + "\" else helpDeskDb$ = DefaultDir$ + "/projects/helpDesk_project\data\helpDesk.db" incdir$ = DefaultDir$ + "/projects/" + projectDir$ + "/" end if
should read
projectDir$ = "helpDesk_project" if left$(Platform$,3) = "win" then helpDeskDb$ = DefaultDir$ + "\projects\helpDesk_project\data\helpDesk.db" incdir$ = DefaultDir$ + "\projects\" + projectDir$ + "\" else helpDeskDb$ = DefaultDir$ + "/projects/helpDesk_project/data/helpDesk.db" incdir$ = DefaultDir$ + "/projects/" + projectDir$ + "/" end if
same solution for ticketLog.bas and cust.bas
easy when you actually look
|
|
|
Post by meerkat on Apr 11, 2018 7:28:54 GMT -5
OK! I must be getting blind in my old age. I don't see any difference? What changed?
|
|
metro
Full Member
Posts: 180
|
Post by metro on Apr 11, 2018 7:31:12 GMT -5
you had helpDeskDb$ = DefaultDir$ + "/projects/helpDesk_project\data\helpDesk.db"
should be
forward slash /data/helpdesk.db
think I'll have a coopers pale Ale with cascade hops (home brew on tap) I've just earned it
|
|
|
Post by meerkat on Apr 11, 2018 7:39:01 GMT -5
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.
Thanks for the help.. Now I owe you a brew.
Dan
|
|
metro
Full Member
Posts: 180
|
Post by metro on Apr 11, 2018 7:42:43 GMT -5
Win10 seems to be fine Dan, it did have a problem with the old DB but as far as using Ticket Ticket Log Customer Translate tables (xlate) I'M guilty of not testing completly
|
|