Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Number of articles not displaying via link

Posted on 2011-03-08
7
Medium Priority
?
424 Views
Last Modified: 2012-05-11
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
Comment
Question by:roycasella
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 4

Expert Comment

by:freeversed
ID: 35081421
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
 
LVL 7

Author Comment

by:roycasella
ID: 35093290
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
 
LVL 4

Expert Comment

by:freeversed
ID: 35094225
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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 7

Accepted Solution

by:
roycasella earned 0 total points
ID: 35116961
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
 
LVL 4

Expert Comment

by:freeversed
ID: 35155576
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
 
LVL 7

Author Comment

by:roycasella
ID: 35156094
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
 
LVL 7

Author Closing Comment

by:roycasella
ID: 35187251
We discovered the solution ourselves.
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Welcome Friends, This is the tutorial for how to create new simple module in joomla 1.5. In the module has two important files. One is XML file and another file is PHP controller file. First you need to create the XML file. (CODE) …
First of all, we will need Jumi component or Sourcerer plugin for this to work. We need either of these because the main focus here is custom development outside of the standard modules or articles within Joomla. You can find Jumi here...it's my …
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses

704 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question