I had a mysite 5.x-1.10 in my installation.

When i tried to install the new version without deleting the table entries; it shows an error regarding an entry in mysite_data table. For which i deleted the tables mysite* from my database. And copied the newer version in the site>>all>>modules folder.

This time when i am trying to install the version it shows following warning:

user warning: Table 'drupal_demo.mysite' doesn't exist query: SELECT m.uid, m.title, m.status, m.updated, m.layout, m.style, m.format, m.theme, u.name, u.picture FROM mysite m INNER JOIN users u ON m.uid = u.uid WHERE u.status = 1 AND m.uid = 1 in D:\xampp\htdocs\drupal_demo\includes\database.mysql.inc on line 172.

user warning: Table 'drupal_demo.mysite_data' doesn't exist query: SELECT COUNT(mid) as count FROM mysite_data WHERE uid = 1 in D:\xampp\htdocs\drupal_demo\includes\database.mysql.inc on line 172.

These warning views on every links on my installation.

I am working on drupal for 2 months now (ongoing). Please help me out on this problem. I hope this does not turns out to be a foolish enquiry.

Thank you in advance.

Comments

agentrickard’s picture

Assigned: neotohin » agentrickard
Category: bug » support

The normal upgrade process for Drupal modules is as follows.

1) Copy the new module files into your modules directory.

2) Log in as user 1.

3) Run www.example.com/update.php

Doing so will run the necessary scripts to update your database tables. There were changes from the 5.x.1.10 release to 5.x.2.5.

It sounds like you didn't upgrade correctly. So here is my suggestion.

1) Go to the modules page.

2) Deactivate MySite

3) Click the Uninstall modules link.

4) Uninstall MySite. This will generate errors, since some of the tables don't exist. That is ok.

5) Enable MySite. Doing this should re-install the proper tables.

Problem is, you will have lost all your old MySite user data. But that already happened when you deleted the tables.

neotohin’s picture

Though i thanked you in advance.

But i can't help myself thanking you again.

Saved my drupal soul.

agentrickard’s picture

Status: Active » Closed (fixed)

This is part of the learning curve. We've all done it.

Just remember to run update.php when you upgrade modules.