Need help moving tables

More
11 years 10 months ago #466 by rmarcant
I can't move the tables no matter what I try. I've tried deleting the oscommerce tables from marvikshop and importing the ones from my old oscommerce tables and then renaming them and that doesn't work.

I just need an example of what to do to move the tables. I've searched the internet with no luck. Both databases are in the same website server and the gui commands won't do it because it can't find the database I'm and wanting to copy to.

Please help.

Please Log in to join the conversation.

More
11 years 10 months ago #467 by Simpel
Replied by Simpel on topic Re: Need help moving tables
There is nothing to move. You just need to export and import the data into the tables.

First of all the tables are the same. The only thing what changed is the name and ofcourse some contributions which was installed.

For an example we use the manufacturers table: ( We just export the table into phpMyAdmin)

This is the MarvikShop table
CREATE TABLE IF NOT EXISTS `j17_osc_manufacturers` (
`manufacturers_id` int(11) NOT NULL auto_increment,
`manufacturers_name` varchar(32) NOT NULL,
`manufacturers_image` varchar(64) default NULL,
`date_added` datetime default NULL,
`last_modified` datetime default NULL,
PRIMARY KEY (`manufacturers_id`),
KEY `IDX_MANUFACTURERS_NAME` (`manufacturers_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=87 ;

And this is the Oscommerce table

CREATE TABLE IF NOT EXISTS `manufacturers` (
`manufacturers_id` int(11) NOT NULL auto_increment,
`manufacturers_name` varchar(32) NOT NULL,
`manufacturers_image` varchar(64) default NULL,
`date_added` datetime default NULL,
`last_modified` datetime default NULL,
PRIMARY KEY (`manufacturers_id`),
KEY `IDX_MANUFACTURERS_NAME` (`manufacturers_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

As you can see the only thing is j17_osc_manufacturers and manufacturers.
It's very easy to copy your tables from OSCommerce to MarvikShop
Just rename the table and import your data in the MarvikShop tables.

BUT!! you always had to compare the tables first. Oscommerce shops could be heavy modified. If you had an extra option/column/rule in your table please add them first into the oscommcere table before export and import.

For me there where only a few tables important.
j17_osc_address_book
j17_osc_categories
j17_osc_categories_description
j17_osc_customers
j17_osc_customers_basket
j17_osc_customers_info
j17_osc_customers_points_pending
j17_osc_manufacturers
j17_osc_manufacturers_info
j17_osc_orders
j17_osc_orders_products
j17_osc_orders_status_history
j17_osc_orders_total
j17_osc_products
j17_osc_products_description
j17_osc_products_to_categories
j17_osc_subscriptions

Do not changes the j17_osc_configuration and j17_osc_configuration_group!

Please Log in to join the conversation.

More
11 years 10 months ago #468 by rmarcant
I tried that with only those files. You first have to delete the marvikshop oscommerce database files that were created in installation before you can rename the old oscommerce database files that are copied over. Joomla 2.5 will not let you rename an existing file with the same name in the table. You didn't mention that step (which I already knew). So simply copying and renaming isn't going to work.

When I did that, I got errors in marvikshop on the front end (when trying to access the shop) and the backend when trying to access the products page. Could this be the extra option/column/rule you mention that caused the errors?

Please Log in to join the conversation.

More
11 years 10 months ago #469 by Simpel
Replied by Simpel on topic Re: Need help moving tables
When copy the database tables, you had to use phpMyAdmin not joomla ...:unsure:

What kind of errors do you get? database errors are very clear. Mostly they miss a rule or something.

Please Log in to join the conversation.

More
11 years 10 months ago #470 by rmarcant
Yes, I use phpMyadmin only for all of this. When I do one in the next hour, I'll let you know the error if I get one.

How do I do the table compare?

Please Log in to join the conversation.

More
11 years 10 months ago #471 by Simpel
Replied by Simpel on topic Re: Need help moving tables
How do I do the table compare?

I login phpMyAdmin in firefox and explorer. So you can open joomla/marvikshop and second your old oscommerce shop.

Please Log in to join the conversation.

More
11 years 10 months ago - 11 years 10 months ago #472 by rmarcant
I moved all tables from your post.
I deleted address book, customers, customer_basket, customer_info and then renamed those same 4 to the marvikshop table names.

When I checked the Customers Page in MarvikShop, I get the following error.

1054 - Unknown column 'c.customers_group_id' in 'on clause'

select count(*) as total from aw4gd_osc_customers c left join aw4gd_osc_address_book a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id left join aw4gd_osc_customers_groups cg on c.customers_group_id = cg.customers_group_id

And when I add customers_group_id to the customers table, I get this error now. This move process is ridiculously difficult.

1054 - Unknown column 'c.customers_group_ra' in 'field list'

select c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_email_address, c.customers_group_id, c.customers_group_ra, a.entry_country_id, a.entry_company, cg.customers_group_name from aw4gd_osc_customers c left join aw4gd_osc_address_book a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id left join aw4gd_osc_customers_groups cg on c.customers_group_id = cg.customers_group_id order by c.customers_id DESC limit 0, 20
Last edit: 11 years 10 months ago by rmarcant.

Please Log in to join the conversation.

Time to create page: 0.341 seconds
Events Joomla
MarvikShop
Finnaly it's here:
 
No bridges, no look a likes!
This is the ultimate integration
between Oscommerce and Joomla!
Documentation
Site Showcase
Follow us

Joomla! Debug Console

Session

Profile Information

Memory Usage

Database Queries