Tag Archive index

SQL General error – 1553 Cannot drop index XYZ needed in a foreign key constraint

9. Februar 2016 Kommentare deaktiviert für SQL General error – 1553 Cannot drop index XYZ needed in a foreign key constraint By webpirat
// show indexes of table
SHOW CREATE TABLE news;

// shows something like this
...
CONSTRAINT `FK_3A51546D12469DE2` FOREIGN KEY (`category_id`) REFERENCES `news_category` (`id`),
...

// drop index
ALTER TABLE news DROP FOREIGN KEY FK_3A51546D12469DE2;

, , , , , , ,

howto get kohana 3.3.x or 3.2.x up and running when default route failes after fresh installation

5. Dezember 2013 Kommentare deaktiviert für howto get kohana 3.3.x or 3.2.x up and running when default route failes after fresh installation By webpirat

copy the system/classes/kohana/request.php to your application/classes/kohana/request.php directory and open the file.
edit the file at around line 332 in the detect_uri method.


	public static function detect_uri()
	{

		...

		// cut out the initial base part to make sure the internal routing will get correct input
		$uri = str_replace(Kohana::$base_url.Kohana::$index_file, '', $uri);
		return $uri;
	}

, , , , , , , , , , , ,