Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

mysql dump executed but nothing shows up


laptop13

Recommended Posts

I got a data dump from a supplier and put it through the main database and it said everything was executed successfully. however when i log into admin and catalog, as well as the actual database nothing shows up? any ideas? im a newb when it comes to databasing. thanks for any help

Link to comment
Share on other sites

I got a data dump from a supplier

 

Post a sample

 

and put it through the main database

 

how did you do this? Using EP, phpmyadmin?

 

might be able to help then....

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Link to comment
Share on other sites

I got a data dump from a supplier

 

Post a sample

 

and put it through the main database

 

how did you do this? Using EP, phpmyadmin?

 

might be able to help then....

Its is a huge database of products, so a sample would only show on peice of the table. I put it in through myphpadmin, would that make a difference? it had said query executed successfully 22*** lines added i think.

Link to comment
Share on other sites

Were any conversions made to the table and column names and data types required by osC?

 

no i do not believe so, the dump was given to me by the company and the guy didn't know what tey used so i read their code and saw OSC in there and downloaded oscom, all the tables matched. so this was a dump from their database. I have CC and it never worked but i'm thinking of switching to oscomm if its benificial.

Link to comment
Share on other sites

Without knowing the structure and parameters of the dump and the version of osC that you are using, we can not help you. It is very interesting that they supply a dump for osCommerce. Is it known to work and for what version? We also need to know what version of MySQL and PHP you are using.

 

BTW, does CC = CubeCart?

For ALL problems, please review this link first -> osCommerce Knowledge Base

Link to comment
Share on other sites

Yes cubecart. i am using the latest version of OSCom, php and mysql v.4 because that is what the dump came out of. i do not know what version of oscom they are using. is there a way that i could attach such a large file or can you tell me whic portion i would need to post here to see if it is correct?

Link to comment
Share on other sites

Yes cubecart. i am using the latest version of OSCom, php and mysql v.4 because that is what the dump came out of. i do not know what version of oscom they are using. is there a way that i could attach such a large file or can you tell me whic portion i would need to post here to see if it is correct?

 

 

Hi,

 

I also experienced the same problem a few months back, hopefully my instructions below will help and solve the problem!

 

* Back up your files & database

 

* I am presuming you can manually create a MySQL database in your hosting control panel, so create a new database and keep the information stored for later use.

 

* You will now need to upload the mysql dump in myphpadmin to the new database created

 

* Once this is complete you will need catalog/includes/configure.php and catalog/admin/includes/configure.php

 

* Finally you will need to edit both configure.php files i have provided an example below...

 

 

 

// define our database connection

define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty for productive servers

define('DB_SERVER_USERNAME', 'rob8294_osc1');

define('DB_SERVER_PASSWORD', 'hu92olnj940');

define('DB_DATABASE', 'rob8294_osc1');

define('USE_PCONNECT', 'false'); // use persistent connections?

define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'

?>

 

 

I hope this solves the problem if you need any help just give me a shout!

Good Luck :D

Highvisualproducts

Link to comment
Share on other sites

Post just the global mysql parameters at the beginning of the dump and the table creation statements for the first table for now.

 

Are you getting any error messages in osC? Have you configured your database connection strings per the post above?

For ALL problems, please review this link first -> osCommerce Knowledge Base

Link to comment
Share on other sites

Hi,

 

I also experienced the same problem a few months back, hopefully my instructions below will help and solve the problem!

 

* Back up your files & database

 

* I am presuming you can manually create a MySQL database in your hosting control panel, so create a new database and keep the information stored for later use.

 

* You will now need to upload the mysql dump in myphpadmin to the new database created

 

* Once this is complete you will need catalog/includes/configure.php and catalog/admin/includes/configure.php

 

* Finally you will need to edit both configure.php files i have provided an example below...

 

 

 

// define our database connection

define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty for productive servers

define('DB_SERVER_USERNAME', 'rob8294_osc1');

define('DB_SERVER_PASSWORD', 'hu92olnj940');

define('DB_DATABASE', 'rob8294_osc1');

define('USE_PCONNECT', 'false'); // use persistent connections?

define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'

?>

 

 

I hope this solves the problem if you need any help just give me a shout!

Good Luck :D

 

 

both of my configure files have the correct information in them already? is there something i need to change?

Link to comment
Share on other sites

Post just the global mysql parameters at the beginning of the dump and the table creation statements for the first table for now.

 

Are you getting any error messages in osC? Have you configured your database connection strings per the post above?

 

 

here is the first part of it, well a fraction of the over all dump but i think this is what you are asking for.

 

# phpMyAdmin MySQL-Dump

# version 2.4.0

# http://www.phpmyadmin.net/ (download page)

#

# Host: localhost

# Generation Time: Feb 29, 2008 at 01:30 PM

# Server version: 4.0.16

# PHP Version: 4.3.4

# Database : `lamin-xc_p_os1`

# --------------------------------------------------------

 

#

# Table structure for table `categories`

#

 

CREATE TABLE 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,

PRIMARY KEY (categories_id),

KEY idx_categories_parent_id (parent_id)

) TYPE=MyISAM;

 

#

# Dumping data for table `categories`

#

 

INSERT INTO categories VALUES (45, 'gmc-logo.gif', 447, 0, '2005-04-14 09:41:37', '2007-02-13 13:16:17');

INSERT INTO categories VALUES (44, 'Cadillac-Logo.gif', 447, 0, '2005-04-14 09:41:13', '2007-02-13 13:13:34');

INSERT INTO categories VALUES (35, 'Ford-Logo.gif', 447, 0, '2005-04-14 09:33:26', '2007-02-13 13:14:45');

INSERT INTO categories VALUES (36, 'honda-logo.gif', 447, 0, '2005-04-14 09:33:57', '2007-02-13 13:17:16');

INSERT INTO categories VALUES (37, 'Mazda-Logo.gif', 447, 0, '2005-04-14 09:35:18', '2007-02-13 13:28:59');

INSERT INTO categories VALUES (38, 'Mitsubishi-logo.gif', 447, 0, '2005-04-14 09:35:42', '2007-02-13 13:29:48');

INSERT INTO categories VALUES (39, 'ferrari-logo.gif', 447, 0, '2005-04-14 09:36:30', '2007-02-13 13:14:32');

INSERT INTO categories VALUES (40, 'lotus-logo.gif', 447, 0, '2005-04-14 09:37:24', '2007-02-13 13:25:30');

INSERT INTO categories VALUES (52, 'landrover-logo.gif', 447, 0, '2005-04-14 09:47:18', '2007-02-13 13:20:44');

INSERT INTO categories VALUES (42, 'chrysler-logo.gif', 447, 0, '2005-04-14 09:40:09', '2007-02-13 13:14:01');

INSERT INTO categories VALUES (66, '94acura.jpg', 31, 0, '2005-04-14 09:58:06', '2007-11-11 10:26:35');

INSERT INTO categories VALUES (34, 'Chevy-Logo.gif', 447, 0, '2005-04-14 09:33:14', '2007-02-27 12:53:14');

Link to comment
Share on other sites

Well, for starters, the sort orders are all 0. Nothing is going to show until each of the categories has a unique sort order and I would not use 0 to begin. I assume that there is a parent category number 447 and 31.

 

Everything else looks okay so far. The table creation statement matches that used in osCommerce-2.2rc2a.

For ALL problems, please review this link first -> osCommerce Knowledge Base

Link to comment
Share on other sites

both of my configure files have the correct information in them already? is there something i need to change?

 

As long as both configure.php files contain the new database information it should work

E.G

 

// define our database connection

define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty for productive servers

define('DB_SERVER_USERNAME', 'rob8294_osc1');

define('DB_SERVER_PASSWORD', 'hu92olnj940');

define('DB_DATABASE', 'rob8294_osc1');

define('USE_PCONNECT', 'false'); // use persistent connections?

define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'

?>

 

Please let me know how you get.

 

Louise

Highvisualproducts

Link to comment
Share on other sites

As long as both configure.php files contain the new database information it should work

E.G

 

// define our database connection

define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty for productive servers

define('DB_SERVER_USERNAME', 'rob8294_osc1');

define('DB_SERVER_PASSWORD', 'hu92olnj940');

define('DB_DATABASE', 'rob8294_osc1');

define('USE_PCONNECT', 'false'); // use persistent connections?

define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'

?>

 

Please let me know how you get.

 

Louise

 

 

And i also found that when i was using the mysql dump it would not work if i was to install oscommerce the default way, I had to manually edit the 2 configure.php files and it would then pick up the database. If i did not do that it would never pick the database up for some reason.

Highvisualproducts

Link to comment
Share on other sites

Well, for starters, the sort orders are all 0. Nothing is going to show until each of the categories has a unique sort order and I would not use 0 to begin. I assume that there is a parent category number 447 and 31.

 

Everything else looks okay so far. The table creation statement matches that used in osCommerce-2.2rc2a.

 

Can you explain the sort order?

and what it would need to be changed too

Link to comment
Share on other sites

Intrestingly, i started small and took one section products and tested it, it seems it had an extra value at the end, probably something specific they had on their end. so i modified all that in textpad. Now it seems if i add them line by line it work, however if i try to add the whole section it just says error ad gives no explination....?

Link to comment
Share on other sites

The "sort order" is the order that your categories are displayed at your store. In some osC functions a 0 value means 'don't show it'. If two categories have the same sort order either the last one retrieved from the database will show or sometimes nothing will show.

 

Just use an integer for the sort order. I like to space them out, ie. 5, 10, 15, 20, etc, so that I can easily reorder them if I ever wish to. BTW, there is a 3 digit limit, so you can not use a number larger than 999 unless you modify the database table column definition.

For ALL problems, please review this link first -> osCommerce Knowledge Base

Link to comment
Share on other sites

Ok i got them all to work correctley, I took a stock OScom database and deleted the tables pertenint to the dump out and loaded it section by section. So now i have to figure out where to load pictures and thumbnails, then i have to build an all new site around oscom, LOL

Link to comment
Share on other sites

I do have one important question though, this loaded all the catagories into the base catagorys, since this is just a database of a particular product, how can i move it one out.

 

IE

 

car part 1

car part 2

 

make it

 

company #1

>car part 1

> car part 2

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...