34 replies to this topic

[danz]

I would like to use this for fish tanks and wondering if there is any hardcoded values with car related info or is there a language file  I can modify to meet our needs? Also any encoding so if er need to make some changes?

Also is there an edit to show a "my garage" in the postbit?

Edited by danz, 14 October 2008 - 02:30 AM.

[Vince]

All titles are changable trough the ACP -> Tools & settings -> My Rides
Yes it will show the latest topic the member made in the forum that is the My Rides forum, you can disable that by not doing that edit.

[TX5]

Vadim88, on Aug 10 2008, 01:03 AM, said:

Quote

sweet!!!! can I have multiple "My Ride" forums?

Sorry, Currently it works on one forum only. But with a little tweak in can work with several. Contact me if you wish to extend it for you.

Thanks Gary, Actually that was requested by a member it took a while to complete since it does stuff that normally won't be included by default in a forum software.

can you give me the code to make it work on multipul forums please

btw.. this mode is awesome  

[Vince]

It's not done yet, This will require several adjustments to the code. I would prefer doing it once i upgrade the mod for IPB 3.

And thanks.

[sini69]

There seems to be some issues with hanging MySQL requests. Has this been reported by anyone else? My server load averages have gone nuts since installing this modification.

Running 'mysqladmin proc stat' returns this line....

| 25665 | sinister_qssipfd | localhost | sinister_qssipfdb | Query   | 111  | Copying to tmp table | SELECT a.*,p.*,t.* FROM ibf_attachments a  LEFT JOIN ibf_posts p ON ( p.pid=a.attach_rel_id )

All other query below this are locked and the site hangs while this is happening.

I have been talking to my server support and they won't go in to detail of course but they pointed me in the direction of a bad script. I looked through the sources/lib/func_myrides.php file and it is the file calling this above query.

I know another forum that is also running this script and it shows "10.5625 sec" load time, where mine is "163.7689 sec"

I imagine their timeout is just shorter than mine. The forum runs fine until someone opens the "my rides" forum.... then all other users experience a frozen forum for a short period.

I am no genius with PHP, MySQL or whatever but I've done my best to research and explain the problem.

[sini69]

Oh, and if multiple users open that forum you can guess what happens..... It can freeze for many minutes (5 minutes or so).

[Vince]

This is an issue only if you have:

a) lots of topics in the my rides forum, every topic has it's own image so for every topic it needs to query the database with the default of 20 it should work fine
every topic has more then 10 attachments attached to it.

either way this modification has to perform the query just to show the small image next to each topic title which is the attachment in that topic. if you want to make the board go faster you will need to remove that feature (if you want i can tell you how) and it should work fine. this was reported by only 2 members with really busy boards. the query is uses  a limit so it's optimized but when you via the forum with more then 20 topics on each page that can be a problem. and i guess that's what happens to you.

like i said if you want you can try to limit the amount of topics per forum page to 20 if that still doesn't work i can tell you how to remove the small images shown next to the topic title.

[sini69]

Hey Vadim,

I have 30 topics per page in the members ride forum though there is 25 pages which I assume is the problem. It doesn't just view the 30 on that page, but all threads that are viewable? I know IPB gives you the option to trim to say 30 per page with limit of last 30 days or the likes perhaps that is what you mean?

The other forum I was looking at using the same modification only has 5 pages (last 60 days).

[Vince]

it shouldn't matter the query will limit it per the amount of topics per page, i doubt if a forum with 5 pages of topics has the same issues. but this is only the second time someone reported this, i will try to see how this can be optimized maybe using cache but still there isn't much i can do at the moment besides telling you how to remove the query to show the small attachment next to each topic title.

[sini69]

Hey Vadim,

Just done a bit of testing with adjusting forum settings in the my rides section. It appears the pages does matter. I have changed it to 'past 60 days' and it is in fact quicker. So much quicker that it's not even an issue, where as before the entire forum was held up and traffic come to a near stop.

I have enabled the script again and have sub 2.x load times now, compared to the 15+, or sometimes minutes, load times.

As I mentioned in a previous post I don't know anything about mysql or php code but changing from "all" to "60 days" did indeed make a difference. No issues so far with "60 days" limit.

Just thought I would give you that feedback as I thought it may help you solve the problem. All going smooth so far.

Thanks Vadim.

[Vince]

Thanks for letting me know that, Yea i guess fetching X amount from the past 60 days will be quicker then fetching all of the topics. Glad you got this sorted out. Hopefully for V3 it won't be an issue even with the setting set to ALL.

Thanks, vadim.

[sini69]

Hey V88..... problem starting to come back again. It was running sweet for a little while but it's starting to bog again. I am not sure if it is google (or others) crawling the site but it's certainly bogging things down. I have decided to remove the forum from my google sitemap so it's not crawled but ideally I would like it crawled.

Since I paid for it I would also not like to limit or reduce its functionality by removing the images in the forum index. I think its' a great feature even if it is causing the problem.

Do you think perhaps you could look in to it a little more? Strange I (and only a couple others) are experiencing the problem while the majority are not.

If you want any server specs or version details let me know and I'll happily share.

Thanks.

[Vince]

I would appreciate getting some info like the site url, sever specs (just in case) and if you can PM me some ACP access so i could see if there is something that is miss configured.

Thanks, Vince.

[TX5]

anyway of gettin this fixed up to enable multipul use through my forum?

[TX5]

how much to get this mod made to use through out my forum on different parts of my choice?