• Registered: 03/11/2013
  • Posts: 4

Topic: Problem with login/password

I installed the program, but for some reason it will not accept the login/password which i selected during the instal phase...
please advise

  • From: Netherlands, Amsterdam
  • Registered: 03/06/2011
  • Posts: 111

Re: Problem with login/password

try the default login:    user:   admin     / password:   password

  • Registered: 03/11/2013
  • Posts: 4

Re: Problem with login/password

nope, no such luck

  • From: Netherlands, Amsterdam
  • Registered: 03/06/2011
  • Posts: 111

Re: Problem with login/password

Try using phpmyadmin run the following query, password will be set to default (admin /   password).

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);

  • Registered: 03/11/2013
  • Posts: 4

Re: Problem with login/password

hmmm, honestly I dont know what you just wrote, is there a for "idiots" directions on how to do this...

  • From: Netherlands, Amsterdam
  • Registered: 03/06/2011
  • Posts: 111

Re: Problem with login/password

MyotOwner wrote:

is there a for "idiots" directions on how to do this...

A complete reinstallation

  • Registered: 03/11/2013
  • Posts: 4

Re: Problem with login/password

i did that twice.... ( i got this program from hostmonster link, the tech guys there helped me install it the 2nd time to make sure it was done correctly)

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,150

Re: Problem with login/password

disable the .htaccess file and try - if it works, then sort it out with your sysadmin.

apmuthu's Website