Announcement

Collapse
No announcement yet.

PHPMYADMIN running sql query for

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • tubedogg
    replied
    There was an error in it, I've fixed it in my post above.

    Leave a comment:


  • xsngx
    replied
    Error
    SQL-query :

    UPDATE user SET invisible=0,showemail=1,adminemail=1,receivepms=1,emailnotification=0,nosessionhash=1,emai lonpm=1,pmpopup=1,cookieuser=1

    MySQL said:


    Unknown column 'receivepms' in 'field list'

    Back


    I get this error now...

    Leave a comment:


  • Steve Machol
    replied
    You have a line feed between 'pm' and 'popup'. Remove it and try again. That query needs to be entered as one long line.

    Leave a comment:


  • xsngx
    replied
    Hey tubedog thanks for replying but i get a error

    Error
    SQL-query :

    UPDATE user SET invisible=0,showemail=1,adminemail=1,receivepms=1,emailnotification=0,nosessionhash=1,emai lonpm=1,pm
    popup=1,cookieuser=1

    MySQL said:


    You have an error in your SQL syntax near 'popup=1,cookieuser=1' at line 2

    Back

    Leave a comment:


  • tubedogg
    replied
    http://vbulletin.com/forum/showthrea...threadid=29122

    UPDATE user SET invisible=0, showemail=1, adminemail=1, receivepm=1, emailnotification=0, nosessionhash=1, emailonpm=1, pmpopup=1, cookieuser=1
    Last edited by tubedogg; Mon 15th Apr '02, 6:37pm.

    Leave a comment:


  • xsngx
    replied
    anyone know how to write a sql query that will do that?

    Leave a comment:


  • xsngx
    started a topic PHPMYADMIN running sql query for

    PHPMYADMIN running sql query for

    Ok i need to run a sql query on PHPMYADMIN

    i need to make it so all my users are using this setting

    Receive mailings from admins
    Yes

    Show email
    Yes

    Invisible on 'Online users' list
    No

    Receive PMs
    Yes

    Email on PM
    Yes

    PM Popup
    Yes

    Show Signatures
    Yes

    Show Avatars
    Yes

    Show Images
    Yes

    Show VBcode
    Yes

    Use email notification by default
    No

    Remember Username and password
    Yes

    Browse boards with cookies
    Yes

    Can someone help me write a sql query to do that for phpmyadmin? Thanks!
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X