vBJournal for vBulletin 3.5

This is a Port of vB Journal by An-Net

A t t e n t i o n
This Hack is unsupported and incompatible with PHP 5.
You are herby advised to not use it.
If you do have this hack installed it is advised to use vBulletin Blog instead.
You can import current entries to vBulletin Blog via Impex and uninstall this hack afterwards.

[jesus likes pie]

Originally Posted by .Tim

Install went fine, I thought, but I get this when I try and edit permissions:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
        `title` = 'Administrators',
        `description` = '',
        `usertitle` = 'Administrator',
        `opentag` = '',
        `closetag` = '',
        `passwordexpires` = '0',
        `passwordhistory` = '0',
        `ucash_paycheck` = '0',
        `forumpermissions` = '470810623',
        `attachlimit` = '0',
        `pmquota` = '65535',
        `pmpermissions` = '3',
        `pmsendmax` = '5',
        `calendarpermissions` = '63',
        `wolpermissions` = '31',
        `adminpermissions` = '3',
        `genericpermissions` = '204472319',
        `genericoptions` = '22',
        `profilepicmaxwidth` = '150',
        `profilepicmaxheight` = '150',
        `profilepicmaxsize` = '4294967295',
        `avatarmaxwidth` = '200',
        `avatarmaxheight` = '200',
        `avatarmaxsize` = '4294967295',
        `profileviewpermissions` = '15',
        `userpagepermissions` = '0',
        `imghost` = '3',
        `imghostset` = '1024',
        `imghost_width` = '1600',
        `imghost_height` = '1200',
        `imghost_files` = '1000',
        `journalpermissions` = '1'
WHERE usergroupid=6;

MySQL Error  : Unknown column 'userpagepermissions' in 'field list'
Error Number : 1054

ALTER TABLE usergroup ADD userpagepermissions CHAR(15) NOT NULL;

Running that query should make the error go away by putting his column back.

[guv2000]

good hack
i install and clicked install.
thnx

[Andreas]

@Jesus likes Pie
It's actually not a Bug but working as designed.

The settings are cached, and this cache needs to be built once which isn't done by the installatin script as I expected the Admin to check/modify the settings anyway.
You don't have to turn it off and on again, just click Save.

Are there really people who don't take a look at the settings first? Strange ...

[Andreas]

Originally Posted by jesus likes pie

ALTER TABLE usergroup ADD userpagepermissions CHAR(15) NOT NULL;

Running that query should make the error go away by putting his column back.

Adding a column to fix errors caused by a Hack that is not even being uses (anymore) does not make much sense, does it?

[???`S?LV?R???`]

Originally Posted by KirbyDE

@???`S?LV?R???`
It will work, but the installation does not work 100% if you are upgrading from a 3.0 installation. .

what if it's a fresh installation of it? any problems/issues? what about uninstallation?

[Andreas]

A fresh installation will not be affected, as well as uninstall.

[???`S?LV?R???`]

Originally Posted by KirbyDE

A fresh installation will not be affected, as well as uninstall.

Good to hear, alright well I got 3.5.0 Rc2 installed, will that be a problem at all?

[Andreas]

No. Should work just fine with RC2.
But one of the next Versions will require RC3 at least.

[???`S?LV?R???`]

Originally Posted by KirbyDE

No. Should work just fine with RC2.
But one of the next Versions will require RC3 at least.

thanks again, good to know, I was just holding off on the install of rc3 until gold came out since it would be easier, btw any time frame the newer version of the journal that will require atleast rc3 will be released?

[Andreas]

Nope, no ETA.