0
Germi,
The application was perfectly running but after a import of artists and albums the trouble started.
I can't figure out a link problem in the Music Collection After hours of searching an complete clean install a 500 page kept bugging me. Now I see the problem:
The Music Collection generates a hyperlink to the artist as:
.."/option=com_muscol&view=artist&id=3"
But the correct hyperlink is:
.."/option=com_muscol&view=artists&id=3"
SO ARTIST WITH AN "S". What's happening? Do I have to do a search and replace in the code?
Dave
The application was perfectly running but after a import of artists and albums the trouble started.
I can't figure out a link problem in the Music Collection After hours of searching an complete clean install a 500 page kept bugging me. Now I see the problem:
The Music Collection generates a hyperlink to the artist as:
.."/option=com_muscol&view=artist&id=3"
But the correct hyperlink is:
.."/option=com_muscol&view=artists&id=3"
SO ARTIST WITH AN "S". What's happening? Do I have to do a search and replace in the code?
Dave
Responses (19)
-
Accepted Answer
-
Accepted Answer
0The problem is solved after I applied the SEF.
But an other thing happens. I imported 12,000 artist and 47,000 albums succesfully. Everything works but...
If I want to view for example http://www.ipod2000.com/muscol/q.html. the system reaches the maximum time limit of 60 seconds or a 500 page. Is my DB too big? (max time is 60 and de memory limit is 64M)
My biggest problem is that in the admin the "Albums" gives also (directly) an 500 page, so I can't edit mij parameters.
Can you have a look at the Query?
Thanks again!
Dave -
Accepted Answer
0hello Dave
WOW!! 47.000 albums!!! thats a collection my friend!
yes in that case it is possible that, when loading all the artist on the letter Q (for instance), it exceeds the max execution time. but I would say I only happens if you choose the "detailed" view for artists list (that one I hav here, where the thumbnails of the albums of every artist are loaded.)
the first thing to try to avoid this would be change the view to DEFAULT instead of detailed
also, for such huge collections, you should enable the PAGINATION option for the artists list... otherwise the result of the querys can be too big.
but, of course, to change that parameter (activate pagination and/or select default view) you need to enter on "albums" in the backend, and you say that you get an 500 error...
hm... but did you change anything on any file? I mean, you could see the page before, right?
since the SEF doesn't take effect on the admin area... you shouldn have this error!... so weird...
maybe you can send to my mail an admin username & password so I can check it myself? -
Accepted Answer
0Yes it sure is. These are not my records but it is a productfeed.
Now I cleared the artists and album tables to access the admin "Albums" changed the view to default and enabled the pagination. But 47.000 is still to large for the application.
I find it a bit strange because with 10.000 it is running very fast. How big is your collection?
It's no must for me to have such a big collection. The goal is 3000-4000 albums. So it will manage.
Thanks for all your help!
Dave -
Accepted Answer
0my collection is only about 1000 records... (but I'm only 24 years old!)
it is weird, if the pagination is enabled there wouldn't have to be any problem if the collection is of 27000 or even more, since where the pagination is enabled, the query to the database is small.
it should work good with 10, 10000 or 100000 records... :S
tell me if I can help oyu in anything else -
Accepted Answer
-
Accepted Answer
0hello Dave,
I've been taking a look. on admin area, when I click on ALBUMS I dont get a 500 error, but as you said the page just does not charges. I dont really know why this is happening.
also on the frontend I try to access the Q letter (for instance) and I get nothing.
I wanted to see the value of you pagination "show" parameter (a global joomla configuration parameter), but since I am admin (and not superadmin) I can't see it.
tell me what value do you have there (you can find it in global configuration)
I really think I shouldn't have anythign to do with the database size... but since you said that it worked fine with 10.000 albums... maybe there's some kind of problem.
I assume you didnt entered the albums one by one, you probably did some mysql import from a CSV file or so (did you?)
if this is the case, and you can do the importation again without loosing data, maybe it would be a good idea to empty the muscol tables and import the data again, but limitating it to only the first 10000 records (just to try if it still works with 10000)
is the only way I see to check if it really has something to do with database size...
Germi -
Accepted Answer
0First of all congratulations with FC Barcelona. The next pice is the Champions League! I am, like many Dutch footballlovers, a big Barcelonafan. Not only the game but also the city. I've been there twice. I realy enjoyed special Catalunia art, people and food... I've been in Malaga, Madrid, Valencia, Sevilla, San Sebastian/Pamplona, but Barcelona is my favorite. I'm from the Netherlands, Utrecht city. Utrecht is the best city in Holland. With the best club: FC Utrecht
Listen up... the strange thing is I emptied the Album table and failures (500 pages) still occur. Isn't that strange?
Do you want to have a look at my album and artist CSV upload files?
Dave -
Accepted Answer
-
Accepted Answer
-
Accepted Answer
-
Accepted Answer
-
Accepted Answer
-
Accepted Answer
-
Accepted Answer
0Germi,
Congratulations for winning the Champions League with FC Barcalona. The Triple! You are probely very proud!!!
I solved the problem... that is: the provider solved the problem. They migrated the site to server with a 32 mb memory limit. And I had to disable a error parameter. Anyway it is running with 50.000 albums and 50.000 artists. :cheer:
Thnaks for all your help.
Dave -
Accepted Answer
-
Accepted Answer
-
Accepted Answer
Your Reply

Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here.
Register Here »