maxrisc:
Duplicate post
Question, I have got it working but can't install the eBay categories when i try to do the import i get this error ERROR mysql_query: and a whole list of this ( not going to list it all)
DROP TABLE IF EXISTS ebay_categories; CREATE TABLE ebay_categories ( myid bigint(20) NOT NULL auto_increment, name varchar(100) NOT NULL default '', id int(11) NOT NULL default '0', parentid int(11) NOT NULL default '0', leaf set('0','1') default '0', PRIMARY KEY (myid)); -- --Data for table ebay_categories -- INSERT INTO ebay_categories VALUES (1, 'Antiques', 20081, 0, ''); INSERT INTO ebay_categories VALUES (2, 'Antiquities (Classical, Amer.)', 37903, 20081, ''); INSERT INTO ebay_categories VALUES (3, 'Egyptian', 37905, 37903, '1'); INSERT INTO ebay_categories VALUES (4, 'Greek', 37906, 37903, '1'); INSERT INTO ebay_categories VALUES (5, 'Roman', 37907, 37903, '1'); INSERT INTO ebay_categories VALUES (6, 'The Americas', 37908, 37903, '1'); INSERT INTO ebay_categories VALUES (7, 'Other', 73464, 37903, '1'); INSERT INTO ebay_categories VALUES (8, 'Architectural & Garden', 4707, 20081, ''); INSERT INTO ebay_categories VALUES (9, 'Ceiling Tins', 37909, 4707, '1'); INSERT INTO ebay_categories VALUES (10, 'Chandeliers, Fixtures, Sconces', 63516, 4707, '1'); INSERT INTO ebay_categories VALUES (11, 'Doors', 37910, 4707, '1'); INSERT INTO ebay_categories VALUES (12, 'Finials', 63517, 4707, '1'); INSERT INTO ebay_categories VALUES (13, 'Fireplaces, Mantles', 63518, 4707, '1'); INSERT INTO ebay_categories VALUES (14, 'Garden', 4708, 4707, '1'); INSERT INTO ebay_categories VALUES (15, 'Hardware', 37911, 4707, ''); INSERT INTO ebay_categories VALUES (16, 'Door Bells, Knockers', 37912, 37911, '1'); INSERT INTO ebay_categories VALUES (17, 'Hooks & Brackets', 37913, 37911, '1'); INSERT INTO ebay_categories VALUES (18, 'Knobs & Handles', 37914, 37911, '1'); INSERT INTO ebay_categories VALUES (19, 'Locks & Keys', 37915, 37911, '1'); INSERT INTO ebay_categories VALUES (20, 'Plates - Doors, Lights', 37916, 37911, '1'); INSERT INTO ebay_categories VALUES (21, 'Other', 66637, 37911, '1'); INSERT INTO ebay_categories VALUES (22, 'Signs', 63519, 4707, '1'); INSERT INTO ebay_categories VALUES (23, 'Stained Glass', 4771, 4707, '1'); INSERT INTO ebay_categories VALUES (24, 'Tiles', 37917, 4707, '1'); INSERT INTO ebay_categories VALUES (25, 'Weathervanes, Lightning Rods', 37918, 4707, '1'); INSERT INTO ebay_categories VALUES (26, 'Windows, Sashes, Locks', 63520, 4707, '1'); INSERT INTO ebay_categories VALUES (27, 'Other', 1207, 4707, '1'); INSERT INTO ebay_categories VALUES
then at the bottom it states this
1 eBay Categories successfully added to your database.
Your eBay categories have been successfully uploaded!
Now if i am thinking right when i make a listing i should be able to select a category for first category and second category right by a drop down list ?????
thank you for this mod
Robert Cooper
