Announcement

Collapse
No announcement yet.

mysql error - not sure why

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

  • 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'"); 

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

    Comment


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

      (UPDATE tablename not UPDATE TABLE tablename)

      Comment


      • #4
        Originally posted by nullified View Post
        Disregard, simple mistake of having TABLE in the query.
        Originally posted by Martin Meredith View Post
        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...
        X