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.

Comments

nig’s picture

nig commented

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

nig’s picture

nig commented

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

nig’s picture

nig commented

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....