Problems importing osc database

[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]

I take that back.

Yes Zen_ is used for all.

zen_banners_history
zen_categories
zen_categories_description

Where do I go now?

[Webskipper]

I believe this is what we wanted.

-- phpMyAdmin SQL Dump
-- version 2.10.2
-- http://www.phpmyadmin.net
--
-- Host: localhost:3306
-- Generation Time: Nov 29, 2007 at 11:33 AM
-- Server version: 4.0.16
-- PHP Version: 4.4.1

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `zen_p_os2`
--

-- --------------------------------------------------------

--
-- Table structure for table `zen_categories`
--

CREATE TABLE `zen_categories` (
`categories_id` int(11) NOT NULL auto_increment,
`categories_image` varchar(64) default NULL,
`parent_id` int(11) NOT NULL default '0',
`sort_order` int(3) default NULL,
`date_added` datetime default NULL,
`last_modified` datetime default NULL,
`categories_status` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`categories_id`),
KEY `idx_parent_id_cat_id_zen` (`parent_id`,`categories_id`),
KEY `idx_status_zen` (`categories_status`),
KEY `idx_sort_order_zen` (`sort_order`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

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


-- --------------------------------------------------------

--
-- Table structure for table `zen_categories_description`
--

CREATE TABLE `zen_categories_description` (
`categories_id` int(11) NOT NULL default '0',
`language_id` int(11) NOT NULL default '1',
`categories_name` varchar(32) NOT NULL default '',
`categories_description` text NOT NULL,
PRIMARY KEY (`categories_id`,`language_id`),
KEY `idx_categories_name_zen` (`categories_name`)
) TYPE=MyISAM;

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

[DrByte]

Right. And your INSERT statements need to use the zen_ tablenames as well.

[Webskipper]

Sorry. Where do I see an insert?

Do you zen via phone? My bill.

[Webskipper]

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