-
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
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 :
Code:
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
-
Re: Export email module
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.
-
Re: Export email module
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.
-
Re: Export email module
The admin_pages table was added for v1.5.0.
-
Re: Export email module
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.