After Install Pligg 1.0.0 Pligg_Users Table Doesn' t Exist

[airweb]

Hello, i' ve got a problem with plidd 1.0.0
After install and create Admin Account who doesn't work
I' m going to PhpMyAdmin for more information
And table pligg_users is missing

maybe others tables are missing too
i' ve got 18 tables
pligg_categories
pligg_comments
pligg_config
pligg_formulas
pligg_friends
pligg_group_member
pligg_group_shared
pligg_links
pligg_messages
pligg_misc_data
pligg_modules
pligg_redirects
pligg_saved_links
pligg_tag_cache
pligg_tags
pligg_totals
pligg_trackbacks
pligg_votes

Can you give me the Sql Script for pligg_users please ?

[Yankidank]

Clear your mysql database and try the install again. For some reason a lot of people have been having this issue, but we can't do much about it unless you PM us login information to your server along with MySQL datails so that we can see what's wrong.

[gislabs]

Hi, well i installed Pligg CMS 1.0.0 a few minutes ago.. well same error. It's working now but i found the following:

I opened Pligg_CMS_1.0.0\Pligg 1.0.0\install\installtables.php and searched for users key word and i copied the sql string changing " . table_users . " for pligg_users

$sql = "CREATE TABLE `" . table_users . "` (
`user_id` int(20) NOT NULL auto_increment,
`user_login` varchar(32) NOT NULL default '',
`user_level` enum('normal','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_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,
`last_email_friend` timestamp NOT NULL,
`last_reset_code` varchar(255) default NULL,
`user_location` varchar(255) default NULL,
`user_occupation` varchar(255) default NULL,
`user_categories` VARCHAR(1024) NOT NULL default '',
PRIMARY KEY (`user_id`),
UNIQUE KEY `user_login` (`user_login`),
KEY `user_email` (`user_email`)
) TYPE = MyISAM;";

Now, my data base shows an error whe executing SQL because it's version 4.x and varchar max length is 255 for this version and `user_categories` VARCHAR(1024) NOT NULL default has a length valid only in version 5.x so i changed varchar to 255 and it's working perfectly.

Read the attachment (txt)

Here i show pligg_users SQL string working on MySql 4.x:

CREATE TABLE `pligg_users` (
`user_id` int(20) NOT NULL auto_increment,
`user_login` varchar(32) NOT NULL default '',
`user_level` enum('normal','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_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,
`last_email_friend` timestamp NOT NULL,
`last_reset_code` varchar(255) default NULL,
`user_location` varchar(255) default NULL,
`user_occupation` varchar(255) default NULL,
`user_categories` VARCHAR(255) NOT NULL default '',
PRIMARY KEY (`user_id`),
UNIQUE KEY `user_login` (`user_login`),
KEY `user_email` (`user_email`)
) TYPE = MyISAM;

Kind regards,

Gislabs México