MyBB Community Forums

Hi,
line 36 of install/resources/upgrade30.php

$db->update_query('profilefields', array('viewableby' => '-1', 'editableby' => '-1'));

But there isn't this field in 1.6 and this field created in line 184 and 207 :|

Quote:MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1054 - Unknown column 'viewableby' in 'field list'
Query:
UPDATE mybb_profilefields SET viewableby=-1, editableby=-1

---
For CREATE TABLE buddyrequests don't check the table exists before.
We must add this code in line 702:

	if($db->table_exists("buddyrequests"))
	{
		$db->drop_table("buddyrequests");
	}

---
In line 803 and 818, add cloumn posbit after "hidden" but in line 194, 217 and 240 it's renamed to profile! :|

$db->add_column("profilefields", "postbit", "smallint NOT NULL default '0' AFTER hidden");

must replace to

$db->add_column("profilefields", "postbit", "smallint NOT NULL default '0' AFTER profile");

and find

$db->add_column("profilefields", "postbit", "tinyint(1) NOT NULL default '0' AFTER hidden");

replace to

$db->add_column("profilefields", "postbit", "tinyint(1) NOT NULL default '0' AFTER profile");

Hi,

Thank you for your report. We have pushed this issue to our Github repository for further analysis where you can track our commits and progress with fixing this bug. Discussions regarding this bug may also take place there too.

Follow this link to visit the issue on Github: https://github.com/mybb/mybb/issues/895

Thanks for contributing to MyBB!

Regards,
The MyBB Group

Thanks.