[TAG] ’ issue
Posted: 17 November 2007 04:26 AM   [ Ignore ]
Member
RankRankRank
Total Posts:  53
Joined  2005-07-18

I understand I should keep my feet on the ground, but maybe something can be done with ‘

MySQL ERROR:

Error Number: 1064

Description: 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 ‘s feet on the ground’)’ at line 1

Query: UPDATE exp_tag_tags SET clicks = (clicks + 1) WHERE tag_name IN (’keep one’s feet on the ground’)

P.S. I’m not sure but I think that worked in v.1 (I see I used ‘ before in tags)

 Signature 

tulks.com

Profile
 
 
Posted: 19 November 2007 01:03 PM   [ Ignore ]   [ # 1 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  2751
Joined  2006-10-18

What is it exactly you’re trying to do here? smile

 Signature 
Profile
 
 
Posted: 19 November 2007 01:32 PM   [ Ignore ]   [ # 2 ]
Member
RankRankRank
Total Posts:  53
Joined  2005-07-18

Look at this:

http://tulks.valsts.lv/english/tagcloud/

If I select catch sb’s eye, I get:

MySQL ERROR:

Error Number: 1064

Description: 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 ‘s eye’)’ at line 1

Query: UPDATE exp_tag_tags SET clicks = (clicks + 1) WHERE tag_name IN (’catch sb’s eye’)

 Signature 

tulks.com

Profile
 
 
Posted: 19 November 2007 01:38 PM   [ Ignore ]   [ # 3 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  2751
Joined  2006-10-18

hmmm… it actually works for me smile

 Signature 
Profile
 
 
Posted: 19 November 2007 01:50 PM   [ Ignore ]   [ # 4 ]
Member
RankRankRank
Total Posts:  53
Joined  2005-07-18
Pie Man - 19 November 2007 01:38 PM

hmmm… it actually works for me smile

Screenshot attached.

Image Attachments
mysql.gif
 Signature 

tulks.com

Profile
 
 
Posted: 27 November 2007 02:54 AM   [ Ignore ]   [ # 5 ]
Member
RankRankRank
Total Posts:  53
Joined  2005-07-18

What should I do in this case?

 Signature 

tulks.com

Profile
 
 
Posted: 27 November 2007 07:20 AM   [ Ignore ]   [ # 6 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  2751
Joined  2006-10-18

It’s kinda strange, it still works for me… I’ll see if I can find an answer for you smile

 Signature 
Profile
 
 
Posted: 27 November 2007 07:46 AM   [ Ignore ]   [ # 7 ]
Member
RankRankRank
Total Posts:  53
Joined  2005-07-18

I’ve just tested it on my 2nd PC.

The result:

1st PC:
WinXP w/ all SP/updates
- Firefox 2.0.0.9 - Error
- IE6 - Error
- Opera - No error, works correctly

2nd PC:
The same
- FF 2.0.0.9 - No error
- IE7 - No error

But the website shows a server problem. So, I cannot understand how that can be connected w/ my PC.

...

I removed all cookies. Now it works correctly.

Thanks!

 Signature 

tulks.com

Profile
 
 
Posted: 27 November 2007 07:47 AM   [ Ignore ]   [ # 8 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  2751
Joined  2006-10-18

Haha, so I shouldn’t lose anymore sleep over this?

Glad you got this solved smile

 Signature 
Profile