MyBB Community Forums

Did you use the final version, or the beta?

Just upgraded to final, still getting this error whenever I try to update any usergroup:

MyBB SQL Error

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1054 - Unknown column 'canaddusermappin' in 'field list'
Query:
UPDATE mybb_usergroups SET type='1', title='Members', description='', namestyle='{username}', usertitle='', stars='0', starimage='images/star.png', image='images/membergroup.png', isbannedgroup='0', canview='1', canviewthreads='1', canviewprofiles='1', candlattachments='1', canpostthreads='1', canpostreplys='1', canpostattachments='1', canratethreads='1', caneditposts='1', candeleteposts='1', candeletethreads='1', caneditattachments='1', canpostpolls='1', canvotepolls='1', canusepms='1', cansendpms='1', cantrackpms='1', candenypmreceipts='1', pmquota='0', maxpmrecipients='5', cansendemail='1', maxemails='5', canviewmemberlist='1', canviewcalendar='1', canaddevents='1', canbypasseventmod='0', canmoderateevents='0', canviewonline='1', canviewwolinvis='0', canviewonlineips='0', cancp='0', issupermod='0', cansearch='1', canusercp='1', canuploadavatars='1', canchangename='1', showforumteam='0', usereputationsystem='1', cangivereputations='1', reputationpower='1', maxreputationsday='5', attachquota='0', cancustomtitle='1', canwarnusers='0', canreceivewarnings='1', maxwarningsday='3', canmodcp='0', canviewusermap='1', canaddusermappin='' WHERE gid='2'

Um, is this still being worked on?

Hmm...it would be cool if it was recorded automatically based on IP of visitors, and had different colors for different types of visitors, like Digital Point:

http://forums.digitalpoint.com/usermap.php

(2008-10-11, 12:32 AM)Zash Wrote: [ -> ]Hmm...it would be cool if it was recorded automatically based on IP of visitors, and had different colors for different types of visitors, like Digital Point:

http://forums.digitalpoint.com/usermap.php

This map doesn't show which users the pins belong to ... pretty useless.

well... and i deactivated the old version first...
damn... why me?!

cheers
mia

(2008-10-11, 05:09 AM)Bey Brad Wrote: [ -> ]

(2008-10-11, 12:32 AM)Zash Wrote: [ -> ]Hmm...it would be cool if it was recorded automatically based on IP of visitors, and had different colors for different types of visitors, like Digital Point:

http://forums.digitalpoint.com/usermap.php

This map doesn't show which users the pins belong to ... pretty useless.

Well then you make one that can ... I was focusing on the fact of it being automatic, not having usernames. And if you wanted you can always switch between two different settings.

I think we should focus on getting the current one actually working first :x

Again, sorry for the late answers. But, school is really started now, problems with my mothers computer are solved, so I hope I can finally become as active as in the past, again.

(2008-10-02, 06:47 PM)Bey Brad Wrote: [ -> ]Just upgraded to final, still getting this error whenever I try to update any usergroup:

ERROR TEXT DELETED

Did you maybe restore the table after you activated the plugin? Are you sire you downloaded it here (by the URL to http://forum.online-urbanus.be, or on the mods site)? Anyway, I'll make you, and all the other people that got this problem, a fix:

ALTER TABLE `mybb_usergroups` ADD `canaddusermappin` INT(1) NOT NULL DEFAULT '1';

If you don't use the default mybb_ prefix, just update it to the one you use and run this query with PHPMyAdmin.

(2008-10-11, 12:32 AM)Zash Wrote: [ -> ]Hmm...it would be cool if it was recorded automatically based on IP of visitors, and had different colors for different types of visitors, like Digital Point:

http://forums.digitalpoint.com/usermap.php

This can be a future option/plugin to have an extra page with a map with all Online users + eventually the username, otherwise "Guest", or the translation in your used language.

(2008-10-11, 05:12 PM)Mia Wrote: [ -> ]well... and i deactivated the old version first...
damn... why me?!

cheers
mia

You can do the same as said to Bey Brad

Thank you!