message from drupal about some fields

If you need help building your website, this is the place to hang out. If you're an HTML, PHP, Perl or web database geek, check it out. / Si vous avez besoin d'aide pour construire votre site web, c'est le forum à regarder! Si vous êtes un expert en HTML, PHP, Perl ou en base de données, c'est le forum pour vous!
Post Reply
ynohtna
The Addict / Le Drogué
Posts: 770
Joined: Mon Aug 14, 2006 5:15 pm
Location: Vancouver, BC
Contact:

message from drupal about some fields

Post by ynohtna »

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 :)
BFHL Admin/Commish
http://www.thebfhl.ca/bfhl
Now in Season 15, using BRHL Player v2.1 Ratings modified.
ynohtna
The Addict / Le Drogué
Posts: 770
Joined: Mon Aug 14, 2006 5:15 pm
Location: Vancouver, BC
Contact:

Re: message from drupal about some fields

Post by ynohtna »

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
BFHL Admin/Commish
http://www.thebfhl.ca/bfhl
Now in Season 15, using BRHL Player v2.1 Ratings modified.
ynohtna
The Addict / Le Drogué
Posts: 770
Joined: Mon Aug 14, 2006 5:15 pm
Location: Vancouver, BC
Contact:

Re: message from drupal about some fields

Post by ynohtna »

Also anyone have simple php code to query and print? :D I can replace the the values that need replacing :)
BFHL Admin/Commish
http://www.thebfhl.ca/bfhl
Now in Season 15, using BRHL Player v2.1 Ratings modified.
SimonT
STHS Owner / Propriétaire du STHS
Posts: 14758
Joined: Sat Oct 08, 2005 4:18 pm
Location: Montreal, Canada
Contact:

Re: message from drupal about some fields

Post by SimonT »

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?
-SimonT
Forum Administrator / Administrateur du Forum
STHS Owner / Propriètaire du STHS
English V2 & V3 Manual - Manuel V2 & V3 Français
ynohtna
The Addict / Le Drogué
Posts: 770
Joined: Mon Aug 14, 2006 5:15 pm
Location: Vancouver, BC
Contact:

Re: message from drupal about some fields

Post by ynohtna »

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?
BFHL Admin/Commish
http://www.thebfhl.ca/bfhl
Now in Season 15, using BRHL Player v2.1 Ratings modified.
SimonT
STHS Owner / Propriétaire du STHS
Posts: 14758
Joined: Sat Oct 08, 2005 4:18 pm
Location: Montreal, Canada
Contact:

Re: message from drupal about some fields

Post by SimonT »

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.
-SimonT
Forum Administrator / Administrateur du Forum
STHS Owner / Propriètaire du STHS
English V2 & V3 Manual - Manuel V2 & V3 Français
ynohtna
The Addict / Le Drogué
Posts: 770
Joined: Mon Aug 14, 2006 5:15 pm
Location: Vancouver, BC
Contact:

Re: message from drupal about some fields

Post by ynohtna »

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 :)
BFHL Admin/Commish
http://www.thebfhl.ca/bfhl
Now in Season 15, using BRHL Player v2.1 Ratings modified.
SimonT
STHS Owner / Propriétaire du STHS
Posts: 14758
Joined: Sat Oct 08, 2005 4:18 pm
Location: Montreal, Canada
Contact:

Re: message from drupal about some fields

Post by SimonT »

Did you try this SQL command:

Code: Select all

SELECT * FROM sqlite_master WHERE type='table' ORDER BY name;
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?
-SimonT
Forum Administrator / Administrateur du Forum
STHS Owner / Propriètaire du STHS
English V2 & V3 Manual - Manuel V2 & V3 Français
ynohtna
The Addict / Le Drogué
Posts: 770
Joined: Mon Aug 14, 2006 5:15 pm
Location: Vancouver, BC
Contact:

Re: message from drupal about some fields

Post by ynohtna »

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
BFHL Admin/Commish
http://www.thebfhl.ca/bfhl
Now in Season 15, using BRHL Player v2.1 Ratings modified.
Post Reply