Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

sql setup error in phpmyadmin and mysql 3.4


alibak

Recommended Posts

Posted

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.

Posted

did you make sure you are tied into the database?

Posted

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

Posted

in phpmyadmin you need to use the database, connecting to it, then you can run the script.

Posted

Oh! yes.

 

Of course, I'm tied to the database.... for sure.

 

I know what you mean now!

 

So now what?

 

thanks for replies.

Posted

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, '');

Posted

then you should check the database, to see if in fact the configuration_group table is in the database,

Posted

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??

Posted

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????

Posted

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.

Posted

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

Posted
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! :P

Is your Osc dated try Phoenix  raising oscommerce from the ashes.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...