Databases
StackOverflow2013
Postsdbo
PO#1064 - You have an error in your SQL syntax; 'ALTER TABLE `field_revision_field_links` DISABLE KEYS */; INSERT INTO `field_rev' at line 5
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO#1064 - You have an error in your SQL syntax; 'ALTER TABLE `field_revision_field_links` DISABLE KEYS */; INSERT INTO `field_rev' at line 5
    primarykey
    data
    text
    <p>I'm having a import problem. </p> <blockquote> <p>#1064 - 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 'ALTER TABLE <code>field_revision_field_links</code> DISABLE KEYS */; INSERT INTO `field_rev' at line 5</p> </blockquote> <p>This is a Drupal database. Can anyone help me? I exported the sql via putty and import the database via phpMyAdmin of Parallels Plesk. Thanks</p> <p>More details:</p> <p>1.) Server version 5.1.69-0ubuntu0.10.04.1 <br> 2.) MySQL dump 10.13 Distrib 5.1.69, for debian-linux-gnu (x86_64) <br> 3.) Drupal version 7.32</p> <pre><code>DROP TABLE IF EXISTS `field_revision_field_links`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `field_revision_field_links` ( `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to', `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance', `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted', `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to', `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to', `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.', `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields', `field_links_value` varchar(255) DEFAULT NULL, `field_links_format` varchar(255) DEFAULT NULL, PRIMARY KEY (`entity_type`,`entity_id`,`revision_id`,`deleted`,`delta`,`language`), KEY `entity_type` (`entity_type`), KEY `bundle` (`bundle`), KEY `deleted` (`deleted`), KEY `entity_id` (`entity_id`), KEY `revision_id` (`revision_id`), KEY `language` (`language`), KEY `field_links_format` (`field_links_format`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Revision archive storage for field 117 (field_links)'; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `field_revision_field_links` WRITE; /*!40000 ALTER TABLE `field_revision_field_links` DISABLE KEYS */; INSERT INTO `field_revision_field_links` VALUES ('node','basic_page',0,14,14,'und',0,'&lt;a href=\"http://www.jcdecaux.co.uk/news\"&gt;News&lt;/a&gt;','full_html'),('node','basic_page',0,14,14,'und',1,'http://www.jcdecaux.co.uk/','full_html'); /*!40000 ALTER TABLE `field_revision_field_links` ENABLE KEYS */; UNLOCK TABLES; </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USmarkvicencio
    1. USmarkvicencio
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. PO#1064 - You have an error in your SQL syntax; 'ALTER TABLE `field_revision_field_links` DISABLE KEYS */; INSERT INTO `field_rev' at line 5
      1. This table or related slice is empty.
      1. VTDownMod
    2. VO
      singulars
      1. PO#1064 - You have an error in your SQL syntax; 'ALTER TABLE `field_revision_field_links` DISABLE KEYS */; INSERT INTO `field_rev' at line 5
      1. This table or related slice is empty.
      1. VTDownMod
    1. COYou have an error in your SQL syntax
      singulars
      1. PO#1064 - You have an error in your SQL syntax; 'ALTER TABLE `field_revision_field_links` DISABLE KEYS */; INSERT INTO `field_rev' at line 5
      1. USPraveen Prasannan
    2. COcare to post your query?
      singulars
      1. PO#1064 - You have an error in your SQL syntax; 'ALTER TABLE `field_revision_field_links` DISABLE KEYS */; INSERT INTO `field_rev' at line 5
      1. USAndrew Barber
    3. COI've removed the Microsoft SQL Server tag since it's pretty obvious that you are using MySQL.
      singulars
      1. PO#1064 - You have an error in your SQL syntax; 'ALTER TABLE `field_revision_field_links` DISABLE KEYS */; INSERT INTO `field_rev' at line 5
      1. USÁlvaro González
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload