Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

MySQL Error


Guest

Recommended Posts

This one has me stumped.

 

Any Ideas?

 

Here is the error:

 

acg00001 - Booby 0011136 - Column count doesn't match value count at row 1

 

insert into download_images values ('133',filename1='',filename2='',filename3='',filename4='',filename5='',filename6='',filename7='',filename8='',filename9='',filename10='')

 

[TEP STOP]

 

 

Here is the database:-- phpMyAdmin SQL Dump

-- version 2.10.0.2

-- http://www.phpmyadmin.net

--

-- Host: localhost

-- Generation Time: Aug 08, 2007 at 11:07 PM

-- Server version: 4.1.22

-- PHP Version: 4.4.4

 

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

 

--

-- Database: `express_sspl`

--

 

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

 

--

-- Table structure for table `download_images`

--

 

CREATE TABLE `download_images` (

`products_id` int(11) NOT NULL default '0',

`filename1` varchar(200) NOT NULL default '',

`filename2` varchar(200) NOT NULL default '',

`filename3` varchar(200) NOT NULL default '',

`filename4` varchar(200) NOT NULL default '',

`filename5` varchar(200) NOT NULL default '',

`filename6` varchar(200) NOT NULL default '',

`filename7` varchar(200) NOT NULL default '',

`filename8` varchar(200) NOT NULL default '',

`filename9` varchar(200) NOT NULL default '',

`filename10` varchar(200) NOT NULL default '',

`price1` varchar(20) default '0',

`price2` varchar(20) default '0',

`price3` varchar(20) default '0',

`price4` varchar(20) default '0',

`price5` varchar(20) default '0',

`price6` varchar(20) default '0',

`price7` varchar(20) default '0',

`price8` varchar(20) default '0',

`price9` varchar(20) default '0',

`price10` varchar(20) default '0',

PRIMARY KEY (`products_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

--

-- Dumping data for table `download_images`

--

 

 

INSERT INTO `download_images` VALUES (12444, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12445, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12446, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12447, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12448, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12449, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12450, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12451, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12452, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12453, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12454, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12455, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12456, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12457, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12458, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12459, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12460, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12461, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12462, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12463, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12464, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12465, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12466, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12467, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12468, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12469, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12470, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12471, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12472, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12473, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12474, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12475, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12476, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12477, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12478, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12479, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12480, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12481, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12482, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12483, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12484, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12485, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12486, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12487, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12488, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12489, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12490, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12491, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12492, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12493, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12494, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12495, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12496, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12497, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12498, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12499, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12500, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12501, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12502, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12503, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12504, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12505, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12506, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12507, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12508, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12509, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12510, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12511, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `download_images` VALUES (12512, '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

Link to comment
Share on other sites

It's quite simple really, the table has 21 fields, so the query has to match them:

 

insert into download_images values ('133','filename1','filename2','filename3','filename4','filename5','filename6','filename7','filename8','filename9','filename10','price1','price2','price3','price4','price5','price6','price7','price8','price9','price10');

 

The 'filename' values have to be replaced with the actual filenames, and the 'price' values have to be replaced with the actual prices - or else left blank e.g. '','','','','','',

 

Vger

Link to comment
Share on other sites

OK, I understand there is 21 fields, and the quary has to match. But what I don't understand is where to modify the quary so it will match.

 

Edit:

 

So the table is wrong,

 

Do I need to add the line you made to correct the issue?

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...