Problem with Newspaper Template - mysql edit

[bid]

When I try to edit dates in MYSQL to change them more than one day before, I dont receive anything displayed in the specified categories.

However when using default template it works and displays correctly l!!!

Probably the Newspaper layout.php file has any bug. In my opinion is a problem with ["GET"]["range"] but not sure how to edit. (line 59 of 112 in serendipity 0.8 alpha 11)

[Guest]

When I try to edit dates in MYSQL to change them more than one day before, I dont receive anything displayed in the specified categories.

However when using default template it works and displays correctly l!!!

Probably the Newspaper layout.php file has any bug. In my opinion is a problem with ["GET"]["range"] but not sure how to edit. (line 59 of 112 in serendipity 0.8 alpha 11)

when delete all the section of ["GET"]["range"] all of the entries are listed at once without pagination.

[Guest]

When I try to edit dates in MYSQL to change them more than one day before, I dont receive anything displayed in the specified categories.

However when using default template it works and displays correctly l!!!

Probably the Newspaper layout.php file has any bug. In my opinion is a problem with ["GET"]["range"] but not sure how to edit. (line 59 of 112 in serendipity 0.8 alpha 11)

when delete all the section of ["GET"]["range"] all of the entries are listed at once without pagination.

The example is http://www.SHOPZERO.com/uk/news2/index.php - when I click the ALL Categories is fine - but all the entries belong to Online Brands - when I click it shows EMPTY.
That's only becouse I edited date in mysql manually - when I change to other template than Newspaper - it works fine and display all of the records.

[garvin]

Then the newspaper template is broken. I will try to contact the author of the template, Jannis, if he can fix it. The bug you're experiencing shouldn't have anything todo with you having editet a mysql stamp

I'll post news here when I've investigated this issue.

regards,
garvin

[garvinhicking]

Just remove this block:

Code: Select all

                if (!isset($serendipity['GET']['range']) || !is_numeric($serendipity['GET']['range'])) {
                    $serendipity["GET"]["range"] = date("Ymd", serendipity_serverOffsetHour());
                }

and you'll be fine

[Guest]

Just remove this block:

Code: Select all

                if (!isset($serendipity['GET']['range']) || !is_numeric($serendipity['GET']['range'])) {
                    $serendipity["GET"]["range"] = date("Ymd", serendipity_serverOffsetHour());
                }

and you'll be fine

I did it yesterday.
WHen I remove the part- it doesn't make pagination at all - list all records on the first page - I will show you at
http://shopzero.com/uk/news2/index.php

please,, choose the category ONline brands in the right panel - it doesn't make pagination...
Thanks

[garvinhicking]

Hi!

My pagination works properly with the newspaper blog in current CVS.

I get this URL for pagination:

http://localhost/serendipityindex.php?/archives/P2.html

while you get:

http://shopzero.com/uk/news2/index.php? ... es/P2.html

notice the index.php?/index/ part! Where does this come from? It doesn't happen in my installation, tell me which paths you setup!

Regards,
Garvin

[Guest]

[quote="garvinhicking"]Hi!

My pagination works properly with the newspaper blog in current CVS.

I get this URL for pagination:

http://localhost/serendipityindex.php?/archives/P2.html

while you get:

http://shopzero.com/uk/news2/index.php? ... es/P2.html

notice the index.php?/index/ part! Where does this come from? It doesn't happen in my installation, tell me which paths you setup!

Regards,
Garvin[/quote

IT happens when I change the date (timestamp) manually for more than one day bacK in MYSQL - when I use smarty templates the dates are shown with earliest dates as I wish in "default" template
ie. I decrease the timestapm 86400 per day (60secX60minX24Hours) - but when I use this template "NEWSPAPER" the records with manually changed dates don't show in the category they were saved to - however they appear in "ALL Categories".
WHEN not inserting my records everyday I wish to spread them over one week period at one day to look more natural than inserting all of them at one time

When I remove the section ["GET"]["range"] they are listen without pagination
My question is what and where should I change to get my records displayed in NEWSPAPER layout.php(or my own layout) when my MYSQL records are changed manually.

[Guest]

Hi!

My pagination works properly with the newspaper blog in current CVS.

I get this URL for pagination:

http://localhost/serendipityindex.php?/archives/P2.html

while you get:

http://shopzero.com/uk/news2/index.php? ... es/P2.html

notice the index.php?/index/ part! Where does this come from? It doesn't happen in my installation, tell me which paths you setup!

Regards,
Garvin[/quote

IT happens when I change the date (timestamp) manually for more than one day bacK in MYSQL - when I use smarty templates the dates are shown with earliest dates as I wish in "default" template
ie. I decrease the timestapm 86400 per day (60secX60minX24Hours) - but when I use this template "NEWSPAPER" the records with manually changed dates don't show in the category they were saved to - however they appear in "ALL Categories".
WHEN not inserting my records everyday I wish to spread them over one week period at one day to look more natural than inserting all of them at one time

When I remove the section ["GET"]["range"] they are listen without pagination
My question is what and where should I change to get my records displayed in NEWSPAPER layout.php(or my own layout) when my MYSQL records are changed manually.

SO the problem seems to me is related to the "range" - the script covers only records from the day I started adding records to the specified category - I would like not to limit the listings in specified category to the day I set up the category - but to have a chance to change their dates of insertion back.

[garvinhicking]

Tell us the SQL string you used to modify the date of your entries.

Still, the pagination of your newspaper layout is broken because of the URLs I pasted, and where I asked for your path settings. You may want to try to checkout a recent CVS of Serendipity including the fixed layout.php from the newspaper layout?

Regards,
Garvin

[bid]

Tell us the SQL string you used to modify the date of your entries.

Still, the pagination of your newspaper layout is broken because of the URLs I pasted, and where I asked for your path settings. You may want to try to checkout a recent CVS of Serendipity including the fixed layout.php from the newspaper layout?

Regards,
Garvin

STILL the issue wasn't solved.
visit:
http://shopzero.com/uk/news3/index.php

you will see that with Newspaper template when you choose ONline Brands category you will have no pagination. - that happens becouse the "range" is lost somewhere lost - it starts probably from the time I set the category - but I wish to backdate the entries MANUALLY in mysql.
However it works well with DEFAULT template - but I need the php - layout.php.

[ted]

Tell us the SQL string you used to modify the date of your entries.

Still, the pagination of your newspaper layout is broken because of the URLs I pasted, and where I asked for your path settings. You may want to try to checkout a recent CVS of Serendipity including the fixed layout.php from the newspaper layout?

Regards,
Garvin

STILL the issue wasn't solved.
visit:
http://shopzero.com/uk/news3/index.php

you will see that with Newspaper template when you choose ONline Brands category you will have no pagination. - that happens becouse the "range" is lost somewhere lost - it starts probably from the time I set the category - but I wish to backdate the entries MANUALLY in mysql.
However it works well with DEFAULT template - but I need the php - layout.php.

there is a limitation
$serendipity["GET"]["range"] = date("Ymd", serendipity_serverOFFsetHour());

that's the place which stops the records from displaying records in the specified category - layout.php line 50 -60 , but when you remove it it is diplayed without pagination - is it possible to backdate somewhere the serendipity_serverOFFsetHour() ?????????

[garvinhicking]

Please read through my postings again and answer the questions I had. Then I may be able to help you further.

Another question: Are you using the latest CVS version without any changes to Serendipity files? Or have you modified any of those?

Regards,
Garvin

[Guest]

Please read through my postings again and answer the questions I had. Then I may be able to help you further.

Another question: Are you using the latest CVS version without any changes to Serendipity files? Or have you modified any of those?

Regards,
Garvin

I used the latest CSV yesterday - but the listing didn't have pagination at all when I chose the category I saved records for. - Without any changes to the code I insert in the latest Serendipity my record and change the date for earlier than today - then the listing doesn't appear in the category I saved for.
Another way I use PHPadmin to change dates - timestamp and lastmodified of my records.
With smarty template it works(edited records are shown in category they were saved for) but not with layout.php - I would like to modify.

[garvinhicking]

Again, please read through my questions. I asked for your SQL code you use.

Maybe you can compare the code of layout.php with the one in include/genpage.inc.php - there the actions to be performed with the range parameter and stuff should match what happens in newspapers layout.php. If you use the embed directive please pay attention if your wrapper/index.php performans modifications on the $serendipity rray.

Regards,
Garvin