[MaryTheG(r)eek]

Originally Posted by masterweb

Hi, i installed this mod but when i arrived to: "...Step 8: By default none usergroup has permissions to use vbjournal, so you need to give permissions to any group. Goto AdminCP->Usergroups->Usergroup Manager and edit any usergroup you like to give permissions...." I got from admincp this error:

Database error in vBulletin 3.6.8:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Registered Users',
`description` = '',
`usertitle` = ' Newcomer',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`forumpermissions` = '754175',
`genericpermissions` = '472389319',
`attachlimit` = '0',
`pmquota` = '50',
`pmpermissions` = '3',
`pmsendmax` = '5',
`calendarpermissions` = '63',
`wolpermissions` = '1',
`adminpermissions` = '0',
`genericoptions` = '62',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '80',
`avatarmaxheight` = '80',
`avatarmaxsize` = '20000',
`signaturepermissions` = '137215',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '10000',
`sigmaxrawchars` = '1000',
`sigmaxchars` = '500',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '2',
`credit_induction` = '100',
`credit_referral` = '100',
`credit_refbonus` = '0.05',
`credit_daily` = '0',
`credit_active` = '10',
`credit_birthday` = '100',
`credit_repgive` = '0.1',
`credit_reppos` = '10',
`credit_repneg` = '-15',
`credit_thread` = '20',
`credit_threadrate` = '5',
`credit_post` = '5',
`credit_ownthreadpost` = '3',
`credit_postsize` = '0.1',
`credit_pollmake` = '10',
`credit_pollvote` = '3',
`credit_unthread` = '-20',
`credit_unpost` = '-5',
`creditpermissions` = '0',
`mgccustomusergroupperms` = '0',
`nbmsgshowchatbox` = '',
`itraderpermissions` = '3',
`vbjournal` = '1'
WHERE usergroupid=2;

MySQL Error : Unknown column 'mgccustomusergroupperms' in 'field list'
Error Number : 1054
Date : Sunday, September 9th 2007 @ 11:09:20 AM
Script : http://www.onlinewebmarket.net/admin....php?do=update
Referrer : http://www.onlinewebmarket.net/admin...&usergroupid=2
IP Address : 81.208.106.65
Username : masterweb
Classname : vb_database

____________________________________

Some time ago i had a similar error with a mod that doesn't create the required tables. Now it's a similar problem?, what i must to do?.

Pls help

This error is not coming for vbJournal. If you check the error vbJournal has got already a value. Seems that a mod that you tried to install in the past was wrong. Can you remember something like "mgc"?

Maria