Announcement

Collapse
No announcement yet.

mysql error - not sure why

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

  • nullified
    replied
    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.

    Leave a comment:


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

    (UPDATE tablename not UPDATE TABLE tablename)

    Leave a comment:


  • nullified
    replied
    Disregard, simple mistake of having TABLE in the query.

    Leave a comment:


  • nullified
    started a topic mysql error - not sure why

    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'"); 
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X