Import of large category and link list problem.

[Saint Isaiah]

Hello,

I have just finished taking the categories and businesses from my old business directory portal and uploaded it into the database for IndexU. However, now when I attempt to access the index.php page or view_cat.php page, even though I rebuilt all the links and categories in the admin panel, both pages result in a 500 internal server error.

The link to the site is below. I imported 1,530 business directories and 11,336 businesses.

http://www.solanocounty.net/beta/

Any idea what the problem could be?

[hermit36]

hi there 11336 links with 1530 categories is not consider large data check your categories using directory mysql table there should be some conflict within your sql table

[Saint Isaiah]

hi there 11336 links with 1530 categories is not consider large data check your categories using directory mysql table there should be some conflict within your sql table

I'm not able to access the MYSQL terminal to perform commands such as "directory." I only have phpMyAdmin access. But all of the links themselves show up perfectly, and if you are on a page other than home, the categories display on the right side par perfectly. There is only a 500 error when the home page is accessed and when I try to view the categories in the admin panel. I also checked for any differences between the rows I imported, vs the rows for categories created in the admin panel, and both are a perfect match in format.

[ezykiwi]

A few things id look at doing would be...

Go into the admin section and update the category paths and link numbers.... just so that its all matching.

Id also look at playing around with the index template file and deleting the category part and other parts 1 by 1 to find what is causing the issue.

I like to figure out why things like that arnt working though so I can understand the code more

best of luck

[Saint Isaiah]

A few things id look at doing would be...

Go into the admin section and update the category paths and link numbers.... just so that its all matching.

Id also look at playing around with the index template file and deleting the category part and other parts 1 by 1 to find what is causing the issue.

I like to figure out why things like that arnt working though so I can understand the code more

best of luck

Ok so I can definitely tell that the problem is in the PHP of displaying the categories. I ripped <%category%> out of the index template and the site worked fine. What's also strange is that when I made all the cats children to a single parent cat, the parent cat shows fine and when clicked on will show the full listing of every cat and link. It's just that when you try to display every cat on the index page I get the 500 error.

Awfully Strange....

[ezykiwi]

hmmmm so whats the structure of the categories ...

How many of them have the parent as 0? or how many should be displayed on the main page?

[Saint Isaiah]

Well originally I was going to have all the cats be parents, and only show the list of all the cats on the frontpage, but that results in the error. So instead I made a parent cat to put all of the cats in it. It works ok now I guess, but I still cant expand the categories on the view_cat.php admin page. It still results in a 500 error.

[dody]

Please send me your url and ftp access to support@nicecoder.com
I'd be happy to check it.