Text only | Text with Images

TinyPortal

Development => Support => Topic started by: glypo on August 02, 2008, 11:24:58 PM

Title: 500 ISE in articles after custom port. Am I missing any relationships?
Post by: glypo on August 02, 2008, 11:24:58 PM
Well I love TP, and managed to convince the site owner I help out to switch from Xoops to Tinyportal.

I've been getting on with heavily modifying a theme to look smart and fit the site, around 40% done there. So I decided to port the stories/articles from xoops into the articles. Then problem. I made a basic SQL to just simply port all my articles over from xoops to tinyportal.

However after I done this, I get a 500 error when I try and access the Articles/Categories part in the Admin CP! D'oh! So really my question is, why? Is the articles table relational to something else that I may need to update? (I only ported to the smf_tp_articles)

Here is a screenshot of my table (click to enlarge)
(https://www.tinyportal.net/proxy.php?request=http%3A%2F%2Fwww.glypo.com%2Fgeneral%2Fsql-small.gif&hash=a9c2b232a961883b1ba1592ae401971ce320ce86) (http://www.glypo.com/general/sql.gif)

Is there anything obvious I could have missed here?

Any help would be massively appreciated as I want to get TP to work, I can't face going back to xoops!

Thanks!
Title: Re: 500 ISE in articles after custom port. Am I missing any relationships?
Post by: IchBin on August 03, 2008, 12:10:30 AM
If I remember right the articles are also tied to the tp_variables table. You should probably remove your "imported" article to fix your forum so you can access it. Then, create an article so you can see what tables and rows are affected. Then you'll be able to see the necessary changes you're going to need to make.
Title: Re: 500 ISE in articles after custom port. Am I missing any relationships?
Post by: glypo on August 03, 2008, 01:00:36 AM
Thanks for the reply! Very quick too.

I already tried comparing like for like, and only thing that was missing was the "shortname". Maybe this is the problem, I'll try now. If it works, will be awesome and I can post my conversion kit up for everyone to convert entire xoops (including forum, as that works) to TP.

I done as you suggested, and got rid of my imported stuff and made a new article, and I couldn't see anything in the variables table change.
Title: Re: 500 ISE in articles after custom port. Am I missing any relationships?
Post by: IchBin on August 03, 2008, 01:22:29 AM
That depends on if you add it to a category or not.
Title: Re: 500 ISE in articles after custom port. Am I missing any relationships?
Post by: glypo on August 03, 2008, 02:46:43 AM
Well I have now filled in the field "shortname" and still get the 500 error in the backend/admin.

I have already assigned the articles to a category (6) which I made previously.

I am now wondering if the error is due to my numbering, as my first news item is id 124 and some big gaps in someof the numbers.
Title: Re: 500 ISE in articles after custom port. Am I missing any relationships?
Post by: IchBin on August 03, 2008, 05:21:05 AM
Probably something Bloc will have to comment on if he sees this post.
Title: Re: 500 ISE in articles after custom port. Am I missing any relationships?
Post by: glypo on August 04, 2008, 01:49:52 PM
Okay cool. I really appreciate your help trying IchBin.

I will keep trying to get this done. I do hope Bloc sees this though, as I am stuck!
Title: Re: 500 ISE in articles after custom port. Am I missing any relationships?
Post by: Dragooon on August 11, 2008, 07:04:37 PM
Do you see anything in Forum error log?
Title: Re: 500 ISE in articles after custom port. Am I missing any relationships?
Post by: bloc on August 11, 2008, 07:10:39 PM
It should not matter what the id's are..even with big gaps between.

So "index.php?page=251" result in a 500 error? ..is this on TP 0.9.8 or TP 1.0?
Text only | Text with Images