Page 1 of 2 12 LastLast
Results 1 to 10 of 12

No Products in Categories box

This is a discussion on No Products in Categories box within the osCMax v2 Features Discussion forums, part of the osCmax v2.0 Forums category; In my new RC2 install, with my converted 1.7 database, I get NO Infoboxes at all displaying. In the admin, ...

      
  1. #1
    Member
    Join Date
    Jul 2005
    Posts
    91
    Rep Power
    0


    Default No Products in Categories box

    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

  2. #2
    osCMax Developer

    michael_s's Avatar
    Join Date
    Jul 2002
    Location
    Phoenix, AZ
    Posts
    19,501
    Rep Power
    567


    Default RE: No Products in Categories box

    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...
    Michael Sasek
    osCMax Developer


    osCmax installation service - Have our professionals install osCmax on your server - same day service!
    osCmax 2.0 User Manual - the must have beginners guide to osCmax v2.0

    Stay Up To Date with everything osCMax:
    Free osCMax Newsletters - Security notices, New Releases, osCMax News
    osCMax on Twitter - Up to the minute info as it happens. Know it first.

    osCmax Documentation

  3. #3
    Member
    Join Date
    Jul 2005
    Posts
    91
    Rep Power
    0


    Default OK, is there a quick way to do that?

    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

  4. #4
    osCMax Developer

    michael_s's Avatar
    Join Date
    Jul 2002
    Location
    Phoenix, AZ
    Posts
    19,501
    Rep Power
    567


    Default RE: OK, is there a quick way to do that?

    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.
    Michael Sasek
    osCMax Developer


    osCmax installation service - Have our professionals install osCmax on your server - same day service!
    osCmax 2.0 User Manual - the must have beginners guide to osCmax v2.0

    Stay Up To Date with everything osCMax:
    Free osCMax Newsletters - Security notices, New Releases, osCMax News
    osCMax on Twitter - Up to the minute info as it happens. Know it first.

    osCmax Documentation

  5. #5
    Member
    Join Date
    Jul 2005
    Posts
    91
    Rep Power
    0


    Default Right

    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

  6. #6
    Member
    Join Date
    Jul 2005
    Posts
    91
    Rep Power
    0


    Default RE: Right

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

  7. #7
    Member
    Join Date
    Jul 2005
    Posts
    91
    Rep Power
    0


    Default Diff of Configuration Tables Complete

    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

  8. #8
    osCMax Developer

    michael_s's Avatar
    Join Date
    Jul 2002
    Location
    Phoenix, AZ
    Posts
    19,501
    Rep Power
    567


    Default RE: Diff of Configuration Tables Complete

    Did you add the tables and data for the infoboxes?

    Specifically: theme_configuration

    Should have 20 records in it...

    Code:
    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
    Code:
    /*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');
    Michael Sasek
    osCMax Developer


    osCmax installation service - Have our professionals install osCmax on your server - same day service!
    osCmax 2.0 User Manual - the must have beginners guide to osCmax v2.0

    Stay Up To Date with everything osCMax:
    Free osCMax Newsletters - Security notices, New Releases, osCMax News
    osCMax on Twitter - Up to the minute info as it happens. Know it first.

    osCmax Documentation

  9. #9
    Member
    Join Date
    Jul 2005
    Posts
    91
    Rep Power
    0


    Default 1.7 to 2.0 Conversion Strategy

    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

  10. #10
    osCMax Developer

    michael_s's Avatar
    Join Date
    Jul 2002
    Location
    Phoenix, AZ
    Posts
    19,501
    Rep Power
    567


    Default RE: 1.7 to 2.0 Conversion Strategy

    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...
    Michael Sasek
    osCMax Developer


    osCmax installation service - Have our professionals install osCmax on your server - same day service!
    osCmax 2.0 User Manual - the must have beginners guide to osCmax v2.0

    Stay Up To Date with everything osCMax:
    Free osCMax Newsletters - Security notices, New Releases, osCMax News
    osCMax on Twitter - Up to the minute info as it happens. Know it first.

    osCmax Documentation

Page 1 of 2 12 LastLast

Similar Threads

  1. Link all products in categories box
    By giuspy in forum osCmax v1.7 Discussion
    Replies: 0
    Last Post: 02-15-2006, 02:39 AM
  2. No Products in Categories box
    By kenlyle in forum osCmax v1.7 Discussion
    Replies: 2
    Last Post: 11-06-2005, 07:31 AM
  3. Directory of categories-products
    By damnedpig in forum osCmax v1.7 Discussion
    Replies: 7
    Last Post: 06-28-2005, 07:46 PM
  4. import products and categories only
    By jloyzaga in forum osCmax v1.7 Discussion
    Replies: 7
    Last Post: 09-05-2003, 12:17 PM
  5. Number of products in categories
    By don in forum osCommerce 2.2 Installation Help
    Replies: 4
    Last Post: 03-07-2003, 05:20 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •