By TonyBy on

When I run update.php I get the following message:

PDOException: SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'weight' at row 1: UPDATE {system} SET info=:db_update_placeholder_0, weight=:db_update_placeholder_1 WHERE (filename = :db_condition_placeholder_0) ; Array ( [:db_update_placeholder_0] => a:14:{s:4:"name";s:8:"Standard";s:11:"description";s:51:"Install with commonly used features pre-configured.";s:7:"version";s:4:"7.22";s:4:"core";s:3:"7.x";s:12:"dependencies";a:21:{i:0;s:5:"block";i:1;s:5:"color";i:2;s:7:"comment";i:3;s:10:"contextual";i:4;s:9:"dashboard";i:5;s:4:"help";i:6;s:5:"image";i:7;s:4:"list";i:8;s:4:"menu";i:9;s:6:"number";i:10;s:7:"options";i:11;s:4:"path";i:12;s:8:"taxonomy";i:13;s:5:"dblog";i:14;s:6:"search";i:15;s:8:"shortcut";i:16;s:7:"toolbar";i:17;s:7:"overlay";i:18;s:8:"field_ui";i:19;s:4:"file";i:20;s:3:"rdf";}s:7:"project";s:6:"drupal";s:9:"datestamp";s:10:"1365027012";s:7:"package";s:5:"Other";s:3:"php";s:5:"5.2.4";s:5:"files";a:0:{}s:9:"bootstrap";i:0;s:6:"hidden";b:1;s:8:"required";b:1;s:17:"distribution_name";s:6:"Drupal";} [:db_update_placeholder_1] => 1000 [:db_condition_placeholder_0] => profiles/standard/standard.profile ) in system_update_files_database() (line 2268 of /var/www/html/wl7/modules/system/system.module).

Could anybody tell me how to decode this or point to resources that could explain it? Thanks for the help.

Comments

VM’s picture

VM commented

similar issue discussed here: http://drupal.org/node/1003692 I'd seek other discussions utilizing 'PDOException: SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column' as the keywords.

khli7’s picture

khli7 commented

Dear Sir/Madam,

I have also come cross this problem when I upgrade the verison from 6.28 to 7.22.

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'mattscom_sales.system' doesn't exist: SELECT name, schema_version FROM {system} WHERE type = :type; Array ( [:type] => module ) in drupal_get_installed_schema_version() (line 155 of /home/mattscom/public_html/includes/install.inc).

It would be much appreciated if you can teach me how to solve the problem.

I have restored the database successfully in the phpMyAdmin, the message says

Restoring Database
-- phpMyAdmin SQL Dump
-- version 3.5.5
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Apr 29, 2013 at 11:14 AM
-- Server version: 5.1.68-cll
-- PHP Version: 5.3.17

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `mattscom_sales`
--

-- --------------------------------------------------------

--
-- Table structure for table `mattscom_sales.system`
--

CREATE TABLE IF NOT EXISTS `mattscom_sales.system`
`name` varchar30 DEFAULT NULL,
`age` int11 DEFAULT NULL,
`height` float DEFAULT NULL,
`date` datetime DEFAULT NULL
ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

What is the next thing I need to do to find the Base table in order to solve the problem.

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'mattscom_sales.system' doesn't exist: SELECT name, schema_version FROM {system} WHERE type = :type; Array [:type] => module in drupal_get_installed_schema_version line 155 of /home/mattscom/public_html/includes/install.inc.

Thanks very much,
Matthew

khli7’s picture

khli7 commented

Dear Sir/Madam,

Please kindly check if my settings are correct or not for Exporting databases from the current server in phpMyAdmin homepage.

Export Method:

Quick - display only the minimal options
Custom - display all possible options ticked this box

Databases:

Select All / Unselect All
information_schema
mattscom_sales I choose this one

Output:

Save output to a file
File name template: @SERVER@ use this for future exports
Character set of the file: utf-8
Compression: Zipped

View output as text

Format:
SQL I choose this option in combo box

Format-specific options:

Display comments includes info such as export timestamp, PHP version, and server version I ticked this box

Additional custom header comment n splits lines:
Include a timestamp of when databases were created, last updated, and last checked

Enclose export in a transaction

Disable foreign key checks

Database system or older MySQL server to maximize output compatibility with:
Add DROP DATABASE statement

Dump table
structure
data
structure and data this option is selected

Object creation options

Add statements:

Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT statement

Add CREATE PROCEDURE / FUNCTION / EVENT statement this box is ticked

CREATE TABLE options: this box is ticked

IF NOT EXISTS this box is ticked

AUTO_INCREMENT this box is ticked

Enclose table and column names with backquotes Protects column and table names formed with special characters or keywords this box is ticked

Data dump options

Instead of INSERT statements, use:

INSERT DELAYED statements

INSERT IGNORE statements
Function to use when dumping data:

Syntax to use when inserting data:

include column names in every INSERT statement
Example: INSERT INTO tbl_name col_A,col_B,col_C VALUES 1,2,3

insert multiple rows in every INSERT statement
Example: INSERT INTO tbl_name VALUES 1,2,3, 4,5,6, 7,8,9

both of the above
Example: INSERT INTO tbl_name col_A,col_B VALUES 1,2,3, 4,5,6, 7,8,9 I selected this box

neither of the above

And this one

Example: INSERT INTO tbl_name VALUES 1,2,3

Maximal length of created query 50000

Dump binary columns in hexadecimal notation for example, "abc" becomes 0x616263 I ticked this box

Dump TIMESTAMP columns in UTC enables TIMESTAMP columns to be dumped and reloaded between servers in different time zones I ticked this box

Thanks very much,
Matthew

VM’s picture

VM commented

your error is completely different than this post is discussing.

David_Rothstein’s picture

David_Rothstein commented

Note that #1007038: profiles/standard update query blocks 6 to 7 update if the site started on Drupal 4.6 or earlier (PDOException: SQLSTATE[22003]: Numeric value out of range) is a likely cause of the original problem reported here.