Hall of Fame

[Will]

I need instruction on creating a database known as jads table it was not on my server for some reason after the latest update and I can't use the Overvideo ads. Anyone know how I can recreate it? I have very minimal coding knowledge...

[PHPVibe A.]

all tables are in setup/db.sql

phpmyadmin, run this on the database:

Code Select Expand

CREATE TABLE IF NOT EXISTS `#dbprefix#jads` (
  `jad_id` int(20) unsigned NOT NULL AUTO_INCREMENT,
  `jad_type` varchar(64) NOT NULL DEFAULT '0',
  `jad_box` varchar(64) NOT NULL DEFAULT '0',
  `jad_start` varchar(64) NOT NULL DEFAULT '0',
  `jad_end` varchar(64) NOT NULL DEFAULT '0',
  `jad_body` longtext NOT NULL,
  `jad_title` varchar(64) NOT NULL,
  `jad_pos` varchar(64) NOT NULL,
  `jad_extra` text NOT NULL,
  PRIMARY KEY (`jad_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;

change #dbprefix# to vibe_ or your used prefix.

[Will]

Thanks bro I found the jads table in the 3.6.2. db.sql.... I upgraded straight from 3.6 thats why I didn't have it. Thanks for the help I appreciate it.