Pages:
1
2 |
Christina
Member
 
Posts: 30
Registered: 7-1-2012
Member Is Offline
|
|
[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?
|
|
Christina
Member
 
Posts: 30
Registered: 7-1-2012
Member Is Offline
|
|
Any help would be appreciated! Thanks.
|
|
lottos
Administrator
      
Posts: 482
Registered: 6-3-2002
Member Is Offline
Mood: pass me a TimTam
|
|
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.
|
|
Christina
Member
 
Posts: 30
Registered: 7-1-2012
Member Is Offline
|
|
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.
|
|
Christina
Member
 
Posts: 30
Registered: 7-1-2012
Member Is Offline
|
|
Still not resolved if anyone can help, thanks! 
|
|
Christina
Member
 
Posts: 30
Registered: 7-1-2012
Member Is Offline
|
|
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. 
|
|
lottos
Administrator
      
Posts: 482
Registered: 6-3-2002
Member Is Offline
Mood: pass me a TimTam
|
|
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.
|
|
lottos
Administrator
      
Posts: 482
Registered: 6-3-2002
Member Is Offline
Mood: pass me a TimTam
|
|
Member doesn't appear to take on advice.
Closed.
|
|
Christina
Member
 
Posts: 30
Registered: 7-1-2012
Member Is Offline
|
|
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?
|
|
lottos
Administrator
      
Posts: 482
Registered: 6-3-2002
Member Is Offline
Mood: pass me a TimTam
|
|
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?
|
|
Christina
Member
 
Posts: 30
Registered: 7-1-2012
Member Is Offline
|
|
14466 topics / 179117 posts / 1804 members
Any help would be appreciated... it would be so hard to start over.
|
|
lottos
Administrator
      
Posts: 482
Registered: 6-3-2002
Member Is Offline
Mood: pass me a TimTam
|
|
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?
|
|
Christina
Member
 
Posts: 30
Registered: 7-1-2012
Member Is Offline
|
|
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.
|
|
lottos
Administrator
      
Posts: 482
Registered: 6-3-2002
Member Is Offline
Mood: pass me a TimTam
|
|
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.
|
|
Christina
Member
 
Posts: 30
Registered: 7-1-2012
Member Is Offline
|
|
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
|
|
Christina
Member
 
Posts: 30
Registered: 7-1-2012
Member Is Offline
|
|
Do those look different than how they should look?
|
|
Mouser
XMB Contributor
      
Posts: 202
Registered: 4-14-2008
Member Is Offline
Mood: Christmasy. Yes, in September.
|
|
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.
|
|
Christina
Member
 
Posts: 30
Registered: 7-1-2012
Member Is Offline
|
|
It's the cp.php file. Thanks Mouser! Attachment: cp.php (124kB) This file has been downloaded 419 times
|
|
lottos
Administrator
      
Posts: 482
Registered: 6-3-2002
Member Is Offline
Mood: pass me a TimTam
|
|
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 253 times
|
|
Mouser
XMB Contributor
      
Posts: 202
Registered: 4-14-2008
Member Is Offline
Mood: Christmasy. Yes, in September.
|
|
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 420 times
|
|
Pages:
1
2 |