chrometweaks.org

Would iPage let me sell-on a domain name and some hosting I have with them?

Click Here To View All Answers...


First of all Would iPage let me sell-on a domain name and some hosting I have with them? Looking forward for any answer. Second question of mine... Hi all,.

I have just noticed that using.

User_tracking.

Or maybe it is something else,.

When a cateogry or product includes apostrophes.

Ie. St. Paul's, it give me an error.

1064 - Erreur de syntaxe prs de 's')' la ligne 1.

Insert into user_tracking (customer_id, full.

Is there way to about it without compromising the use of ( ' ) in the world?.

I have many Italian words with the apostophe, I wouldn't like to change them all..

Thanks.

Salvo..

Comments (148)

That's a good question. I'm not sure what is the answer. I'll do some research in Google and get back to you if I bump into an good answer. You should email the people at iPage as they probably can answer it..

Comment #1

Yes, I know that, the only problem is that the apostrophes is in the category name and If I try to put St. Paul\'s, it delete the \ and I don't know why. Try it...

The error occurs because I am using the user trucking contribution, that insert the category name into the table with the apostrophe..

Is there a way around it?.

Thanks.

Salvo..

Comment #2

How about using ' in place of the '.

This might work some places and not others but it's worth a try.......

Tom..

Comment #3

The post hid the actual html equivalent of quote..... :-).

Ampersand#39;.

Try this.....

Tom..

Comment #4

Try this code in place of an apostrophe here I have to seperate the code eliments or you will just see '.

&#.

Followed by.

39;.

Take the first part of the code and place it together with the second part of the code so that you have no spaces this number code gives an apostrophe..

Comment #5

Thanks.

I will try all these options.

This post has been edited by.

Salvo.

: 15 February 2004, 21:43..

Comment #6

Hi,.

This comes from your magic_quote setting in php.ini or .htaccess..

I dont think OSC does the right check for this like.

HERE.

In the example..

Try adding this to your .htaccess.

<IfModule mod_php4.c>.

Php_flag magic_quotes_gpc On.

</IfModule>.

This post has been edited by.

User99999999.

: 15 February 2004, 22:46..

Comment #7

This didn't work.

Here where the error is.

1064 - Erreur de syntaxe prs de 's Cathedral')' la ligne 1.

Insert into user_tracking (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url, page_desc) values ('', 'Guest', '09a3e1d134fa73f0fc5830f1bd34c498', 'ip', '1076996753', '1076996753', '/site2004/product_info.php?cPath=1_17&products_id=180&osCsid=09a3e1d134fa73f0fc5830f1bd34c498', 'St. Paul's Cathedral').

Any other help is appreciated.

Salvo..

Comment #8

Check in your admin -> tools -> server info.

It should have 'magic_quotes_gpc On' in there..

Try changing it in php.ini..

Comment #9

Ok I thought you ment when you create a category you get that error..

Try this.

User_tracking.php line 52.

$page_desc = $page_desc_values['categories_name'];.

$page_desc = addslashes($page_desc_values['categories_name']);..

Comment #10

I have changed like this and still don't work.

Should I change them all? how do you change the master?.

Magic_quotes_gpc On Off.

Magic_quotes_runtime Off Off.

Magic_quotes_sybase Off Off.

This is this in the php.ini.

; - magic_quotes_gpc = Off [Performance].

; Input data is no longer escaped with slashes so that it can be sent into.

; SQL databases without further manipulation. Instead, you should use the.

; function addslashes() on each input element you wish to send to a database..

How and where do you add the function addslashes() ? .

This post has been edited by.

Salvo.

: 17 February 2004, 07:07..

Comment #11

Your problem was only with this mod..

Edit this file.

Catalog/includes/functions/user_tracking.php line 52.

Change this.

$page_desc = $page_desc_values['categories_name'];.

To this.

$page_desc = addslashes($page_desc_values['categories_name']);..

Comment #12

Dave,.

I will try your advice tonight (GMT TIME) and I will let you know..

Thanks.

Salvo..

Comment #13

Well Done Dave.

I have added.

Addslashes.

And it worked very well.

Thank you.

Salvo..

Comment #14

Hi all,.

I have just noticed that using.

User_tracking.

Or maybe it is something else,.

When a cateogry or product includes apostrophes.

Ie. St. Paul's, it give me an error.

1064 - Erreur de syntaxe prs de 's')' la ligne 1.

Insert into user_tracking (customer_id, full.

Is there way to about it without compromising the use of ( ' ) in the world?.

I have many Italian words with the apostophe, I wouldn't like to change them all..

Thanks.

Salvo..

Comment #15

When ' apostrophes are used mysql interprets these as code so you need to place \ before a '.

As in St. Paul\'s,..

Comment #16


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