is there a for "idiots" directions on how to do this...
A complete reinstallation
]]>If your administration hasn't the prefix 0_, please change it first in the query.
If this doesn't works, maybe you have experienced a installation/rights problem.
DROP TABLE IF EXISTS `0_users`;
CREATE TABLE IF NOT EXISTS `0_users` (
`id` smallint(6) NOT NULL auto_increment,
`user_id` varchar(60) NOT NULL default '',
`password` varchar(100) NOT NULL default '',
`real_name` varchar(100) NOT NULL default '',
`role_id` int(11) NOT NULL default '1',
`phone` varchar(30) NOT NULL default '',
`email` varchar(100) default NULL,
`language` varchar(20) default NULL,
`date_format` tinyint(1) NOT NULL default '0',
`date_sep` tinyint(1) NOT NULL default '0',
`tho_sep` tinyint(1) NOT NULL default '0',
`dec_sep` tinyint(1) NOT NULL default '0',
`theme` varchar(20) NOT NULL default 'default',
`page_size` varchar(20) NOT NULL default 'A4',
`prices_dec` smallint(6) NOT NULL default '2',
`qty_dec` smallint(6) NOT NULL default '2',
`rates_dec` smallint(6) NOT NULL default '4',
`percent_dec` smallint(6) NOT NULL default '1',
`show_gl` tinyint(1) NOT NULL default '1',
`show_codes` tinyint(1) NOT NULL default '0',
`show_hints` tinyint(1) NOT NULL default '0',
`last_visit_date` datetime default NULL,
`query_size` tinyint(1) default '10',
`graphic_links` tinyint(1) default '1',
`pos` smallint(6) default '1',
`print_profile` varchar(30) NOT NULL default '1',
`rep_popup` tinyint(1) default '1',
`sticky_doc_date` tinyint(1) default '0',
`startup_tab` varchar(20) NOT NULL default '',
`inactive` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `user_id` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 ;--
-- Dumping data for table `0_users`
--INSERT INTO `0_users` VALUES(1, 'admin', '5f4dcc3b5aa765d61d8327deb882cf99', 'Administrator', 2, '', 'adm@adm.com', 'en_US', 0, 0, 0, 0, 'default', 'Letter', 2, 2, 4, 1, 1, 0, 0, '2008-04-04 12:34:29', 10, 1, 1, '1', 1, 0, 'orders', 0);