Kryptronic Software Support Forum

RobH · 06-17-2009 05:25:37

Hi guys,

I have a user with a problem logging into his cart account, when he clicks the 'send password' link the cart shows an error. Is it possible for me to force sending of his current password or to reset to a default password?

Thanks in advance.

RobH

Dave · 06-17-2009 06:11:20

You may change the password in admin under Home > Hybrid X Core > User Accounts: Users, User Groups and Affiliate Payments > Manage User Accounts

RobH · 06-17-2009 07:37:40

I did try this but assumed it must have been looking for a hash or something - it came back with the same error. I've now deleted the customer account and asked him to recreate it or guest checkout. Maybe some type of corruption?

Cheers

H

Dave · 06-17-2009 07:39:39

In admin the password is entered in plain text. It's hashed when it's updated in the DB.

RobH · 06-17-2009 09:51:13

Ok thanks Dave, like I said, I tried this and tried to login using the customer's email and the pass I'd just set, It came back with an error - something about not being possible and please try again later (!?).

Cheers

RobH

RobH · 07-20-2009 08:05:51

Hi Guys,

This has just happened again, I'm unable to manually set a password via khxc user admin and then login using the new credentials, it just doesn't accept it. I suspect something is preventing ccp from updating the khxc database, this would possibly agree with some other minor problems I've found. Could this be a permissions issue? I'm using SQL Express 2005 on a Windows 2003 web edition server. All permissions were default when the installation was made.

The only option I currently have is to delete the user account and ask them to make it again.

Cheers
H

Dave · 07-20-2009 08:24:59

If it were a permissions problem almost nothing would work including ordering. SQL Express 2005 is not a supported database engine in CCP which may explain the problems you are having.

RobH · 07-21-2009 04:27:43

Hi Dave, thanks for the reply.

When you say 'unsupported' do you mean untested or that there are known issues which make SQL Express unsuitable? If this is an inherent problem with SQL Express I'm obviously going to need to change to another version, is there an alternative open source/free option? Before I proceed I need to be reasonably certain that the problem is SQL Express.

I guess the next question will be 'is it possible to change the SQL database engine without reinstalling the cart?'.

Cheers

H

Dave · 07-21-2009 05:45:51

Not tested and we have no idea if it would be suitable for CCP. From the sounds of it the answer is probably not. The majority of folks using CCP use MySQL.

The DB itself would have to be loaded from scratch unless you can find something that will copy data from SQL Express over to MySQL or whatever database you choose. For things like your products and categories you should be able to export them as CSV files and import them again after changing DB engines.

RobH · 07-21-2009 08:13:52

Ok, thanks Dave, I don't need to move much data other than customer data, I only use CCP for its 'remoteadd' facility hence I have no categories or products to migrate.

The error is of the type 'Cannot use object of type KHXCerror as array'

I went for SQL Express for 'convenience' as I'd never worked with an SQL dbase before and SQL Express was preinstalled as default software on my hosted dedicated server. Couldn't find a suitable download of MySQL that I didn't have to pay for. Oh well, you live and learn I guess...

Cheers

H

Dave · 07-21-2009 08:35:26

Everything MySQL is free. The only things they actually sell are support agreements. Probably 98.726% of the world uses MySQL mainly because it is free

RobH · 07-21-2009 10:42:19

Hmm...just done a bit of research and it appears that SQL Express offers the same basic functionality and uses the same syntax as MS SQL, the only difference being limitations to performance and database size (4GB). There is nothing to suggest that if CCP works with MS SQL it won't work with SQL Express.

I reckon the error that I'm getting when trying to import a .csv into khxc is the key to all my problems.

Cheers

H

Dave · 07-21-2009 10:46:26

Well I guess that's good news for you then. You might want to consider moving to MySQL as support for MS SQL is not present in CCP version 7. It's very limited use and restrictions prompted us to remove it from the supported list of DB engines.

smalkan · 07-29-2009 19:00:48

I have forgotten e-mail address for admin login. How can I retrieve it!

dh783 · 07-29-2009 20:08:47

If you can get into your private_directory you can look in the config.php file which would contain the information as long as you did change it in ccp's admin or you can look into the database through something like phpadmin and check the user table for your informtion.

John

Kryptronic Software Support Forum

#1 06-17-2009 05:25:37

User account login problem

#2 06-17-2009 06:11:20

Re: User account login problem

#3 06-17-2009 07:37:40

Re: User account login problem

#4 06-17-2009 07:39:39

Re: User account login problem

#5 06-17-2009 09:51:13

Re: User account login problem

#6 07-20-2009 08:05:51

Re: User account login problem

#7 07-20-2009 08:24:59

Re: User account login problem

#8 07-21-2009 04:27:43

Re: User account login problem

#9 07-21-2009 05:45:51

Re: User account login problem

#10 07-21-2009 08:13:52

Re: User account login problem

#11 07-21-2009 08:35:26

Re: User account login problem

#12 07-21-2009 10:42:19

Re: User account login problem

#13 07-21-2009 10:46:26

Re: User account login problem

#14 07-29-2009 19:00:48

Re: User account login problem

#15 07-29-2009 20:08:47

Re: User account login problem

Board footer