A few users of my boards are having a problem lately that I have run out of ideas on what might be wrong and where to look to try to fix it.
Running 6.4.1, with IIP 5.4.4, Sidebar Pal, and a few other mods. Everything worked flawlessly before I upgraded to 6.4.1 and installed IIP and Sidebar Pal (was running 6.4 with a few mods prior to that, and the only changes since then are the upgrade to 6.4.1 and the installation of IIP and Sidebar Pal).
A FEW users (only two that I'm sure of right now) are able to see and read the forums . . . but cannot post, and cannot send PMs. They can hit a reply link, or a new thread link, or a send a PM link, and get the text entry form, and type things in, but once they hit Submit (or well, I guess, "Continue"), it just refreshes the page with entirely blank entry boxes again, and doesn't actually post anything.
I've logged in as them with "Become this user" and tried to post something, and was unable to do so. Once I log out and log back in as myself, everything works fine for me - and it's working fine for the majority of my users.
Any thoughts or suggestions on this one? Anyone seen something similar before?
Ok. I've attached it to this post as a text file for the new post page's source.
Also, from the sql error logs, I've seen this pop up:
Thu, Feb 12 2004 16:40:30 -0700 /forums/viewmessage.php Chief_Boats Unable to do_query: UPDATE w3t_Messages SET M_Status = ' ' WHERE M_Uid = '374' AND M_Number = - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4
I'm glad to see that I'm not the only person going crazy with this problem...
it only occurred in while creating replies - they complained about not being able to write PM, but that was BS since the actual error was found in "addpost.php" and not any other module.
After I solved the problem, they still complained. Then I told them to clear their cache & cookies - they never saw the problem again
I'm having fits on this. Almost every new user that registers is unable to submit anything - make posts, send private messages, or even update their profiles. Clearly, something's not getting properly set when they register, but I'm not familiar enough with the registration process that I don't know which files to scour. I don't remember any of the mods I've done touching on registration stuff either.
[]JoshPet said: What exactly makes you think that it's the U_Name field (this is their real name)? That field isn't required and it's not used during registration.
Or did you mean U_Username (that's the display name you see online).
When you upgraded to 6.4.1 did you upgrade ALL scripts (I believe the changedfiles.txt file was missing a few files). [/]
I'm not sure it's that field. It seemed to be missing, and I added it for a few users, and they then seemed to be able to post.
When I upgraded, I believe I took Beyond Compare and compared my existing install of a modified 6.4 to the clean 6.4.1 and examined files with differences, as well as manually consulting the changedfiles.txt. There is a small possibility something may have been missed.
Hmm. Doubtful, as if it affects someone, it prevents them from posting on their account on any system, whereas I can post fine on my account, but if I become that user, I cannot post. I'll try it under one of the Mozilla variants and see if it makes any difference.
I would try stock scripts for a bit - and see if that fixes the problem. You probably missed something in doing beyond compare. There were some new security checks in place for 6.4.1 and such - so you'd want to make sure you had everthing correct.
I've run through another beyond compare session . . . I unzipped a fresh copy of 6.4.1, and then downloaded a fresh copy of the forum from the site (not that I don't already have the same code, in theory, locally, but it never hurts to be -sure-). Went through and changed every little single bit of difference between the fresh and the live code other than things I know are changes from specific mods - even little things like there being or not being a couple of trailing spaces after something.
I *think* I've got it fixed, as I just made a new user account and was able to post (and tried both Mozilla and IE6) fine. I'm waiting to hear back from a few users who have been having problems.
If this does fix it . . . good, but I'm also going to be extremly annoyed. NOTHING in ANY of the differences leapt up to me as something that seemed like the likely cause for this problem. I'd have been happier going through everything, then finding one thing and thinking "Oh, that's the problem, I'm such an idiot." I hate it when things are fixed but I don't understand WHY.
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.