Problems Logging Into Admin

[trevorjdaniel]

Hi There,

I was wondering if anyone could help me please?

I have a Zen Cart install that has fallen over and a friend has asked me to look at it.

Basically, when someone hits the homepage the following error occurs:

1054 Unknown column 'c.parent_id' in 'on clause'
in:
[SELECT c.categories_id as id, c.parent_id, cd.categories_name as cName, cd2.categories_name as pName FROM categories c, categories_description cd LEFT JOIN categories_description cd2 ON c.parent_id=cd2.categories_id AND cd2.language_id='1' WHERE c.categories_id=cd.categories_id AND cd.language_id='1']

I googled this problem and it looks initially like it could be something to do with SEO URLs and the suggested fix is reset the URL cache.

So, I logged into the admin side of the shop and was presented with the admin front page with no problem. BUT, whenever i click on any link in the admin page it asks me to log in again!

So, i basically cant get to any admin functions. i just keep getting logged out and when i log in all i can get to is the admin front page.

Can anyone help please?

Thanks

Trev

[trevorjdaniel]

Just a quick update.

I have fixed the problem with the SEO URLS module by amending the sql in one of the files as suggested in another thread - great!

But the admin area still won't let me stay logged in.

I have also now tried adding php_value session.auto_start 0 into the .htaccess file at the root level but when i do that the server falls over with and internal 500 error.

Can anyone help please?

Thanks

Trev

[stevesh]

Have you seen these?:

https://www.zen-cart.com/tutorials/i...hp?article=281
https://www.zen-cart.com/tutorials/index.php?article=84

[rich phitzwell]

I have been racking my brain on this one for the better part of a couple of days. In my admin config I have enabled ssl, I have verified ssl is working on my domain. but now when i go to my admin page this pops up instead of the fields for logging in.

This is a fresh install, all that I have done is enable ssl and remove the blank lines at the end of both config files. I have checked line one and there are no blank spaces. I have gone through the file permissions in the tutorial and set everything to where it should be. I have been using notepad and saving as UTF-8. We have a shared ssl, but it works fine with https://www.mydomain.com. any thoughts?



Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /home/content/a/n/d/xxxx/html/eandl/cart/admin/includes/configure.php:1) in /home/content/a/n/d/xxx/html/eandl/cart/includes/functions/sessions.php on line 108

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/content/a/n/d/xxxx/html/eandl/cart/admin/includes/configure.php:1) in /home/content/a/n/d/xxx/html/eandl/cart/includes/functions/sessions.php on line 108

Warning: Cannot modify header information - headers already sent by (output started at /home/content/a/n/d/xxxx/html/eandl/cart/admin/includes/configure.php:1) in /home/content/a/n/d/xxx/html/eandl/cart/admin/includes/init_includes/init_templates.php on line 36

Warning: Cannot modify header information - headers already sent by (output started at /home/content/a/n/d/xxx/html/eandl/cart/admin/includes/configure.php:1) in /home/content/a/n/d/xxxx/html/eandl/cart/admin/includes/functions/general.php on line 21

[rich phitzwell]

I should mention that if I put in https://www.mydomain/zencart/admin/login.php I get the login screen with these errors

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/content/a/n/d/xxxx/html/xxxx/cart/admin/includes/configure.php:1) in /home/content/a/n/d/xxxx/html/xxxx/cart/includes/functions/sessions.php on line 108

Warning: Cannot modify header information - headers already sent by (output started at /home/content/a/n/d/xxx/html/xxx/cart/admin/includes/configure.php:1) in /home/content/a/n/d/xxxx/html/xxx/cart/admin/includes/init_includes/init_templates.php on line 36

Then it actually does log me in but I have to erase anything after /admin/ to get into the admin section. But it is showing up as https://....

Sorry, trying to be as clear as possible.

[rich phitzwell]

OK, Im a dumbass and its been written here before. My editor caused all the issues. Im not sure if I accidentally opened it in my editor or just straight from notepad but I went ahead and did a fresh install and downloaded crimson editor. took care of all the warnings.

Do not use dreamweaver or frontpage or .... any of these editors to edit php ever!

[kiddo]

Properly set up, Dreamweaver is a terrific PHP editor.

[rich phitzwell]

It may be, but ive found many times that most pages work fine but specific pages causes issues such as the configure pages. I honestly dont get it but it has caught me more than one time. I would love to know how your setting up dreamweaver for these pages though.