Bug VBSEO to DBSEO migration issue

[OpenSightSoftware]

DBSEO 1.0.0 beta 8

Just installed DBSEO lastnight to replace VBSEO and I've run into a complicate migration issue.

My forum layout has 4 main categories (forum acting as category) and within each category are child forums.

The structure is as such

FlashFXP > News
FlashFXP > General Discussion
Donationware > Software

with VBSEO this structure was mapped as

http://www.flashfxp.com/forum/flashfxp/news/
http://www.flashfxp.com/forum/flashfxp/general-discussion/
http://www.flashfxp.com/forum/donationware/software/

Now with DBSEO (after importing from VBSEO) the structure has changed to the follow

http://www.flashfxp.com/forum/news/
http://www.flashfxp.com/forum/general-discussion/
http://www.flashfxp.com/forum/software/

What can I do to make DBSEO handle a structured layout where categories and forums are nested?

As-is this leads to a rather complicated issue with handling the following situation

FlashFXP > Release Archive > FlashFXP 3.0 Release Candidate > Bug reports
http://www.flashfxp.com/forum/bug-reports/

ioFTPD > ioFTPD > ioFTPD beta > Bug reports
http://www.flashfxp.com/forum/bug-reports/

I was expecting DBSEO to be a drop in replacement for VBSEO but at the moment this does not appear to be the case, at least for my specific situation.

 

[Fillip H.]

What's the value of the "Forum Path" and "Forum URLs" settings in the URL Rewrite Settings?

 

[Fillip H.]

Update: Nevermind, I see the issue. I will notify you as soon as a hotfix is available.

 

[Fillip H.]

Update 2: Multiple files have changed in order to correct this issue, I would recommend re-downloading the product and re-uploading all files.

 

[OpenSightSoftware]

Thank you for your amazing fast and prompt fix however I am seeing a slight problem.

I re-downloaded 1.0.0b8 and replaced all of the files on the server (and cleared all caches, etc)

There seems to be a slight problem with all forum urls showing as
http://www.flashfxp.com/forum/a/
or
http://www.flashfxp.com/forum/a/a/

The new build is live on my forum now if you want to take a look at it.

 

[Fillip H.]

Could you please create and PM me with a temporary FTP and AdminCP account?

For security reasons, we recommend you create a new FTP account only for DBTech support, then disable or delete it after we have both confirmed the issue has been solved and there are no further issues.

The same applies to AdminCP accounts; they should ideally be temporary accounts created for us only. If we have created an account on your site already, you can optionally boost that account to Administrator and then de-admin this account once the issue has been solved.

If you use a .htaccess password protection for your AdminCP directory, it is recommended that you create a new authorised user for DBTech and remove this user once the issue has been solved.

Please test any temporary accounts you create to ensure that the FTP account has access to the forum files, and that the AdminCP account can access the administrative controls for the product we are assisting you with.

Ensuring this is all in order before submitting the information will significantly speed up the process of assisting you. We will alert you via PM if there's any issues with the login information you have provided.

When sending the PM, for your security you should also un-tick the "Save a copy in my Sent Items folder" checkbox. When the access details have been received, we will delete the PM from our inbox. Ensuring you have not kept a copy of the PM reduces the risk of security breaches.

Thank you for helping us debug our products and allowing us to assist you, we appreciate it

 

[OpenSightSoftware]

Unfortunately I am not able to give you direct access to this server.

What's the value of the "Forum Path" and "Forum URLs" settings in the URL Rewrite Settings?

"[forum_path]" = [forum_title]

"Forum URLs" = [forum_path]/

I have attempted to determine the problem on my own since I am unable to allow you remote access and I have come up with a crude hack to solve the problem that might give you some insight on whats going on.

I have included the details below as hidden text, since I wasn't sure the best way to share it.

[HIDE]
File: /forum/dbtech/dbseo/includes/library/forum.php
.....
public static function createUrl($data = array(), $format = NULL)
.....
// Grab our forum cache
$forumcache = DBSEO::$db->fetchForumCache();

the problem is that $forumcache doesn't contain the correct information for "seopath" however if we call the function with $force set to true it forces the cached value to be updated and this updates "seopath" to the correct value and thus the line becomes

$forumcache = DBSEO::$db->fetchForumCache(true);

Not sure if maybe the forumcache is being created before enough information is available to create the correct seopath or if maybe another function needs to be called to force the seopath to update.

I noticed that the DBSEO::filterText() function returns "a" and thus never returning "", at some point FilterText() must be passed some invalid information that results in "a" being returned, perhaps the text being passed is an empty string and that causes this whole mess.

[/HIDE]

 

[Fillip H.]

Have you tried clicking the Clear System Cache link in the DBSEO CP?

If that doesn't work, are you able to set up a staging server and reproduce it there?

 

[OpenSightSoftware]

Have you tried clicking the Clear System Cache link in the DBSEO CP?

Yes.

I have some additional information for you.

(after undoing my fix)
If I view a post or thread directly after clearing the system cache then I can reproduce it every time.
i.e. http://www.flashfxp.com/forum/showthread.php?p=83196#post83196

Now if I clear the system cache again and then immediately load the main forum the problem doesn't seem to occur.
i.e. http://www.flashfxp.com/forum/

I did some php debug stack traces and came to the following

viewing a thread performs the flow logic
[HIDE]
DBSEO_Rewrite_Thread::createUrl()
DBSEO::$db->fetchForumCache();
DBSEO_Rewrite_Forum::createUrl();
DBSEO::$db->fetchForumCache();


My guess is that the second call to DBSEO::$db->fetchForumCache(); returns the wrong info unless $force is true since the cache isn't completely built at this point, my hack resulted in $force set to true side stepped the problem.

my guess is that the forumcache shouldn't be used unless its fully initialized and in this case its not when the second fetchForumCache() is called.

[/HIDE]

 

[Fillip H.]

Can you try re-downloading and re-uploading all files, then clear the cache again?

I made a few other changes that may have affected this issue.

 

[OpenSightSoftware]

I am afraid that this update does not resolve the problem.

Your code changes don't appear take into consideration that the forumcache contains an invalid seopath

because your FilterText() replaces an empty string with "a" we have to take that into consideration when seopath is set to say "a" or "a/a"

if the $forumcache is initialized and seopath = "a", "a/a", etc then the cache needs to be updated instead of the cached value being returned, once the cache is set it doesn't appear to ever update the seopath with the correct values without being forced to do.

 

[Fillip H.]

The "a" is a fall-back, and it's not actually relevant to the core issue at all. Without access to a staging server or at least write access to the DBSEO files for your live server, I have unfortunately no way of replicating this issue and thus no way of assisting you further.

Please investigate whether it is possible to grant write access to a specific folder (the "dbtech/dbseo" folder and all files within it) on your server setup so that you can grant me the access I require to look into this issue and fix it.

 

[Fillip H.]

Update: I've been able to replicate this issue locally, I will post back when I have more information or a hotfix is available.

 

[Fillip H.]

Update 2: This should now be fixed

If you re-download the product, re-upload the files and then Clear System Cache within the DBSEO AdminCP, the URLs should display correctly.

 

[OpenSightSoftware]

Thank you very much. I can confirm that the issue is now 100% fixed :RpS_w00t: