Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.
By mod_phx on
hi everyone,
i attempted installing CCK and Flexinode (at different times) and got the errors below. Does anyone know what might have caused this to happen?
"Table 'drupal.flexinode_type' doesn't exist query: SELECT * FROM flexinode_type in /srv/www/htdocs/includes/database.mysql.inc on line 121"
"Table 'drupal.node_type_content' doesn't exist query: SELECT * FROM node_type_content nt ORDER BY nt.type_name ASC in /srv/www/htdocs/includes/database.mysql.inc on line 121."
"Table 'drupal.node_field' doesn't exist query: SELECT * FROM node_field nf in /srv/www/htdocs/includes/database.mysql.inc on line 121."
Comments
Their database tables were
Their database tables were not created and are missing.
Normally, if you have the correct versions for Drupal 4.7, they should contain an '.install' file which creates their tables automatically as soon as you enable them in /admin/modules.
No idea why the tables were not created. Take a look in your database just in case you notice anything strange with the table names.
----------
Edit: A possible reason is that you had installed them previously and then uninstalled them improperly by just deleted their tables, so their entries in the system table were left there and are telling Drupal that the modules are up to date.
hmmm
i'm not sure why that would be.
i looked in the db, and nothing seemed super weird. there's no node_type_content table, for instance, but shouldn't content.install create the table? i checked the permissions on the content.install file, and all users have full access to the file.
weird!!!
Look in the system table to
Look in the system table to see if the modules already have an entry there.
If there is an entry, delete it so that Drupal does not think that the tables already exist.
tried that, but still no luck
i went to the system table and deleted the modules/cck/content.module entry, but no luck.
maybe it's something fundamental that i did wrong?
is it the fact that i'm using mysql 5.0?
I don't see any reason why
I don't see any reason why mysql 5 can be a problem.
What did you do after deleting the entry from the system table? Did you enable the module again?
Also try to run Drupal's /update.php.
yup
after i deleted the entry from the system table, i dropped the cck folder in the modules folder, then went to the modules page and checked on the box to enable the content module. after i clicked "save configuration" the screen just went white, and the new database table(s) don't get created.
i also tried extracting the SQL statements from content.install and used them to create the tables in the database and it worked fine, but i still get the white screen after attempting to enable the content module.
maybe i'm not enabling the content module in the correct manner? do i need to do something before checking on the content module box and clicking "save configuration"? are there any other modules that need to be installed before the content module?
No, nothing special is
No, nothing special is needed. No idea what is going on.
Perhaps a PHP memory problem (http://drupal.org/node/31819)
Also try running Drupal's /update.php