Problems importing osc database

[DrByte]

Green light was actually a literal meaning for the Green text after a successful SQl upload.

So, you're saying that whatever you did to massage your osc data in preparation for importing ... doesn't work because when you try to import, phpMyAdmin fails to do the import?

That would suggest that either:
- your SQL file that you're trying to load is too large for the job to complete before PHP times out
or
- something you've done is causing MySQL errors ... which one would expect that phpMyAdmin would display on the screen so you have an idea what's wrong.

Did you follow the recommended import instructions?
FAQ articles available in this page: https://www.zen-cart.com/tutorials/i...hp?article=153

[Webskipper]

"Did you follow the recommended import instructions?"

Yes. The zen.sql was fortified with the categories from osc.

I only tried it with all category tables.

The way to import is to find the zen.sql right?

OSC version is 2.2 with a lot of mods, I have a fresh copy of Zen installed. i deleted the zen db and cart and started over just this moment. That's why I have been absent.

I did try to tell the Zen cart to talk to the OSC DB through the config files and also by uploading the OSC db onto the zen DB and neither worked.

I am sorry that I do not remember the phpadmin errors.

[DrByte]

I only tried it with all category tables.

When you say "all category tables" ... what are those tables? And which fields did you have in your import sql?
Were your INSERT statements using explicit column/field names, or were they general? Explicit is safest -- if you name the columns, there is less chance for error.

Posting the first 50-100 lines of your import script (you called it zen.sql) might be a help.

I am sorry that I do not remember the phpadmin errors.

Surely they're re-creatable, right?

[Webskipper]

There are only 2 category tables to mention:
zen_categories
zen_categories_description

I selected the Zen DB, clicked Structure, export, highlighted the 2 category fields, selected everything under SQL options except Structure and Complete inserts and saved AS. This is what I get.
--------------------------------------------------------------------------------
--- phpMyAdmin SQL Dump
-- version 2.10.2
-- http://www.phpmyadmin.net
--
-- Host: localhost:3306
-- Generation Time: Nov 29, 2007 at 09:35 AM
-- Server version: 4.0.16
-- PHP Version: 4.4.1

SET FOREIGN_KEY_CHECKS=0;

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

SET AUTOCOMMIT=0;
START TRANSACTION;

--
-- Database: `zenned_p_os2`
--

--
-- Dumping data for table `zen_categories`
--


--
-- Dumping data for table `zen_categories_description`
--


SET FOREIGN_KEY_CHECKS=1;

COMMIT;

Now, when I do the same to the OSC DB and then compare them, all it looks like I have to do is copy and paste the:

INSERT DELAYED IGNORE INTO `categories` (`categories_id`, `categories_image`, `parent_id`, `sort_order`, `date_added`, `last_modified`) VALUES
(1, 'KYO3021B.jpg', 0, 0, '2007-03-20 20:33:09', '2007-03-21 17:23:01'),
(2, 'clear.gif', 0, 0, '2007-03-20 20:33:09', '2007-08-03 21:32:14'),
(3, 'clear.gif', 0, 0, '2007-03-20 20:33:09', '2007-08-08 21:43:53'),
(25, 'futk6900-175.jpg', 23, 0, '2007-03-21 21:16:56', NULL),

and the rest into the appropriate area. I also tried a script someone (merlin) wrote to just insert in the SQL and run it. I did not see anything change. What's porting in programming terms?

Thanks for your help.

[DrByte]

"zen_categories" vs "categories" ... those are different table names.

Why are you using "zen_categories" in one place and "categories" in another?

Is your Zen Cart database set up to use "zen_" prefixes on all the table names? (ie: DB_PREFIX setting in your configure.php files.)

[Webskipper]

"Is your Zen Cart database set up to use "zen_" prefixes on all the table names?"

Yes, no good?

[DrByte]

Using "zen_" prefixes is fine ... as long as you're consistent.

Are you really using "categories" instead of "zen_categories" in your zen.sql import? If so, then I'm not surprised that you're not seeing the data in Zen Cart ... because you're not loading it into your Zen Cart tables.

[Webskipper]

OSC DB imported into ZEN DB properly. All set thanks!