Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
general-topic
Order Groups and Forums not loading
Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Feb 26, 2014 - 11:40 am

I would suggest an attachment to a PM to me.

And a link to your forum page if that's Ok so I can see the order displayed there and let me know which ones are wrong... It will be later tonight now I am afraid but I will get it done today.

andy-signature.png
YELLOW
SWORDFISH
Avatar
gorky5
Member
Free Members
sp_UserOfflineSmall Offline
Feb 26, 2014 - 12:07 pm

Thanks Andy. I really appreciate the help. I edited my previous message and included the attachment. Feel free to remove it once you've grabbed it from there (I can't edit the message any longer).

My forum is http://www.beatlesbible.com/forum/

There are quite a few errors, but I'll try to detail them all:

  • John Lennon, Paul McCartney, George Harrison and Ringo Starr forums should all be below "Recording and musicology", in that order (Ringo's already is in the right place; the other three need to go above)
  • In "Non-Beatles discussions" there are two sub-forums which have been orphaned - "Forum games" and "Heal/Hurt games". These should be sub-forums of "All together now".
  • Also in "Non-Beatles discussions" are forums for various albums. These were previously sub-forums of "The albums". The order of these sub-forums is currently correct and should be retained: Please Please Me; With The Beatles; A Hard Day's Night; Beatles For Sale; Help!; Rubber Soul; Revolver; Sgt Pepper; Magical Mystery Tour; White Album; Yellow Submarine; Abbey Road; Let It Be; Live At The BBC; Anthology; Love

Thanks again Andy - it's really good of you to help with this.

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Feb 26, 2014 - 3:23 pm

Are you going to send me the database table dump as well?

 

 

andy-signature.png
YELLOW
SWORDFISH
Avatar
gorky5
Member
Free Members
sp_UserOfflineSmall Offline
Feb 27, 2014 - 5:36 am

As I said previously, I'd included it in an earlier message.

No matter, I'll send it as a PM too.

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Feb 27, 2014 - 6:19 am

I am ever so sorry. I completely missed that.

Now I have found it... however, what you have sent me is a csv file and I really do need a standard SQL dump so that I can insert it into my test database and work with it.

andy-signature.png
YELLOW
SWORDFISH
Avatar
gorky5
Member
Free Members
sp_UserOfflineSmall Offline
Feb 27, 2014 - 8:45 am

Sorry, I wasn't sure what the best format would be. I'll PM you an SQL version.

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Feb 27, 2014 - 9:33 am

I have sent you a PM.

andy-signature.png
YELLOW
SWORDFISH
Avatar
Omar Jordan
Member
Free Members
sp_UserOfflineSmall Offline
Mar 1, 2014 - 2:05 pm

Yellow Swordfish said
Thanks to the help of a user who let us look at his database we have now pinned this issue down and have what we hope is a fix currently in testing.

The problem seems to come about when the order groups/forums panel is used for the first time when the actual display sequence data held against the forums is basically corrupted. The annoying thing is that the new panel was designed to avoid potential corruptions in the sequence data but doesn't appear to handle existing corruptions properly. And for that we apologise but that was hard to test for as there can be so many different combinations.

We are pretty sure that if the sequence numbers (forum_seq) are corrected in the raw data before using the new panel then all is well. And we have re-written some of the code to help deal with this but, as I say, that is currently in testing. Manually correcting the sequence data using a tool like phpMyAdmin is possible but obviously not to be recommended for those with little or no experience of editing raw data tables.

Again we really do apologise for this. Let me know if you need any help as I am willing to try and correct your data if you wanted to send it to me.

Does this mean that you might be able to help correct my potentially corrupt data to get my clients forum fully running? I am only little familiar with phpMyAdmin.

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Mar 2, 2014 - 3:13 am

It can always be manually changed if the correct sequence is known and the database table is available. I would need a sql dump of the sfforums table and a listing of the correct sequence.

andy-signature.png
YELLOW
SWORDFISH
Avatar
Omar Jordan
Member
Free Members
sp_UserOfflineSmall Offline
Mar 2, 2014 - 3:04 pm

I could definitely get you a sql dump. But I'm not sure what the correct sequence is supposed to be. Do you just simply need to know the correct order the forums are supposed to be in? I can get that from my client.

Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 650
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 617
Members: 17359
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10125
Posts: 79620