Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#13 2004-07-30 19:34:20

Tom Alday
Member
Registered: 2004-04-27
Posts: 38
Website

Re: rsx_request_count: Article Request Counter

When i try to add the table in SQL i get this error:

Error

SQL-query :

ALTER TABLE ‘textpattern’ ADD ‘request_count’INT DEFAULT ‘0’ NOT NULL

MySQL said:
  1. - 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 ‘‘textpattern’ ADD ‘request_count’INT DEFAULT ‘0’ NOT NULL’ a

It’s possible i’m simply doing it wrong since SQL is not my strong point

Offline

#14 2004-07-31 07:23:42

ramanan
Plugin Author
From: Toronto
Registered: 2004-03-12
Posts: 323
Website

Re: rsx_request_count: Article Request Counter

Tom, make sure you don’t use the curly quotes in your SQL statement. that may cause problems. I am not sure what else would be a problem in your query.

Pospel, how are you using the tag? There should be no second argument to the tag.

Offline

#15 2005-01-23 19:20:13

colak
Admin
From: Cyprus
Registered: 2004-11-20
Posts: 9,007
Website GitHub Mastodon Twitter

Re: rsx_request_count: Article Request Counter

phpMyAdmin returns the same error

  1. - 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 ‘‘textpattern’ ADD ‘request_count’ INT DEFAULT ‘0’ NOT NULL’ at line 1

Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.

Offline

#16 2005-01-24 05:24:55

paularms
Member
From: University of Minnesota
Registered: 2004-10-21
Posts: 155
Website

Re: rsx_request_count: Article Request Counter

Ramanan: I see that you have a page displaying your most viewed articles and giving the number of views. Is this another plugin that you plan to release or do I really need to learn PHP?

and colak, there is a graphical way to add that in phpMyAdmin instead of just entering in the SQL. click on the txp_textpattern table and at the bottom, right after “Print view” and “Propose table structure”, click the GO button and you can add the stuff manually.

Last edited by paularms (2005-01-24 05:26:42)

Offline

#17 2005-01-24 10:30:47

colak
Admin
From: Cyprus
Registered: 2004-11-20
Posts: 9,007
Website GitHub Mastodon Twitter

Re: rsx_request_count: Article Request Counter

Ramanan, thanks for the response. I am new with mysql and phpmyadmin. Can you please be more specific. On adding a new field I am presented with
Field
Type
Length/Values*
Collation
Attributes
Null
Default**
Extra

4 radio buttons and a checkbox

Am I correct in assuming that the fields should be filled like this
Field: request_count
Type: INT
Length/Values*
Collation
Attributes
Null: not nul
Default** : 0
Extra

the 3rd radi button selected
and the checkbox uncheckked

Your advise would be appreciated…

Last edited by colak (2005-01-24 10:31:10)


Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.

Offline

#18 2005-01-24 12:59:09

ramanan
Plugin Author
From: Toronto
Registered: 2004-03-12
Posts: 323
Website

Re: rsx_request_count: Article Request Counter

Field: request_count
Type: INT
Attribute : Unsigned (not needed really)
Null: Not Null
Default: 0
Extra:

Primary:
Index:
Unique:
- : <— select this radio button

fulltext:

That should be correct. You don’t need to check the unique radio button, because there is only one row in this table.

Offline

#19 2005-01-25 07:33:50

colak
Admin
From: Cyprus
Registered: 2004-11-20
Posts: 9,007
Website GitHub Mastodon Twitter

Re: rsx_request_count: Article Request Counter

Thank you ramanan. Done it and it doesn’t work… will have to experiment a bit more.


Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.

Offline

#20 2005-01-29 09:57:54

colak
Admin
From: Cyprus
Registered: 2004-11-20
Posts: 9,007
Website GitHub Mastodon Twitter

Re: rsx_request_count: Article Request Counter

It somehow started working now. thanx again!


Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.

Offline

#21 2006-12-19 15:01:31

dai
Member
Registered: 2006-12-07
Posts: 21

Re: rsx_request_count: Article Request Counter

When I try there to download rsx_request_count.txt I got 404 error. Seems like ramanan removed plugin for some reasons :(

plugin can be found at http://www.funkaoshi.com/static/rsx_request_count.txt

Offline

#22 2007-10-20 02:45:06

ramanan
Plugin Author
From: Toronto
Registered: 2004-03-12
Posts: 323
Website

Re: rsx_request_count: Article Request Counter

The link at the start of this post works; i’m confused? Or maybe I fixed it after the fact.

Last edited by ramanan (2007-10-20 02:45:56)

Offline

#23 2010-03-25 18:55:00

amavai
Member
Registered: 2009-08-25
Posts: 37

Re: rsx_request_count: Article Request Counter

Hi Forum,

Roman, thanks for the plugin. But I would like to ask if someone can help me with the addition into de database. I tried several times with no sucess..

I have MySQL 5,0 and the options when I try to creat the entry are:

Field: request_count
Type; INT
Lenght/Values:
Default: Here I have some options: None, As Defined, NULL, Current_timestamp
and then a blank box, where I supouse I have to fill with 0
Collation:
Atributes:
Null ( check box , unchecked I supouse)
Index: Unique
AUTO_INCREMENT: Should be check?
Comments;

I added, deleted, and always receive the same error: #1062 – Duplicate entry ‘0’ for key 2

Could you please help me to let me know how I configure this?

Thanks a lot!

Amavai

Offline

#24 2012-12-18 15:48:35

Pat64
Plugin Author
From: France
Registered: 2005-12-12
Posts: 1,595
GitHub Twitter

Re: rsx_request_count: Article Request Counter

Hi Folks ;)

I use this plugin for a project that need it. I notice article access weren’t well updated. The only way to correct is to disable the “send lastmod” preferences option.

But, in this case, the website is much slower. Is there a better way?

Thanks for your advices.

Problem solved: this occures with smd_xml without “cache_time” attribute set.

Last edited by Pat64 (2012-12-18 17:25:37)


Patrick.

Github | CodePen | Codier | Simplr theme | Wait Me: a maintenance theme | [\a mi.ni.ma]: a “Low Tech” simple Blog theme.

Offline

Board footer

Powered by FluxBB