mysql error - not sure why

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • nullified
    Member
    • May 2005
    • 38
    • 3.5.0 Pre-Release

    mysql error - not sure why

    trying to import a product on a different vbulletin install. not sure why it's erroring on the following line:
    PHP Code:
    $db->query_write("UPDATE TABLE " TABLE_PREFIX "usergroup SET bannersyspermissions = '0' WHERE usergroupid = '1'"); 
  • nullified
    Member
    • May 2005
    • 38
    • 3.5.0 Pre-Release

    #2
    Disregard, simple mistake of having TABLE in the query.

    Comment

    • Mez
      Senior Member
      • Mar 2004
      • 273
      • 3.7.x

      #3
      try
      PHP Code:
      $db->query_write("UPDATE " TABLE_PREFIX "usergroup SET bannersyspermissions = '0' WHERE usergroupid = '1'"); 

      (UPDATE tablename not UPDATE TABLE tablename)

      Comment

      • nullified
        Member
        • May 2005
        • 38
        • 3.5.0 Pre-Release

        #4
        Originally posted by nullified
        Disregard, simple mistake of having TABLE in the query.
        Originally posted by Martin Meredith
        try
        PHP Code:
        $db->query_write("UPDATE " TABLE_PREFIX "usergroup SET bannersyspermissions = '0' WHERE usergroupid = '1'"); 

        (UPDATE tablename not UPDATE TABLE tablename)
        rgr, found that you after about an hour or two of agrevation. thanks though.

        Comment

        widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
        Working...