logging in issues?

[gamblegarage]

Sorry guys, bear with me. First issue is I can't navigate this site to save my life. No idea where my control panel is for keeping track of my threads.

 

 

So I did my entire website over a month ago and can't remember the log in for the life of me. Finally had some time to play tonight and can't figure it out. Been searching for awhile.

 

using godaddy for hosting so I was able to get into cpanel and my site/admin and i can't log in. I searched and searched and tried to truncate the tables via phpmyadmin but still can't log in. At no point does it ask me to setup a new name/pw. And I not supposed to use mysite.com/admin or from some other place?

 

I'm about at the point where I am thinking about calling godaddy and having them wipe everything on my domain so i can start from scratch. I don't want to as i'm going to lose hours of work but again i'm losing hours of time because i can't log in. And If  I do there is there a way to back up all the stuff i've put into my site so far?

 

I'm already gotten quotes from other people to build my site, but it's pretty far out of my reach. Plus I have a few of them to do and this is still my first one :(

[Dan Cole]

And I not supposed to use mysite.com/admin or from some other place?

 

@@gamblegarage

 

Paul, I haven't had to truncate my password table but from the many posts I've read on the subject I think you need to try and login (doing exactly what you were told not to do) and you will be asked to set up a user and password.   If that doesn't work post back with whatever error messages you receive and I'm sure someone will be able to help you out.

 

Dan

[MrPhil]

No idea where my control panel is for keeping track of my threads.

 

Sign in. Click on your name at the upper right. Click on "My Content" in the drop-down menu. You will see your posts.

[gamblegarage]

Thank you both.

This is the error I get when trying to log in from the index.php page

 

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator at [email protected] to inform them of the time this error occurred, and the actions you performed just before this error.

More information about this error may be available in the server error log.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

[Dan Cole]

@@gamblegarage @@MrPhil

 

Sorry but this doesn't sound like a osC login issue...looks more like a server issue to me.   Phil seems to have a good grasp on those matters so hopefully he'll have some suggestions for you.

 

Dan

[MrPhil]

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

All sorts of things could have gone wrong. If you can otherwise use your site, it's probably not an error in your .htaccess or php.ini files. Is this a regular user login or admin login that you're talking about? They could have separate .htaccess files. Otherwise, maybe there's an error in login.php or some related file, such as a blank line at the beginning or end. Did you edit anything since the last time it worked? Check the "last modified" dates (timestamps) on all files, to see if a hacker has modified a file lately without your permission.

 

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

Ignore this one. It means that you don't have an error page for this one (e.g., /500.shtml).

[Bob Terveuren]

Hi

Maybe try this:

 

go to your cPanel -> File Manager , navigate down to the /admin/ folder (or whatever name yours has) and look for a .htaccess file in there - rename that to something like .htaccessold and see what happens.

 

If you no longer get the 500 error then you'll maybe find that the htaccess/htpasswd combo has got screwed

[gamblegarage]

This is the error if I change the .htacess file name. How can I restore to say a month or so ago and see if I can log in?

 

 

1146 - Table 'i1257413_osco1.administrators' doesn't exist

select id from administrators limit 1

[TEP STOP]

 

 

Mr Phil, i didn't edit anything since i created it. Story is basically my son was in the hospital so I stayed with him for a week and had some time to do my site so i did and then haven't touched until until recently and once I got home I can't log in anymore. Go figure now that I have time to do it lol

[gamblegarage]

Also under phpmyadmin, under osco1 I don't have anything that says administrators. 

It was there the other day.

[BrockleyJohn]

@@gamblegarage, my guess is you dropped the administrators table when you intended to empty it. If you were running osCommerce 2.3.4 then this sql will put it back:

CREATE TABLE administrators (
  id int NOT NULL auto_increment,
  user_name varchar(255) binary NOT NULL,
  user_password varchar(60) NOT NULL,
  PRIMARY KEY (id)
) CHARACTER SET utf8 COLLATE utf8_unicode_ci;

run through the sql tab in phpMyAdmin, once you're viewing the database and have a list of the remaining tables down the left hand side.

 

There are lots of other tables left, aren't there?

 

If you didn't already drop it, you should get a 'table already exists' error.

[BrockleyJohn]

Alternatively, goDaddy may be taking regular backups of your webspace. You can contact support there and see if they can help you restore it.

[MrPhil]

Note that most hosts will charge you a fee to restore files or databases, if you're the one who messed them up. They'll restore for free only if there was a system-wide failure of some sort. Let this be a lesson to do your own backups, and download and store them offsite (on your PC). Also learn how to inspect a backup to see if it looks complete, and once in a while, practice restoring both database and file backups so you will know how to do it when (not if) the time comes for real!

[gamblegarage]

Speaking with Godaddy about this, they do NOT backup databases that are not their online store. So i am responsible to do my own

 

So I still can't log in. 

I'm thinking can i back up the remaining databases such as my products, and info, then 'format' everything on my domain, reinstall oscommerce so i get a new name/pw and then restore my products and the other info i've already added?

[gamblegarage]

So I just realized there is a back up that was created, now i have no idea if it was as soon as my stuff was installed or after i set everything up, but it's worth a shot.

So i downloaded the administrators.php and when i try to import it from phpmyadmin I get this error

 

Error

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unknown Punctuation String @ 1
STR: <?
SQL: <?php
/*
$Id$

osCommerce, Open Source E-Commerce Solutions
http://www.osc'at line 1 

[BrockleyJohn]

administrators.php isn't a a backup of the administrators table, it's one of the admin pages (for setting up administrators).

 

If you have any backups created from within osCommerce, they'll be in the folder [catalog]/admin/backups and there'll be a single file for all the tables in the database at a certain time. They don't happen by themselves though, you'll have had to do something to put them there.

 

So, if we're going to try to help you rescue what's left of the work you did, we need to start by taking a backup of what's still there, before you delete any more of it! This applies to both the database and the file store so we keep your product images. However, since your install is shot, we'll have to do the database backup through phpmyadmin.

 

First go back into phpmyadmin, and check that you're looking at your osCommerce database: you should see quite a long list of tables down the left. At the top of this list, above the input field but below the buttons for phpMyAdmin, you should see the name of the database followed by a number in brackets which on a normal osC 2.3.4 database would read (50) - it's the number of tables. What does yours say?

 

If you don't also have a list of the tables in the right-hand side of the window, click on the line I was just talking about - this will select the database and will open up the structure tab on the right with another list of the tables.

 

Now click the Export tab at the top,

- check that all the tables are selected in the left half of this page

- check that on the right, the Structure box has a tick, and inside there should be ticks next to Add IF NOT EXISTS, Add AUTO_INCREMENT value, and Enclose table and field names in backquotes

- check that on the right, the Data box also has a tick and inside there are ticks for Complete inserts, Extended inserts, and that Export type is set to INSERT

- make sure there's a tick in the Save as file box at the bottom too, the settings inside it don't matter too much 

Press Go and it'll save a backup of what's left of your data to your computer

 

Report how you got on and how many tables there are, and we'll let you know what to do next. Good luck!

[MrPhil]

So i downloaded the administrators.php and when i try to import it from phpmyadmin I get this error

 

 

Of course you got an error! phpMyAdmin "import" needs an ".sql" type file (a sequence of SQL commands), not PHP code. A backup will be either .sql or some sort of compressed SQL (e.g., .sql.tgz). If you have absolutely no idea of what you're doing, STOP immediately before you do any more damage to your site, and hire someone to fix it for you. If they can. If you're very lucky, all you did was erase (drop) the one table, and that can be rebuilt (as suggested) without too much strain.

 

By the way, if just renaming .htaccess changed your error message from "internal error" to "Table ____ doesn't exist", that suggests multiple problems. At the least, your .htaccess has errors in it, plus something happened to the table (in the database).

[gamblegarage]

I tried, most people want $1500-$5k. So if i can manage to do it myself and save money, that's the plan. I'm going to see if I can format the drive and start from scratch

[BrockleyJohn]

A word or two to the wise... apart from the obvious stuff you've already learnt like keeping a note of your password somewhere safe, there are some things you should do as soon as you've installed osCommerce and before spending too much time setting up your store.

 

If you downloaded it yourself, you'll have two folders called catalog and docs and in the latter a big pdf 'documentation'

 

If you installed from a hosting control panel, you might have the docs folder - or not. If not, download the whole package including the docs from here http://www.oscommerce.com/Products

 

Pay attention to the Post-Installation Steps in the doc - these basically take you through getting rid of all the warning messages that come up in your admin panel after installing.

 

Then go further down and learn how to make a backup and how to restore it and check you can do that with your new store. These are only database backups, you also need to learn how to ftp your backup files and the rest of your store (most importantly the images) to somewhere safe - probably your own computer.

 

And then you're ready to go! Just remember to keep backing up...