No Products in Categories box

[kenlyle]

In my new RC2 install, with my converted 1.7 database, I get NO Infoboxes at all displaying.

In the admin, I can't give anyone rights to Admin info_boxes because I get an error message that info_boxes.php is not installed, but I see it in catalog/admin/includes/boxes/

Any clues appreciated.

K

[michael_s]

You may have converted the db structure, but you now need to either import the osCMax 2 specific configuration data into your converted db, or you need to export your customer, products, categories and orders from the converted db and import them into the native osCMax 2 db...

[kenlyle]

Yeah! Thanks, Michael!

Is there an easy way? Do you happen to know the configuration_group_id (s) of the groups you added? Then I could query them out and just add those.

Thanks,
K

[michael_s]

You could just to a data sql dump from your upgraded db and the osCMax db for the configuration table (data only), and then diff the output .sql batch files to see where the differences are, and merge in/overwrite with the osCMax 2 data. I use kdiff3 or BeyondCompare for this.

[kenlyle]

I think that there are some things in admin_files that are important, too.

I am going to backup my admin_files table, then blow in the copy from Max2, and see what that does.

K

[kenlyle]

OK, Infobox Admin shows up now in my Admin page menu, just that there are no boxes.

[kenlyle]

I did the diff. It looks like the only good things in my old configuration table that weren't in the new one relate to my shipping and payment module and PayPal, and some MoPics stuff that is probably just somewhere else.

So I figured I would just deal with fixing those items. I backed up my configuration and configuration_group tables and copied in the ones from the oscmax2 RC2.

Still no Infoboxes to Admin show up in my catalog/admin/infobox_configuration.php

What to try next?

Thanks,
Ken

[michael_s]

Did you add the tables and data for the infoboxes?

Specifically: theme_configuration

Should have 20 records in it...

CREATE TABLE `theme_configuration` (                                
                       `configuration_id` int(11) NOT NULL auto_increment,               
                       `configuration_title` varchar(64) NOT NULL default '',            
                       `configuration_key` varchar(64) NOT NULL default 'BOX_HEADING_',  
                       `configuration_value` varchar(255) NOT NULL default '',           
                       `configuration_description` varchar(255) NOT NULL default '',     
                       `configuration_group_id` int(11) NOT NULL default '1',            
                       `configuration_column` varchar(64) NOT NULL default 'left',       
                       `location` int(5) NOT NULL default '0',                           
                       `sort_order` int(5) default NULL,                                 
                       `last_modified` datetime default NULL,                            
                       `date_added` datetime NOT NULL default '0000-00-00 00:00:00',     
                       `box_heading` varchar(64) NOT NULL default '',                    
                       PRIMARY KEY  (`configuration_id`)                                 
                     ) TYPE=MyISAM

/*Data for the table `theme_configuration` */

insert into `theme_configuration` values (1,'best sellers','BOX_HEADING_BEST_SELLERS','no','Display Best Sellers box?',1,'left',12,1,'2005-04-01 12:31:54','2003-04-15 11:01:05','');
insert into `theme_configuration` values (3,'currencies','BOX_HEADING_CATEGORIES_CURRENCIES','yes','Display Currencies box?',1,'right',8,3,'2003-04-15 18:16:37','2003-04-15 11:01:05','');
insert into `theme_configuration` values (5,'information','BOX_HEADING_INFORMATION','yes','Display Information box?',1,'left',7,5,'2005-02-22 19:36:38','2003-04-15 11:01:05','');
insert into `theme_configuration` values (6,'languages','BOX_HEADING_LANGUAGES','yes','Display Languages box?',1,'right',7,6,'2003-04-15 18:16:33','2003-04-15 11:01:05','');
insert into `theme_configuration` values (7,'manufacturer info','BOX_HEADING_MANUFACTURER_INFO','yes','Display Manufacturer Info box?',1,'right',9,7,'2003-04-15 18:40:37','2003-04-15 11:01:05','');
insert into `theme_configuration` values (8,'manufacturers','BOX_HEADING_MANUFACTURERS','no','Display Manufacturers box?',1,'left',6,8,'','2003-04-15 11:01:05','Manufactures');
insert into `theme_configuration` values (9,'order history','BOX_HEADING_ORDER_HISTORY','yes','Display Order History box?',1,'right',4,9,'2005-02-22 18:29:03','2003-04-15 11:01:05','');
insert into `theme_configuration` values (10,'product notifications','BOX_HEADING_PRODUCT_NOTIFICATIONS','yes','Display Product Notifications box?',1,'right',9,10,'2003-04-17 01:32:54','2003-04-15 11:01:05','');
insert into `theme_configuration` values (11,'reviews','BOX_HEADING_REVIEWS','yes','Display Reviews box?',1,'right',6,11,'2003-04-15 18:16:22','2003-04-15 11:01:05','');
insert into `theme_configuration` values (12,'search','BOX_HEADING_SEARCH','yes','Display Search box?',1,'left',5,12,'','2003-04-15 11:01:05','Quick Find');
insert into `theme_configuration` values (13,'shopping cart','BOX_HEADING_SHOPPING_CART','yes','Display Shopping Cart box?',1,'right',1,13,'2005-02-23 22:16:01','2003-04-15 11:01:05','');
insert into `theme_configuration` values (14,'specials','BOX_HEADING_SPECIALS','yes','Display Specials box?',1,'right',5,14,'2003-04-15 18:16:17','2003-04-15 11:01:05','Specials');
insert into `theme_configuration` values (15,'tell a friend','BOX_HEADING_TELL_A_FRIEND','yes','Display Tell a Friend box?',1,'right',4,15,'2003-04-15 18:16:03','2003-04-15 11:01:05','');
insert into `theme_configuration` values (16,'what\'s new','BOX_HEADING_WHATS_NEW','yes','Display What\'s New? box?',1,'left',4,16,'','2003-04-15 11:01:05','What\'s New');
insert into `theme_configuration` values (26,'articles','BOX_HEADING_ARTICLES','no','',1,'right',10,(null),'','0000-00-00 00:00:00','Articles');
insert into `theme_configuration` values (25,'loginbox','BOX_HEADING_LOGIN_BOX','yes','',1,'right',2,(null),'2005-02-23 22:16:12','0000-00-00 00:00:00','Sign In');
insert into `theme_configuration` values (28,'affiliate','BOX_HEADING_AFFILIATE','yes','',1,'left',3,(null),'','0000-00-00 00:00:00','Affiliates');
insert into `theme_configuration` values (2,'categories','BOX_HEADING_CATEGORIES','yes','',1,'left',1,(null),'','0000-00-00 00:00:00','Categories');
insert into `theme_configuration` values (22,'wishlist','BOX_HEADING_CUSTOMER_WISHLIST','yes','',1,'right',3,(null),'2005-02-22 18:28:48','0000-00-00 00:00:00','My Wish List');
insert into `theme_configuration` values (29,'Authors','BOX_HEADING_AUTHORS','no','',1,'right',11,(null),'','0000-00-00 00:00:00','Authors');

[kenlyle]

I typed this into the Quick Reply once, and it was apparently lost. This time will be quicker and dirtier.

-Copy your 1.7 database, structure and data, to a new database
-Apply my mysqldiff from the other thread
-Rename your configuration and configuration_group and theme_configuration tables for backup
-Copy in those tables from an OSCMax2 database
-Reinstall your payment modules, shipping zones, copy over your images, and pretty up.

This will give you a functional store, hopefully.

I still need help in finding all my text bits, like my Privacy Policy, Shipping and Returns, etc., and copying them over. I'd appreciate some tips.

Thanks,
Ken

[michael_s]

For copying privacy, etc, just go to your web site, and copy the text right off the page, then paste it into the wysiwyg editor in the osCMax 2 admin for that particular page and submit. Done.

Very easy to do and repeat it for each static page...