XMB Forum Software
Not logged in [Login - Register]
Go To Bottom

Printable Version  
 Pages:  1  
Author: Subject: [Resolved] Cannot Update Forum Settings
Christina
Member
***




Posts: 25
Registered: 7-1-2012
Member Is Offline


[*] posted on 11-17-2013 at 05:58 AM
[Resolved] Cannot Update Forum Settings


Full Board URL: http://www.exposureforums.org/
XMB Version: 1.9.11

When trying to access cp.php?action=forum to update forums, it will not update. I can access the file but cannot update any information. If I try to update something, it just reloads the page again.

I installed hacks but it worked for a few months after I installed the hacks so I don't think that's the problem.

Any suggestions?
View user's profile View All Posts By User
Christina
Member
***




Posts: 25
Registered: 7-1-2012
Member Is Offline


[*] posted on 11-19-2013 at 03:34 PM


Any help would be appreciated! Thanks.
View user's profile View All Posts By User
lottos
Administrator
********




Posts: 461
Registered: 6-3-2002
Member Is Offline

Mood: pass me a TimTam

[*] posted on 11-19-2013 at 08:17 PM


Check with webhost to see if they did any php or mysql upgrades just prior to the issue starting.

Create a new test forum area, eg http://www.exposureforums.org/test/, upload XMB 1.9.11 and create a copy of your database, then link the test forum to the database copy. Test to see if the problem occurs. Start installing each hack and test to see if problem occurs. If problem occurs you will know which, if any, hack was the cause.



View user's profile View All Posts By User
Christina
Member
***




Posts: 25
Registered: 7-1-2012
Member Is Offline


[*] posted on 11-21-2013 at 05:44 AM


I tried using a fresh cp.php file and it didn't work. The database is HUGE and took me a few days to update from 1.9.5 to 1.9.11 which is why I don't want to go that route quite yet but will if need be.

The hacks I have installed are: Theme preview, Shop, Thread Totals, and Custom Themes... do you know if any of those are known to cause issues?

Any help would be appreciated! Thanks.
View user's profile View All Posts By User
Christina
Member
***




Posts: 25
Registered: 7-1-2012
Member Is Offline


[*] posted on 11-24-2013 at 04:19 PM


Still not resolved if anyone can help, thanks! :)
View user's profile View All Posts By User
Christina
Member
***




Posts: 25
Registered: 7-1-2012
Member Is Offline


[*] posted on 12-15-2013 at 10:32 PM


Sorry for the triple post, but I uninstalled the hacks and checked this program before reinstalling a hack and before reinstalling another and it kept doing the same thing.

My theory is because the database is so big... could that be the problem? If so, how would I go about deleting a specific forum & all its threads via phpMyAdmin? Any help is appreciated. :)
View user's profile View All Posts By User
lottos
Administrator
********




Posts: 461
Registered: 6-3-2002
Member Is Offline

Mood: pass me a TimTam

[*] posted on 12-16-2013 at 08:06 AM


Quote: Originally posted by Christina  
I tried using a fresh cp.php file and it didn't work. The database is HUGE and took me a few days to update from 1.9.5 to 1.9.11 which is why I don't want to go that route quite yet but will if need be.

The hacks I have installed are: Theme preview, Shop, Thread Totals, and Custom Themes... do you know if any of those are known to cause issues?

Any help would be appreciated! Thanks.


OK,

instead of

Quote: Originally posted by lottos  
Check with webhost to see if they did any php or mysql upgrades just prior to the issue starting.

Create a new test forum area, eg http://www.exposureforums.org/test/, upload XMB 1.9.11 and create a copy of your database, then link the test forum to the database copy. Test to see if the problem occurs. Start installing each hack and test to see if problem occurs. If problem occurs you will know which, if any, hack was the cause.


try


Create a new test forum area, eg http://www.exposureforums.org/test/, upload a new copy of XMB 1.9.11 from our downloads and link the test forum to the existing database. You may have to temporarily change the xmb_settings table via phpmyadmin to make that point back to the test forum area. Test to see if the problem occurs. If it doesn't then you have residual issues from a hack install on your production install.



View user's profile View All Posts By User
lottos
Administrator
********




Posts: 461
Registered: 6-3-2002
Member Is Offline

Mood: pass me a TimTam

[*] posted on 12-17-2013 at 08:24 PM


Member doesn't appear to take on advice.

Closed.



View user's profile View All Posts By User
Christina
Member
***




Posts: 25
Registered: 7-1-2012
Member Is Offline


[*] posted on 12-19-2013 at 04:40 AM


I was away for business and couldn't try it right away.

I just installed a fresh install here: http://www.exposureforums.org/test/ and linked it to the existing database. Tried moving/renaming a forum and it continues to just reload the page again.

Is there anything that can be done to fix this?
View user's profile View All Posts By User
lottos
Administrator
********




Posts: 461
Registered: 6-3-2002
Member Is Offline

Mood: pass me a TimTam

[*] posted on 12-19-2013 at 10:10 PM


It could be attempted via mySQL, but you really need to know what it is you're trying to change.

Just out of curiousity, you said your database is large - how many posts?



View user's profile View All Posts By User
Christina
Member
***




Posts: 25
Registered: 7-1-2012
Member Is Offline


[*] posted on 12-20-2013 at 02:38 AM


14466 topics / 179117 posts / 1804 members

Any help would be appreciated... it would be so hard to start over.
View user's profile View All Posts By User
lottos
Administrator
********




Posts: 461
Registered: 6-3-2002
Member Is Offline

Mood: pass me a TimTam

[*] posted on 12-20-2013 at 04:53 AM


That is odd. I really doubt it's the size of your database as it's not large at all.

More likely to be a slow webhost and it's timing out.


I have 157937 topics / 1089751 posts / 108835 members and no issue like yours.

Can you define exactly what you are trying to do?




View user's profile View All Posts By User
Christina
Member
***




Posts: 25
Registered: 7-1-2012
Member Is Offline


[*] posted on 12-20-2013 at 05:59 AM


Hm, strange.

What's happening is when I go to the admin page to update the forums (cp.php?action=forum), it won't let me update. I'll make the change (i.e. changing a board from on to off, etc) and press "submit changes" and all it does it reload the page and not make any changes. It just takes me back to cp.php?action=forum without making the change.
View user's profile View All Posts By User
lottos
Administrator
********




Posts: 461
Registered: 6-3-2002
Member Is Offline

Mood: pass me a TimTam

[*] posted on 12-20-2013 at 08:52 PM


UPDATE xmb_forums set status = 'off' WHERE fid = 'fidnum';


(replace fidnum with the forum id number - find this via Admin or by hovering mouse over forum title on index page.)


If this works and I believe it will, perhaps a possible issue with your forum is some additional 'column' on your forums table placed there by a mod/hack, which the forum admin script itself isn't aware of. You could check this by comparing the columns between your existing database xmb_forums table and from a fresh xmb forum install which creates a new empty database, or another way is to run this via phpmyadmin:

describe xmb_forums

then list the output here and someone can compare it to a default install.



View user's profile View All Posts By User
Christina
Member
***




Posts: 25
Registered: 7-1-2012
Member Is Offline


[*] posted on 12-21-2013 at 02:09 AM


Okay, I ran the first query and it worked. Here is the list I see when entering describe xmb_forums:


Field Type Null Key Default Extra
type varchar(15) NO MUL
fid smallint(6) NO PRI NULL auto_increment
name varchar(128) NO
status varchar(15) NO MUL
lastpost varchar(54) NO
moderator varchar(100) NO
displayorder smallint(6) NO MUL 0
description text YES NULL
allowhtml char(3) NO
allowsmilies char(3) NO
allowbbcode char(3) NO
userlist text NO NULL
theme smallint(3) NO 0
posts int(10) NO 0
threads int(10) NO 0
fup smallint(6) NO MUL 0
postperm varchar(11) NO 0,0,0,0
allowimgcode char(3) NO
attachstatus varchar(15) NO
password varchar(32) NO
View user's profile View All Posts By User
Christina
Member
***




Posts: 25
Registered: 7-1-2012
Member Is Offline


[*] posted on 12-24-2013 at 07:55 PM


Do those look different than how they should look?
View user's profile View All Posts By User
Mouser
XMB Contributor
********




Posts: 202
Registered: 4-14-2008
Member Is Offline

Mood: Christmasy. Yes, in September.

[*] posted on 12-27-2013 at 02:48 PM


Just compared that to the XMB schema :: ./include/schema.inc.php
Looks the same like a XMB 1.9.13 installation.

Is it the cp.php file or the cp2.php file ? I forgot ... anyways, could you attach it here?
I'll be away till January 6th, but ... I'd like to build in some "echo's" to see if every part of information is actually being submitted and received correctly.
View user's profile View All Posts By User
Christina
Member
***




Posts: 25
Registered: 7-1-2012
Member Is Offline


[*] posted on 12-28-2013 at 04:54 PM


It's the cp.php file. Thanks Mouser!

Attachment: cp.php (124kB)
This file has been downloaded 321 times

View user's profile View All Posts By User
lottos
Administrator
********




Posts: 461
Registered: 6-3-2002
Member Is Offline

Mood: pass me a TimTam

[*] posted on 12-29-2013 at 07:32 AM


Hey Mouser, just so you are aware:

I requested Christina use a fresh xmb and point it to her DB and she says it errored again.

The cp file is modded with FunForum's theme preview and some other stuff, so if you're going to edit it with echo's, perhaps some echos around the mods might be beneficial.

The list of non-standard lines is attached.

Attachment: delete.txt (9kB)
This file has been downloaded 207 times





View user's profile View All Posts By User
Mouser
XMB Contributor
********




Posts: 202
Registered: 4-14-2008
Member Is Offline

Mood: Christmasy. Yes, in September.

[*] posted on 12-29-2013 at 09:45 AM


Thanks for the additional info lottos!

Odd. So all that happens, is the same page reloads again.
Is that only when modifying forums? Or is that with every part of the Admin Panel ?

Theme Preview and Custom Themes I've installed as well, no issues on my board so far. Same happening on a fresh install, then it's even weirder :(

When you're in the Admin Panel --> Forums... Can you check out the source code? Right mouse button --> 'View Source' (or something alike)
Then search for "forumsubmit" and copy/paste me the line here where that is present.
Should look something like this;
Code:
<td bgcolor="#FFFFFF" class="ctrtablerow"><input type="submit" name="forumsubmit" value="Submit Changes" class="submit" /></td>


Then try this file.
It will echo the content $_POST array. Lets see if the info even arrives.

A very small start.. But gotta start somewhere :)


Attachment: cp.php (124kB)
This file has been downloaded 305 times

View user's profile View All Posts By User
 Pages:  1  

  Go To Top

Powered by XMB 1.9.12 (Debug Mode)
XMB Forum Software © 2001-2024 The XMB Group
[Queries: 16] [PHP: 68.1% - SQL: 31.9%]