Web Analytics Made Easy -
StatCounter MySQL Problem - CodingForum

Announcement

Collapse
No announcement yet.

MySQL Problem

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • MySQL Problem

    Filling MySQL Table I get notice Data truncated for column 'paid' at row 1 (complete SQL code below)

    INSERT INTO `users` (`user_id`, `title`, `fname`, `lname`, `email`, `psword`, `uname`, `registration_date`, `class`, `user_level`, `addr1`, `addr2`, `city`, `county`, `pcode`, `phone`, `paid`) VALUES
    (1, 'Mr', 'Jack', 'Smith', '[email protected]', 'bda7aeb2f7a4cf6f6f26b7c9e96e009913b2594b', 'wagglytail', '2013-01-05 20:34:41', '30', 1, '1 The Street', '', 'Townsville', 'Devon', 'EX12 6RE', '', ''),
    (2, 'Mr', 'James', 'Smith', '[email protected]', '34ae707a963ad8a1fb248f8c1f50a4d3d5dd2e64', 'muscleman', '2013-01-06 11:37:02', '30', 0, '3 The Street', 'The Village', 'Townsville', 'Devon', 'EX12 8RE', '', ''),
    (3, 'Mr', 'Mike', 'Rosoft', '[email protected]', '315806a3a2ae3ae81d1294746df09ac6ceaa587c', 'benefactor', '2013-02-02 13:02:34', '125', 0, '3 The Street', '', 'Townsville', 'Devon', 'EX12 6RE', '01111 444 6', ''),
    (4, 'Ms', 'Olive', 'Branch', '[email protected]', 'e832f6808645a6c6304fd90e99f5685c1403b245', 'mspopeye', '2013-02-02 13:06:09', '30', 0, '4 The Street', 'The Village', 'Townsville', 'Devon', 'EX12 6RE', '', ''),
    (5, 'Mr', 'Frank', 'Incense', '[email protected]', '71ea58aa789b63d377fa73c441348da5840bd0dc', 'mythking', '2013-02-02 13:08:39', '30', 0, '5 The Street', '', 'Townsville', 'Devon', 'EX24 6PG', '01111 444 6', ''),
    (52, 'Mrs', 'Annie', 'Versary', '[email protected]', '2f635f6d20e3fde0c53075a84b68fb07dcec9b03', 'celebrate', '2013-03-29 12:13:30', '30', 0, '6 The Street', 'The Village', 'Townsville', 'Devon', 'EX12 6RE', '', ''),
    (53, 'Mr', 'Terry', 'Fide', '[email protected]', '55deee02330052a7bb715168f9405b33ef752662', 'trembling', '2013-03-29 12:17:21', '30', 0, '8 The Street', '', 'Townsville', 'Devon', 'EX12 6RE', '', ''),
    (54, 'Mrs', 'Annie', 'Mossity', '[email protected]', '5097e90d39e6fd70da7651222a400b843e77bc56', '', '2013-03-29 12:27:52', '30', 0, '9 The Street', '', 'Townsville', 'Devon', 'EX12 6RE', '01111 622 3', ''),
    (55, 'Mr', 'Percy', 'Veer', '[email protected]', '4ac6f592d402e8f092fc0d9ce146f19e2cc089f7', '', '2013-03-29 12:37:18', '30', 0, '9 The Street', '', 'Townsville', 'Devon', 'EX12 6RE', '', ''),
    (56, 'Mr', 'Darrel', 'Doo', '[email protected]', 'a34b2d93b414ea65c52ac05fb5aac57041ded75b', '', '2013-03-29 12:41:12', '30', 0, '10 The Street', 'The Village', 'Townsville', 'Devon', 'EX12 6RE', '01234 777 6', ''),
    (57, 'Mr', 'Stan', 'Dard', '[email protected]', 'c46b524b22c5e2b8633474eb8045a8bab5bfef1c', '', '2013-03-29 15:41:07', '30', 0, '10 The Street', '', 'Townsville', 'Devon', 'EX12 6RE', '', ''),
    (58, 'Miss', 'Nora', 'Bone', '[email protected]', '916671ef4cc4c2348d55d7d9da64340afef9c57d', 'strongteeth', '2013-03-29 15:55:35', '30', 0, '11 The Street', 'The Village', 'Townsville', 'Devon', 'EX12 6RE', '01297123123', ''),
    (59, 'Mrs', 'Barry', 'Cade', '[email protected]', '2496e6e4e2f44fb00a6111369e0d8e108a8e3777', 'mybarrier', '2013-03-29 15:57:43', '30', 0, '12 The Street', '', 'Townsville', 'Devon', 'EX12 6RE', '01297 77777', ''),
    (60, 'Miss', 'Dee', 'Jected', '[email protected]', '9b5a7d91f8f01eb9cb45b3fe4b349f6699ca44d7', 'pessimist', '2013-03-29 16:57:33', '30', 0, '13 The Sreet', '', 'Townsville', 'Devon', 'EX12 6RE', '01297553888', ''),
    (61, 'Mrs', 'Lynn', 'Seed', '[email protected]', 'a2614195adf5952916965acba1b4111058453ba4', 'artistic', '2013-03-29 17:10:19', '30', 0, '14 The Street', 'The Village', 'Townsville', 'Devon', 'EX12 6RE', '', ''),
    (62, 'Mr', 'Barry', 'Tone', '[email protected]', '4070f1e15f4b49a01213ec61164b90100354fcf6', 'midrange', '2013-03-29 17:13:00', '30', 0, '15 The Street', '', 'Townsville', 'Devon', 'EX12 6RE', '10297555444', ''),
    (63, 'Mr', 'Adrian', 'West', '[email protected]', '7f3352a958720285b72a0aeb601572a35d2dce3e', 'cobblers', '2013-03-30 19:38:20', '30', 0, '55 Astbury Street', '', 'Townsville', 'Devon', 'EX12 6RE', '01111222333', ''),
    (64, 'Mr', 'Adrian', 'West', '[email protected]', 'dc7e372d5767c1cfe1738f0d3d47a9d91add47e7', 'cobblers', '2013-03-31 10:54:05', '30', 0, '55 Astbury Street', '', 'Townsville', 'Devon', 'EX12 6RE', '', ''),
    (65, 'Miss', 'Minnie', 'Mouse', '[email protected]', 'c9b80bb35f975546bd0533520f529b9c294ccf42', 'cheesy', '2013-03-31 11:08:40', '30', 0, '55 Astbury Street', '', 'Townsville', 'Devon', 'EX12 6RE', '01111222333', '');

    Please, let me know how to correct this error.

    Regards,
    Aleksandar

  • #2
    We need to see how the table is defined to even start on what might be happening.
    Stephen
    Learn Modern JavaScript - http://javascriptexample.net/
    Helping others to solve their computer problem at http://www.felgall.com/

    Don't forget to start your JavaScript code with "use strict"; which makes it easier to find errors in your code.

    Comment

    Working...
    X