Export email module

Hey guys, so im trying to install the Export Email Module, ive uploaded the files and then goto Admin -> Tools -> Install SQL patches and copy/paste this code

INSERT INTO admin_pages (page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order) VALUES ('emailExport', 'BOX_TOOLS_EMAIL_EXPORT', 'FILENAME_EMAIL_EXPORT', '', 'tools', 'Y', 999); 

And i get this error :

 Cannot execute because table admin_pages does not exist. CHECK PREFIXES!

Any ideas what im doing wrong? Im trying to extract the email addresses from my customers so i can use mailchimp as a mailer :)

Any help would be great!

Many thanks

Did you specify a SQL table prefix (like zen) when you installed? If you did, then your admin_pages table will be named zen_admin_pages. Look in your /includes/configure.php file, near the bottom, for the definition of DB_PREFIX.

It looks like something was overlooked in this module. I have the same exact problem. I went directly into MySQL and there is no admin_pages on the table list. The config file shows "define('DB_PREFIX', '');" My tables do not have a prefix.

Maybe this module actually only good for version 1.5 ? I have 1.39. I am currently checking to see where, and how the ZC admin panel pulls the list of items in the tools list.

The admin_pages table was added for v1.5.0.

Thanks lat9.

Here is what solved the problem for me in 1.39.
1.) Find tools_dhtml.php in the /admin/includes/boxes directory.
2.) Add the following line to the array section where you see all of the other BOX_TOOLS entries.
$za_contents[] = array('text' => BOX_TOOLS_EMAIL_EXPORT, 'link' => zen_href_link(FILENAME_EMAIL_EXPORT, '', 'NONSSL'));

Everything appears to be working fine after this edit.