By manveru on

Hi,
Every time the cron job runs I've got two following errors:

pg_query() [function.pg-query]: Query failed: ERROR: relation "drupal_version" does not exist w pliku /home/manveru/wwwroot/manveru.pl/includes/database.pgsql.inc, linia 125.

and:

query: SELECT s.name, s.filename, s.description, s.status, v.vid, v.info, v.cvstag, v.cvsid, v.changed, v.cvsversions, v.cvslasthttp FROM drupal_system s LEFT OUTER JOIN drupal_version v ON s.name=v.name WHERE s.type='module' ORDER BY s.weight ASC, s.filename ASC w pliku /home/manveru/wwwroot/manveru.pl/includes/database.pgsql.inc, linia 144.

I think there is something missing in my database. It is possible, because I migrate my DB from MySQL to PostgreSQL. My questin is anyone able to tell me what shoul I check for sure and where can I get the structure of missing relation to restore it manually?

Thanks in advance.

⋅ Categories: Drupal 5.x

Comments

cog.rusty’s picture

cog.rusty commented

The error says that the "drupal_version" table is missing.

The "version" table is created by the releasemonitor module (for its structure, see the releasemonitor.install file). Check whether the table exists and whether it has the correct name (with your "drupal_" prefix). If something happened which is hard to correct, then it may be enough to completely uninstall and then reinstall the releasemonitor module.

manveru’s picture

manveru commented

Thanks, your information was helpful. The table creation query was wrong (as in many modules).

[b]M[/b]anveru