MyBB Community Forums

Full Version: Database difference Install <> Upgrade
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hi,

I upgraded my board from 1.4.14 to 1.6 but I also installed a fresh copy of MyBB 1.6 in a different folder (same MySQL server, same Web server, same PHP version).

Because I'm a little bit paranoid ( Big Grin ) I compared the database structure of both installations and I found differences:

Table adminoptions

On fresh installation:
`uid` int(11) NOT NULL default '0'

On upgraded installation:
`uid` int(10) NOT NULL default '0'

Table delayedmoderation

On fresh installation:
`delaydateline` bigint(30) NOT NULL default '0'

On upgraded installation:
`delaydateline` bigint(30) unsigned NOT NULL default '0'

I just want to let you know these facts...
I'd report that as a bug so a dev can check what it should be.
(2010-08-07, 12:00 PM)MattRogowski Wrote: [ -> ]I'd report that as a bug so a dev can check what it should be.

Thanks. Can you give me the ticket number? I can not find it on dev site... Blush

Here is another difference:

Table promotions

On fresh installation:
`referralstype` char(2) NOT NULL default ''

On upgraded installation:
`referralstype` varchar(2) NOT NULL default ''

Table reputation

On fresh installation:
KEY `pid` (`pid`)

On upgraded installation:
missing