STHS Forum

So I seemed to have been able to connect my sths.db to my drupal site because one of my modules can seem to see the tables and attributes. I'm just playing a bit to see what I could potentially do.

Using the Views module, I can have a GUI to build my select. It seems to work ok when picking number type of fields ProPlayerStat: Number and I get get lists of numbers, but when I choose a name like ProPlayerStat: Name

I get a message like:

Name
The handler for this item is broken or missing and cannot be used. If a module provided the handler and was disabled, re-enabling the module may restore it. Otherwise, you should probably delete this item.

I'm just wondering, is this a sths db problem or problem with me in my usage of the tools in drupal?

Thanks

If it means anything, the drupal module is saying a sqlite_master table is required. Is there such thing? Sorry if I'm asking the wrong type of questions

Also anyone have simple php code to query and print? I can replace the the values that need replacing

Hi.

I'm not sure to understand your last question versus the information you said from Drupal? I never play with Drupal so I don't about it really. Can you show me something?

Hi SImon

I made a little doc showing you what I see on my end. http://1drv.ms/1N6H5MQ

for the sqlite_master table post, I only asked that because it was referenced as a required thing for all the sqlite features to work

Does the document help you understand what I'm talking about?

Hi.
For the SQLite_Master table, I’ll check how can I do but it look weird because the FAW of SQLite said “Every SQLite database has an SQLITE_MASTER table that defines the schema for the database.” (Source : https://www.sqlite.org/faq.html)
By showing, I was more curious about the website it can create.

Ya I saw that FAQ too and was wondering if it was perhaps missing or something in your STHS.db.

Is there anything else you'd like to see from me?

Do you have a small php snippet I can try to use? I can paste PHP code in drupal so in theory, the data should show up in the spot I paste it

Did you try this SQL command:
When I'm using SQLite Studio, it works fine. I try creating the database manually but I was told it was protected table.

I think it's hidden table?

I don't know cause I don't have anything set up yet to query sqlite db...

Maybe I'll show the DB to the developers and see if they can give more insight