*I keep getting the error below every time I edit a certain content type. I have tried Uninstalling / reinstalling the taxonomy image module but it's not fixing the issue. The * field_data_taxonomy_image tabel does not exist in the database. .
*PDOException*: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'field_data_taxonomy_image' doesn't exist: SELECT DISTINCT field_data_taxonomy_image0.entity_type AS entity_type, field_data_taxonomy_image0.entity_id AS entity_id, field_data_taxonomy_image0.revision_id AS revision_id, field_data_taxonomy_image0.bundle AS bundle FROM {field_data_taxonomy_image} field_data_taxonomy_image0 WHERE (field_data_taxonomy_image0.taxonomy_image_fid = :db_condition_placeholder_0) AND (field_data_taxonomy_image0.deleted = :db_condition_placeholder_1) ; Array ( [:db_condition_placeholder_0] => 256 [:db_condition_placeholder_1] => 0 ) in *field_sql_storage_field_storage_query()* (line *585* of *modules/field/modules/field_sql_storage/field_sql_storage.module*).
Have you tried running update.php? On 29 Jul 2014 11:25, "Mutuku Ndeti" jnmutuku@gmail.com wrote:
*I keep getting the error below every time I edit a certain content type. I have tried Uninstalling / reinstalling the taxonomy image module but it's not fixing the issue. The * field_data_taxonomy_image tabel does not exist in the database. .
*PDOException*: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'field_data_taxonomy_image' doesn't exist: SELECT DISTINCT field_data_taxonomy_image0.entity_type AS entity_type, field_data_taxonomy_image0.entity_id AS entity_id, field_data_taxonomy_image0.revision_id AS revision_id, field_data_taxonomy_image0.bundle AS bundle FROM {field_data_taxonomy_image} field_data_taxonomy_image0 WHERE (field_data_taxonomy_image0.taxonomy_image_fid = :db_condition_placeholder_0) AND (field_data_taxonomy_image0.deleted = :db_condition_placeholder_1) ; Array ( [:db_condition_placeholder_0] => 256 [:db_condition_placeholder_1] => 0 ) in *field_sql_storage_field_storage_query()* (line *585* of *modules/field/modules/field_sql_storage/field_sql_storage.module*).
-- How can I fix this?
thanks
-- [ Drupal support list | http://lists.drupal.org/ ]
You might want to try running the "update.php" file from [your/drupal/path]/update.php. Do this after clearing the cache memory from the admin dashboard.
Give it a shot!
On 29/07/2014, Mutuku Ndeti jnmutuku@gmail.com wrote:
*I keep getting the error below every time I edit a certain content type. I have tried Uninstalling / reinstalling the taxonomy image module but it's not fixing the issue. The * field_data_taxonomy_image tabel does not exist in the database. .
*PDOException*: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'field_data_taxonomy_image' doesn't exist: SELECT DISTINCT field_data_taxonomy_image0.entity_type AS entity_type, field_data_taxonomy_image0.entity_id AS entity_id, field_data_taxonomy_image0.revision_id AS revision_id, field_data_taxonomy_image0.bundle AS bundle FROM {field_data_taxonomy_image} field_data_taxonomy_image0 WHERE (field_data_taxonomy_image0.taxonomy_image_fid = :db_condition_placeholder_0) AND (field_data_taxonomy_image0.deleted = :db_condition_placeholder_1) ; Array ( [:db_condition_placeholder_0] => 256 [:db_condition_placeholder_1] => 0 ) in *field_sql_storage_field_storage_query()* (line *585* of *modules/field/modules/field_sql_storage/field_sql_storage.module*).
-- How can I fix this?
thanks
I ran update.php, cleared cache , run cron but still get the error.
On Tue, Jul 29, 2014 at 2:22 PM, Maina webmail.maina@gmail.com wrote:
You might want to try running the "update.php" file from [your/drupal/path]/update.php. Do this after clearing the cache memory from the admin dashboard.
Give it a shot!
On 29/07/2014, Mutuku Ndeti jnmutuku@gmail.com wrote:
*I keep getting the error below every time I edit a certain content
type. I
have tried Uninstalling / reinstalling the taxonomy image module but it's not fixing the issue. The * field_data_taxonomy_image tabel does not exist in the database. .
*PDOException*: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'field_data_taxonomy_image' doesn't exist: SELECT DISTINCT field_data_taxonomy_image0.entity_type AS entity_type, field_data_taxonomy_image0.entity_id AS entity_id, field_data_taxonomy_image0.revision_id AS revision_id, field_data_taxonomy_image0.bundle AS bundle FROM {field_data_taxonomy_image} field_data_taxonomy_image0 WHERE (field_data_taxonomy_image0.taxonomy_image_fid = :db_condition_placeholder_0) AND (field_data_taxonomy_image0.deleted = :db_condition_placeholder_1) ; Array ( [:db_condition_placeholder_0] =>
256
[:db_condition_placeholder_1] => 0 ) in *field_sql_storage_field_storage_query()* (line *585* of *modules/field/modules/field_sql_storage/field_sql_storage.module*).
-- How can I fix this?
thanks
-- http://www.mosesmaina.com -- [ Drupal support list | http://lists.drupal.org/ ]
This is what I would do: uninstall the module, make sure that its files are deleted from the directory listing, clear cache and run update.php again.
If this doesn't work I would go ahead and export the SQL dump of the database and set up a clone of my Drupal instance and see if the problem persists. Again, this are just things I would try given a situation like yours.
Maina
On 29/07/2014, Mutuku Ndeti jnmutuku@gmail.com wrote:
I ran update.php, cleared cache , run cron but still get the error.
On Tue, Jul 29, 2014 at 2:22 PM, Maina webmail.maina@gmail.com wrote:
You might want to try running the "update.php" file from [your/drupal/path]/update.php. Do this after clearing the cache memory from the admin dashboard.
Give it a shot!
On 29/07/2014, Mutuku Ndeti jnmutuku@gmail.com wrote:
*I keep getting the error below every time I edit a certain content
type. I
have tried Uninstalling / reinstalling the taxonomy image module but it's not fixing the issue. The * field_data_taxonomy_image tabel does not exist in the database. .
*PDOException*: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'field_data_taxonomy_image' doesn't exist: SELECT DISTINCT field_data_taxonomy_image0.entity_type AS entity_type, field_data_taxonomy_image0.entity_id AS entity_id, field_data_taxonomy_image0.revision_id AS revision_id, field_data_taxonomy_image0.bundle AS bundle FROM {field_data_taxonomy_image} field_data_taxonomy_image0 WHERE (field_data_taxonomy_image0.taxonomy_image_fid = :db_condition_placeholder_0) AND (field_data_taxonomy_image0.deleted = :db_condition_placeholder_1) ; Array ( [:db_condition_placeholder_0] =>
256
[:db_condition_placeholder_1] => 0 ) in *field_sql_storage_field_storage_query()* (line *585* of *modules/field/modules/field_sql_storage/field_sql_storage.module*).
-- How can I fix this?
thanks
-- http://www.mosesmaina.com -- [ Drupal support list | http://lists.drupal.org/ ]
-- Tel:254- 722-490994 www.agile.co.ke | www.jipambe.com
Is there a way of finding where the query is stored and delete it. I suspect it's stored somewhere in the DB
On Tue, Jul 29, 2014 at 5:23 PM, Maina webmail.maina@gmail.com wrote:
This is what I would do: uninstall the module, make sure that its files are deleted from the directory listing, clear cache and run update.php again.
If this doesn't work I would go ahead and export the SQL dump of the database and set up a clone of my Drupal instance and see if the problem persists. Again, this are just things I would try given a situation like yours.
Maina
On 29/07/2014, Mutuku Ndeti jnmutuku@gmail.com wrote:
I ran update.php, cleared cache , run cron but still get the error.
On Tue, Jul 29, 2014 at 2:22 PM, Maina webmail.maina@gmail.com wrote:
You might want to try running the "update.php" file from [your/drupal/path]/update.php. Do this after clearing the cache memory from the admin dashboard.
Give it a shot!
On 29/07/2014, Mutuku Ndeti jnmutuku@gmail.com wrote:
*I keep getting the error below every time I edit a certain content
type. I
have tried Uninstalling / reinstalling the taxonomy image module but it's not fixing the issue. The * field_data_taxonomy_image tabel does not exist in the database. .
*PDOException*: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'field_data_taxonomy_image' doesn't exist: SELECT DISTINCT field_data_taxonomy_image0.entity_type AS entity_type, field_data_taxonomy_image0.entity_id AS entity_id, field_data_taxonomy_image0.revision_id AS revision_id, field_data_taxonomy_image0.bundle AS bundle FROM {field_data_taxonomy_image} field_data_taxonomy_image0 WHERE (field_data_taxonomy_image0.taxonomy_image_fid = :db_condition_placeholder_0) AND (field_data_taxonomy_image0.deleted = :db_condition_placeholder_1) ; Array ( [:db_condition_placeholder_0]
=>
256
[:db_condition_placeholder_1] => 0 ) in *field_sql_storage_field_storage_query()* (line *585* of *modules/field/modules/field_sql_storage/field_sql_storage.module*).
-- How can I fix this?
thanks
-- http://www.mosesmaina.com -- [ Drupal support list | http://lists.drupal.org/ ]
-- Tel:254- 722-490994 www.agile.co.ke | www.jipambe.com
-- http://www.mosesmaina.com -- [ Drupal support list | http://lists.drupal.org/ ]
Best place to ask this is in the issue queue for the project:
https://www.drupal.org/project/issues/taxonomy_image?categories=All
That module hasn't got much attention for D7 and doesn't even have a stable release. It's showing less than 100 installs on D7 sites, so chances are there's a bug in there you are experiencing.
Since that's actually a table from the field system, you aren't going to find a simple query to create it. They are created through the field_create_instance function.
Jamie Holly http://hollyit.net
On 7/29/2014 4:24 AM, Mutuku Ndeti wrote:
/I keep getting the error below every time I edit a certain content type. I have tried Uninstalling / reinstalling the taxonomy image module but it's not fixing the issue. The / field_data_taxonomy_image tabel does not exist in the database. . / PDOException/: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'field_data_taxonomy_image' doesn't exist: SELECT DISTINCT field_data_taxonomy_image0.entity_type AS entity_type, field_data_taxonomy_image0.entity_id AS entity_id, field_data_taxonomy_image0.revision_id AS revision_id, field_data_taxonomy_image0.bundle AS bundle FROM {field_data_taxonomy_image} field_data_taxonomy_image0 WHERE (field_data_taxonomy_image0.taxonomy_image_fid = :db_condition_placeholder_0) AND (field_data_taxonomy_image0.deleted = :db_condition_placeholder_1) ; Array ( [:db_condition_placeholder_0] => 256 [:db_condition_placeholder_1] => 0 ) in /field_sql_storage_field_storage_query()/ (line /585/ of /modules/field/modules/field_sql_storage/field_sql_storage.module/).
-- How can I fix this?
thanks
Thanks Jamie,
Is there a way to delete the the query. I really don't need the module. After I Unistall the module, I still get the same error.
On Tue, Jul 29, 2014 at 6:17 PM, Jamie Holly hovercrafter@earthlink.net wrote:
Best place to ask this is in the issue queue for the project:
https://www.drupal.org/project/issues/taxonomy_image?categories=All
That module hasn't got much attention for D7 and doesn't even have a stable release. It's showing less than 100 installs on D7 sites, so chances are there's a bug in there you are experiencing.
Since that's actually a table from the field system, you aren't going to find a simple query to create it. They are created through the field_create_instance function.
Jamie Hollyhttp://hollyit.net
On 7/29/2014 4:24 AM, Mutuku Ndeti wrote:
*I keep getting the error below every time I edit a certain content type. I have tried Uninstalling / reinstalling the taxonomy image module but it's not fixing the issue. The * field_data_taxonomy_image tabel does not exist in the database. .
- PDOException*: SQLSTATE[42S02]: Base table or view not found: 1146
Table 'field_data_taxonomy_image' doesn't exist: SELECT DISTINCT field_data_taxonomy_image0.entity_type AS entity_type, field_data_taxonomy_image0.entity_id AS entity_id, field_data_taxonomy_image0.revision_id AS revision_id, field_data_taxonomy_image0.bundle AS bundle FROM {field_data_taxonomy_image} field_data_taxonomy_image0 WHERE (field_data_taxonomy_image0.taxonomy_image_fid = :db_condition_placeholder_0) AND (field_data_taxonomy_image0.deleted = :db_condition_placeholder_1) ; Array ( [:db_condition_placeholder_0] => 256 [:db_condition_placeholder_1] => 0 ) in *field_sql_storage_field_storage_query()* (line *585* of *modules/field/modules/field_sql_storage/field_sql_storage.module*).
-- How can I fix this?
thanks
-- [ Drupal support list | http://lists.drupal.org/ ]
If you go to the Manage Fields of that Taxonomy (admin/structure/taxonomy), see if that field is still listed and if so, delete it out. If not, you might want to try activating the module again and see if it shows up, then delete the field and uninstall the module.
The only other thing to try would be to disable the field in the field_config table and the instances out of field_config_instance tables. After that, clear Drupal's cache. I would do a backup of the database first, as this can have adverse affects.
Jamie Holly http://hollyit.net
On 7/29/2014 11:23 AM, Mutuku Ndeti wrote:
Thanks Jamie,
Is there a way to delete the the query. I really don't need the module. After I Unistall the module, I still get the same error.
On Tue, Jul 29, 2014 at 6:17 PM, Jamie Holly <hovercrafter@earthlink.net mailto:hovercrafter@earthlink.net> wrote:
Best place to ask this is in the issue queue for the project: https://www.drupal.org/project/issues/taxonomy_image?categories=All That module hasn't got much attention for D7 and doesn't even have a stable release. It's showing less than 100 installs on D7 sites, so chances are there's a bug in there you are experiencing. Since that's actually a table from the field system, you aren't going to find a simple query to create it. They are created through the field_create_instance function. Jamie Holly http://hollyit.net On 7/29/2014 4:24 AM, Mutuku Ndeti wrote:/I keep getting the error below every time I edit a certain content type. I have tried Uninstalling / reinstalling the taxonomy image module but it's not fixing the issue. The / field_data_taxonomy_image tabel does not exist in the database. . / PDOException/: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'field_data_taxonomy_image' doesn't exist: SELECT DISTINCT field_data_taxonomy_image0.entity_type AS entity_type, field_data_taxonomy_image0.entity_id AS entity_id, field_data_taxonomy_image0.revision_id AS revision_id, field_data_taxonomy_image0.bundle AS bundle FROM {field_data_taxonomy_image} field_data_taxonomy_image0 WHERE (field_data_taxonomy_image0.taxonomy_image_fid = :db_condition_placeholder_0) AND (field_data_taxonomy_image0.deleted = :db_condition_placeholder_1) ; Array ( [:db_condition_placeholder_0] => 256 [:db_condition_placeholder_1] => 0 ) in /field_sql_storage_field_storage_query()/ (line /585/ of /modules/field/modules/field_sql_storage/field_sql_storage.module/). -- How can I fix this? thanks-- [ Drupal support list | http://lists.drupal.org/ ]-- Tel:254- 722-490994 www.agile.co.ke http://www.agile.co.ke | www.jipambe.com http://www.jipambe.com
-
Jamie Holly -
Maina -
Mutuku Ndeti -
Muzaffer Tolga Ozses