LOCK TABLES

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Anti-Spam Guide
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
kaszkai
Registered User
Posts: 242
Joined: Wed Jun 29, 2011 11:44 pm

LOCK TABLES

Post by kaszkai » Thu Sep 08, 2016 2:55 pm

Hello,

when importing the database by phpmyadmin gets the error:

Zapytanie SQL:

--
-- Table structure for table phpbb_sortables_confirm

DROP TABLE IF EXISTS phpbb_sortables_confirm;

MySQL zwrócił komunikat: Dokumentacja
1100 - Table 'phpbb_sortables_confirm' was not locked with LOCK TABLES
Poland ;)

User avatar
JimA
Community Team Leader
Community Team Leader
Posts: 7651
Joined: Thu Jul 31, 2008 5:54 am
Location: The Netherlands
Name: Jim Mossing Holsteyn
Contact:

Re: LOCK TABLES

Post by JimA » Thu Sep 08, 2016 8:53 pm

Looking at the table name, this seems like a problem with one of your MODs, and specifically the Sortables CAPTCHA plugin. You'd need to ask support from the author, which can be done over here. :)
Image Jim Mossing Holsteyn - Community Team Leader
Knowledge Base | Documentation | Board rules

If you're having any questions about the rules/customs of this website, feel free to drop me a PM.

kaszkai
Registered User
Posts: 242
Joined: Wed Jun 29, 2011 11:44 pm

Re: LOCK TABLES

Post by kaszkai » Fri Sep 09, 2016 1:22 pm

After removing sortables CAPTCHA plugin deviation occurs with the next table:
Zapytanie SQL:

--
-- Table structure for table phpbb_styles

DROP TABLE IF EXISTS phpbb_styles;

MySQL zwrócił komunikat: Dokumentacja
1100 - Table 'phpbb_styles' was not locked with LOCK TABLES
It's something the LOCK TABLE

Code: Select all

--
-- Table structure for table `phpbb_styles`
--

DROP TABLE IF EXISTS `phpbb_styles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phpbb_styles` (
  `style_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `style_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `style_copyright` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `style_active` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `template_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `theme_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `imageset_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`style_id`),
  UNIQUE KEY `style_name` (`style_name`),
  KEY `template_id` (`template_id`),
  KEY `theme_id` (`theme_id`),
  KEY `imageset_id` (`imageset_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `phpbb_styles`
--

LOCK TABLES `phpbb_styles` WRITE;
/*!40000 ALTER TABLE `phpbb_styles` DISABLE KEYS */;
INSERT INTO `phpbb_styles` VALUES (1,'prosilver','© phpBB Group',1,1,1,1),(2,'grunge','© RocketTheme, 2010',1,2,2,2);
/*!40000 ALTER TABLE `phpbb_styles` ENABLE KEYS */;
UNLOCK TABLES;
Poland ;)

kaszkai
Registered User
Posts: 242
Joined: Wed Jun 29, 2011 11:44 pm

Re: LOCK TABLES

Post by kaszkai » Mon Sep 12, 2016 11:15 pm

I removed the entries from the file s, there were a dozen or so and succeeded

Code: Select all

LOCK TABLES `phpbb_styles` WRITE;
UNLOCK TABLES;
Poland ;)

Locked

Return to “[3.0.x] Support Forum”