vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=252)
-   -   database help (https://vborg.vbsupport.ru/showthread.php?t=286303)

RoC wonko 08-04-2012 12:14 PM

ok thank again for your help got out of the brown smelly stuff :)

--------------- Added [DATE]1344091282[/DATE] at [TIME]1344091282[/TIME] ---------------

just did the hooks trick and it worked a treat, still have database problems in the permission for admins.
Database error in vBulletin 4.2.0:

Invalid SQL:
UPDATE administrator SET
### Bitfield: administrator.adminpermissions ###
adminpermissions = IF(adminpermissions & 4, adminpermissions, adminpermissions + 4),
adminpermissions = IF(adminpermissions & 8, adminpermissions, adminpermissions + 8),
adminpermissions = IF(adminpermissions & 16, adminpermissions, adminpermissions + 16),
adminpermissions = IF(adminpermissions & 32, adminpermissions, adminpermissions + 32),
adminpermissions = IF(adminpermissions & 64, adminpermissions, adminpermissions + 64),
adminpermissions = IF(adminpermissions & 128, adminpermissions, adminpermissions + 128),
adminpermissions = IF(adminpermissions & 256, adminpermissions, adminpermissions + 256),
adminpermissions = IF(adminpermissions & 512, adminpermissions, adminpermissions + 512),
adminpermissions = IF(adminpermissions & 1024, adminpermissions, adminpermissions + 1024),
adminpermissions = IF(adminpermissions & 2048, adminpermissions, adminpermissions + 2048),
adminpermissions = IF(adminpermissions & 4096, adminpermissions, adminpermissions + 4096),
adminpermissions = IF(adminpermissions & 8192, adminpermissions, adminpermissions + 8192),
adminpermissions = IF(adminpermissions & 16384, adminpermissions, adminpermissions + 16384),
adminpermissions = IF(adminpermissions & 65536, adminpermissions, adminpermissions + 65536),
adminpermissions = IF(adminpermissions & 131072, adminpermissions, adminpermissions + 131072),
adminpermissions = IF(adminpermissions & 262144, adminpermissions, adminpermissions + 262144),
adminpermissions = IF(adminpermissions & 524288, adminpermissions, adminpermissions + 524288),
adminpermissions = IF(adminpermissions & 1048576, adminpermissions, adminpermissions + 1048576),
adminpermissions = IF(adminpermissions & 2097152, adminpermissions, adminpermissions + 2097152),
adminpermissions = IF(adminpermissions & 4194304, adminpermissions, adminpermissions + 4194304),
adminpermissions = IF(adminpermissions & 8388608, adminpermissions, adminpermissions + 8388608),
blogpermissions = 3,
vbcmspermissions = 3,
### Bitfield: administrator.dbtech_statusadminperms ###
dbtech_statusadminperms = IF(dbtech_statusadminperms & 1, dbtech_statusadminperms, dbtech_statusadminperms + 1),
### Bitfield: administrator.dbtech_ajaxthreadsadminperms ###
dbtech_ajaxthreadsadminperms = IF(dbtech_ajaxthreadsadminperms & 1, dbtech_ajaxthreadsadminperms, dbtech_ajaxthreadsadminperms + 1),
cssprefs = '',
dismissednews = ''
WHERE userid = 1;

MySQL Error : Unknown column 'dbtech_statusadminperms' in 'field list'
Error Number : 1054
Request Date : Saturday, August 4th 2012 @ 08:25:58 AM
Error Date : Saturday, August 4th 2012 @ 08:25:59 AM
Script : http://www.reign-of-chaos.co.uk/admi....php?do=update
Referrer : http://www.reign-of-chaos.co.uk/admi...hp?do=edit&u=1
IP Address : 88.97.12.60
Username : Wonko
Classname : vB_Database
MySQL Version : 5.1.63-community-log

--------------- Added [DATE]1344108891[/DATE] at [TIME]1344108891[/TIME] ---------------

--------------- Added [DATE]1344108947[/DATE] at [TIME]1344108947[/TIME] ---------------

sorted the above out by removing all dbteck plugins unfortunately still having problems in that although I am the super admin I still do not have permission to use cms grrrrrrr:( everything else now appears to be fixed again (fingers crossed)

Sorry, you don't have permission to access the administrative controls on this page.

If you need to access this page, ask your lead administrator to enable your permissions for this page using the Administrator Permissions section of the control panel.


All times are GMT. The time now is 12:49 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.01083 seconds
  • Memory Usage 1,730KB
  • 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)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (1)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