Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
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:- - 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
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
Re: rsx_request_count: Article Request Counter
phpMyAdmin returns the same error
- - 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
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
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
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
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
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
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
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