Error running ps_fonts_font_pack.sql

mfscripts4810

New Member
Feb 27, 2015
3
0
0
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

New Member
Jan 29, 2013
860
1
0
UK
www.ysmods.com
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

Code:
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.