2 missing tables - Please help.

[MissCC]

Hi! A customer order at my shop and when I check his details in page admin/orders.php I am getting this error:

 

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''' at line 1

 

select * from zones where zone_country_id = '0' and zone_name = 'cote d'or'

 

[TEP STOP]

 

 

 

Also in Products attribute I have this error:

 

1146 - Table 'misscc_shop.products_options_values_to_products_options' doesn't exist

 

select pov.products_options_values_id, pov.products_options_values_name, pov2po.products_options_id from products_options_values pov left join products_options_values_to_products_options pov2po on pov.products_options_values_id = pov2po.products_options_values_id where pov.language_id = '1' order by pov.products_options_values_id

 

[TEP STOP]

 

 

If someone can provide me those 2 missing tables that would be helpful! Thanks in advance.

[MissCC]

Is there any other sites/forums where I can ask because I really need those tables. Please let me know.

[Guest]

Looks like a bad install. I'd back the DB up and try to reinstall it again. Then just import the backed up sql back into the DB to get all your information back. Back the whole site up before you do anything like that tho, just incase.

 

Make sure not to install the test data again or you'll have to go back in and delete it all.

[spax]

I think the first error is because of the apostrophe in cote d'or.

Find that query and either escape it with a backslash so it looks like 'cote d\'or'

Or use two apostrophes, like 'cote d''or'

Or surround with double quotes "cote d'or"

 

The second error looks like you have either not updated your database, with the .sql file that came with a contribution you have installed or, you haven't updated database_tables.php in admin, catalog or both.

[MissCC]

Thanks for your answer. It is possible to find the table somewhere, I can then ad it to my sql , I am really scared to reinstall all my database and destroy everything...it happen to me before so I don't want to take the risk. :'(

[spax]

The second error looks like you have either not updated your database, with the .sql file that came with a contribution you have installed or, you haven't updated database_tables.php in admin, catalog or both.

 

Ignore the first part of that statement, as products_options_values_to_products_options is a native table to osC. I must have been tired or on the happy juice when I (didn't) read it before. However, you should still make sure the table is properly defined in admin/includes/database_tables.php. Have you had to make any changes to that file?

[MissCC]

Ignore the first part of that statement, as products_options_values_to_products_options is a native table to osC. I must have been tired or on the happy juice when I (didn't) read it before. However, you should still make sure the table is properly defined in admin/includes/database_tables.php. Have you had to make any changes to that file?

 

No never. I have to add t-shirts to my shop now and I absolutly need those tables for the Products Attributes (sizes). Is it possible to find that table somewhere without to reinstall the shop. I won't take that risk.

[MissCC]

I found it! Here it is if someone need it:

 

--

-- Table structure for table `products_options_values_to_products_options`

--

 

CREATE TABLE `products_options_values_to_products_options` (

`products_options_values_to_products_options_id` int(11) NOT NULL auto_increment,

`products_options_id` int(11) NOT NULL default '0',

`products_options_values_id` int(11) NOT NULL default '0',

PRIMARY KEY (`products_options_values_to_products_options_id`)

) TYPE=MyISAM AUTO_INCREMENT=45 ;

 

--

-- Dumping data for table `products_options_values_to_products_options`

--

 

INSERT INTO `products_options_values_to_products_options` VALUES (1, 4, 1);

INSERT INTO `products_options_values_to_products_options` VALUES (2, 4, 2);

INSERT INTO `products_options_values_to_products_options` VALUES (3, 4, 3);

INSERT INTO `products_options_values_to_products_options` VALUES (4, 4, 4);

INSERT INTO `products_options_values_to_products_options` VALUES (5, 3, 5);

INSERT INTO `products_options_values_to_products_options` VALUES (6, 3, 6);

INSERT INTO `products_options_values_to_products_options` VALUES (7, 3, 7);

INSERT INTO `products_options_values_to_products_options` VALUES (8, 3, 8);

INSERT INTO `products_options_values_to_products_options` VALUES (9, 3, 9);

INSERT INTO `products_options_values_to_products_options` VALUES (10, 5, 10);

INSERT INTO `products_options_values_to_products_options` VALUES (13, 5, 13);

INSERT INTO `products_options_values_to_products_options` VALUES (14, 6, 14);

INSERT INTO `products_options_values_to_products_options` VALUES (15, 6, 15);

INSERT INTO `products_options_values_to_products_options` VALUES (16, 2, 16);

INSERT INTO `products_options_values_to_products_options` VALUES (17, 3, 17);

INSERT INTO `products_options_values_to_products_options` VALUES (18, 2, 18);

INSERT INTO `products_options_values_to_products_options` VALUES (19, 2, 19);

INSERT INTO `products_options_values_to_products_options` VALUES (20, 7, 20);

INSERT INTO `products_options_values_to_products_options` VALUES (21, 7, 21);

INSERT INTO `products_options_values_to_products_options` VALUES (22, 7, 22);

INSERT INTO `products_options_values_to_products_options` VALUES (23, 7, 23);

INSERT INTO `products_options_values_to_products_options` VALUES (24, 7, 24);

INSERT INTO `products_options_values_to_products_options` VALUES (25, 7, 25);

INSERT INTO `products_options_values_to_products_options` VALUES (26, 8, 26);

INSERT INTO `products_options_values_to_products_options` VALUES (27, 2, 27);

INSERT INTO `products_options_values_to_products_options` VALUES (28, 6, 28);

INSERT INTO `products_options_values_to_products_options` VALUES (29, 6, 29);

INSERT INTO `products_options_values_to_products_options` VALUES (30, 6, 30);

INSERT INTO `products_options_values_to_products_options` VALUES (31, 6, 31);

INSERT INTO `products_options_values_to_products_options` VALUES (32, 6, 32);

INSERT INTO `products_options_values_to_products_options` VALUES (33, 6, 33);

INSERT INTO `products_options_values_to_products_options` VALUES (34, 6, 34);

INSERT INTO `products_options_values_to_products_options` VALUES (35, 9, 35);

INSERT INTO `products_options_values_to_products_options` VALUES (36, 9, 36);

INSERT INTO `products_options_values_to_products_options` VALUES (37, 9, 37);

INSERT INTO `products_options_values_to_products_options` VALUES (38, 9, 38);

INSERT INTO `products_options_values_to_products_options` VALUES (39, 9, 39);

INSERT INTO `products_options_values_to_products_options` VALUES (40, 9, 40);

INSERT INTO `products_options_values_to_products_options` VALUES (41, 9, 41);

INSERT INTO `products_options_values_to_products_options` VALUES (42, 9, 42);

INSERT INTO `products_options_values_to_products_options` VALUES (43, 9, 43);

INSERT INTO `products_options_values_to_products_options` VALUES (44, 9, 44);

 

-- --------------------------------------------------------