Error running ps_fonts_font_pack.sql

[mfscripts4810]

SQL query:

INSERT INTO `font` VALUES (19, 'Assimilate', '', '2009-11-15 16:45:54', 'active', 0, 'ASSIMILA.TTF', NULL, '', '', 0, 1, '', '', '');

MySQL said: Documentation
#1136 - Column count doesn't match value count at row 1

I'm getting the above error when I try to run the ps_fonts_font_pack.sql file from my offline folder. Am I doing something wrong?

 

[ysmods]

Sounds as if the installation file didn't upload correctly (database.sql).

If you do not have anything on your site yet, you can drop the "font" table and run the following query

CREATE TABLE IF NOT EXISTS `font` (
`id` int(11) NOT NULL,
  `fontName` varchar(255) NOT NULL,
  `fontDesigner` varchar(255) NOT NULL,
  `dateCreated` timestamp NULL DEFAULT NULL,
  `status` enum('active','disabled','removed','pending') NOT NULL DEFAULT 'active',
  `totalDownloads` int(11) NOT NULL DEFAULT '0',
  `fontForPreview` varchar(255) NOT NULL,
  `fontRating` int(3) DEFAULT NULL,
  `submissionIpAddress` varchar(15) NOT NULL,
  `previewOverride` varchar(50) NOT NULL,
  `submittedUserId` int(11) NOT NULL,
  `licenseId` int(11) NOT NULL,
  `urlWebsite` text NOT NULL,
  `urlProfile` text NOT NULL,
  `urlBlog` text NOT NULL
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

If you do have fonts in the table, please post the "font" table structure so that we can provide a fix for you.

 

[mfscripts4810]

There is already data in that table but I am happy to drop it and rebuild it if you think it will help.

 

[mfscripts4810]

Okay, that worked. My Categories look a bit off now though?

 

[zuberkhan20602529]

I Am Having Same Problem Please Help Me