By shojo on

Hello all-

I am upgrading a test_site from 4.5.2 to 4.6.3.
when I got to the last update changelog date, I saw that there was no update needed.

excited by my new success, I wanted to see what the site would look like in my old theme.

now I get this:

user error: Unknown column 'severity' in 'field list'
query: INSERT INTO watchdog (uid, type, message, severity, link, location, hostname, timestamp) VALUES (0, 'access denied', '<em>admin</em> denied access.', 1, '<a href=\"admin\" class=\"active\">view</a>', '/test_site/index.php?q=admin', '68.237.235.150', 1138478972) in /home/shojo62/public_html/test_site/includes/database.mysql.inc on line 66.

Fatal error: Unknown column 'severity' in 'field list' query: INSERT INTO watchdog (uid, type, message, severity, link, location, hostname, timestamp) VALUES (0, 'php', 'Unknown column \'severity\' in \'field list\' query: INSERT INTO watchdog (uid, type, message, severity, link, location, hostname, timestamp) VALUES (0, \'access denied\', \'&lt;em&gt;admin&lt;/em&gt; denied access.\', 1, \'&lt;a href=\\&quot;admin\\&quot; class=\\&quot;active\\&quot;&gt;view&lt;/a&gt;\', \'/test_site/index.php?q=admin\', \'68.237.235.150\', 1138478972) in /home/shojo64/public_html/test_site/includes/database.mysql.inc on line 66.', 2, '', '/test_site/index.php?q=admin', '68.237.235.150', 1138478972) in /home/shojo62/public_html/test_site/includes/database.mysql.inc on line 66

is there anyway for me to correct this without having to "do it all over"?

⋅ Categories: Drupal 4.6.x

Comments

chx’s picture

chx commented

this tells me that at least watchdog is NOT updated.
--
My developer blog. | The news is Now Public | Ask not what Drupal can do for you -- ask what you can do for Drupal.

--
Drupal development: making the world better, one patch at a time. | A bedroom without a teddy is like a face without a smile.

shojo’s picture

shojo commented

1)Do I reinstall the the backup version I had (4.5.2) and do it all over?
a) if so, should i not jump from 4.5.2 to 4.6.0 but pick the one where watchdog was updated?

2)Can I revert back to 4.6.2?

3) Or is there something else I can do?

_____________________
Visit
http://www.localghost.org
Education As Intellectual Self-Defense

heine’s picture

heine commented

From http://drupal.org/node/29684 :

Execute the query:

ALTER TABLE watchdog ADD COLUMN severity tinyint(3) unsigned NOT NULL default '0';

--
Tips for posting to the forums.
When your problem is solved, please post a follow-up to the thread you started.

shojo’s picture

shojo commented

Great, that helped. My site is back up.
BUT...
I still get an error: 

user error: Table 'shojo64_testsite.queue' doesn't exist
query: SELECT uid, vote FROM queue WHERE nid = 164 in /home/shojo62/public_html/test_site/includes/database.mysql.inc on line 66.

where the number "164" runs all the way to "148"

I am not sure what this is telling me.

_____________________
Visit
http://www.localghost.org
Education As Intellectual Self-Defense

pamphile’s picture

pamphile commented

This helped me too

Thanks !

Marcel
http://computingnews.com
http://01wholesale.com