php myfaq instalation problem

  • sohang
  • Newbie
  • Newbie
  • sohang
  • Posts: 6

Post 3+ Months Ago

when I installed php myfaq on my localhost there is an error occure after 5th step of 1-5 step


DB error: Table 'myfaq.faq_faqconfig' doesn't exist

Query:

INSERT INTO faq_faqconfig VALUES ('main.enableWysiwygEditor', 'true')



acc. to this msg if i create new table then what property should have in this table and how many field to created is not mentioned on error msg..

Pleas help.......
  • Anonymous
  • Bot
  • No Avatar
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post 3+ Months Ago

  • PolishHurricane
  • Mastermind
  • Mastermind
  • User avatar
  • Posts: 1585

Post 3+ Months Ago

I found this on google:
Code: [ Select ]
 
DROP TABLE IF EXISTS `faq_faqconfig`;
 
CREATE TABLE `faq_faqconfig` (
`config_name` varchar(255) NOT NULL default '',
`config_value` varchar(255) default NULL,
PRIMARY KEY (`config_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
  1.  
  2. DROP TABLE IF EXISTS `faq_faqconfig`;
  3.  
  4. CREATE TABLE `faq_faqconfig` (
  5. `config_name` varchar(255) NOT NULL default '',
  6. `config_value` varchar(255) default NULL,
  7. PRIMARY KEY (`config_name`)
  8. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  9.  


Try running that. If you don't have latin1, then you might want to change that though. Who knows why they made them 255 characters though, that's a pretty insane waste of space for each configuration variable.

Post Information

  • Total Posts in this topic: 2 posts
  • Users browsing this forum: No registered users and 159 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
cron
 

© 1998-2014. Ozzu® is a registered trademark of Unmelted, LLC.