(HELP) Registration database error

[tamiyausa]

They only way I fixed it was to delete the old database and run Impex again.

I was merging 3 forums into one and the 2nd merge had no issues, it was not until the 3rd was there issues. I...

[tamiyausa]

yup I did


Database error in vBulletin 4.2.0:

Invalid SQL:
INSERT INTO userfield
(field2, userid)
VALUES
('CA', 2848);

...

[tamiyausa]

VB4.2 site

If someone trys to register they can fill in all the info when they submit it and get to this page /forum/register.php?do=addmember


Its just a generic error...

[tamiyausa]

Ok so here is the story...

Merged VB 4.2 forums to one.

Some icons do not show like "/forum/images/icons/icon5.png"
Others do show "/forum/images/icons/icon1.png"...

[tamiyausa]

I have two slower forums and thinking of combining them to maybe get more user interaction.

Is there a way to do this, there are alot of useful posts, info etc. hate to loose info from either...

[tamiyausa]

Ok I figured out the problem, by mistake...

it was a skin issue, the skin I had installed was blocking delete issues for some reason? Skin has been removed and now everything works the way...

[tamiyausa]

Ok, never mind it is still happening.

A bit more info

Super mod can not delete post from front end but if the click the mod and login to the backend ModCP they can delete posts...

[tamiyausa]

Ok the only way I was able to solve this was bring my site back to 3.X then load the 4.1.1 files and run the update once again.

Seems to be working now, I just need to check with a few other...

[tamiyausa]

Thanks, I have verified it works. I never noticed that as mine is always checked i guess...

Thanks again.

[tamiyausa]

I have a user that says, he can see messages in his inbox, but when he looks at sent messages its ZERO.

So I logged in as him and I see the same thing, So I'm thinking they got deleted......

[tamiyausa]

Further messing around and testing things, I was wrong admin's can not complete a successful Delete or ban via modcp.

I had tried to do a "delete and ban" as a super mod it would...

[tamiyausa]

Ok bumping the PHP memory to 64M fixed the issue.

thanks

[tamiyausa]

Steve, thanks I have looked at that page before with never any results. I was able to finally get an error to display on the white page> Fatal error: Allowed memory size of 16777216 bytes exhausted...

[tamiyausa]

So I have been receiving complaints on one of our forums that when people try to read a new PM in their inbox they get a white page upon clicking the message.

Board is running 4.1.1
...

[tamiyausa]

I hope this way it is more clear...

Upgraded from 3.x to 4.1.1

Before super mods could delete or ban members in mod que. Now in upgraded 4.1.1 they can not but I as as the admin...

[tamiyausa]

Thanks but in my last post I said I was in the Mod manager as you can see in the screen shot provided. marked all to yes except the "LAST TWO"...

[tamiyausa]

Ok I have upgraded from 3.x to 4.1.1

Now super mods that were able to "delete posts as spam" or "delete posts" can not.

I even moved one of them to admin...

[tamiyausa]

Ok, looks the the problem is user based.

I can create a new user and that user can open new PM's fine.
I was able to login to the DB and reset some user info on my main admin and now...

[tamiyausa]

Nobody? This is still and issue and need help please...

[tamiyausa]

Ok here goes the details:

Started getting blank pages on reading a NEW PM

Went through all the blank page fixes

No luck so I

exported the DB and imported...