Zen Cart Logo
Forums / Addon Templates / testimonial manager sidebox error

testimonial manager sidebox error

Locked

Started by ctcentralinfo on 15 Jun 2006, 1:14 PM · Views: 7,885

Results 1 to 13 of 13
This thread is locked. New replies are disabled.
15 Jun 2006, 1:14 PM
#1
ctcentralinfo avatar

ctcentralinfo

Totally Zenned

Join Date:
Apr 2005
Posts:
853
Plugin Contributions:
0

testimonial manager sidebox error

I just installed the testimonial manager from Dehaw to a fresh installation of
zencart 1.3.0.1, but now I am getting this error:

1146 Table 'sonny1_booksjapan.TABLE_CUSTOMER_TESTIMONIALS' doesn't exist
in:
[select * FROM TABLE_CUSTOMER_TESTIMONIALS WHERE status = 1 ORDER BY rand() LIMIT 1]

Rich People scream, Wealthy people whisper

https://www.cooltechcentral.com

24 Jun 2006, 4:30 AM
#2
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,515
Plugin Contributions:
176

Re: testimonial manager sidebox error

Sounds like you didn't install the file that defines the TABLE_CUSTOMER_TESTIMONIALS value.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

3 Feb 2008, 1:41 AM
#3
27gerd27 avatar

27gerd27

New Zenner

Join Date:
Nov 2006
Posts:
32
Plugin Contributions:
0

Re: testimonial manager sidebox error

Hi,
maybe someone can help me.
If i run the sql patch i allways get the return:

1136 Column count doesn't match value count at row 1
in:
[INSERT INTO TSconfiguration_group VALUES (NULL, 'Testimonials Manager', 'Testimonials Manager Display Settings', '1', '1');]
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.

what does that mean? And what can i do?

Thank you for your help

Gerd

3 Feb 2008, 2:30 AM
#4
clydejones avatar

clydejones

Deceased

Join Date:
Nov 2005
Location:
Colorado Springs, CO USA
Posts:
7,017
Plugin Contributions:
12

Re: testimonial manager sidebox error

27gerd27:

Hi,
maybe someone can help me.
If i run the sql patch i allways get the return:

1136 Column count doesn't match value count at row 1
in:
[INSERT INTO TSconfiguration_group VALUES (NULL, 'Testimonials Manager', 'Testimonials Manager Display Settings', '1', '1');]
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.

what does that mean? And what can i do?

Thank you for your help

Gerd

Is this a fresh install of Testimonial Manager or an upgrade?

Did you copy and paste the sql statement into admin -> install SQL patches and then run the statement from there?

Note: further questions about Testimonial Manager should be posted in this thread.

NOTE: We are sorry that Clyde is no longer with us.
We are grateful for all his contributions to the Zen Cart community.

16 Jun 2008, 11:19 PM
#5
rwj avatar

rwj

New Zenner

Join Date:
Jan 2008
Posts:
12
Plugin Contributions:
0

Re: testimonial manager sidebox error

New install of testimonial manager, clicking on any of the links -- read more, all or add a testimonial returns a page not found error. Zen-Cart version 1.3.8a currently running on machine. Can view the testimonial in admin.

17 Jun 2008, 12:17 AM
#6
clydejones avatar

clydejones

Deceased

Join Date:
Nov 2005
Location:
Colorado Springs, CO USA
Posts:
7,017
Plugin Contributions:
12

Re: testimonial manager sidebox error

rwj:

New install of testimonial manager, clicking on any of the links -- read more, all or add a testimonial returns a page not found error. Zen-Cart version 1.3.8a currently running on machine. Can view the testimonial in admin.

URL for your site?

NOTE: We are sorry that Clyde is no longer with us.
We are grateful for all his contributions to the Zen Cart community.

17 Jun 2008, 4:05 AM
#8
clydejones avatar

clydejones

Deceased

Join Date:
Nov 2005
Location:
Colorado Springs, CO USA
Posts:
7,017
Plugin Contributions:
12

Re: testimonial manager sidebox error

rwj:

Site is still in development mode--but can be viewed at
https://www.creativepetfurniture.com/zencart/index.php.

Apparently you are missing the three template files for those pages.

Make sure you have uploaded ALL the files listed.

Change the YOUR_TEMPLATE folder to match the name of your custom template (in your case creative)

includes/extra_datafiles/testimonials_manager_filenames.php
includes/functions/testimonials.php
includes/languages/english/extra_definitions/YOUR_TEMPLATE/testimonials_manager_defines.php
includes/languages/english/YOUR_TEMPLATE/testimonials_add.php
includes/languages/english/YOUR_TEMPLATE/testimonials_manager.php
includes/languages/english/YOUR_TEMPLATE/testimonials_manager_all_testimonials.php
includes/languages/english/html_includes/define_testimonials_add.php
includes/languages/english/html_includes/YOUR_TEMPLATE/define_testimonials_add.php
includes/modules/pages/testimonials_add
includes/modules/pages/testimonials_manager
includes/modules/pages/testimonials_manager_all_testimonials
includes/modules/sideboxes/YOUR_TEMPLATE/testimonials_manager.php
includes/templates/YOUR_TEMPLATE/sideboxes/tpl_testimonials_manager.php
includes/templates/YOUR_TEMPLATE/templates/tpl_testimonials_add_default.php
includes/templates/YOUR_TEMPLATE/templates/tpl_testimonials_manager_all_testimonials_default.php
includes/templates/YOUR_TEMPLATE/templates/tpl_testimonials_manager_default.php
includes/templates/YOUR_TEMPLATE/css/testimonials_add.css
includes/templates/YOUR_TEMPLATE/css/testimonials_manager.css
includes/templates/YOUR_TEMPLATE/css/testimonials_manager_all_testimonials.css

NOTE: We are sorry that Clyde is no longer with us.
We are grateful for all his contributions to the Zen Cart community.

17 Jun 2008, 8:47 PM
#9
rwj avatar

rwj

New Zenner

Join Date:
Jan 2008
Posts:
12
Plugin Contributions:
0

Re: testimonial manager sidebox error

Thanks Clyde. I really appreciate your help. I had placed the files for the modules/pages in the wrong directory. This add-on works and looks great. A great job. Thanks again.

27 Jun 2008, 1:00 AM
#10
jkempton avatar

jkempton

New Zenner

Join Date:
Sep 2006
Posts:
11
Plugin Contributions:
0

Re: testimonial manager sidebox error

Hello everybody. I just installed the testimonials manager and for some reason testimonial shows in the browser bar on home page and also when i select a product it shows as the heading and logging in to cart it also shows in heading.Has anybody had this problem or can someone help me fix this error? Thanks in advance for all your help.

27 Jun 2008, 1:26 AM
#11
clydejones avatar

clydejones

Deceased

Join Date:
Nov 2005
Location:
Colorado Springs, CO USA
Posts:
7,017
Plugin Contributions:
12

Re: testimonial manager sidebox error

jkempton:

Hello everybody. I just installed the testimonials manager and for some reason testimonial shows in the browser bar on home page and also when i select a product it shows as the heading and logging in to cart it also shows in heading.Has anybody had this problem or can someone help me fix this error? Thanks in advance for all your help.

Make sure that you have renamed ALL the YOUR_TEMPLATE folders to match the name of your custom template.

Make sure the following files have been uploaded to your server.
includes/extra_datafiles/testimonials_manager_filenames.php
includes/functions/testimonials.php
includes/languages/english/extra_definitions/YOUR_TEMPLATE/testimonials_manager_defines.php
includes/languages/english/YOUR_TEMPLATE/testimonials_add.php
includes/languages/english/YOUR_TEMPLATE/testimonials_manager.php
includes/languages/english/YOUR_TEMPLATE/testimonials_manager_all_testimonials.php
includes/languages/english/html_includes/define_testimonials_add.php
includes/languages/english/html_includes/YOUR_TEMPLATE/define_testimonials_add.php
includes/modules/pages/testimonials_add
includes/modules/pages/testimonials_manager
includes/modules/pages/testimonials_manager_all_testimonials
includes/modules/sideboxes/YOUR_TEMPLATE/testimonials_manager.php
includes/templates/YOUR_TEMPLATE/sideboxes/tpl_testimonials_manager.php
includes/templates/YOUR_TEMPLATE/templates/tpl_testimonials_add_default.php
includes/templates/YOUR_TEMPLATE/templates/tpl_testimonials_manager_all_testimonials_default.php
includes/templates/YOUR_TEMPLATE/templates/tpl_testimonials_manager_default.php
includes/templates/YOUR_TEMPLATE/css/testimonials_add.css
includes/templates/YOUR_TEMPLATE/css/testimonials_manager.css
includes/templates/YOUR_TEMPLATE/css/testimonials_manager_all_testimonials.css

NOTE: We are sorry that Clyde is no longer with us.
We are grateful for all his contributions to the Zen Cart community.

27 Jun 2008, 1:31 AM
#12
clydejones avatar

clydejones

Deceased

Join Date:
Nov 2005
Location:
Colorado Springs, CO USA
Posts:
7,017
Plugin Contributions:
12

Re: testimonial manager sidebox error

Please post any future inquires about Testimonial Manager [in the proper forum and topic

](http://www.zen-cart.com/forum/showthread.php?t=55604)

NOTE: We are sorry that Clyde is no longer with us.
We are grateful for all his contributions to the Zen Cart community.

27 Jun 2008, 2:39 PM
#13
jkempton avatar

jkempton

New Zenner

Join Date:
Sep 2006
Posts:
11
Plugin Contributions:
0

Re: testimonial manager sidebox error

Sorry,
Thanks again for your help.