Anvil Studios
web development
Posts Tagged ‘PDOException’
Uncaught PDOException with SQLSTATE[HY000]
19 Feb 2009Problem:
I was setting up a database query using a PDOStatement, by looping through an array of values and binding each parameter seperately. But on executing the query, I got the following error:
Fatal error: Uncaught exception ‘PDOException’ with message ‘SQLSTATE[HY000]: General error: 1452 Cannot add or update a child row: a foreign key constraint fails (`places/places`, CONSTRAINT `places_ibfk_3` FOREIGN KEY (`login_id`) REFERENCES `login` (`id`) ON DELETE CASCADE)’ in G:….
- (1) Comment
- Tags: Database, PDO, PDOException
About this blog
Based in South Africa, we're a web-development company...
Categories
- Categories
- Administration
(2)
- Apache (3)
- Beginner (1)
- CSS (5)
- Database (4)
- development (1)
- Google maps (1)
- HTML (14)
- HTML101 (1)
- Javascript (8)
- MySQL (7)
- PHP (17)
- Planning (1)
- Programming Concepts (4)
- Revision Control (2)
- SEO (2)
- Uncategorized (1)
- Administration
- Lamer: Both are excellent solutions, thanks. But I cannot help but think the guys who create these standard [...]
- Nico: I've had other people also telling me it does not work. Seems it works for some and for some not. An [...]
- Ivan: I changed both php.ini in wamp directory (D:\wamp\bin\apache\Apache2.2.17\bin and D:\wamp\bin\php\ph [...]
- martin: just what i was looking for, thanks! [...]
- Kishore: This has really helped me.. Thanks! [...]
- Browsers Explained
- The importance of Wireframes and Specification Documents
- HTML 101, Part 4 – Attributes
- HTML 101, Part 3 – Tags
- HTML 101, Part 2 – Setup
- HTML 101, Part 1 – Introduction
- Web Developer Bootcamp: Introduction
- Alter a foreign key in mySQL
- AJAX Form submit with jquery
- Error vs Exception, Part 4