Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
  #1  
Old 02-12-2006, 08:23 PM
inspiration100 inspiration100 is offline
 
Join Date: Apr 2005
Posts: 132
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Help wanted, Usergroup error

Whenever I go into admin area (www.webmastersdatabase.com/admincp) and Create a usergroup, I get the error

Warning: mysql_real_escape_string() expects parameter 1 to be string, array given in /includes/class_core.php on line 666

Warning: mysql_real_escape_string() expects parameter 1 to be string, array given in /includes/class_core.php on line 666

Warning: mysql_real_escape_string() expects parameter 1 to be string, array given in /includes/class_core.php on line 666.



A bit more information about the error:
### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO usergroup
(`title`, `description`, `usertitle`, `opentag`, `closetag`, `passwordexpires`, `passwordhistory`, `ispublicgroup`, `canoverride`, `userpagepermissions`, `forumpermissions`, `attachlimit`, `pmquota`, `pmpermissions`, `pmsendmax`, `calendarpermissions`, `wolpermissions`, `adminpermissions`, `genericpermissions`, `genericoptions`, `profilepicmaxwidth`, `profilepicmaxheight`, `profilepicmaxsize`, `avatarmaxwidth`, `avatarmaxheight`, `avatarmaxsize`, `itraderpermissions`, `pagerpermissions`, `pagerquota`, `pagerminpost`, `pagerminpostperday`, `pagermaxperday`, `pagersendmax`, `pagersendmaxchar`)
VALUES
('test', 'test', 'test', '', '', '', '', '0', '0', '0', '651271', '1000000', '0', '0', '5', '0', '1', '0', '2626563', '9', '100', '100', '25000', '50', '50', '20000', '0', '0', '', '', '', '', '', '');

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


Any ideas? Thanks :nervous:

anyone?

Folks, help needed!
Reply With Quote
  #2  
Old 02-16-2006, 08:54 PM
maroceve maroceve is offline
 
Join Date: Oct 2005
Location: Casablanca, Morocco
Posts: 232
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I have the same problem .when i try updating my usergroups ..seems like some vbpager files are still in there or something ? i don't understand this.

please help

Database error in vBulletin 3.5.0:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Administrators',
`description` = '',
`usertitle` = 'Administrator',
`opentag` = '<span style=\"font-weight: bold;\">',
`closetag` = '</span>',
`passwordexpires` = '180',
`passwordhistory` = '360',
`userpagepermissions` = '0',
`vbpunch` = '1',
`arcadepermissions` = '255',
`forumpermissions` = '1048575',
`attachlimit` = '0',
`pmquota` = '1000',
`pmpermissions` = '3',
`pmsendmax` = '100',
`calendarpermissions` = '63',
`wolpermissions` = '31',
`adminpermissions` = '3',
`genericpermissions` = '205520831',
`genericoptions` = '31',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '200',
`avatarmaxheight` = '200',
`avatarmaxsize` = '65535',
`pagerpermissions` = '0',
`ecdownloadpermissions` = '0'
WHERE usergroupid=6;

MySQL Error : Unknown column 'pagerpermissions' in 'field list'
Error Number : 1054
Date : Thursday, February 16th 2006 @ 10:53:29 PM
Script : http://www.maroceve.com/forums/admincp/usergroup.php
Referrer : http://www.maroceve.com/forums/admin...&usergroupid=6
IP Address : 196.217.200.98
Username : Ez
Classname : vb_database
Reply With Quote
  #3  
Old 02-16-2006, 09:04 PM
S@NL - BlackBik's Avatar
S@NL - BlackBik S@NL - BlackBik is offline
 
Join Date: Jul 2004
Location: Netherlands
Posts: 307
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Looks like both of you uninstalled some hack, but it's not completely uninstalled.
Rever to the documentation of that hack en rerun the uninstall (manualy if you have to). That may sort things out.
Reply With Quote
  #4  
Old 02-16-2006, 09:06 PM
maroceve maroceve is offline
 
Join Date: Oct 2005
Location: Casablanca, Morocco
Posts: 232
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I did do that ..i got rid of all the files ! one by one ..of vbpager ..
im gonna try to see if i missed something

thanks for responding S@nl'BlackBik

o wow u want to hear something funny..

i did REINSTALL THE XML as a product of vbpager ..

now i can update my usergroupes without a prob !!
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 05:40 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.07137 seconds
  • Memory Usage 2,183KB
  • 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
  • (4)post_thanks_box
  • (4)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (4)post_thanks_postbit_info
  • (4)postbit
  • (4)postbit_onlinestatus
  • (4)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