Agh Crap......Not Again

Whenever a user goes into the OPTIONS and presses SUBMIT CHANGES

They get this message
--------------------------------------
There seems to have been a slight problem with the Blazing Mic database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.
----------------------------------------

Anything I can do?

I installed the STORE HACK, BANK HACK, NOW PLAYING, AUTO POST COLORS! All today.....ugh

[Steve Machol]

You will need to post the complete error message - either from the email you received, or by having the users go to View/Source in their browsers and providing you with this error to post here.

[ZiRu$]

oh.....cool man....i didn't know that i could go into the SOURCE and it would tell me.....anyways.....here's the message

-----------------------------------------
Invalid SQL: UPDATE user
SET styleid='1',adminemail='1',
enablewysiwyg='0',showemail='1',invisible='0',cook ieuser='1',
maxposts='-1',daysprune='-1',
timezoneoffset='-6',emailnotification='0',
startofweek='1',options='11',receivepm='1',
emailonpm='0',pmpopup='0',pmpopupfull='0',usergrou pid='11',
nosessionhash='1'
WHERE userid='1'
mysql error: Unknown column 'pmpopupfull' in 'field list'

mysql error number: 1054

Date: Monday 26th of August 2002 12:38:49 AM
Script: http://www.xxxxxxxxxxx.com/member.php
Referer: http://www.xxxxxxxxxxx.com/member.ph...on=editoptions
-->
--------------------------------------------

[g-force2k2]

Zirus you probably installed a hack and then didn't delete the query... run this:

PHP Code:

ALTER TABLE user DROP pmpopupfull 


that should do the trick regards...

g-force2k2

[ZiRu$]

not really man....when i go to run that query i get this message
---------------------------
Invalid SQL: ALTER TABLE user DROP pmpopupfull
mysql error: Can't DROP 'pmpopupfull'. Check that column/key exists

mysql error number: 1091

Date: Monday 26th of August 2002 09:44:39 AM
Script: http://www.xxxxxxxxxx.com/admin/query.php
Referer: http://www.xxxxxxxxxx.com/admin/query.php
-->
--------------------

[g-force2k2]

errr.. my bad Zirus what was i thinking

open member.php

find the locations of:

pmpopupfull

and delete them

should be a few if im not mistaken

should be one in the editing and updating... if you need more support just ask regards...

g-force2k2

[ZiRu$]

ok thx man.....i'm at work.....i'll do it when i get home....I'll reply with results

[g-force2k2]

Originally posted by ZiRu$
ok thx man.....i'm at work.....i'll do it when i get home....I'll reply with results

okay np man right now im at college so it don't help me either else i'd try and give you the exact instructions you would need to do regards...

g-force2k2

[ZiRu$]

It worked perfectly man...thx