[Delphiprogrammi]

Originally Posted by The Realist

Clicking a users warning link and I get this error:

Invalid SQL: select * from warnings where warned_post='65273' AND warned_status='A'
mysql error: Unknown column 'warned_status' in 'where clause'


Any ideas?

I know its a missing columb, but what text do I need to put it back?

Laters

yeah you're missing a table run this MySQL query

ALTER  TABLE `".TABLE_PREFIX."warnings`ADD COLUM warned_status char(1);

carefull with TABLE_PREFIX .... open install_warn.php there you can see the sql code ...

Originally Posted by The Realist

Clicking a users warning link and I get this error:

Invalid SQL: select * from warnings where warned_post='65273' AND warned_status='A'
mysql error: Unknown column 'warned_status' in 'where clause'


Any ideas?

I know its a missing columb, but what text do I need to put it back?

Laters

Just came accross another DB error:

When I edit the warning options and save them, I get this DB error:

Database error in vBulletin 3.0.6:

Invalid SQL: update warning_options set
hierarchical='Yes',
automatic='No',
automaticpm='No',
autocomments='No',
warner='1',
automatic_warner='',
collector='',
banned_limit='7',
points_before_banned='5',
warnings_before_banned='10',
banned_usergroup_id='14',
troll_usergroup_id='4',
protected_usergroups='6',
aprotected_usergroups='',
restore_groupid='0',
incr_ban_days='Yes',
max_no_bans='3',
bans_mature='0',
viewoption='Mgm',
multiple_per_post='Yes',
send_pm_warning='Yes',
send_em_warning='Yes',
email_on_ban='Yes',
historical='Yes',
allowoffpost='Yes',
warnings_per_page='20',
textbutoption='Text',
modoption='All'
where oid='1'
mysql error: Unknown column 'modoption' in 'field list'

HELP

ok settle down and please download the latest version the errors you are describing about missing database tables are telling you are trying to install an outdated version of this hack