• quaker
  • quaker
  • Senior Member
  • Offline
  • From: USA
  • Registered: 2006-02-22
  • Posts: 1,783

Topic: i need help adding this code into my db!

i need help adding this code into my db!

what am i doing wrong?

im trying to add this to the pun_config db

o_additional_sidelinks       with the same value as the o_additional_navlinks

conf_name  varchar(255)
conf_value  text


INSERT INTO `pun_config` (
  `conf_name` varchar(255) collate latin1_german2_ci NOT NULL default '',
  `conf_value` text collate latin1_german2_ci,
  PRIMARY KEY  (`conf_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci;

-- 
-- Dumping data for table `pun_config`
-- 

INSERT INTO `pun_config` VALUES ('o_additional_sidelinks', '');
My stuff or my style might sux, but atleast I'm willing to help when I can.
Don't be stupid and help ! We are the stupid one's !!!

quaker's Website

  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

Re: i need help adding this code into my db!

Nothing is wrong, but as I keep telling you, latin1_german2_ci is not the collation used by most MySQL installs. As such, you're going to have issues if you import that table elsewhere, just like the users table issue you had.

  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

Re: i need help adding this code into my db!

Let me correct my statement: the first query should be a create table statement, not an insert statement