"Attribute Required for Text" - what would make it stop working?

[cristaltech]

No Change. The folowing error when inserting the code:

1062 Duplicate entry 'PRODUCTS_OPTIONS_TYPE_SELECT' for key 2
in:
[INSERT INTO zen_configuration VALUES ('', 'Product option type Select', 'PRODUCTS_OPTIONS_TYPE_SELECT', '0', 'The number representing the Select type of product option.', 0, NULL, '2007-03-19 17:57:39', '2007-03-19 17:57:39', NULL, NULL);]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

[Ajeh]

Search your configuration table and check that each of those configuration_keys exist with the proper configuration_value ...

[cristaltech]

On search of the tables I get the error:
I ALSO get this error adding the table.
This I have done from PHPmyAdmin
Error
SQL query:

INSERT INTO `configuration`
VALUES (

'', 'Product option type Select', 'PRODUCTS_OPTIONS_TYPE_SELECT', '0', 'The number representing the Select type of product option.', 0, NULL , '2007-03-19 17:57:39', '2007-03-19 17:57:39', NULL , NULL
);



MySQL said:

#1146 - Table 'cristalt_zc2.configuration' doesn't exists

[Ajeh]

Sounds like you are using table prefixes ...

Browse the configuration table of your database ... this might be called something like zen_configuration or fred_configuration ...

Search for the configuration_key
PRODUCTS_OPTIONS_TYPE_SELECT
UPLOAD_PREFIX
TEXT_PREFIX

What configuration_values are these set to?

[CrystalKoi]

Hi Ajeh,

I am also having a similar problem on one of my sites too.

I have tired the other steps to fix this but a no go so far, here are the key and values for what you asked for

PRODUCTS_OPTIONS_TYPE_SELECT Has: 0
UPLOAD_PREFIX Has: upload_
TEXT_PREFIX Has: txt_


Hope you can help, if I find a solution I will post back.

Thanks

[CrystalKoi]

So I found my fix..funny isn't it always after you post the problem you understand it more!

So here was the fix for me

In IH_VERSION the settings were:

Image Handler Version IH_VERSION 2.0 This is used by image handler to check if the data... 0 100 NULL 2007-06-06 16:47:03 NULL zen_cfg_textarea_small(

I was missing '); on the end there for some reason.

So I just edited that section in phpmyadmin and now it works great!

Just had to read your sql patch and compare it to my settings, Thanks!

I hope that helps some other people out there.

[cristaltech]

Sounds like you are using table prefixes ...

Browse the configuration table of your database ... this might be called something like zen_configuration or fred_configuration ...

Search for the configuration_key
PRODUCTS_OPTIONS_TYPE_SELECT === 0
UPLOAD_PREFIX === upload_
TEXT_PREFIX === txt_

What configuration_values are these set to?

As above

[CrystalKoi]

Cristaltech,

What do you have for set_function?

Also do you have IH_VERSION and if so what do you have for set_function?

You should be able to look at the sql patch that Ajeh posted and see if it matches up.

The dates shouldn't matter.

PRODUCTS_OPTIONS_TYPE_SELECT', '0', 'The number representing the Select type of product option.', 0, NULL, '2007-03-19 17:57:39', '2007-03-19 17:57:39', NULL, NULL);

UPLOAD_PREFIX', 'upload_', 'Prefix used to differentiate between upload options and other options', 0, NULL, '2007-03-19 17:57:39', '2007-03-19 17:57:39', NULL, NULL);

TEXT_PREFIX', 'txt_', 'Prefix used to differentiate between text option values and other option values', 0, NULL, '2007-03-19 17:57:39', '2007-03-19 17:57:39', NULL, NULL);

IH_VERSION', '2.0', 'This is used by image handler to check if the database is up to date with uploaded image handler files.', 0, 100, NULL, '2007-06-06 16:47:03', NULL, 'zen_cfg_textarea_small(');


Hope that helps you more.

[Ajeh]

So here was the fix for me

In IH_VERSION the settings were:

Image Handler Version IH_VERSION 2.0 This is used by image handler to check if the data... 0 100 NULL 2007-06-06 16:47:03 NULL zen_cfg_textarea_small(

I was missing '); on the end there for some reason.

So I just edited that section in phpmyadmin and now it works great!

Thanks for posting that discovery ... very helpful to know ...

[japanophyle]

I had the same problem and it seems to fixed after installing the code Ajeh provided. I don't have Google Site map, but have a slew of other add-ons, not sure which is the culprit.

I have Super Orders 1.x (not new 2.0)
Quick Updates
Email Archive

And a few I commissioned for my site, not publicly released:
Monthly Reports
Email Updated Order (re-emails order after it has been edited)