Testimonial Manager Support Thread

[gaffettape]

Sorry to string this out over soooo many posts Clyde, but I have just one more very quick question.

Is it possible to add my sites title & tagline after the testimonials title in the following code:

// Testimonials:
  case 'testimonials_manager':
  define('META_TAG_TITLE', $page_check->fields['testimonials_title']);
  define('META_TAG_DESCRIPTION', zen_trunc_string($page_check->fields['testimonials_html_text'],TESTIMONIALS_MANAGER_DESCRIPTION_LENGTH));
  define('META_TAG_KEYWORDS', $page_check->fields['testimonials_title']);
  break;

Thanks.

[clydejones]

Sorry to string this out over soooo many posts Clyde, but I have just one more very quick question.

Is it possible to add my sites title & tagline after the testimonials title in the following code:

// Testimonials:
  case 'testimonials_manager':
  define('META_TAG_TITLE', $page_check->fields['testimonials_title']);
  define('META_TAG_DESCRIPTION', zen_trunc_string($page_check->fields['testimonials_html_text'],TESTIMONIALS_MANAGER_DESCRIPTION_LENGTH));
  define('META_TAG_KEYWORDS', $page_check->fields['testimonials_title']);
  break;

Thanks.

You should be able to add them as indicated by the highlight.

// Testimonials:
  case 'testimonials_manager':
  define('META_TAG_TITLE', $page_check->fields['testimonials_title'] . TITLE . TAGLINE);
  define('META_TAG_DESCRIPTION', zen_trunc_string($page_check->fields['testimonials_html_text'],TESTIMONIALS_MANAGER_DESCRIPTION_LENGTH));
  define('META_TAG_KEYWORDS', $page_check->fields['testimonials_title']);
  break;

[gaffettape]

You should be able to add them as indicated by the highlight.

// Testimonials:
  case 'testimonials_manager':
  define('META_TAG_TITLE', $page_check->fields['testimonials_title'] . TITLE . TAGLINE);
  define('META_TAG_DESCRIPTION', zen_trunc_string($page_check->fields['testimonials_html_text'],TESTIMONIALS_MANAGER_DESCRIPTION_LENGTH));
  define('META_TAG_KEYWORDS', $page_check->fields['testimonials_title']);
  break;

Perfect, thanks for your help Clyde

[cherylam1103]

Hello,
I have tried to install this module on my test offline site which is running Zen v1.3.9h, php version 5.3.5, database MySQL 5.5.8 and I am getting the following error in Zen when I run the install sql for the testimonial addon, can you please advise what issue is and let me know if you need any additional information. (I have changed YOUR_TEMPLATE folders to match mine which is CUSTOM.


1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 1
in:
[CREATE TABLE testimonials_manager ( testimonials_id int(11) NOT NULL auto_increment, language_id int(11) NOT NULL default '1', testimonials_title varchar(64) NOT NULL default '', testimonials_url VARCHAR( 255 ) NULL DEFAULT NULL, testimonials_name text NOT NULL, testimonials_image varchar(254) NOT NULL default '', testimonials_html_text text, testimonials_mail text NOT NULL, testimonials_company VARCHAR( 255 ) NULL DEFAULT NULL, testimonials_city VARCHAR( 255 ) NULL DEFAULT NULL, testimonials_country VARCHAR( 255 ) NULL DEFAULT NULL, testimonials_show_email char(1) default '0', status int(1) NOT NULL default '0', date_added datetime NOT NULL default '0000-00-00 00:00:00', last_update datetime NULL default NULL, PRIMARY KEY (testimonials_id) ) TYPE=MyISAM ;]
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.

Look forward to receiving assistance as this sound like a good addition to Zen.
Regards Cheryl.

[cherylam1103]

Hello,
I have tried to install this module on my test offline site which is running Zen v1.3.9h, php version 5.3.5, database MySQL 5.5.8 and I am getting the following error in Zen when I run the install sql for the testimonial addon, can you please advise what issue is and let me know if you need any additional information. (I have changed YOUR_TEMPLATE folders to match mine which is CUSTOM.

Look forward to receiving assistance as this sound like a good addition to Zen.
Regards Cheryl.

Ok I have since looked in Zen Configuration menu and Testimonials Manager is there however when I go to my test site I don't see it, do I need to setup anything else? I have added install part to my style sheet.

Regards Cheryl.

[cherylam1103]

Ok I have since looked in Zen Configuration menu and Testimonials Manager is there however when I go to my test site I don't see it, do I need to setup anything else? I have added install part to my style sheet.

Regards Cheryl.

Ok silly me didn't upload files. I have added install part to my style sheet and uploaded files, activated sidebox and am now getting below error on site where sideboxes should appear.

1146 Table 'aescrapb.testimonials_manager' doesn't exist
in:
[select testimonials_id, testimonials_image, testimonials_title, testimonials_html_text, date_added from testimonials_manager where status = 1 and language_id = 1 order by rand(), testimonials_title limit 5].

Any suggestions?
Regards Cheryl.

[cherylam1103]

Ok silly me didn't upload files. I have added install part to my style sheet and uploaded files, activated sidebox and am now getting below error on site where sideboxes should appear.

1146 Table 'aescrapb.testimonials_manager' doesn't exist
in:
[select testimonials_id, testimonials_image, testimonials_title, testimonials_html_text, date_added from testimonials_manager where status = 1 and language_id = 1 order by rand(), testimonials_title limit 5].

Any suggestions?
Regards Cheryl.

Sorry, me again This now goes back to original problem I think. I ran the install sql in my phpMyAdmin on my data base and got the same error as before; #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 18

As I don't know to much about syntax I cannot workout what is not right in sql. The end of the install script has the following;
... `last_update` datetime NULL default NULL,
PRIMARY KEY (`testimonials_id`)
) TYPE=MyISAM ;

INSERT INTO `testimonials_manager` VALUES (1, 1, 'Great', '', 'Clyde Designs', '', 'This is just a test submission to show you how it looks, great, eh?', '[email protected]', NULL, NULL, NULL, 0, 1, now(), NULL);

Can you please advise what issue is with syntax in install script, thanks.
Cheryl.