PDA

View Full Version : PLZ need help fast


ztempuser
05-27-2006, 07:23 PM
hello everyone today i was trying to change the color of the usernames in the user manager but after i did the change to a group it goes to a mysql error

Database error in vBulletin 3.5.1:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Registered Users',
`description` = '',
`usertitle` = '',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`anymediapermissions` = '1',
`pagerpermissions` = '1',
`pagerquota` = '0',
`pagerminpost` = '0',
`pagerminpostperday` = '2',
`pagermaxperday` = '0',
`pagersendmax` = '0',
`pagersendmaxchar` = '300',
`imghost` = '0',
`imghostset` = '',
`imghost_width` = '',
`imghost_height` = '',
`imghost_files` = '',
`forumpermissions` = '782847',
`attachlimit` = '0',
`pmquota` = '50',
`pmpermissions` = '3',
`pmsendmax` = '5',
`calendarpermissions` = '63',
`wolpermissions` = '1',
`adminpermissions` = '0',
`genericpermissions` = '203953863',
`genericoptions` = '30',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '150',
`avatarmaxheight` = '150',
`avatarmaxsize` = '80000',
`journalpermissions` = '34783'
WHERE usergroupid=2;

MySQL Error : Unknown column 'imghost' in 'field list'
Error Number : 1054
Date : Saturday, May 27th 2006 @ 02:09:26 PM
Script : http:/my.domain.com/forum/admincp/usergroup.php
Referrer : http://my.domain.com/forum/admincp/usergroup.php?do=edit&usergroupid=2
IP Address : **.***.*.***
Username : seesoe
Classname : vb_database
can someone please help me fast, i have a lot of modding i need to do to that section inorder to start modding something bigger
btw this error come to every user group editing

Zachery
05-27-2006, 07:29 PM
Its from a hack you've installed, you'l need to uninstall it to get it working again properly.

ztempuser
05-27-2006, 10:41 PM
i think i know this hack its the host images for your user hack, but the thing is i have already removed this hack,
i went into my forum db and i went to user groups and looked in that ad admin table and i cold not find any line that has hostim but i was able to find all the rest

Kirk Y
05-28-2006, 04:35 AM
Go find the instructions to install it again, and work through them backwards, just make sure you removed all the plugins and code modifications (assuming there were any).

ztempuser
05-28-2006, 04:50 AM
hhmmm this was a while back when i first started miy board, back then i saved all the files that came from the mod/hacks i would do to vb
now i don't save them, luckly since it was one of the first mods i added i still have the install file somewhere but where? lol i will find it