Before you post a question, read this:

  • Plugin Author DivaVocals

    (@divavocals)


    11 years ago

    **THIS STICKY IS JUST AN INSTALL/SUPPORT TOPIC INTRO**
    **DO NOT POST COMMENTS HERE.. CREATE A NEW TOPIC IF YOU NEED HELP**
    **COMMENTS ADDED HERE WILL NOT RECEIVE A RESPONSE**

    When asking for help, please include the following information along with the issue you are describing. (please don’t say “it broken” or “it doesn’t work” as this isn’t nearly as descriptive as is needed to help)

    • What versions of Zen Cart and WordPress you are running
    • Server info (PHP & mySQL versions)

    Setting up this plugin is pretty straight forward.. Issues occur if the prerequisites are not met or if one of the admin options does not match your Zen Cart /includes/configure.php file.

    Does your WordPress/Zen Cart setup match the required prerequisites??

    Prerequisites for Zen Cart for WordPress (zen4wp)

    • A Zen Cart store installed and operable. Tested with Zen Cart v1.5.x.
    • WordPress installed and operable. Tested with WordPress v3.5.x – v3.9.x.
    • The Zen Cart and WordPress installations share a common mySQL database. (use table prefixes to separate WordPress tables from Zen Cart tables)
    • The Zen Cart and WordPress installations must share the same domain.
    • Update the admin configuration options with the correct filepath to the WordPress installation.

    Note: If your store/blog configuration does NOT match these prerequisites, then Zen Cart for WordPress (zen4wp) will not function

    If your WordPress and Zen Cart setup meets the prerequisites, then set the plugin option settings to the value of the like-named entry in your Zen Cart’s /includes/configure.php file. They need to match EXACTLY..

    Regarding the database setup required:
    ======================================
    It doesn’t matter which one you install first (Zen Cart or WordPress), but during the installation when you are asked for your database information you MUST use the SAME database information for both. (DB name, DB Password, DB Username)

    Regarding database prefixes: The default Zen Cart database prefix is ” (i.e. none) and the default WordPress prefix is ‘wp_’. While PERSONALLY I prefer using a DB prefix for BOTH Zen Cart and WordPress (i.e. Typically I use zen_ for Zen Cart and for WordPress I use wp_), as long as the prefixes are different, you should be good-to-go!

    Changing the table prefix for the Zen Cart tables is pretty easy, but NOT REQUIRED. For anyone who has already installed Zen Cart without a table prefix (the default), and now WANTS to add a table prefix, there is a very SIMPLE script you can run to add a table prefix to one’s Zen Cart install.

    SELECT Concat('ALTER TABLE ', TABLE_NAME, ' RENAME TO my_prefix_', TABLE_NAME, ';') FROM information_schema.tables WHERE table_schema = 'my_database'

    Your result set will be a bunch of queries that you can copy and paste into your favorite MySQL editor (phpMyAdmin, whatever). Just paste those in and execute, and you’re all done.

    Once the script its run, an update to the store and admin configure.php files to include the new table prefix is all that’s needed..

    https://wordpress.org/plugins/zen4wp/

Viewing 1 replies (of 1 total)
  • Plugin Author DivaVocals

    (@divavocals)

    10 years, 2 months ago

    If your WordPress and Zen Cart installations aren’t SHARING the same database, then you will need to combine your WordPress and Zen Cart databases and update one of the configuration files (WordPress or Zen Cart) to use the combined database with Zen4WP.

    The basic steps are:

    • Export (dump) your WordPress database, and import the resulting dump SQL into your Zen Cart database (or vice versa dump the Zen Cart database and import to the WordPress database)
    • Update the configuration file of either WordPress or Zen Cart (depends on which direction you did the database combination) to use the combined database.

    More detailed import and export instructions can be found here:
    https://wordpress.org/support/topic/export-and-import-mysql-databases

    If you are unfamiliar with HOW to do this, you may need to hire someone to help you with this task. As part of supporting the free version of this plugin, we are certainly able and willing to provide as much basic instruction here in this forum for combining your databases. However, it may be difficult to execute the work required if you are not familiar with how to use your web-host’s cPanel (or Plesk) phpMyAdmin tool. Different hosts use different versions of phpMyAdmin so giving specific instruction for how to access your host’s phpMyAdmin Admin will be difficult. The instructions provided in this support thread are basic instructions which should work for most host’s. However, if you are still having trouble with this, then you may need to contact your host to help you with this or consider hiring someone to help you with this work.

    How do I know if Zen Cart and WordPress share the same database?

    Look in your wp-config.php file for WordPress these defines:

    define('DB_NAME', 'your_database');    // The name of the database
/** MySQL database username */
define('DB_USER', 'your_database_username');     // Your MySQL username
/** MySQL database password */
define('DB_PASSWORD', 'your_database_password'); // ...and password

    If WordPress and Zen Cart are SHARING the same database, then the wp-config.php defines will MATCH these defines in Zen Cart’s configure.php file

    define('DB_SERVER_USERNAME', 'your_database_username');
  define('DB_SERVER_PASSWORD', 'your_database_password');
  define('DB_DATABASE', 'your_database');
Viewing 1 replies (of 1 total)

The topic ‘Before you post a question, read this:’ is closed to new replies.