Problems importing osc database

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

Ok. I retried the import through SQl and got a:

Fatal error: Call to a member function on a non-object in /home/-/public_html/-/includes/classes/category_tree.php on line 68

"Call a member"

When clicking on "All products" in the store.

[Webskipper]

Ok no fatal errors now.

Still want to import.

[DrByte]

Following the FAQ ... you have data that you want to import.
You modified the table structure of your "old" data.
You then exported the data to a file which you said you called "zen.sql".

Right?

Backing up a step ... you modified the table structure ... but did you change the table "name" to match your Zen Cart database's table name?

ie: rename your *old* "categories" table to "zen_categories" (since you have decided to use "zen_" as a table prefix.

After you rename the tables you're exporting, do your export. Then try to import the data to your new database you plan to use for Zen Cart.

Otherwise you're just importing all your data into a table that Zen Cart will never see.

[Webskipper]

Ok. I tried that a few times and i don't see new categories or products.

Do you want to do this since I am not getting it?

I just deleted and created the ZN db one last time.

I'm afraid that I'll just have to plug each product in one at a time.