[closed, not solved] News module unstable

[frankmanl]

I experience a growing instability in News module.
These are some of the phenomena (they do not occur in every case, but they do occur often):
• Search module gives 404 errors when news items contain the sought phrase
• when adding an image to a news item, the summary page won't load
• in my news tag I define a detail page, but the details are returned in another page
• clicking the more link of a news summary returns a 404 error
I defined 5 categories, some of them have subcategories (up to 25).
There are about 1500 news items, but not more than about 100 in each category.
I defined 22 fields for my News module.
Most of the news items I added to my data base using SQL statements.
It all worked fine a couple of weeks ago, but things are going wrong now, and it seems to get worse.

I wonder: do I ask too much of News module?
Do these problems sound familiar?
In which direction should I look for a solution?

Below you'll find my system info - what else can I tell?

Frank



----------------------------------------------

Cms Version: 1.11.9

Installed Modules:

CMSMailer: 5.2.2
CMSPrinting: 1.0.5
FileManager: 1.4.3
MenuManager: 1.8.6
ModuleManager: 1.5.5
News: 2.14.1
Search: 1.7.11
ThemeManager: 1.1.8
TinyMCE: 2.9.12
Gallery: 1.6.1
GBFilePicker: 1.3.3
CGExtensions: 1.37.3
CGSmartImage: 1.13
MicroTiny: 1.2.5
AdvancedContent: 0.9.4.3


Config Information:

php_memory_limit:
process_whole_template:
max_upload_size: 50000000
url_rewriting: mod_rewrite
page_extension:
query_var: page
image_manipulation_prog: GD
auto_alias_content: true
locale:
default_encoding: utf-8
admin_encoding: utf-8
set_names: true


Php Information:

phpversion: 5.5.5
md5_function: On (True)
gd_version: 2
tempnam_function: On (True)
magic_quotes_runtime: Off (False)
E_STRICT: 0
E_DEPRECATED: 0
memory_limit: 128M
max_execution_time: 120
output_buffering: 4096
safe_mode: Off (False)
file_uploads: On (True)
post_max_size: 32M
upload_max_filesize: 50M
session_save_path: /tmp (0777)
session_use_cookies: On (True)
xml_function: On (True)
xmlreader_class: On (True)


Server Information:

Server Api: cgi-fcgi
Server Db Type: MySQL (mysqli)
Server Db Version: 5.1.41
Server Db Grants: Found a "GRANT ALL" statement that appears to be suitable
Server Time Diff: No filesystem time difference found


----------------------------------------------

[Rolf]

I use News module at a few sites, I haven't had any of these issues. Might be server related?? Any errors in error log?

[paulbaker]

• Search module gives 404 errors when news items contain the sought phrase
..........
Most of the news items I added to my data base using SQL statements.

Does News module update Search module every time a news item is added/updated? If so that might explain why Search doesn't know about your SQL-added news?

[frankmanl]

Hi guys,

ERRORS
the server's error log of the last couple of days:

[Fri Nov 01 07:30:30 2013] [error] [client 66.249.78.23] File does not exist: /home/vhosts/beaufort-extra.nl/subdomains/tijdelijkewebsite/httpdocs/settings_zita.xml
[Fri Nov 01 08:19:25 2013] [error] [client 66.249.78.23] File does not exist: /home/vhosts/beaufort-extra.nl/subdomains/tijdelijkewebsite/httpdocs/robots.txt
[Fri Nov 01 14:38:18 2013] [error] [client 37.74.135.118] File does not exist: /home/vhosts/beaufort-extra.nl/subdomains/hesk/httpdocs/favicon.ico
[Fri Nov 01 14:38:18 2013] [error] [client 37.74.135.118] File does not exist: /home/vhosts/beaufort-extra.nl/subdomains/hesk/httpdocs/favicon.ico
[Fri Nov 01 20:20:46 2013] [error] [client 66.249.78.23] File does not exist: /home/vhosts/beaufort-extra.nl/subdomains/tijdelijkewebsite/httpdocs/robots.txt
[Tue Nov 05 11:27:21 2013] [error] [client 37.74.135.118] File does not exist: /home/vhosts/beaufort-extra.nl/subdomains/hesk/httpdocs/favicon.ico
[Tue Nov 05 11:27:21 2013] [error] [client 37.74.135.118] File does not exist: /home/vhosts/beaufort-extra.nl/subdomains/hesk/httpdocs/favicon.ico
[Sat Nov 09 04:14:13 2013] [error] [client 157.56.92.152] File does not exist: /home/vhosts/beaufort-extra.nl/subdomains/rooster/httpdocs/robots.txt
[Mon Nov 11 08:24:28 2013] [error] [client 37.74.135.118] File does not exist: /home/vhosts/beaufort-extra.nl/subdomains/hesk/httpdocs/favicon.ico
[Mon Nov 11 08:54:50 2013] [error] [client 37.74.135.118] File does not exist: /home/vhosts/beaufort-extra.nl/subdomains/hesk/httpdocs/favicon.ico
[Mon Nov 11 08:55:04 2013] [error] [client 37.74.135.118] File does not exist: /home/vhosts/beaufort-extra.nl/subdomains/hesk/httpdocs/favicon.ico

CMSMS's own log mentions no errors at all.

SEARCH UPDATE
I initialy added most of the news records using SQL. I then reindexed search.
Later I added more news items in the conventional way: by adding them in the add article screen.
I again reindexed search.

I'll give you some examples.
1) http://tijdelijkewebsite.beaufort-extra ... erten-2013
The list of gigs is called like this:

Code: Select all

{news category='2013' summarytemplate='bf-concertarchief' showall='1' sortasc='true' detailpage='programma' detailtemplate='bf-agenda'}

look for 07-08-2013, 20:15 • Dromen bij Glass en Pärt
Opens in page nieuws, YouTube iframe is too big (should fit in the wrapper)
12-10-2013, 20:15 • The Kik & gasten opens in the correct page (programma) and iframe fits in wrapper.
23-02-2013, 20:15 • Chris Chameleon won't open at all.
All of these items were added to the database using SQL.

2) http://tijdelijkewebsite.beaufort-extra ... tiviteiten
Look for 11-12-2013, 20:00 • Jubileumconcert Maljaki Luludji
This one opens correctly.
But 13-12-2013, 20:15 • De Vries en De Vries ondernemerscabaret
does not. The picture in this news item stops the page from loading (it should be right after <div class="ladderFoto">.
This picture is, as all pictures on this position, a CGSmartImage pic.
BTW: on November 8 my admin log says: Core - Cannot load module CGSmartImage ... Problem loading dependent module CGExtensions version 1.36.2 - this happened three times that day (so, some error after all?).
Current version of CGSmartImage is 1.13, version of CGExtensions is 1.37.3

[frankmanl]

2) http://tijdelijkewebsite.beaufort-extra ... tiviteiten
(...)
But 13-12-2013, 20:15 • De Vries en De Vries ondernemerscabaret
does not. The picture in this news item stops the page from loading (it should be right after <div class="ladderFoto">.
This picture is, as all pictures on this position, a CGSmartImage pic.

I just upgraded CGSmartImage to version 1.14.
The problem described above is solved, pages do load completely now, but now SmartImages are not displayed anymore at all!

I kind of become desperate.
Would it make sense to set up this site all over again (in another subdomain) and then import the database?

[Rolf]

Hey Frank,

Everything looks fine here... Perhaps clear your browser cache and try again! I have been there...

Rolf

[velden]

No, it doesn't seem to look right. I guess it's about the 60x60 image that should be in front of title and 40x40 behind news titles?

Seem to be blank. However, CGSmartImage does generate that code so it's doing something.

You could try with noembed=1 parameter.

Could you post the code you use for CGSmartImage?

[frankmanl]

clear browser cache
Makes no difference. I test in 5 different browsers - all the same.

CGSmartImage
noembed does not make a difference.
My code, for page http://tijdelijkewebsite.beaufort-extra.nl/programma
the part that concerns CGSmartImage:

Code: Select all

<div class="ladderFoto">
{if $kleineladder != 1}
  {if $foto1 != '' && $foto1 != NULL}
    {if $oud == 1}
      {CGSmartImage src="uploads/images/agenda/oudsysteem/{$foto1}" title="{$fototekst1}" alt="{$fototekst1}" alias="agenda_thumbnail" noembed="1"}
    {else}
      {CGSmartImage src="{$entry->file_location}/{$foto1}" title="{$fototekst1}" alt="{$fototekst1}" alias="agenda_thumbnail" noembed="1"}
    {/if}
  {/if}
{/if}
</div>

and here's the complete code of my News summary template.

Code: Select all

{global_content name='ADM_pagination_2'}

<div class="hr"></div>

{foreach from=$items item=entry}

{* haal een aantal waarden op uit de basisvelden*}
{* date_format:"%a %e %b '%y, %R" = ma 21 okt '13, 12.30 *}
{if $entry->postdate}
  {if $entry->postdate|date_format:"%R:%S" == "00:00:01"} {* geef geen tijd weer *}
    {assign var=postdate value=$entry->postdate|date_format:"%a %e %b '%y"}
  {else}
    {assign var=postdate value=$entry->postdate|date_format:"%a %e %b '%y, %R"}
  {/if}
{else}
  {assign var=postdate value=''}
{/if}
{assign var=moreurl value=$entry->moreurl}
{assign var=title value=$entry->title|cms_escape:htmlall}

{* haal een aantal waarden op uit de extra velden, maar maak ze eerst leeg *}
{if isset($entry->fields)}
{assign var=subtitel value=''}
{assign var=tags value=''}
{assign var=foto1 value=''}
{assign var=fototekst1 value=''}
{assign var=uitverkocht value='0'}
{assign var=derden value='0'}
{assign var=kleineladder value='0'}
{assign var=oud value='0'}
{foreach from=$entry->fields item='field'}
{if $field->name == 'subtitel'}{assign var=subtitel value=$field->value}{/if}
{if $field->name == 'tags'}{assign var=tags value=$field->value}{/if}
{if $field->name == 'foto1'}{assign var=foto1 value=$field->value}{/if}
{if $field->name == 'foto1-tekst'}{assign var=fototekst1 value=$field->value}{/if}
{if $field->name == 'OPTIE uitverkocht'}{assign var=uitverkocht value=$field->value}{/if}
{if $field->name == 'OPTIE activiteit derden'}{assign var=derden value=$field->value}{/if}
{if $field->name == 'OPTIE kleine ladderweergave'}{assign var=kleineladder value=$field->value}{/if}
{if $field->name == 'OPTIE OUD SYSTEEM'}{assign var=oud value=$field->value}{/if}
{/foreach}
{/if}

<div class="Ladder{if $derden == 1} derden{/if}">
{* zet link om het hele blokje heen *}
<a href="{$moreurl}" title="{$title}">

<div class="ladderFoto">
{if $kleineladder != 1}
  {if $foto1 != '' && $foto1 != NULL}
    {if $oud == 1}
      {CGSmartImage src="uploads/images/agenda/oudsysteem/{$foto1}" title="{$fototekst1}" alt="{$fototekst1}" alias="agenda_thumbnail" noembed="1"}
    {else}
      {CGSmartImage src="{$entry->file_location}/{$foto1}" title="{$fototekst1}" alt="{$fototekst1}" alias="agenda_thumbnail" noembed="1"}
    {/if}
  {/if}
{/if}
</div>

{if $kleineladder == 1}
<div class="kleineladder">{$postdate} • {$title}</div>
{else}

<div class="ladderDatumSerie">
{$postdate}
{if $tags !== '' && $tags !== NULL}
 • {$tags|replace:',':' • '}
{/if}
{if $uitverkocht == 1} • UITVERKOCHT{/if}
</div>

<h3>{$title}</h3>

{if $subtitel !== '' && $subtitel !== NULL}
  <div class="ladderSubtitel">
  {$subtitel}
  </div>
{/if}
{/if}

</a>
</div>{* .Ladder *}

<div class="clearfloat"></div>
<div class="hr"></div>
{/foreach}

<div class="bottomnav">{global_content name='ADM_pagination_2'}</div>

[chandra]

By the way - do you know the {assign} short form?

{$moreurl = $entry->moreurl}

Better to read and a bit more php stylish

[calguy1000]

I initialy added most of the news records using SQL

I would bet that this is the cause of most of your 404 errors.

[frankmanl]

By the way - do you know the {assign} short form?

Thanks!

I initialy added most of the news records using SQL
I would bet that this is the cause of most of your 404 errors.

Really? But then, is there another, save way to add these 1500 records?
And items I added using News' interface, that were found correctly by Search module two weeks ago now cause a 404 error ...

[chandra]

Maybe you should post your sql ...

[frankmanl]

The commands I filled the database with? I don't have these anymore.
My data come from another database with completely different structure. I had to rename fields, change field types and combine (or split) other fields to fit it all into the news tables.
I could provide my current tables:
cms_module_news
cms_module_news_categories
cms_module_news_categories_seq
cms_module_news_fielddefs
cms_module_news_fieldvals
cms_module_news_seq
Would that be useful?

[chandra]

Are you really sure you have now the same database structure News module needed?

[frankmanl]

Yes.
I first set up News as usual, defined fields etc. and then, when all fields were set up I imported the data by SQL.