Problem deleting inactive users after upgrade to 3.2.2

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
Post Reply
User avatar
Acorn
Registered User
Posts: 392
Joined: Tue Sep 26, 2006 8:11 am
Location: UK
Contact:

Problem deleting inactive users after upgrade to 3.2.2

Post by Acorn » Fri Apr 20, 2018 11:47 am

Support Request Template
What version of phpBB are you using? phpBB 3.2.2
Who do you host your board with? Shared hosting on Rackspace
How did you install your board? I used the download package from phpBB.com
What is the most recent action performed on your board? Update from a previous version of phpBB3
Is registration required to reproduce this issue? Yes
Do you have any MODs installed? No
Do you have any extensions installed? Yes
What version of phpBB3 did you update from? phpBB 3.0-B1
What extensions do you have installed? Add User
Large Font
Obscure Contact Us
Right Header Image
Board Announcements
Stop Forum Spam
What styles do you currently have installed? My own customised prosilver
What language(s) is your board currently using? English
Which database type/version are you using? MySQL 5
What is your level of experience? New to PHP but not phpBB
What username can be used to view this issue? You need to be an admin
What password can be used to view this issue? No answer given
What actions did you take (updating your board; installing a MOD, style or extension; etc.) prior to this problem becoming noticeable? I updated the board from 3.1.10 to 3.2.2 yesterday.
Please describe your problem. I have admin activation enabled for new registrations. When I try to delete a new account I get a General Error message as follows:

SQL ERROR [ mysqli ]

Table 'forums_archive.phpbb_privmsgs_folder' doesn't exist [1146]

SQL

DELETE FROM phpbb_privmsgs_folder WHERE user_id = 1510

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 996
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 193
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 329
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/includes/functions_user.php
LINE: 674
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/includes/acp/acp_users.php
LINE: 233
CALL: user_delete()

FILE: [ROOT]/includes/functions_module.php
LINE: 676
CALL: acp_users->main()

FILE: [ROOT]/adm/index.php
LINE: 82
CALL: p_master->load_active()

If I go back a page and click on 'confirm' again, to delete the user, I find that the user has been deleted and no longer exists.
Generated by SRT Generator
Getting braver all the time. :D

User avatar
Acorn
Registered User
Posts: 392
Joined: Tue Sep 26, 2006 8:11 am
Location: UK
Contact:

Re: Problem deleting inactive users after upgrade to 3.2.2

Post by Acorn » Fri Apr 20, 2018 2:19 pm

I have just discovered that a similar error message is being given when users try to access their PMs.
General Error
SQL ERROR [ mysqli ]

Table 'forums_archive.phpbb_privmsgs_folder' doesn't exist [1146]
I guess something has gone wrong with the database update, but I don't know any SQL, so I don't know what to do about it.
Getting braver all the time. :D

User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 49340
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: Problem deleting inactive users after upgrade to 3.2.2

Post by stevemaury » Fri Apr 20, 2018 2:38 pm

That would be an upGRADE, not an upDATE. Exactly how did you upgrade? What is the uncompressed size of your database backup file?
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. PM or email me.

All unsolicited PMs will be ignored.

User avatar
Acorn
Registered User
Posts: 392
Joined: Tue Sep 26, 2006 8:11 am
Location: UK
Contact:

Re: Problem deleting inactive users after upgrade to 3.2.2

Post by Acorn » Fri Apr 20, 2018 2:55 pm

The database backup file is 32.9 MB.

I uploaded the full package, replaced the images, files and store directories and the config.php file, then went to forums/install and followed the instructions for the database upgrade.

I had a few problems initially and restored the database backup that I had made before starting (through phpMyAdmin). When I tried again I had no problems at all.
Getting braver all the time. :D

User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 49340
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: Problem deleting inactive users after upgrade to 3.2.2

Post by stevemaury » Fri Apr 20, 2018 4:27 pm

Do you have a text editor, like Crimson editor ot Notepad++ (both free, Google) that will open your db backup file? If so, search for privmsgs_folder and cut and paste all the commands to create and populate that table into another file. Now, confirm that your database does not have that table and post back.
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. PM or email me.

All unsolicited PMs will be ignored.

User avatar
Acorn
Registered User
Posts: 392
Joined: Tue Sep 26, 2006 8:11 am
Location: UK
Contact:

Re: Problem deleting inactive users after upgrade to 3.2.2

Post by Acorn » Fri Apr 20, 2018 5:34 pm

The current database definitely doesn't have the privmsgs_folder table. It goes straight from privmsgs to privmsgs_rules.

I have copied the relevant part of the previous database backup into a new file - 13 lines starting with # Table: phpbb_privmsgs_folder and finishing with a line that starts INSERT INTO phpbb_privmsgs_folder.

Many, many thanks for your help.
Getting braver all the time. :D

User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 49340
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: Problem deleting inactive users after upgrade to 3.2.2

Post by stevemaury » Fri Apr 20, 2018 5:41 pm

Can you post those 13 lines in code tags, along with the 15 lines before and after them?
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. PM or email me.

All unsolicited PMs will be ignored.

User avatar
Acorn
Registered User
Posts: 392
Joined: Tue Sep 26, 2006 8:11 am
Location: UK
Contact:

Re: Problem deleting inactive users after upgrade to 3.2.2

Post by Acorn » Fri Apr 20, 2018 5:55 pm

These are the 13 lines:

Code: Select all

# Table: phpbb_privmsgs_folder
DROP TABLE IF EXISTS phpbb_privmsgs_folder;
CREATE TABLE `phpbb_privmsgs_folder` (
  `folder_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL DEFAULT '0',
  `folder_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `pm_count` mediumint(8) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`folder_id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

INSERT INTO phpbb_privmsgs_folder (folder_id, user_id, folder_name, pm_count) VALUES (2, 478, 'research responses', 0),(3, 981, 'Archive', 1),(5, 57, 'notes', 1),(6, 548, 'Chat room settings', 1),(7, 70, 'Chat Room Opening Controls', 8);
Immediately before this is a series of lines beginning

Code: Select all

INSERT INTO phpbb_privmsgs (msg_id, root_level, author_id
which clearly have PMs at the ends of the lines, so I can't copy them here. Before those lines the code is:

Code: Select all

# Table: phpbb_privmsgs_rules
DROP TABLE IF EXISTS phpbb_privmsgs_rules;
CREATE TABLE `phpbb_privmsgs_rules` (
  `rule_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL DEFAULT '0',
  `rule_check` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `rule_connection` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `rule_string` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `rule_user_id` int(10) unsigned NOT NULL DEFAULT '0',
  `rule_group_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `rule_action` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `rule_folder_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`rule_id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

INSERT INTO phpbb_privmsgs_rules (rule_id, user_id, rule_check, rule_connection, rule_string, rule_user_id, rule_group_id, rule_action, rule_folder_id) VALUES (2, 55, 2, 9, 'Test Mod', 66, 0, 4, 0);
These are the lines immediately after the privmsgs_folder coding:

Code: Select all

# Table: phpbb_privmsgs_rules
DROP TABLE IF EXISTS phpbb_privmsgs_rules;
CREATE TABLE `phpbb_privmsgs_rules` (
  `rule_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL DEFAULT '0',
  `rule_check` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `rule_connection` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `rule_string` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `rule_user_id` int(10) unsigned NOT NULL DEFAULT '0',
  `rule_group_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `rule_action` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `rule_folder_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`rule_id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

INSERT INTO phpbb_privmsgs_rules (rule_id, user_id, rule_check, rule_connection, rule_string, rule_user_id, rule_group_id, rule_action, rule_folder_id) VALUES (2, 55, 2, 9, 'Test Mod', 66, 0, 4, 0);
Last edited by Mick on Sat Apr 21, 2018 6:58 am, edited 1 time in total.
Reason: Added code tags
Getting braver all the time. :D

User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 49340
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: Problem deleting inactive users after upgrade to 3.2.2

Post by stevemaury » Fri Apr 20, 2018 5:58 pm

OK, paste those 13 lines into the SQL window in phpmyadmin and click Go.
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. PM or email me.

All unsolicited PMs will be ignored.

User avatar
Acorn
Registered User
Posts: 392
Joined: Tue Sep 26, 2006 8:11 am
Location: UK
Contact:

Re: Problem deleting inactive users after upgrade to 3.2.2

Post by Acorn » Fri Apr 20, 2018 6:06 pm

:mrgreen: Thank you so much. Everything seems to be back to normal now. And next time I will have a much better idea of what to do.
Getting braver all the time. :D

Post Reply

Return to “[3.2.x] Support Forum”

Who is online

Users browsing this forum: millipede, thunderchero, will_hough and 37 guests