Agh Crap......Not Again

[ZiRu$]

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.php?action=editoptions
-->
--------------------------------------------

[g-force2k2]

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

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 :p

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 :p regards...

g-force2k2

[ZiRu$]

It worked perfectly man...thx