alibak Posted June 21, 2004 Posted June 21, 2004 hello, when I try to install the HTML editor's sql by using phpmyadmin and mysql 3.2347, I get the following error. (PLEASE NOTE: for the sake of privacy I've changed my database name to XXX in here) ------------------------ Error SQL-query : INSERT INTO configuration_group( configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible ) VALUES ( '112', 'WYSIWYG Editor 1.7', 'HTMLArea 1.7 Options', '15', '1' ) MySQL said: #1146 - Table 'XXX.configuration_group' doesn't exist -------------------------- Could anyone be kind enough to help me in this matter? thanks.
alibak Posted June 21, 2004 Author Posted June 21, 2004 I'm sorry but what do you mean by "tied to the database"?? Please clarify! But I think I'm tied to the database! :D
Guest Posted June 21, 2004 Posted June 21, 2004 in phpmyadmin you need to use the database, connecting to it, then you can run the script.
alibak Posted June 21, 2004 Author Posted June 21, 2004 Oh! yes. Of course, I'm tied to the database.... for sure. I know what you mean now! So now what? thanks for replies.
alibak Posted June 21, 2004 Author Posted June 21, 2004 this is an example of the begining of the sql file: INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES ('112', 'WYSIWYG Editor 1.7', 'HTMLArea 1.7 Options', '15', '1'); INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ('', 'PRODUCT DESCRIPTIONS use WYSIWYG HTMLAREA?', 'HTML_AREA_WYSIWYG_DISABLE', 'Enable', 'Enable/Disable WYSIWYG box', 112, 0, now(), now(), NULL, 'tep_cfg_select_option(array(\'Enable\', \'Disable\'),'); INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ('', 'Product Description Basic/Advanced Version?', 'HTML_AREA_WYSIWYG_BASIC_PD', 'Basic', 'Basic Features FASTER<br>Advanced Features SLOWER', 112, 10, now(), now(), NULL, 'tep_cfg_select_option(array(\'Basic\', \'Advanced\'),'); INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ('', 'Product Description Layout Width', 'HTML_AREA_WYSIWYG_WIDTH', '505', 'How WIDE should the HTMLAREA be in pixels (default: 505)', 112, 15, now(), now(), NULL, ''); INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ('', 'Product Description Layout Height', 'HTML_AREA_WYSIWYG_HEIGHT', '240', 'How HIGH should the HTMLAREA be in pixels (default: 240)', 112, 19, now(), now(), NULL, '');
Guest Posted June 21, 2004 Posted June 21, 2004 then you should check the database, to see if in fact the configuration_group table is in the database,
alibak Posted June 21, 2004 Author Posted June 21, 2004 just checked and the table exists! it's here... ! now what?
alibak Posted June 21, 2004 Author Posted June 21, 2004 could it be that it has something to do with the # of the table that it's not recognizing??? I mean, I'm not good in trouble shooting sql... but I think this 1.7 version has been working for most people (the html editor).... so don't understand why it doesn't recognize the configuration table??
alibak Posted June 21, 2004 Author Posted June 21, 2004 Look, I just noticed something: the error says: #1146 - Table 'XXX.configuration_group' doesn't exist NOW: the XXX is the prefix I chose for my database during oscommerce setup (it's not really XXX I've changed it here for sake of discussion). The error lies in between XXX and configuration in the name! there's a DOT (.) there!!! But in my tables it's not a DOT, rather it's an underscore (_)!! I bet this is the problem .... so now what????
Guest Posted June 21, 2004 Posted June 21, 2004 if you can see the table is there via phpmyadmin, then you should be able to run a query against it. try to open that table.
kwikone Posted June 21, 2004 Posted June 21, 2004 Well, in the .sql file you could add the following (at the top)... USE XXX; Where XXX is your database name and in this way you would not have to be connected to your database (which is why the first original question about being tied to the database was asked). (what did you mean by "prefix" :huh: ) since the "XXX.<table name>" is actually <database name>.<table name> which means phpMyAdmin was trying to use database XXX and the table was NOT there
241 Posted June 21, 2004 Posted June 21, 2004 this is an example of the begining of the sql file: INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES ('112', 'WYSIWYG Editor 1.7', 'HTMLArea 1.7 Options', '15', '1'); INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ('', 'PRODUCT DESCRIPTIONS use WYSIWYG HTMLAREA?', 'HTML_AREA_WYSIWYG_DISABLE', 'Enable', 'Enable/Disable WYSIWYG box', 112, 0, now(), now(), NULL, 'tep_cfg_select_option(array(\'Enable\', \'Disable\'),'); INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ('', 'Product Description Basic/Advanced Version?', 'HTML_AREA_WYSIWYG_BASIC_PD', 'Basic', 'Basic Features FASTER<br>Advanced Features SLOWER', 112, 10, now(), now(), NULL, 'tep_cfg_select_option(array(\'Basic\', \'Advanced\'),'); INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ('', 'Product Description Layout Width', 'HTML_AREA_WYSIWYG_WIDTH', '505', 'How WIDE should the HTMLAREA be in pixels (default: 505)', 112, 15, now(), now(), NULL, ''); INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ('', 'Product Description Layout Height', 'HTML_AREA_WYSIWYG_HEIGHT', '240', 'How HIGH should the HTMLAREA be in pixels (default: 240)', 112, 19, now(), now(), NULL, ''); have you tried placing the quotes around the table configuration_group to give `configuration_group` as all the rest of that sql appears to be using the quotes around the tables you need to make the sql more uniform one way or the other either with or without quotes. INSERT INTO `configuration_group` (`configuration_group_id`, `configuration_group_title`, `configuration_group_description`, `sort_order`, `visible`) VALUES ('112', 'WYSIWYG Editor 1.7', 'HTMLArea 1.7 Options', '15', '1'); try the above No longer giving free advice. Please place deposit in meter slot provided. Individual: [=] SME: [==] Corporation: [===] If deposit does not fit one of the slots provided then you are asking too much! Is your Osc dated try Phoenix raising oscommerce from the ashes.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.