• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 446
  • Last Modified:

Number of articles not displaying via link

I have a Joomla site which currently is in development and has, at the moment, over 30000 records. However, now that the site has this amount of content, articles will display within a Section Blog layout, but when clicking on some of the readmore links this is leading to a blank white page. This is not the case with all articles as some of them will load fine, it seems to be affecting half, obviously this is an estimate as I haven't tried this on all 30000 records. Any helps as to what the cause of this would be greatly appreciated.

Many thanks
0
Romolo
Asked:
Romolo
  • 4
  • 3
1 Solution
 
freeversedCommented:
I would guess it is related to how you loaded the website with the 30k articles - assuming you didn't paste the information in through Joomla! and used ETL or directly manipulating the database. Can you shed some light on how you added this amount of sontent to the website?

Fre.
0
 
RomoloIT Professional ConsultantAuthor Commented:
It was uploaded using an odbc connection straight to the database, appending straight to the articles table. I there any additional detail you require?

Shaun
0
 
freeversedCommented:
I suggest you play around with this method, adding smaller numbers of articles and seeing if you can figure out why some articles cause Read More errors and others not.

I would also suggest that you look at the source of the browser output when you see the whitescreen after clicking a Read more link, to determine where the browser has stopped parsing the page.

I haven't come across this error before but I have had issues directly manipulating the database like that. I tend to avoid it now, it is always hassle. Maybe look in the extensions directory to see if someone has a component for uploading large amounts of article data, such as in this category:

http://extensions.joomla.org/extensions/migration-a-conversion/data-import-a-export/
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
RomoloIT Professional ConsultantAuthor Commented:
We exported and import via .sql file and in another environment, it responded correctly.

Could you comment on limitations that could have been causing this issue.

0
 
freeversedCommented:
Please post the solution which you discovered.

Were there any differences between the test environment, where the SQL import worked and this one where it did not?
0
 
RomoloIT Professional ConsultantAuthor Commented:
It was a restriction to MySQL of using big selects. The host we moved to had no such restriction and so the site is now working. However, the known issues with Joomla 1.5 handling large amount of articles is still apparent and can be slow.

0
 
RomoloIT Professional ConsultantAuthor Commented:
We discovered the solution ourselves.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now