vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   vBJournal for vBulletin 3.5 (https://vborg.vbsupport.ru/showthread.php?t=96462)

jesus likes pie 09-19-2005 10:43 AM

Quote:

Originally Posted by .Tim
Install went fine, I thought, but I get this when I try and edit permissions:

Code:

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

:confused:



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

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

guv2000 09-19-2005 11:20 AM

good hack ;)
i install and clicked install.
thnx ;)

Andreas 09-19-2005 11:53 AM

@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 09-19-2005 12:07 PM

Quote:

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???` 09-19-2005 01:16 PM

Quote:

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 09-19-2005 01:18 PM

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

???`S?LV?R???` 09-19-2005 01:22 PM

Quote:

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 09-19-2005 01:25 PM

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

???`S?LV?R???` 09-19-2005 01:28 PM

Quote:

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 09-19-2005 01:29 PM

Nope, no ETA.


All times are GMT. The time now is 09:10 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02424 seconds
  • Memory Usage 1,745KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete