[jjmusicpro]

SO we are up to 5 people that have this same problem....

[AshDigg]

If anyone can PM me thier ftp / db details, i'll be happy to take a look tomorrow morning - around 9am central time.

[jjmusicpro]

AshDigg: I just PM you my ftp/db details.

Thanks again for the help!

[jjmusicpro]

FYI You can remove all files in the httpdocs folder, thats where you will need to install it.

[kbeeveer46]

If anyone wants to PM me their ftp and database info I can also try installing it for you.

[jjmusicpro]

Kbeever46 I've also PM'ed you information for another site of mine, this way there can be 2 of you working on it, to help us all out once you find the anwser.

Thanks again.

[spatiban]

Manually creating tables!

Check for 'createtables.php' file in your Install folder and extract the SQL code for creating tables. Modify the table names with proper prefix you may need. Then run the SQL code inside your PHPMYAdmin on the database you already created.

[jjmusicpro]

I tried that and it didnt work

[kbeeveer46]

jjmusicpro and lowparts, what host are you using? I'm asking because I think you guys use the same host. After FTP'ing into both of your servers they look very identical.

[jjmusicpro]

ipower.com server

can someone give us a copy of there DB?
I am trying to parse all this .php file and its not coming out right here is what i have:



REATE TABLE table_blogs (
`blog_id` int(20) NOT NULL auto_increment,
`blog_key` varchar(35) default NULL,
`blog_type` enum('normal','blog') NOT NULL default 'normal',
`blog_rss` varchar(64) NOT NULL default '',
`blog_rss2` varchar(64) NOT NULL default '',
`blog_atom` varchar(64) NOT NULL default '',
`blog_url` varchar(64) default NULL,
PRIMARY KEY (`blog_id`),
UNIQUE KEY `key` (`blog_key`)
) TYPE = MyISAM;

CREATE TABLE table_categories (
`category__auto_id` int(11) NOT NULL auto_increment,
`category_lang` varchar(" . strlen($dblang) . ") NOT NULL default " . "'" . $dblang . "',
`category_id` int(11) NOT NULL default '0',
`category_parent` int(11) NOT NULL default '0',
`category_name` varchar(64) NOT NULL default '',
`category_safe_name` varchar(64) NOT NULL default '',
`rgt` int(11) NOT NULL,
`lft` int(11) NOT NULL,
`category_enabled` int(11) NOT NULL default '1',
`category_order` int(11) NOT NULL default '0',
`category_color` varchar(6) default 'FF0000',
PRIMARY KEY (`category__auto_id`),
UNIQUE KEY `key` (`category_name`)
) TYPE = MyISAM;


CREATE TABLE table_comments(
`comment_id` int(20) NOT NULL auto_increment,
`comment_randkey` int(11) NOT NULL default '0',
`comment_parent` int(20) default '0',
`comment_link_id` int(20) NOT NULL default '0',
`comment_user_id` int(20) NOT NULL default '0',
`comment_date` timestamp NOT NULL,
`comment_karma` smallint(6) NOT NULL default '0',
`comment_nick` varchar(32) default NULL,
`comment_content` text NOT NULL,
`comment_votes` int(20) NOT NULL default '0',
PRIMARY KEY (`comment_id`),
UNIQUE KEY `comments_randkey` (`comment_randkey`,`comment_link_id`,`comment_user _id`,`comment_parent`),
KEY `comment_link_id_2` (`comment_link_id`,`comment_date`)
) TYPE = MyISAM;

CREATE TABLE table_friends (
`friend_id` int(11) NOT NULL auto_increment,
`friend_from` bigint(20) NOT NULL default '0',
`friend_to` bigint(20) NOT NULL default '0',
PRIMARY KEY (`friend_id`),
UNIQUE KEY `friends_from_to` (`friend_from`,`friend_to`)
) TYPE = MyISAM;


CREATE TABLE table_languages (
`language_id` int(11) NOT NULL auto_increment,
`language_name` varchar(64) NOT NULL default '',
PRIMARY KEY (`language_id`),
UNIQUE KEY `language_name` (`language_name`)
) TYPE = MyISAM;


CREATE TABLE table_links (
`link_id` int(20) NOT NULL auto_increment,
`link_author` int(20) NOT NULL default '0',
`link_blog` int(20) default '0',
`link_status` enum('discard','queued','published','abuse','dupli cated') NOT NULL default 'discard',
`link_randkey` int(20) NOT NULL default '0',
`link_votes` int(20) NOT NULL default '0',
`link_karma` decimal(10,2) NOT NULL default '0.00',
`link_modified` timestamp NOT NULL,
`link_date` timestamp NOT NULL,
`link_published_date` timestamp NOT NULL,
`link_category` int(11) NOT NULL default '0',
`link_lang` int(11) NOT NULL default '1',
`link_url` varchar(200) NOT NULL default '',
`link_url_title` text,
`link_title` text NOT NULL,
`link_title_url` varchar(255) default NULL,
`link_content` text NOT NULL,
`link_summary` text default NULL,
`link_tags` text,
`link_field1` varchar(255) NOT NULL default '',
`link_field2` varchar(255) NOT NULL default '',
`link_field3` varchar(255) NOT NULL default '',
`link_field4` varchar(255) NOT NULL default '',
`link_field5` varchar(255) NOT NULL default '',
`link_field6` varchar(255) NOT NULL default '',
`link_field7` varchar(255) NOT NULL default '',
`link_field8` varchar(255) NOT NULL default '',
`link_field9` varchar(255) NOT NULL default '',
`link_field10` text NOT NULL default '',
`link_field11` text NOT NULL default '',
`link_field12` text NOT NULL default '',
`link_field13` text NOT NULL default '',
`link_field14` text NOT NULL default '',
`link_field15` text NOT NULL default '',
PRIMARY KEY (`link_id`),
KEY `link_author` (`link_author`),
KEY `link_url` (`link_url`),
KEY `link_date` (`link_date`),
KEY `link_published_date` (`link_published_date`),
FULLTEXT KEY `link_url_2` (`link_url`,`link_url_title`,`link_title`,`link_co ntent`,`link_tags`),
FULLTEXT KEY `link_tags` (`link_tags`)
) TYPE = MyISAM;

CREATE TABLE table_trackbacks (
`trackback_id` int(10) unsigned NOT NULL auto_increment,
`trackback_link_id` int(11) NOT NULL default '0',
`trackback_user_id` int(11) NOT NULL default '0',
`trackback_type` enum('in','out') NOT NULL default 'in',
`trackback_status` enum('ok','pendent','error') NOT NULL default 'pendent',
`trackback_modified` timestamp NOT NULL,
`trackback_date` timestamp NULL default NULL,
`trackback_url` varchar(200) NOT NULL default '',
`trackback_title` text,
`trackback_content` text,
PRIMARY KEY (`trackback_id`),
UNIQUE KEY `trackback_link_id_2` (`trackback_link_id`,`trackback_type`,`trackback_u rl`),
KEY `trackback_link_id` (`trackback_link_id`),
KEY `trackback_url` (`trackback_url`),
KEY `trackback_date` (`trackback_date`)
) TYPE = MyISAM;

CREATE TABLE table_users (
`user_id` int(20) NOT NULL auto_increment,
`user_login` varchar(32) NOT NULL default '',
`user_level` enum('normal','special','blogger','admin','god') NOT NULL default 'normal',
`user_modification` timestamp NOT NULL,
`user_date` timestamp NOT NULL,
`user_pass` varchar(64) NOT NULL default '',
`user_email` varchar(128) NOT NULL default '',
`user_names` varchar(128) NOT NULL default '',
`user_lang` int(11) NOT NULL default '1',
`user_karma` decimal(10,2) default '10.00',
`user_url` varchar(128) NOT NULL default '',
`user_lastlogin` timestamp NOT NULL,
`user_aim` varchar(64) NOT NULL default '',
`user_msn` varchar(64) NOT NULL default '',
`user_yahoo` varchar(64) NOT NULL default '',
`user_gtalk` varchar(64) NOT NULL default '',
`user_skype` varchar(64) NOT NULL default '',
`user_irc` varchar(64) NOT NULL default '',
`public_email` varchar(64) NOT NULL default '',
`user_avatar_source` varchar(255) NOT NULL default '',
`user_ip` varchar(20) default '0',
`user_lastip` varchar(20) default '0',
`last_reset_request` timestamp NOT NULL,
`user_location` varchar(255) default NULL,
`user_occupation` varchar(255) default NULL,
PRIMARY KEY (`user_id`),
UNIQUE KEY `user_login` (`user_login`),
KEY `user_email` (`user_email`)
) TYPE = MyISAM;";


CREATE TABLE table_tags (
`tag_link_id` int(11) NOT NULL default '0',
`tag_lang` varchar(4) NOT NULL default 'en',
`tag_date` timestamp NOT NULL,
`tag_words` varchar(64) NOT NULL default '',
UNIQUE KEY `tag_link_id` (`tag_link_id`,`tag_lang`,`tag_words`),
KEY `tag_lang` (`tag_lang`,`tag_date`)
) TYPE = MyISAM;


CREATE TABLE table_votes (
`vote_id` int(20) NOT NULL auto_increment,
`vote_type` enum('links','comments') NOT NULL default 'links',
`vote_date` timestamp NOT NULL,
`vote_link_id` int(20) NOT NULL default '0',
`vote_user_id` int(20) NOT NULL default '0',
`vote_value` smallint(11) NOT NULL default '1',
`vote_ip` varchar(64) default NULL,
PRIMARY KEY (`vote_id`),
KEY `user_id` (`vote_user_id`),
KEY `link_id` (`vote_link_id`),
KEY `vote_type` (`vote_type`,`vote_link_id`,`vote_user_id`,`vote_i p`)
) TYPE = MyISAM;

CREATE TABLE table_pageviews (
`pv_id` int(10) unsigned NOT NULL auto_increment,
`pv_type` varchar(20) NOT NULL default '',
`pv_page_id` int(11) NOT NULL default '0',
`pv_datetime` timestamp NOT NULL,
`pv_user_id` int(11) NOT NULL default '0',
`pv_user_ip` varchar(64) default NULL,
PRIMARY KEY (`pv_id`)
) TYPE = MyISAM;

CREATE TABLE table_config (
`var_id` int(11) NOT NULL auto_increment,
`var_page` varchar(50) NOT NULL,
`var_name` varchar(100) NOT NULL,
`var_value` varchar(50) NOT NULL,
`var_defaultvalue` varchar(50) NOT NULL,
`var_optiontext` varchar(200) NOT NULL,
`var_title` varchar(200) NOT NULL,
`var_desc` text NOT NULL,
`var_method` varchar(10) NOT NULL,
`var_enclosein` varchar(5) default NULL,
PRIMARY KEY (`var_id`)
) TYPE = MyISAM;

CREATE TABLE table_messages (
`idMsg` int(11) NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`body` text NOT NULL,
`sender` int(11) NOT NULL default '0',
`receiver` int(11) NOT NULL default '0',
`senderLevel` int(11) NOT NULL default '0',
`readed` int(11) NOT NULL default '0',
`date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (`idMsg`)
) TYPE = MyISAM;


echo "Creating table: 'modules'<br>";
$sql = "CREATE TABLE `" . table_modules . "` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(50) NOT NULL,
`version` float NOT NULL,
`folder` varchar(50) NOT NULL,
`enabled` tinyint(1) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM;";
mysql_query( $sql, $conn );


INSERT INTO table_users VALUES (1, 'god', 'god', now(), now(), '1e41c3f5a260b83dd316809b221f581cdbba8c1489e6d5896 ', 'blank@pligg.com', '', 1, 10.00, 'www.pligg.com', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '0', '0', '0', '', '');

INSERT INTO table_categories VALUES (0, '" . $dblang . "', 0, 0, 'all', 'all', 0, 0, 2, 0, '000000');

UPDATE table_categories SET `category__auto_id` = '0' WHERE `category_name` = 'all' LIMIT 1;

INSERT INTO table_categories VALUES (1, '" . $dblang . "', 1, 0, 'pligg', 'pligg', 0, 0, 1, 0, '000000');

INSERT INTO table_modules VALUES (1, 'Javascript Effects Pack', 0.1, 'scriptaculous', 1);

INSERT INTO table_modules VALUES (2, 'Admin Modify Language', 0.1, 'admin_language', 1);