Page 1 of 1

LOCK TABLES

Posted: Thu Sep 08, 2016 2:55 pm
by kaszkai
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

Re: LOCK TABLES

Posted: Thu Sep 08, 2016 8:53 pm
by JimA
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. :)

Re: LOCK TABLES

Posted: Fri Sep 09, 2016 1:22 pm
by kaszkai
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;

Re: LOCK TABLES

Posted: Mon Sep 12, 2016 11:15 pm
by kaszkai
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;