Error on updating drupal core version

tsaorin - March 14, 2008 - 12:59
Project:Members
Version:5.x-1.x-dev
Component:Code
Category:bug report
Priority:normal
Assigned:Unassigned
Status:active
Description

I've updated my 5.x Drupal to 5.5, and suddenly Members listings don't work, and I can't add a page or a block.

#1

nig - March 23, 2008 - 22:44

I've just updated from 4.7.11 to 5.7 and I am getting lots of errors in my logs, like -

Table 'healhead_test.members_page' doesn't exist query: SELECT mid, name, description, url, block, page, menu FROM members_page ORDER BY name LIMIT 0, 25 in /home/healhead/public_html/t/includes/database.mysql.inc on line 172.

I can't build a members listing of any kind.

Members was working in 4.7.11

Does anyone know how to proceed?

Thanks

#2

nig - March 29, 2008 - 14:45

It seems the members_page table is not being created by the members.install script.

When I try to put the CREATE TABLE command into MyPHPAdmin I get -
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '{members_page} (
mid int(10) unsigned NOT NULL auto_increment,
' at line 1

Any ideas how to go forward?

Ta

#3

nig - March 29, 2008 - 22:18

I seem to have managed to do this. I copied a chunk of code out of members.install and ran it as an SQL query in MyPHPAdmin. After some adjustments, it ran, setting up the members_page table.
Seems to be working OK.

Has to be beginners luck....

 
 

Drupal is a registered trademark of Dries Buytaert.