phpwcms Support Forum

I figured it out. Run this query in phpmyadmin to delete expired articles:

UPDATE phpwcms_article SET article_deleted = '9' WHERE `article_cid` = '316' AND `article_end` < '2011-02-24 23:59:59';

Note: You need to replace 316 with the catergory id # that you want to delete from (I only wanted to ...

I am not a my mysql expert, so can somebody help me complete this myphpadmin query?

SELECT *
FROM `phpwcms_article`
WHERE `article_cid` =316
AND `article_end` < '2011-02-24 23:59:59'

The above query shows me all the articles in the 316 category that have an end date less than 02/24/11. I want to ...

Hi Oliver,

Thanks for the reply. I am sure your solution works, but I am running version 1.3.3 and the edits above don't match up with the code I see.

This is a large government site, so I am going to see if I can get approval to update to the latest version, then apply the edits.

-Ray

Hi all,

On one of my sites I have a latest news section. All I do is create an article in News category and the 10 latest articles are the listed on the font page of the site by using:
{NEW:10:316}

I am trying to add news that, instead of linking to an article on our site, would link to an ...

nebenaube wrote:have you checked the tables in the database? I upgraded via svn so no problems here.

Yep, all tables are there. Like I said, no errors in the backend, I can create artlices.

-Ray

Same problem here, and I am a seasoned phpwcms user.

I installed the latest version 1.4.1 via ssh telnet (wget and unzipped the archive onto my server with command line). Successful installation, I can navigate around the backend no problems, I setup a template and a test article, but when viewing ...

Jensensen,

Yes, this is solved.

In previous versions, Plain Text was rendered up as:
<p>asdasd asdasd asdada asdasd asdad dfzs sdf.<br>
lksdlksdf lskdfoi liuhrw,m sd lksdfl lksdflk ,ksdnf.<br>
jsdfkjs skdfhu lhdlkjsf kshdflksf lkjshdflk wner.</p>

But the latest 1.3.9 renders plain text as:
<p ...

Evoplure,

Put this at the bottom of your style sheet: (edit the value to your taste. ex: "1em")

-Ray

Same problem here. This was a suprise for me.

I have thousands of articles on one of my sites (a government site). My habit was to use plain text for all normal text content. Now I'll have a site full of paragraphs that have no spacing between them.

In the past, the PLAIN TEXT content part obeyed ...

SOLVED! Actually the solution was already built in.

You need to add a url to the "FE login url:" section of your templates. BACKEND>ADMIN>TEMPLATES

That way, if somebody clicks a logged in only link and they are not logged in, they can be redirected to a page that has a login form. You need to ...

I need a solution for this also.

I am using a hard coded navigation tree. When a user clicks on a menu item for logged in users only, they are directed back to the index page. I need to be able to direct them to a "you must log in first" page.

-Ray

Guys, sorry, I did what Oliver said and that fixed the problem. Was not able to post here or I would have been late for church.

Oliver, as usual I worship you. Such an easy fix that you recognized immediately.

-Ray

{PHP:....myphp.php}

That works, but what about the REQUIRES in the php file that is being called up? They don't seem to get processed.
-Ray

Ok, somebody please help me figure this out. I am using Friefox to test a page. When loaded in phpwcms, the page does not perform the way it was intended, but if I take that page source and put it into its own php file and call that doc in a browser, the page does what it is supposed to. I don't get ...

Thanks flip-flop.

-Ray