Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2011
    Posts
    58
    Plugin Contributions
    0

    Default 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

  2. #2
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    12,399
    Plugin Contributions
    87

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

  3. #3
    Join Date
    May 2010
    Posts
    8
    Plugin Contributions
    0

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

  4. #4
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    12,399
    Plugin Contributions
    87

    Default Re: Export email module

    The admin_pages table was added for v1.5.0.

  5. #5
    Join Date
    May 2010
    Posts
    8
    Plugin Contributions
    0

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

 

 

Similar Threads

  1. Email Address Exporter - How can I export the email addresses of every customer?
    By SpencerW in forum All Other Contributions/Addons
    Replies: 4
    Last Post: 14 Oct 2011, 07:35 AM
  2. Export Email Addresses?
    By neparker in forum General Questions
    Replies: 2
    Last Post: 1 Dec 2009, 09:28 PM
  3. Candapost Desktop EST Export module - does not export
    By oxxyfx in forum All Other Contributions/Addons
    Replies: 1
    Last Post: 6 Sep 2009, 02:11 PM
  4. Email Export in 1.3.8
    By chriscana in forum General Questions
    Replies: 2
    Last Post: 18 Apr 2008, 02:46 PM
  5. Email Export
    By netwiser in forum General Questions
    Replies: 0
    Last Post: 16 Apr 2008, 11:07 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR