Testimonial Manager Support Thread (for ZC v1.5.x)

[jsarwar]

Please re-read my post.. I state what's missing..

I read that but I am not good on sql so if you don't mind can you tell me what I need to type/put in for numinix column in sql to make it go through on my site?

[davewest]

I read that but I am not good on sql so if you don't mind can you tell me what I need to type/put in for numinix column in sql to make it go through on my site?

so... basically, you have more or less columns in the configuration table then data you are trying to fit in. Should only be 11 for the standard ZC Config table. I for one have no idea what you have in there... or why anyone would change it. makes upgrading ZC very hard to do. So, look at the table with phpmyadmin and see what the structure is and fill in the blank... this is the standard 11 column table..

(`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`)

You will have to fill in the blank at the same location it shows with in your config structure.. hopefully at the end... so 'set_function', NULL) you would have to figure out what goes there... NULL is just a common guess, a coma would get you there too.

What ever mod you install that adds to the configuration table may have the same issues so keep notes and be aware of it.

[DivaVocals]

so... basically, you have more or less columns in the configuration table then data you are trying to fit in. Should only be 11 for the standard ZC Config table. I for one have no idea what you have in there... or why anyone would change it. makes upgrading ZC very hard to do. So, look at the table with phpmyadmin and see what the structure is and fill in the blank... this is the standard 11 column table..

(`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`)

You will have to fill in the blank at the same location it shows with in your config structure.. hopefully at the end... so 'set_function', NULL) you would have to figure out what goes there... NULL is just a common guess, a coma would get you there too.

What ever mod you install that adds to the configuration table may have the same issues so keep notes and be aware of it.

I will bet MONEY it's a Numinix module.. they are the ONLY mod devs that added a column to the configuration table to support their custom tabbed view of the configuration settings for their modules. The change makes an overall change to the look/feel of ALL the configuration menus not just their own.. However, only the Numinix modules explicitly use this tabbed view.. The Numinix mods aren't having issues at all.. only those module (like this one which use the shortcut SQL which omits the column names from the SQL script)

And before the question gets asked in response to your post "how do I add the columns back", Chad already posted a few threads back that he submitted an update..

[mc12345678]

I will bet MONEY it's a Numinix module.. they are the ONLY mod devs that added a column to the configuration table to support their custom tabbed view of the configuration settings for their modules. The change makes an overall change to the look/feel of ALL the configuration menus not just their own.. However, only the Numinix modules explicitly use this tabbed view.. The Numinix mods aren't having issues at all.. only those module (like this one which use the shortcut SQL which omits the column names from the SQL script)

And before the question gets asked in response to your post "how do I add the columns back", Chad already posted a few threads back that he submitted an update..

The update is considered available for download. Like davewest suggested, the additional field(s) added to. The table are not addressed per se in the update, ie. If the other plugin(s) expect a value in that row, install of this plugin will assign whatever default value is expected and it is up to that other plugin(s) to correct/handle that default value.

Jsarwar has indicated that at least one numinix module was installed, but review of the provided sql (which does not include sql embedded in the code) did not show indication of modifying the table(s) that were preventing the installation. The change made removes the reliance on the number of columns and also allows certain fields to populate with default information. (Configuration_id for example) rather than guessing at the data type necessary (NULL or 0) to populate the field. It is therefore up to the table altering code to handle the new data that did not assign anything to the new field(s). This action would be expected of any plugin that modified core table fields in this way.

[yaritai]

This is why numinix posted that sql updates to the databse should not be done blindly and should include the column names.

[lat9]

This is why numinix posted that sql updates to the databse should not be done blindly and should include the column names.

Agreed; you never know when an additional field will be added to a table, whether by plugin or by Zen Cart upgrade.

[milkyway]

Good day folks.

I tried to display testimonials at the footer, I've done this at the past but now I can't figure it out.

I guess I'm too old for this coding stuff already

Please kindly give me a hint how to do that

Thanks!!

[robbie269]

How do I make the Testimonial Title field optional and delete it totally?

[countrycharm]

How do I make the Testimonial Title field optional and delete it totally?

I believe the file to edit is:
/includes/modules/pages/testimonials_add/header_php.php

[robbie269]

I believe the file to edit is:
/includes/modules/pages/testimonials_add/header_php.php

Thanks that did the trick.