MyBB Community Forums

The table canusepaypal is not created in mybb_adminoptions
The last tables are: canrunmaint, caneditpms
I think that is the reason why I have no permission.

mySQL error: 1054
Unknown column 'canusepaypal' in 'field list'
Query: UPDATE mybb_adminoptions SET permsset='1', caneditsettings='yes', caneditann='yes', caneditforums='yes', canmodposts='yes', caneditsmilies='yes', caneditpicons='yes', caneditthemes='yes', canedittemps='yes', caneditusers='yes', caneditpfields='yes', caneditugroups='yes', caneditaperms='yes', caneditutitles='yes', caneditattach='yes', canedithelp='yes', canrunmaint='yes', canusepaypal='yes' WHERE uid='1'

No. The reason is that the function I use to check to see if the field exists is broken in the current MyBB version (I think I corrected the mistake long ago on my local copy of MyBB and never realised it wasn't fixed on MyBB).

What you need to do is go to phpMyAdmin and go to the SQL tab.
Do the following SQL command

ALTER TABLE mybb_adminoptions ADD canusepaypal DEFAULT 'no'

You will then need to give yourself permissions again.

Thanks for your support.
I can view the paypal transactions now.

If phpmyadmin is telling you that you are using invalid syntax [or similar message], try:

ALTER TABLE `mybb_adminoptions` ADD `canusepaypal` VARCHAR( 3 ) DEFAULT 'no' NOT NULL ;

That's what was causing my problems.