Problems importing osc database

[Webskipper]

I recently Moved to Zen form OSC and I cannot for the life of me get a green light on an import. Even tried the extra DB trick and import the necessary tables.

Can you help? All the conversion threads are 2 years old.

-Thanks

-Philips

[chuck]

cannot ... get a green light on an import

By "green light" are you using that as a figure of speech? or something more literal?

What exactly isn't working after your import?

Quite a lot more info would be needed to help sort things out ...

[Ajeh]

What version osC are you coming from?

What add-ons are you using?

Did you try running a clean install of Zen Cart ... then dump the database, load the osC database and run the Upgrade?

[Webskipper]

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

OSC version 2.2.

Zen Cart version is 1.3.7.

So, if I just change my 2 include/config files to talk to my OSC DB and then click update, that should get me farther than now?

I don't mind losing any other changes but having all the products and categories would be sweet.

Thanks I'll try it.

[Ajeh]

Any add-ons? or pure osC 2.2 ...

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