Can't Log into my local store

Ok, first of all I would love to say a BIG THANKS to Goh Koon Hoek for writing the Zencart book - I would have never been able to install without it!!:clap:

So here goes - did everything as per book - worked great the firsttime.

Since I was going to be putting my site live after I made it all on my local...

On pg 51 of the book I selected a real name and one of my regular passwords - the email account was my home email.

For the email accounts (again live store in mind) I used the names in the book as given but made the passwords SmithAL, BlancCL, etc instead of just a regular password.

Same thing for the admin logons.

The first time it worked great - now nothing's working.

I tried the support code found on the website to fix it::huh:

after this message

SELECT * FROM zen_zones_to_geo_zones WHERE 1

DELETE FROM admin WHERE admin_name = 'Admin'; INSERT INTO admin (admin_name, admin_email, admin_pass, admin_level) VALUES ('Admin', 'admin@localhost', '351683ea4e19efe34874b501fdbf9792:9b', 1);

and it comes back with

PHP says ? or it says #1146 - Table 'store.admin' doesn't exist

I have tried it after this message (which is there when I open SQL) - I have also deleted the message and tried it and have also changed the directory on the left to zen_admin

nothing seems to work.:no:

I was able to find my name in the sql area and that long number string similar to the one above.

Cookies are deleted.

When I try to do the resend password things I'm getting this message:

Email Error: Could not instantiate mail function. Please check Admin->Configuration->Email Options->Email Transport.

Ok - What do I do?:(

Can some give me a step by step in how to do it in the sql area - still new to this language.:D

or if everything is all *** then please give me ste by step in how to unistall /reinstall.

lastly when I go to http://localhost/phpmyadmin/
it says this at the top:
Welcome to phpMyAdmin 2.6.4-pl1
and this at the bottom:
Your configuration file contains settings (root with no password) that correspond to the default MySQL privileged account. Your MySQL server is running with this default, is open to intrusion, and you really should fix this security hole.

but on the left side it only says databases - when I change it to my store database the message disappears - am I still at risk - how to fix?

Thanks for the help in advance - me not getting a lot of sleep trying to figure this one out not to mention > :frusty:

Hi janissaire, here are some things you can check.

For the SQL query, check that you have replaced all occurrences of the table prefix "zen_" on your local PC to suit the database on your server. I have highlighted the table prefixes you should take note of.

SELECT * FROM **zen_**zones_to_geo_zones WHERE 1

DELETE FROM **zen_**admin WHERE admin_name = 'Admin';

INSERT INTO **zen_**admin (admin_name, admin_email, admin_pass, admin_level) VALUES ('Admin', 'admin@localhost', '351683ea4e19efe34874b501fdbf9792:9b', 1);For moving a store from your local PC to a remote host, you can refer to this link in the Tutorials/FAQs. Remember to re-configure your Email settings to reflect your server's configuration.

To uninstall the Zen Cart in your PC, use phpmyadmin to delete the database, then delete the zen cart directory.

Finally, the security warning appears because XAMPP does not provide a default password for the MySQL database. If you change the MySQL database password, remember to change the passwords in both your configure.php files as well.

Ok will try it as soon as I get home from work.

I Have switched shifts for one day - it's 4 hours earlier than I'm used to - so lack of sleep probably will explain this next sentance clearly since I don't really know where I am at the moment - the caffine from the coffee hasn't kicked in yet :wink:

*"For the SQL query, check that you have replaced all occurrences of the table prefix "zen_" on your " local PC to suit the database on your server.
*

I haven't a clue what you mean by this.

Are you saying to just delete the "zen_" part from my screen when I'm in the qeuery field or do you want me to go to the PHP screen and delete the "zen_" from everything that I see in the main menu that has it - if yes to later how do I do it?

So far no luck - still trying

got

SELECT *
FROM zones_to_geo_zones
WHERE 1
DELETE FROM admin WHERE admin_name = 'Admin'

tried it like this and got something more back:

SELECT *
FROM zen_admin
WHERE 1
INSERT INTO zen_admin( admin_name, admin_email, admin_pass, admin_level )
VALUES (

'Admin', 'admin@localhost', '351683ea4e19efe34874b501fdbf9792:9b', 1
)
LIMIT 0 , 30

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO zen_admin ( admin_name , admin_email , admin_pass , admin_level ) VA' at line 1

However I did this:

Emptied the field and entered this:

INSERT INTO Zen_admin (admin_name, admin_email, admin_pass, admin_level) VALUES ('Admin', 'admin@localhost', '351683ea4e19efe34874b501fdbf9792:9b', 2)

and it worked!!!

I also repeated that code above and in the values area I put in a new name in "admin" and changed the 2 at the end back to a 1 and it's working too!

Thanks!

Thanks for letting us know you've got it to work. :smile:

No problem!!

I thought the solution I found may be helpful to others if they have the same issue.

A word of caution though - if you do it my way, the very first thing you will see at the top when you log in is a huge security warning messge basically saying fix me fix me!!!!!!

so they very first thing you do is go to tools>admin and change the passwords you need to change - as soon as you hit update the message should go away since you are no langer on the default pass word set by the system.

LOL - as you know my mom was sick so I wasn't able to log into my local for 6 months now I can't remember how to log into it :frusty:

Any help?

Assuming your local ZC directory is installed under your XAMPP Apache's web root as "store" and you have not changed the "admin" folder, then the login screen is:

http://localhost/store/admin/login.php

Adjust the "store" and "admin" in the above URL according to your local setup.

oops maybe me not clear lol - I can find the login page - I just can't remeber HOW to login - hahahahahaha

Here are 2 articles that could probably help you. :smile:

• https://www.zen-cart.com/tutorials/index.php?article=84
• https://www.zen-cart.com/tutorials/index.php?article=2
  Remember to check via phpMyAdmin whether your tables are prefixed with a 'zen_' or some other words before resetting your admin password.

Once again you are the best -I'm in:clap:

Hi,
I changed my MySQL database password, How can I change the passwords in configure.php files. Please help with this problem. My current verizon is 1.3.7. Thank you.