By asespat on

I update from 4.7 to 5 but i did not saw modules where still not ready it giveme some trubles. I extract some modules to avoid the problem , but now the web puts this error message::

user warning: Table 'asespat_drupal.node_type' doesn't exist query: SELECT nt.type, nt.* FROM node_type nt ORDER BY nt.type ASC in /home/asespat/public_html/includes/database.mysql.inc on line 167.
user warning: Table 'asespat_drupal.blocks_roles' doesn't exist query: SELECT DISTINCT b.* FROM blocks b LEFT JOIN blocks_roles r ON b.module = r.module AND b.delta = r.delta WHERE b.theme = 'multiflex' AND b.status = 1 AND (r.rid IN (1) OR r.rid IS NULL) ORDER BY b.region, b.weight, b.module in /home/asespat/public_html/includes/database.mysql.inc on line 167.

Any solution?

thanks in advance

Comments

alexis’s picture

alexis commented

It seems your database is missing some tables. You need to run update.php after upgrading the files.

I'd suggesting disabling non core modules before upgrading if you have something not so standard running.

Regards.

Alexis Bellido
Aprende a usar Drupal en menos de 48 horas

cog.rusty’s picture

cog.rusty commented

Did you just upload Drupal 5's files and didn't run /update.php to update the database tables?

If this is what you did, then you may be lucky and you can still upload the old files and go back to 4.7 without damaging your modules' data.

But if you want to go all the way and don't care, you can run /update.php to update the database tables to Drupal 5. That should create the missing tables.

asespat’s picture

asespat commented

yes i updated and remove the modules that makes error , but now i tried to upload and it puts the same message:

user warning: Table 'asespat_drupal.node_type' doesn't exist query: SELECT nt.type, nt.* FROM node_type nt ORDER BY nt.type ASC in /home/asespat/public_html/includes/database.mysql.inc on line 167.
user warning: Table 'asespat_drupal.blocks_roles' doesn't exist query: SELECT DISTINCT b.* FROM blocks b LEFT JOIN blocks_roles r ON b.module = r.module AND b.delta = r.delta WHERE b.theme = 'minnelli' AND b.status = 1 AND (r.rid IN (1) OR r.rid IS NULL) ORDER BY b.region, b.weight, b.module in /home/asespat/public_html/includes/database.mysql.inc on line 167.

Can i stilltry to get back to my 4.7

P.D i upload the taxonomy theme module in version 5.x (i removed it before cos was givving error)

thanks

cog.rusty’s picture

cog.rusty commented

If you want to try to go back to Drupal 4.7. then don't run /update.php but delete Drupal's files in 'includes', 'misc', 'profiles', 'modules' (except your old modules) and 'themes' (except your custom themes), keep a copy of your old settings.php, and then upload Drupal 4.7 again. It is not guaranteed to work, but it may work.

If you want to go ahead to Drupal 5, then disable and delete your old modules and themes and run /update.php to create the missing tables in the database. Then you will have to upload new versions of your modules for Drupal 5 when they become available.