XMB Forum Software

[Resolved] Cannot Update Forum Settings

Christina - 11-17-2013 at 05:58 AM

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 - 11-19-2013 at 03:34 PM

Any help would be appreciated! Thanks.

lottos - 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.

Christina - 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.

Christina - 11-24-2013 at 04:19 PM

Still not resolved if anyone can help, thanks! :)

Christina - 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. :)

lottos - 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.

lottos - 12-17-2013 at 08:24 PM

Member doesn't appear to take on advice.

Closed.

Christina - 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?

lottos - 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?

Christina - 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.

lottos - 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?

Christina - 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.

lottos - 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.

Christina - 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

Christina - 12-24-2013 at 07:55 PM

Do those look different than how they should look?

Mouser - 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.

Christina - 12-28-2013 at 04:54 PM

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

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

lottos - 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 241 times

Mouser - 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 388 times

Christina - 12-29-2013 at 10:55 PM

It happens just when modifying forums not every part of the admin panel.

Code:
<td bgcolor="#eceae0" class="ctrtablerow"><input type="submit" name="forumsubmit" value="Submit Changes" class="submit" /></td>


Tried the new file and didn't make any changes but it did post some array at the top. I've attached that file since it was large.

Thanks again for the help Mouser!

Attachment: array.txt (27kB)
This file has been downloaded 264 times

Daniel Gouveia - 12-30-2013 at 02:46 AM

Just to confirm my theory.

First of all, create a new forum with the latest version of the xmb in a new folder as lottos said, only this time use a new database.

Try creating "forums" to see if it works.

Done that, in your forum "http://www.exposureforums.org/" , go to the admin painel to edit forums, and the category you want to edit, you will press "More Options...", makes some changes and sees if it works.

If you can edit using "More Options", This proves that the XMB has a limit of forums that can create or change by "cp.php?action=forum", and need a fix to work.

Christina - 12-30-2013 at 05:49 AM

http://www.exposureforums.org/test/ and tried to create a new forum and it worked.

http://www.exposureforums.org/ when in the admin panel and editing under "More Options..." it updates the forum; however, I'm still unable to create new Forums/Sub Forums/etc because it just reloads the page.

I don't know what else it can be but I hope we can all figure it out one way or another :)

I appreciate all the help!

Daniel Gouveia - 12-30-2013 at 01:55 PM

Test this cp.php, you can creat new forums but you cant edit forums yet.

Attachment: cp.php (127kB)
This file has been downloaded 387 times

Christina - 12-31-2013 at 04:35 AM

No, I still was not able to create a new forum. I tried making a sub forum if that makes any difference. It didn't reload the page but it didn't add it either.

Thanks for helping!

Daniel Gouveia - 12-31-2013 at 04:16 PM

Sorry for that, I noticed that I have attached the wrong cp.php
Test this cp.php this will work.

Attachment: cp.php (127kB)
This file has been downloaded 404 times

Christina - 12-31-2013 at 06:07 PM

That worked! I was able to create a new forum, but like you said still unable to edit forums.

Thanks for helping!

Daniel Gouveia - 1-1-2014 at 06:04 AM

Quote: Originally posted by Christina  
That worked! I was able to create a new forum, but like you said still unable to edit forums.

Thanks for helping!


Before test this new cp.php, make backup of your "forums" table, you only need to make this backup.

With this cp.php you can creat and edit forums without a problem, but this is only a small fix still needs to be thoroughly tested and may cause some conflicts, so first make a backup of the table because if you have problems you can restore it.

Test it and give me some feedback.

Attachment: cp.php (128kB)
This file has been downloaded 403 times

Christina - 1-1-2014 at 08:44 AM

Hello,

Backed up the forums table and uploaded the new cp.php file and tried to edit forums and still did not work. It just reloaded the page and the edits did not stick.

I appreciate all the help.

Daniel Gouveia - 1-1-2014 at 08:50 PM

You can send me via PM one acount "test" with super admin for me to test your system?
And if is possivel acess to the ftp in case i need to change some code in files.

Christina - 1-4-2014 at 02:04 AM

Okay, I will send over the info!