Database Missing?
venom-at - August 21, 2007 - 11:26
| Project: | Fixed Data Dropdown |
| Version: | 5.x-1.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Jump to:
Description
When I want to create content with the module i geht this error:
user warning: Table 'drupal.fdd_field_blub_data' doesn't exist query: SELECT fdd_value FROM fdd_field_blub_data WHERE fdd_key ="baa"; in C:\xampp\htdocs\drupal\includes\database.mysql.inc on line 172.
user warning: Table 'drupal.fdd_field_blub_data' doesn't exist query: SELECT fdd_value FROM fdd_field_blub_data WHERE instr(fdd_key, "baa") LIMIT 10; in C:\xampp\htdocs\drupal\includes\database.mysql.inc on line 172. The Database-Tables are missing, i can't find any solutions, i need the code to create them self.
#1
Have you created the database on the content type setup page?
Cheers
Mark.
#2
I have createt a new Content Type and in this Content Type is have createt a field with this Module and now when i want to create a content in this field i become the error from above.
#3
When you created the content type, you needed to upload a file, and have it process that file with a regular expression, in order to create the database....
Did you do that bit?
hopefully you have a nice big file with lots of lines of data, like
f00, red
0f0, green
00f, blue
(Only in your case, I'd hope the file is a few k large, otherwise, simply using the taxonomy mechanism might be more appropriate)
When you create the type, then you need to specify (upload) this file, and you need to adjust the regular expression such that the fields are correctly extracted...
#4
i thought this module works with mysql database ifi don't upload a file ?
#5
If you dont want to use the upload mechanism, then you will have to create the mysql database entries yourself.... (And be careful not to over-write them in the form!)
(If you want to do it yourself, then the name of the database table you need to create is given to you in your error message :-) )
#6
Now i have created the databse, no wi can insert data into it.
Problem no wis the Dropdown, i don't see the data which i have inserted in the database.
#7
So, I'm guessing you've got your database with key's and values...
so, now, in principle you should have a text field, into which when you type a key it "auto-completes" - and when it finishes autocompleting, you SHOULD get the values that are associated with that key in the dropdown....
The autocomplete section is the first thing to check. You can try manually running the autocomplete (I can't remeber exactly - I think it's /fixedDataDropdown/autocompleteKeys//
As in the fieldname and string you want to match on. If that returns nothing, then maybe the problem is with your database set up... It's expecting there to be two columns, fdd_key and fdd_value.
One idea might be to "prime" your database with a small amount of data from a file, using the normal interface, and then you could see how the db looks, and insert the rest of your data manually....