Kryptronic Software Support Forum

You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.

#1 07-11-2003 23:35:27

scoutch
Banned
Registered: 07-03-2003
Posts: 3167

apostrophize bug report

I have found a bug when putting an apostrophize in a word.

Example :

- "we're".

The apostrophize doesn't appear on the "admin" and customers page. Where in the programming area can I fix this bug ?


______________________________________________

THIS USER HAS BEEN BANNED FROM THIS FORUM.

If this post contains any language related to
code samples, advice, etc., please read this
entire thread before making a decision to use
this post as a basis for any change to your
software installation.
______________________________________________

Offline

 

#2 07-11-2003 23:37:17

scoutch
Banned
Registered: 07-03-2003
Posts: 3167

Re: apostrophize bug report

Another bug report :

I cannot put a "space" between : "we re" instead neither. The words will still be pulled together.


______________________________________________

THIS USER HAS BEEN BANNED FROM THIS FORUM.

If this post contains any language related to
code samples, advice, etc., please read this
entire thread before making a decision to use
this post as a basis for any change to your
software installation.
______________________________________________

Offline

 

#3 07-12-2003 17:02:55

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19798
Website

Re: apostrophize bug report

The first issue is a valid one, but what you want to do is use an apostrophe, not the single quote (reserved SQL character in CCP).  To get an apostrophe, hit ALT and 0146 at the same time.  Here's one:

we’re

not:

we're

The second issue is not valid.  Spaces are allowed in entries.  The characters that are not allowed at | and '.  For textbox entries, CCP strips " too.  But, that's only for textboxes, not textareas.

___________________________

Nick Hendler
Webmaster, Kryptronic, Inc.


Nick Hendler

Offline

 

#4 07-27-2003 18:42:14

Guest
Guest

Re: apostrophize bug report

This is absolutely ridiculous! Why should we users have to go through all the trouble to use the ALT-0146 to get an ''' character?

We have paid money for this software and expect it to be user friendly! x(

 

#5 07-27-2003 19:07:11

EagleWolf
Member
From: Daytona Beach, FL
Registered: 07-27-2003
Posts: 979

Re: apostrophize bug report

I just don't use conjunctions, oh I mean, I do not use conjuctions.



Thanks,
Chris
http://www.site_name_deleted.com
http://www.equivity.com - e-Commerce Website hosting starting at $5.95/month


Chris
<a href='mailto:webmaster@equivity.com'>webmaster@equivity.com</a>
-

Offline

 

#6 07-28-2003 01:19:45

Guest
Guest

Re: apostrophize bug report

An apostrophe has many other uses, such as "Kryptronic's most popular software, bla bla bla." Why should I try to make the above sentence sounds wierd by avoiding the apostrophe?

And in another instance, not every one is a computer guru person, so don't expect them to know what went wrong in the first place (or anyone who has little or no technical knowledge to maintain the online store with all these complications)! Just imagine, telling a data entry clerk, "hey you, whenever there is an apostrophe in the product description, rephrase it so that it doesn't show!" Absurd!

Such a bug could easily be avoided by doing a regular expression to replace the quote character with the apostrophe character on all form fields. Why is it not fixed I have no idea (this is the 5th major revision of the software!)

 

#7 07-28-2003 11:35:57

kevbo
Member
Registered: 01-13-2002
Posts: 52

Re: apostrophize bug report

<font size="1" color="#FF0000">LAST EDITED ON 07-28-03 AT 12:38 PM (EST)</font><p>Your assumption that this issue is a bug misses the mark completely.  You either missed the part about 'reserved character' or you simply do on understand what that means. Bottom line, there simply is nothing to 'fix' here regarding the program.
If you are not at all a computer guru, please speak to one regarding reserved characters in such things as SQL, PERL, and even HTML, and you will learn that they indeed exist  (outside of CCP) and they differ among languages. The person responsible for creating a web site will either know them or will quickly learn about them thru trial and error.

Programming languages have them and if you are going to rely on a 'data entry clerk' to set up and configure your e-commerce site without any knowledge of basic HTML, Perl, or SQL, you will be running into many 'bugs' as you call them!

Offline

 

#8 07-28-2003 12:07:45

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19798
Website

Re: apostrophize bug report

In response to this post, I've coded logic into 5.1 this morning, which has been fully tested, that automatically replaces the single quote character with the apostrophe character when doing inserts/updates/searches with admin and the frontend.

___________________________

Nick Hendler
Webmaster, Kryptronic, Inc.


Nick Hendler

Offline

 

#9 07-28-2003 19:04:11

Guest
Guest

Re: apostrophize bug report

That's what i call post customer service. ^_^

I DO know what are reserved words, and I understand SQL treats a single quote as a reserved word. But if you do a double quote (hitting the quote key twice), it escapes the first quote, meaning you can have quote entries in your databases, Kevbo. smile

There is no such thing as not possible, its only whether you want to do it or not.

I like Nick's attitude. You deserve a big THANK YOU from me!

Steven

 

#10 07-29-2003 20:24:44

Guest
Guest

Re: apostrophize bug report

5.1 release eh ? It is a free upgrade due to some bug issues or we will have to pay again for it ?

 

#11 07-29-2003 20:30:30

EagleWolf
Member
From: Daytona Beach, FL
Registered: 07-27-2003
Posts: 979

Re: apostrophize bug report

#########
######### New upgrade policy
#########

For the 5.1 tiki release, it has been determined that a scaled price upgrade policy should be in effect. This is the result of very positive user feedback on how to handle pricing the upgrades. The following cost structure will be used for 5.1 (initially):

Full version 5.1: $99.99 (on sale from $199.99)

Upgrade from 4.0: $79.99

Upgrade from 5.0: $49.99

Upgrade from 5.0 if you purchased 5.0 on or after 05/01/2003: $29.99





Thanks,
Chris
http://www.site_name_deleted.com
http://www.equivity.com - e-Commerce Website hosting starting at $5.95/month


Chris
<a href='mailto:webmaster@equivity.com'>webmaster@equivity.com</a>
-

Offline

 

#12 07-29-2003 23:21:23

Guest
Guest

Re: apostrophize bug report

So, for your mistakes, we have to pay the price to buy the corrections ? You're not serious ? !

It's insane. Why not just sending the corrections by e-mails from your database customers then, from 5.0, most of the programming issues will be fixed ?

 

#13 07-30-2003 00:13:01

Guest
Guest

Re: apostrophize bug report

Yes, I agree totally with Scoutch. Bug fixes should NOT be charged a cent! Since this is a minor version upgrade (5.x), it should be given free to existing version 5 customers.

I believe there are many of us who are happy with their existing copy of CCP5 (except for the bugs), and not particularly interested in the features upgrade.

I think paying $29 for the upgrade (or bug patch) for the minor release version is a rip off from us loyal customers.

Steven

 

#14 07-30-2003 01:00:27

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19798
Website

Re: apostrophize bug report

I maintain that this is not a bug, rather a minor annoyance.  There is nothing wrong with 5.0 - it was designed to operate in this manner.

There were changes made to over 3/4 of the files to support this in 5.1, however 99% of the work handled 1% of the issues.

If you want a quick solution for this, here it is:

In the file ./cgi-bin/library/common/database.pl

In the routines 'database_format' change the lines:

###

$return_value =~ s/n/ /gs;
$return_value =~ s/|/ /gs;
$return_value =~ s/\///gs;

$return_value =~ s/''/%27%27/gs;
$return_value =~ s/'//gs;
$return_value =~ s/%27%27/''/gs;

###

To read:

###

$return_value =~ s/n/ /gs;
$return_value =~ s/|/ /gs;
$return_value =~ s/\///gs;
$return_value =~ s/'/’/gs;
$return_value =~ s/"/’’/gs;

###

And in the routine 'database_quote' change the lines:

###

$string =~ s/n/ /gs;
$string =~ s/|/ /gs;
$string =~ s/\///gs;

$string =~ s/''/%27%27/gs;
$string =~ s/'//gs;
$string =~ s/%27%27/''/gs;

if ($execute_type eq "ste") {

$string =~ s/"/''/gs;

} ######### End of if statement.

###

To read:

###

$string =~ s/n/ /gs;
$string =~ s/|/ /gs;
$string =~ s/\///gs;

$string =~ s/'/’/gs;

if ($execute_type eq "ste") {

$string =~ s/"/’’/gs;

} ######### End of if statement.

###

The rest of the work was mainly with admin files and doing the same thing for all primary key insertions.


___________________________

Nick Hendler
Webmaster, Kryptronic, Inc.


Nick Hendler

Offline

 

#15 07-30-2003 01:58:37

Guest
Guest

Re: apostrophize bug report

A rule of thumb which I strongly believe as a programmer is NEVER to delete/remove user information regardless of how insignificant it is (such as a quote character).

You may never know, something that you think is insignificant or redundant may cause lots of problems to the end user if it is deleted.

At least a warning message or some kind of note must be provided to let the user know that modifications will be made to the original information entered by the user.

Doing it secretly or unknownly is not ethical, and therefore I consider this apostrophe issue a bug.

 

#16 07-30-2003 07:03:21

Guest
Guest

Re: apostrophize bug report

Ahh ! that's an answer I was looking for webmaster. Thank you, I will try that on. smile

 

#17 07-30-2003 07:17:26

Guest
Guest

Re: apostrophize bug report

Excellent. The apostrophize is now working. There is only one remaining issue regarding the same subject :

"(CGIVAR)fd_tracking_firstname(/CGIVAR)" is not showing on the news section no more. I have to put my firstname myself since. Is there a way to bring the firstname back by keeping the actual database you gave me ?

 

#18 05-26-2004 16:40:56

nav
Banned
Registered: 04-07-2004
Posts: 666

Re: apostrophize bug report

The alternative solution would be to use : ALT-039 here.


______________________________________________

THIS USER HAS BEEN BANNED FROM THIS FORUM.

If this post contains any language related to
code samples, advice, etc., please read this
entire thread before making a decision to use
this post as a basis for any change to your
software installation.
______________________________________________

Offline

 

#19 05-26-2004 20:48:21

ephemere
Member
Registered: 05-26-2004
Posts: 2

Re: apostrophize bug report

There is langages where you can't avoid the apostrophe (French for instance).
So, I found my way

In the file adm_iud.pl

In both functions:

sub adm_iud_insert_proc
sub adm_iud_update_proc

I replace:

$formdata = $q->param($row);

By:

$formdata = $q->param($row);
$formdata =~ s/'/'/g;

This quick hack allows the apostrophe to be replaced by its html code before to be inserted in the database, therefore avoiding to be stripped out, and later, when it get out of the database, it is reinterpreted into an apostrophe by the browser before to be displayed in the product page or in the form field.  The manipulation is invisible for the end user.

--
Nadine St-Amand
nadine_stamand@videotron.ca

Offline

 

#20 05-26-2004 21:05:35

nav
Banned
Registered: 04-07-2004
Posts: 666

Re: apostrophize bug report

Merci beaucoup Nadine. J'ai bien fait de mettre à jour ce topique. Par contre, je ne vois qu'un résultat de $form_data. Serait-il possible de savoir où ajouter $form_data en 2e sous la routine : update_proc ? smile


______________________________________________

THIS USER HAS BEEN BANNED FROM THIS FORUM.

If this post contains any language related to
code samples, advice, etc., please read this
entire thread before making a decision to use
this post as a basis for any change to your
software installation.
______________________________________________

Offline

 

#21 06-11-2004 14:50:14

ephemere
Member
Registered: 05-26-2004
Posts: 2

Re: apostrophize bug report

In my previous message, the html code of the apostrophe: &  #  39  ;
could not display as it have been interpreted... in this forum smile
So I try again:

Within sub adm_iud_insert_proc
There is at line 885
$formdata = $q->param($row);

that I replace with
$formdata = $q->param($row);
$formdata =~ s/'/&#39;/g;

and
Within adm_iud_update_proc
There is at line 1179

$formdata = $q->param($line);

That I replace with

$formdata = $q->param($line);
$formdata =~ s/'/&#39;/g;


Offline

 

Board footer