Testimonial Manager Support Thread

[clydejones]

Hi Clyde,
That's not the file I changed. I believe that file is from:

\new_installation\includes\extra_datafiles\testimonials_manager_filenames.php

The file I had had to edit is this one:

\new_installation\admin\includes\extra_datafiles\testimonials_manager.php

It might just be my server settings though because nobody else seems to have this problem.

Chris. :)

that file shouldn't effect the functioning of the mod on the "store" side. It would effect the functioning of things on the admin side though.

[HeathenMagic]

Hello Clyde,

Yeah sorry about that, I have regained my senses and found the right thread! ha.
Basically, I get this error after I run the upgrade to update my existing testimonial manager install. I renamed template folders and made sure my files uploaded. I have experienced similar thing before and I don't know if it is to do with prefix. The SQL passed through perfectly though.

1054 Unknown column 'language_id' in 'where clause'
in:
[select testimonials_id, testimonials_image, testimonials_title, testimonials_html_text, date_added from zen_testimonials_manager where status = 1 and language_id = 1 order by rand(), testimonials_title limit 5]

Thanks in advance!

[clydejones]

Hello Clyde,

Yeah sorry about that, I have regained my senses and found the right thread! ha.
Basically, I get this error after I run the upgrade to update my existing testimonial manager install. I renamed template folders and made sure my files uploaded. I have experienced similar thing before and I don't know if it is to do with prefix. The SQL passed through perfectly though.



Thanks in advance!

run this sql statement.

copy and paste into:

admin -> tools -> install sql patches and click the send button

ALTER TABLE `testimonials_manager` ADD `language_id` INT( 11 ) NOT NULL DEFAULT '0' AFTER `testimonials_id` ;

[HeathenMagic]

Many thanks Clyde,

That stopped the error showing up. The sidebox doesn't seem to show at the moment, and I checked the page that shows the testimonials and that has the bottom icons only.

http://www.thegemtree.com/index.php?...l_testimonials

Do I have to use the ALTER TABLE for other of the sql components do you think?

[clydejones]

Many thanks Clyde,

That stopped the error showing up. The sidebox doesn't seem to show at the moment, and I checked the page that shows the testimonials and that has the bottom icons only.

http://www.thegemtree.com/index.php?...l_testimonials

Do I have to use the ALTER TABLE for other of the sql components do you think?

You'll need to update the testimonials to reflect the language id.

run this sql statement:

copy and paste into admin -> tools -> install sql patches and click the send button.

UPDATE `testimonials_manager` SET `language_id` = '1' WHERE `language_id` =0 ;

[HeathenMagic]

WOW! Thanks that did the trick!

[daneh]

Clyde,

Quick question on the mod...When I try to activate it thru admin, I get two different scenarios. ( there is a testimonial written )

1. when enabling for the right sidebox, nothing.
2. when enabling for the left sidebox, everything disappears except the information box, but that ends up in the center of the page.

If I knew how to post a screenshot, I would.
Here is a link though....http://hiddenhillsnursery.com/Shopping Cart

I have this mod working on two other sites, but for some reason, I cannot get this one to work on this site.

Zen 1.3.8
Mother Earth template
PHP 4.4.8
More Information sidebox mod
Testimonials manager mod
Information sidebox mod
editable sideboxes mod

Not that it has anything to do with this issue, but the ez pages won't show either, left or right....coincidence?????