snubbr.com

Question about http+Verisign SSL (https) when submitting forms?

Get a Verisign SSL certificate for 30 days FREE. Click here to use coupon...

Get a free trial of Verisign SSL certificates. Click here for this special deal...
First of all Question about http+Verisign SSL (https) when submitting forms? Thanks for any response. Another question I got... Hi there,.

I am attempting to add a small contribution called "Other Products in This Category Module" and need to load some simple SQL (below). However, when I do so I receive an error which says...................

INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES ('49', 'Products in Category', 'Settings for Other Products in Category Module', '16', '1');.

INSERT INTO configuration VALUES ('', 'Enable Modul?', 'KDU_ENABLE', 'true', 'Enable or disable showing this modul', 49, 1, now(), now(), NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');.

INSERT INTO configuration VALUES ('', 'Max. Number of Products to Display', 'KDU_MAX_NR_PRODUCTS', '15', 'How many products will be shown in this module', 49, 2, now(), now(), NULL, NULL);.

INSERT INTO configuration VALUES ('', 'Thumbnail Image Height (Pixel)', 'KDU_MAX_IMAGE_H', '30', 'Enter thumbnail image height in pixel', 49, 3, now(), now(), NULL, NULL);.

INSERT INTO configuration VALUES ('', 'Thumbnail Image Width (Pixel)', 'KDU_MAX_IMAGE_W', '30', 'Enter thumbnail image width in pixel', 49, 4, now(), now(), NULL, NULL);.

INSERT INTO configuration VALUES ('', 'Sort Column', 'KDU_SORT_OPTION', 'Max. Viewed', 'Sort column', 49, 8, now(), now(), NULL, 'tep_cfg_select_option(array(\'Max. Viewed\',\'Date Added\',\'Product Price\',\'Product Name\',\'Quantity\'),');.

INSERT INTO configuration VALUES ('', 'Sort Order ASC/DESC', 'KDU_SORT_TYPE', 'DESC', 'Sort.

Please would someone point out where I have gone wrong? I must have missed something basic!.

Many thanks..

Paul..

Comments (58)

Hmm... I need to find out myself. I don't know what is the answer. I'll do some research and get back to you if I discover an answer. You should email the people at Verisign as they probably know..

Comment #1

Is that the entire script you have posted ? .

To me it seems to be missing an end (this is what I added) but obviously not right!.

Nic..

Comment #2

This is the whole script from the install instructions........

INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES ('49', 'Products in Category', 'Settings for Other Products in Category Module', '16', '1');.

INSERT INTO configuration VALUES ('', 'Enable Modul?', 'KDU_ENABLE', 'true', 'Enable or disable showing this modul', 49, 1, now(), now(), NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');.

INSERT INTO configuration VALUES ('', 'Max. Number of Products to Display', 'KDU_MAX_NR_PRODUCTS', '15', 'How many products will be shown in this module', 49, 2, now(), now(), NULL, NULL);.

INSERT INTO configuration VALUES ('', 'Thumbnail Image Height (Pixel)', 'KDU_MAX_IMAGE_H', '30', 'Enter thumbnail image height in pixel', 49, 3, now(), now(), NULL, NULL);.

INSERT INTO configuration VALUES ('', 'Thumbnail Image Width (Pixel)', 'KDU_MAX_IMAGE_W', '30', 'Enter thumbnail image width in pixel', 49, 4, now(), now(), NULL, NULL);.

INSERT INTO configuration VALUES ('', 'Sort Column', 'KDU_SORT_OPTION', 'Max. Viewed', 'Sort column', 49, 8, now(), now(), NULL, 'tep_cfg_select_option(array(\'Max. Viewed\',\'Date Added\',\'Product Price\',\'Product Name\',\'Quantity\'),');.

INSERT INTO configuration VALUES ('', 'Sort Order ASC/DESC', 'KDU_SORT_TYPE', 'DESC', 'Sort order (ASC:Ascending, DESC:Descending)', 49, 9, now(), now(), NULL, 'tep_cfg_select_option(array(\'ASC\',\'DESC\'),');.

Thanks again!..

Comment #3

Must be a problem your end as it ran fine on my localhost machine..

Is the whole code going into the box or are you uploading it?..

Comment #4

Now that is strange. I copied and pasted the whole code again and it failed. So I then imported the text file and it worked..

I have no idea how or why that happened, but it worked..

Thanks for the help!!.

Paul..

Comment #5

Hi there,.

I am attempting to add a small contribution called "Other Products in This Category Module" and need to load some simple SQL (below). However, when I do so I receive an error which says...................

INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES ('49', 'Products in Category', 'Settings for Other Products in Category Module', '16', '1');.

INSERT INTO configuration VALUES ('', 'Enable Modul?', 'KDU_ENABLE', 'true', 'Enable or disable showing this modul', 49, 1, now(), now(), NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');.

INSERT INTO configuration VALUES ('', 'Max. Number of Products to Display', 'KDU_MAX_NR_PRODUCTS', '15', 'How many products will be shown in this module', 49, 2, now(), now(), NULL, NULL);.

INSERT INTO configuration VALUES ('', 'Thumbnail Image Height (Pixel)', 'KDU_MAX_IMAGE_H', '30', 'Enter thumbnail image height in pixel', 49, 3, now(), now(), NULL, NULL);.

INSERT INTO configuration VALUES ('', 'Thumbnail Image Width (Pixel)', 'KDU_MAX_IMAGE_W', '30', 'Enter thumbnail image width in pixel', 49, 4, now(), now(), NULL, NULL);.

INSERT INTO configuration VALUES ('', 'Sort Column', 'KDU_SORT_OPTION', 'Max. Viewed', 'Sort column', 49, 8, now(), now(), NULL, 'tep_cfg_select_option(array(\'Max. Viewed\',\'Date Added\',\'Product Price\',\'Product Name\',\'Quantity\'),');.

INSERT INTO configuration VALUES ('', 'Sort Order ASC/DESC', 'KDU_SORT_TYPE', 'DESC', 'Sort.

Please would someone point out where I have gone wrong? I must have missed something basic!.

Many thanks..

Paul..

Comment #6

Thanks for trying to help. Unfortunately I still get an error message (below).

Failed : 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 '; INSERT INTO configuration VALUES ('', 'Enable Modul?', 'KDU_ENABLE', 'true', '' at line 1.

Any thoughts are much appreciated as I can't see what is wrong with it!.

Paul..

Comment #7


This question was taken from a support group/message board and re-posted here so others can learn from it.

 

Categories: Home | Diet & Weight Management | Vitamins & Supplements | Herbs & Cleansing |

Sexual Health | Medifast Support | Nutrisystem Support | Medifast Questions |

Web Hosting | Web Hosts | Website Hosting | Hosting |

Web Hosting | GoDaddy | Digital Cameras | Best WebHosts |

Web Hosting FAQ | Web Hosts FAQ | Hosting FAQ | Hosting Group |

Hosting Questions | Camera Tips | Best Cameras To Buy | Best Cameras This Year |

Camera Q-A | Digital Cameras Q-A | Camera Forum | Nov 2010 - Cameras |

Oct 2010 - Cameras | Oct 2010 - DSLRs | Oct 2010 - Camera Tips | Sep 2010 - Cameras |

Sep 2010 - DSLRS | Sep 2010 - Camera Tips | Aug 2010 - Cameras | Aug 2010 - DSLR Tips |

Aug 2010 - Camera Tips | July 2010 - Cameras | July 2010 - Nikon Cameras | July 2010 - Canon Cameras |

July 2010 - Pentax Cameras | Medifast Recipes | Medifast Recipes Tips | Medifast Recipes Strategies |

Medifast Recipes Experiences | Medifast Recipes Group | Medifast Recipes Forum | Medifast Support Strategies |

Medifast Support Experiences |

 

(C) Copyright 2010 All rights reserved.