Uploaded image for project: 'Support Team Tools'
  1. Support Team Tools
  2. STT-182

deleted users error

This issue belongs to an archived project. You can view it, but you can't modify it. Learn more

    XMLWordPrintable

Details

    • Bug
    • Status: Awaiting Information
    • Resolution: Unresolved
    • Support Toolkit
    • None

    Description

      I updated to phpBB3.0.8, then installed STK 1.0.1.2-PL1
      When I enter the stk delete users menu, I see the picture attached. I checked first line and pressed enter to test, saw the error below.
      Something seems missing.

      General Error
      SQL ERROR [ mysqli ]
       
      You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' forum_last_poster_name = '', forum_last_poster_colour = '3366FF' WHERE forum' at line 2 [1064]
       
      SQL
       
      UPDATE phpbb_forums SET forum_last_poster_id = , forum_last_poster_name = '', forum_last_poster_colour = '3366FF' WHERE forum_last_poster_name = ''
       
      BACKTRACE
       
      FILE: includes/db/mysqli.php
      LINE: 163
      CALL: dbal->sql_error()
       
      FILE: stk/tools/usergroup/restore_deleted_users.php
      LINE: 242
      CALL: dbal_mysqli->sql_query()
       
      FILE: stk/tools/usergroup/restore_deleted_users.php
      LINE: 122
      CALL: restore_deleted_users->_add_user_and_update_data()
       
      FILE: stk/index.php
      LINE: 288
      CALL: restore_deleted_users->run_tool()

      Attachments

        Activity

          People

            Unassigned Unassigned
            mtrs mtrs
            Archiver:
            Noxwizard Patrick Webster

            Dates

              Created:
              Updated:
              Archived: