user warning: members_page' doesn't exist query:

I would advice you to uninstall the module and run this query in phpMyAdmin:

DELETE FROM system WHERE name='members'

Then download the newest version and try a clean install.

sorry, w.r.t your previous answer : the table is well named "$PREFIX_members" where $PREFIX is the prefix used for all tables of the given drupal (sub-)site ?
(i.e. you use qb_query("... {table} ...") ?)

I also get an error:

user warning: You have an error in your SQL syntax near 'fields, encode_mailto, field_length, users_per_page) VALUES ('all_members', 'listin' at line 1 query: INSERT INTO m7_members_page (name, description, access, page, page_title, url, use_pager, page_header, page_header_format, page_footer, page_footer_format, page_empty, page_empty_format, menu, menu_title, block, block_title, users_per_block, block_more, block_use_page_header, block_header, block_header_format, block_use_page_footer, block_footer, block_footer_format, block_use_page_empty, block_empty, block_empty_format, roles, fields, encode_mailto, field_length, users_per_page) VALUES ('all_members', 'listing of members', '6,3', '1', 'List of all members', 'members/all', '0', '', '1', '', '1', '', '1', '0', '', '0', '', '', '0', '0', ' in /home/httpd/html/mysite/drupal/includes/database.mysql.inc on line 172.

{table} is indeed always used, I believe this is an error from upgrading from a version prior to the big changes to the newer version. I added an uninstall option so it should be enough to disable the module, uninstall it and enable it again.

The INSERT has been fixed, as per your suggestion in the other issue. This is available on cvs already.

After installing the 5.x-1.x-dev 2007-Jul-09 version, I am getting the same warning that is reported in the first post of this thread.

user warning: Table '*****.members_page' doesn't exist query: SELECT mid, page_title, menu, menu_title, url, access FROM members_page WHERE page=1 in *****/drupal-5.1/includes/database.mysql.inc on line 172.

oops, forgot to change the status

Hi fm,

Did you upgrade from an old version of members or is this a clean install of the module?
You can find the CREATE command for MySQL in the members.install file.

I don't remember if I'd had it installed previously, but I'll look into manually executing the CREATE command from the install file as you've suggested.

That seems to have worked.

I am getting the same error. The module is not creating the table no matter what I try. When I try to build the table with the string from members.install file, MySQL returns this error...

The MySQL version is 5.0.24a.

matrock, you can't just cut'n'paste an SQL string from an install file (unless you understand what you are doing). The string '{members_page}' is supposed to be substituted for the actual table name by drupal (in case it has a prefix).

If you don't have a table prefix, try removing the braces {} then it may work for you.

I'm having the same problem. I'm attempting to upgrade from an older version of the module, but I'm not that familiar with SQL. Anybody have any advice?

AllanDay, if you're upgrading from a very old version it is advised to disabled and uninstall the module and to enable it again.

Ahhh...! I'm such a fool! I hadn't realised that there's a specific uninstall action - I thought you meant disable the module and run update.php. Thanks wmostrey!