MyBB Community Forums - MyBB 1.4.2

[F] Forum Management - Setting permisions (when all perms are 0)

Wed, 26 Nov 2008 15:38:17 +0000

When all permissions are unchecked: (in ADMINDIR/index.php?module=forum/management&fid=FID#tab_permissions)
foreach($mybb->input['permissions'] as $gid => $permission)

will not work:
Warning [2] Invalid argument supplied for foreach() - Line: 1662 - File: admin/modules/forum/management.php PHP 4.3.11 (Linux)

File: /admin/modules/forum/management.php Line: 1662 Function: unknown

it might be only me but I can't seem to fix it :/

[F] Mass Mail send also to users who disabled to receive mails from Admins

Tue, 25 Nov 2008 21:16:16 +0000

Hello,

i have an Problem, i made an mass mail on my forum (10000 Users) and get now many reports that users who disable "Receive emails from the Administrators." in the UserCP are still receiving the mail?
i use mybb 1.4.3, any idea what is wrong?? or is it an bug in mybb.

regards
cHarOn

[F] [PostgreSQL] Usergoup group by

Mon, 24 Nov 2008 17:45:10 +0000

There is a bug in the usercp.php line 2527 at the select of the usergroups.

MyBB SQL Error

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
    42803 - ERROR: column "g.title" must appear in the GROUP BY clause or be used in an aggregate function 
Query:
    SELECT g.title, g.gid, g.type, COUNT(u.uid) AS users, COUNT(j.rid) AS joinrequests, l.canmanagerequests, l.canmanagemembers FROM zero_groupleaders l LEFT JOIN zero_usergroups g ON(g.gid=l.gid) LEFT JOIN zero_users u ON(((','|| u.additionalgroups|| ',' LIKE '%,'|| g.gid|| ',%') OR u.usergroup = g.gid)) LEFT JOIN zero_joinrequests j ON(j.gid=g.gid) WHERE l.uid='1' GROUP BY g.gid

You have to give all columns which are listed in the select-statement.
I changed the group by into the following and it works, as far as I can see.

GROUP BY g.gid, g.title, g.type, l.canmanagerequests, l.canmanagemembers

[F] Reported posts sent as private messages

Fri, 21 Nov 2008 05:10:00 +0000

If you have email notifications for when you receive private messages turned on the email comes out like this:

Quote:rh1n0,

You have received a new private message on from . To view this message, you can follow this link:

http://www..com/private.php

Please note that you will not receive any further notifications of new messages until you visit .

You can disable new message notifications on your account options page:

http://www..com/usercp.php?action=options

Thank you,
Staff
http://www..com

You'll notice where it says "You have received a new private message on from" it does not say who it is from.
When looking at the private message, it says it is from "MyBB Engine".

Shouldn't the email reflect that?

[F] Merge from smf 1.1.7

Wed, 19 Nov 2008 08:53:30 +0000

Hi,

I´ve tested the merge system for mybb1.4 and wanted to merge from a smf 1.1.7 board.
But I not all of my data was merged:
- only a few posts were merged
- no sub categories were merged
- no attachments were merged
- and so on

Is there a way to merge from smf 1.1.7 or is this impossible? Or should I merge from smf 1.1.7 to mybb 1.2 and then merge to mybb 1.4?

Best regards
krawutke

[F] Logic flaw in usergroup_permission() function [R]

Wed, 19 Nov 2008 06:13:45 +0000

This is the result of a long thread which I decided to delete and simplify.

Okay...well I have issues with my premium members and PM quotas.

An example of the problem is a user can't recieve PMs.

Okay...here is an example of a permission array:

Quote:Array ( [disporder] => 0 [isbannedgroup] => 0 [canview] => 1 [canviewthreads] => 1 [canviewprofiles] => 1 [candlattachments] => 1 [canpostthreads] => 1 [canpostreplys] => 1 [canpostattachments] => 1 [canratethreads] => 1 [caneditposts] => 1 [candeleteposts] => 1 [candeletethreads] => 0 [caneditattachments] => 1 [canpostpolls] => 1 [canvotepolls] => 1 [canusepms] => 1 [cansendpms] => 1 [cantrackpms] => 1 [candenypmreceipts] => 0 [pmquota] => 20 [maxpmrecipients] => 5 [cansendemail] => 0 [maxemails] => 5 [canviewmemberlist] => 1 [canviewcalendar] => 1 [canaddevents] => 1 [canbypasseventmod] => 1 [canmoderateevents] => 0 [canviewonline] => 1 [canviewwolinvis] => 0 [canviewonlineips] => 0 [cancp] => 0 [issupermod] => 0 [cansearch] => 1 [canusercp] => 1 [canuploadavatars] => 1 [canratemembers] => 1 [canchangename] => 1 [showforumteam] => 1 [usereputationsystem] => 1 [cangivereputations] => 1 [reputationpower] => 1 [maxreputationsday] => 10 [candisplaygroup] => 1 [attachquota] => 25000 [cancustomtitle] => 1 [canwarnusers] => 0 [canreceivewarnings] => 1 [maxwarningsday] => 3 [canmodcp] => 0 )

You can see pmquota is 20 yet his group is actually 1500. This function is the problem.

function usergroup_permissions($gid=0)
{
	global $cache, $groupscache, $grouppermignore, $groupzerogreater;

	if(!is_array($groupscache))
	{
		$groupscache = $cache->read("usergroups");
	}

	$groups = explode(",", $gid);


	if(count($groups) == 1)
	{
		return $groupscache[$gid];
	}

	foreach($groups as $gid)
	{
		if(trim($gid) == "" || !$groupscache[$gid])
		{
			continue;
		}

		foreach($groupscache[$gid] as $perm => $access)
		{
			if(!in_array($perm, $grouppermignore))
			{
				if(isset($usergroup[$perm]))
				{
					$permbit = $usergroup[$perm];
				}
				else
				{
					$permbit = "";
				}

				if(in_array($perm, $groupzerogreater))
				{
					if($access == 0)
					{
						$usergroup[$perm] = 0;
						continue;
					}
				}

				if($access > $permbit || ($access == "yes" && $permbit == "no") || !$permbit) // Keep yes/no for compatibility?
				{
					$usergroup[$perm] = $access;
				}
			}
		}
	}

	return $usergroup;
}

I see checks for 0 so is the pmquota getting reset at some point? The array look seems to have a flaw.

Okay...that's it then. There is a logic problem apparently in the function usergroup_permissions().

I can reproduce too.

Array example of usergroups (just an example)

[10]
pmquota -> 0

[11]
pmquota -> 100

[12]
pmquota -> 0

[13]
pmquota -> 50

It's going to make the pmquota 50 because the 0 resets it if the user is inside all 4 groups or even just 11,12,13. Now I realize looking at the permissions array in the cache that this might also effect other things like maxwarningsday, maxpmrecipients,maxemails, reputationpower, and maxreputationsday. The old yes/no system didn't have this problem conflicting with results that use a number. Also this wouldn't be noticed by those without lots of additional groups.

For now I am adding numbers to each pmquota instead of a zero which does fix this but obviously not optimal or permanent. Zero is also for some of these suppose to be unlimited which also won't stick for any of the parameters I mentioned like maxemails.

So this needs to be sorted out and looked into. If I have made errors please let me know but I have spent the afternoon on this. Hopefully it's not confusing to understand.

[F] [PostgreSQL] Adding a attachment [R]

Mon, 17 Nov 2008 14:35:38 +0000

On a forum that is running PostgreSQL, a user can't add a attachment.

To reproduce the error, follow the steps below:

1. In a thread, click the "New Reply" button
2. Enter a message into the new thread input box
3. In the "Attachments" section, click "Browse"
5. Select the file you want to attach
6 Now click "Add attachment"

The following error is returned:

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
    22P02 - ERROR: invalid input syntax for integer: "" 
Query:
    SELECT * FROM trunk_attachments WHERE filename='logo.gif' AND (posthash='fa4510cdde8caa64188cef558b7e1ed5' OR (pid='' AND pid!='0'))

PostgreSQL 8.3.4
PHP 5.2.6
MyBB 1.4.3

[F] [PostgreSQL] Optimize Database [R]

Mon, 17 Nov 2008 14:17:37 +0000

On a forum that is running PostgreSQL, the optimize table tool doesn't work in the Admin CP.

To reproduce the error, follow the steps below:

1. Admin CP > 'Tools & Maintenance' Tab > Optimize Database (Left Menu)
2. Click "Select All" in the Table Selection area
3. Click "Optimize Selected Tables"

The following error is returned:

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
    42601 - ERROR: syntax error at or near "TABLE" LINE 1: ANALYZE TABLE trunk_settinggroups ^ 
Query:
    ANALYZE TABLE trunk_settinggroups

PostgreSQL 8.3.4
PHP 5.2.6
MyBB 1.4.3

[F] error in searching item in template admin [C-Michael83]

Thu, 13 Nov 2008 15:40:44 +0000

admin cp->templates->search template

try to find agreement_1 leaving blank the replace input and you will have:

Warning [2] Missing argument 2 for build_str_ireplace() - Line: 99 - File: inc/functions_compat.php PHP 4.4.7 (Linux)
File 	Line 	Function
[PHP] 	  	errorhandler->error
/inc/functions_compat.php 	99 	build_str_ireplace
/inc/functions_compat.php 	112 	build_str_ireplace
/admin/modules/style/templates.php 	577 	str_ireplace
/admin/index.php 	378 	require
Warning [2] Missing argument 2 for build_str_ireplace() - Line: 99 - File: inc/functions_compat.php PHP 4.4.7 (Linux)
File 	Line 	Function
[PHP] 	  	errorhandler->error
/inc/functions_compat.php 	99 	build_str_ireplace
/inc/functions_compat.php 	112 	build_str_ireplace
/admin/modules/style/templates.php 	577 	str_ireplace
/admin/index.php 	378 	require

mybb version: 1.4.3
php version: 5.2.4
os: ubuntu 5.3

[F] 10,000 PMs problem [C-Ryan Gordon]

Wed, 12 Nov 2008 23:57:30 +0000

I just had a member last night send 10,000 PMs to my members. I woke up to see that. Now...I know officially this isn't a bug but imho it's a priority to stop spammers especially if they can write a script and have 10,000 PMs sent in minutes. This is a grave cause for concern. They could have flooded my server with 1,000,000 PMs and probably crashed the site, server or database.

I have max recipients set to just 1 for the registered group.

I will probably do a custom fix for now to prevent this but please mybb look into this. I exported the data from my logs. There is some really disturbing stuff if it can be repeated.

Sample logs:

Quote:59.93.176.72 - - [12/Nov/2008:04:46:37 -0500] "POST /private.php HTTP/1.1" 302 203 "http://www.hackforums.net/" "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.3) Gecko/2008092417 Firefox/3.0.3"
59.93.176.72 - - [12/Nov/2008:04:46:37 -0500] "POST /private.php HTTP/1.1" 302 203 "http://www.hackforums.net/" "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.3) Gecko/2008092417 Firefox/3.0.3"
59.93.176.72 - - [12/Nov/2008:04:46:38 -0500] "POST /private.php HTTP/1.1" 302 203 "http://www.hackforums.net/" "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.3) Gecko/2008092417 Firefox/3.0.3"
59.93.176.72 - - [12/Nov/2008:04:46:38 -0500] "POST /private.php HTTP/1.1" 302 203 "http://www.hackforums.net/" "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.3) Gecko/2008092417 Firefox/3.0.3"

Appears to probably be using a firefox plugin that would automate the process for them. Hard to really tell for sure but that's how it looks to me. If the flood-control setting "postfloodsecs" can be applied to PM's...I think that's best solution.

Thank you.

[F] Mail Reply Address: Issue Resolved

Wed, 12 Nov 2008 20:32:27 +0000

I did a search for the answer to my question until I got a migraine so forgive this post if the answer is obvious and I missed it...

I'm using PHP mail

When you send an email from my forum to a user, the reply address is the admin email address, meaning I, not the sender, get every email reply.

I did not find any where in the ACP where this could be changed.

How do I get the senders email as the reply to address so any replys go to the original sender and not me?

Also, is there an answer to the SMTP problem that I have seen posted
regarding "The mail server does not understand the MAIL FROM command" in the log file when trying to use SMTP.

Everything else that uses my SMTP server work well?

Thanks for any help !

[F] [Calender] HTML encoding / stripping problem [C-Chris]

Wed, 12 Nov 2008 15:06:57 +0000

This error occurs with version 1.4.3 with german language pack - but I think it will occur with english / each other language pack, too

Here's a screenshot of this error:

(see date at 13st "Start des ""...)

I think this is a bug when trying to strip characters after encoding it at dates topic (in this case: Start des "Wrath of the Lich King" WoW Addons).

This bug isn't a real "high priority" bug, cause you can change the dates topic, so that the characters are stripped without destroying html entities - but nevertheless a statement of a developer would be nice

Thanks,
Dreamwalker (from Germany)

PS: please excuse my poor skills at writing an english text (or at least something that sounds like an english text).

Edit:
I just saw, that there's a "Bug Report" forum @ a mod: please move this thread to this forum - thanks

[F] SQL error when editing thread

Wed, 12 Nov 2008 07:37:27 +0000

I'm running 1.4.2. When I edit (quick edit) an existing thread and click on save changes I get

MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
0 - ERROR: invalid input syntax for integer: ""
Query:
DELETE FROM mybb_threadsubscriptions WHERE uid='' AND tid='10'

This is with Postgresql 8.2.9.

Funny enough when looking at the thread the changes where successfully made.

[F] phpBB 3 to MyBB loginconvert.php problems

Wed, 12 Nov 2008 07:06:24 +0000

Hi,

I have a phpbb 3 forum and want to convert it to MyBB. I am running a few test conversions and having some issues.

If I convert from phpbb 3 to MyBB 1.2.x it works fine and users can login with the loginconvert.php plugin enabled.

If I convert direct from phpbb 3 to MyBB 1.4.x, users can't login whether the plugin is enabled or not. Also, when I convert from phpbb 3 to MyBB 1.2.x, and then upgrade to MyBB 1.4.x (and use the new loginconvert.php plugin, of course ), users can't login either.

Is there an issue with this plugin for 1.4.x versions, or is there a way to work around this?? There's no point in upgrading if I have to use an old version, or if I use the new version but every single user has to request a new password.

Thanks

To update this issue - I have Joomla CMS and it only interfaces with MyBB 1.4.x (with JFusion) properly, not MyBB1.2.x.

I really need this to work ASAP, I hope there is solution.

[F] [WOL] Viewing an attachment [R] [C-Michael83]

Tue, 11 Nov 2008 23:37:39 +0000

If someone is viewing an attachment and you click on the link in the Who's online list it opens in the same window. The link should open a new window like the attachment links in posts do.