Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
  #1  
Old 12-03-2005, 07:27 AM
john1744 john1744 is offline
 
Join Date: Apr 2005
Posts: 268
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default MySQL error while trying to edit HTML Markup for usergroups.

Database error in vBulletin 3.5.0:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Sheep',
`description` = 'Nintendo Fanboys',
`usertitle` = '',
`opentag` = '<span style=\"font-weight: bold;color: #fe0000\">',
`closetag` = '</span>',
`passwordexpires` = '0',
`passwordhistory` = '0',
`ispublicgroup` = '1',
`canoverride` = '1',
`mh_unm_permissions` = '0',
`mh_unm_changelimit` = '30',
`mh_unm_viewhistorylimit` = '1',
`forumpermissions` = '269213703',
`attachlimit` = '1000000',
`pmquota` = '0',
`pmpermissions` = '0',
`pmsendmax` = '5',
`calendarpermissions` = '32',
`wolpermissions` = '1',
`adminpermissions` = '0',
`genericpermissions` = '5123',
`genericoptions` = '8',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '25000',
`avatarmaxwidth` = '50',
`avatarmaxheight` = '50',
`avatarmaxsize` = '20000',
`arcadepermissions` = '0'
WHERE usergroupid=152;

MySQL Error : Unknown column 'arcadepermissions' in 'field list'
Error Number : 1054
Date : Saturday, December 3rd 2005 @ 04:25:58 AM
Script : ***************
Referrer : *********************
IP Address : *******
Username : HAL-9000
Classname : vb_database

It looks like this is an error due to the uninstall of the v3arcade system. I uninstalled that and installed the ibProArcade system.

Any ideas?

Nevermind fixed it.
Reply With Quote
  #2  
Old 12-04-2005, 09:40 PM
wizardace wizardace is offline
 
Join Date: Aug 2004
Location: Athens-Guildford
Posts: 13
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hey, I have the same problem. How did you fix it?
Reply With Quote
  #3  
Old 12-04-2005, 10:09 PM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Looks like an incomplete uninstall of an arcade hack.
Reply With Quote
  #4  
Old 12-04-2005, 10:25 PM
wizardace wizardace is offline
 
Join Date: Aug 2004
Location: Athens-Guildford
Posts: 13
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

That's right. When I try to uninstall it there is another sql error but in this case it makes the forum obsolete as you can't post so I had to deactivate the product.
Reply With Quote
  #5  
Old 12-05-2005, 05:10 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Then also remove the added files from ./includes/xml
Reply With Quote
  #6  
Old 12-05-2005, 10:43 AM
wizardace wizardace is offline
 
Join Date: Aug 2004
Location: Athens-Guildford
Posts: 13
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Actually after running this: ALTER TABLE vb3_usergroup ADD arcadepermissions INT( 10 ) UNSIGNED NOT NULL
everything's okay.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 03:22 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04003 seconds
  • Memory Usage 2,197KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (6)post_thanks_box
  • (6)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (6)post_thanks_postbit_info
  • (6)postbit
  • (6)postbit_onlinestatus
  • (6)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete