processwire
diff --git a/‎wire/core/Field.php
Copy file name to clipboardExpand all lines: wire/core/Field.php
+4-1Lines changed: 4 additions & 1 deletion b/‎wire/core/Field.php
Copy file name to clipboardExpand all lines: wire/core/Field.php
+4-1Lines changed: 4 additions & 1 deletion
diff --git a/‎wire/core/Fields.php
Copy file name to clipboardExpand all lines: wire/core/Fields.php
+5-3Lines changed: 5 additions & 3 deletions b/‎wire/core/Fields.php
Copy file name to clipboardExpand all lines: wire/core/Fields.php
+5-3Lines changed: 5 additions & 3 deletions
@@ -1248,7 +1248,9 @@ public function getTable() {
 			$table = $this->setTable;
 		} else {
 			$name = $this->settings['name'];
-			if(!strlen($name)) throw new WireException("Field 'name' is required");
+			$length = strlen($name);
+			if(!$length) throw new WireException("Field 'name' is required");
+			if($length > 58) $name = substr($name, 0, 58); // 'field_' + 58 = 64 max
 			$table = self::tablePrefix . $name;
 		}
 		if(self::$lowercaseTables) $table = strtolower($table); 
@@ -1265,6 +1267,7 @@ public function getTable() {
 	 */
 	public function setTable($table = null) {
 		$table = empty($table) ? '' : $this->wire()->sanitizer->fieldName($table);
+		if(strlen($table) > 64) $table = substr($table, 0, 64);
 		$this->setTable = $table;
 	}
 
 
@@ -388,12 +388,14 @@ public function ___save(Saveable $item) {
 			// even if only the case has changed. 
 			$schema = $item->type->getDatabaseSchema($item);
 			if(!empty($schema)) {
-				foreach(array($table, "tmp_$table") as $t) {
+				list(,$tmpTable) = explode(Field::tablePrefix, $table, 2);
+				$tmpTable = "tempf_$tmpTable";
+				foreach(array($table, $tmpTable) as $t) {
 					if(!$database->tableExists($t)) continue;
 					throw new WireException("Cannot rename to '$item->name' because table `$table` already exists");
 				}
-				$database->exec("RENAME TABLE `$prevTable` TO `tmp_$table`"); // QA
-				$database->exec("RENAME TABLE `tmp_$table` TO `$table`"); // QA
+				$database->exec("RENAME TABLE `$prevTable` TO `$tmpTable`"); // QA
+				$database->exec("RENAME TABLE `$tmpTable` TO `$table`"); // QA
 			}
 			$item->prevTable = '';
 		}
Original file line number	Diff line number	Diff line change
`@@ -388,12 +388,14 @@ public function ___save(Saveable $item) {`
`388`	`388`	`// even if only the case has changed.`
`389`	`389`	`$schema = $item->type->getDatabaseSchema($item);`
`390`	`390`	`if(!empty($schema)) {`
`391`		`- foreach(array($table, "tmp_$table") as $t) {`
	`391`	`+ list(,$tmpTable) = explode(Field::tablePrefix, $table, 2);`
	`392`	`+ $tmpTable = "tempf_$tmpTable";`
	`393`	`+ foreach(array($table, $tmpTable) as $t) {`
`392`	`394`	`if(!$database->tableExists($t)) continue;`
`393`	`395`	throw new WireException("Cannot rename to '$item->name' because table `$table` already exists");
`394`	`396`	`}`
`395`		- $database->exec("RENAME TABLE `$prevTable` TO `tmp_$table`"); // QA
`396`		- $database->exec("RENAME TABLE `tmp_$table` TO `$table`"); // QA
	`397`	+ $database->exec("RENAME TABLE `$prevTable` TO `$tmpTable`"); // QA
	`398`	+ $database->exec("RENAME TABLE `$tmpTable` TO `$table`"); // QA
`397`	`399`	`}`
`398`	`400`	`$item->prevTable = '';`
`399`	`401`	`}`