Results 1 to 2 of 2

new installation admin account doesn't work

This is a discussion on new installation admin account doesn't work within the osCommerce 2.2 Installation Help forums, part of the osCommerce 2.2 Forums category; Admin Account 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL ...

      
  1. #1
    Lurker
    Join Date
    Apr 2010
    Posts
    2
    Rep Power
    0


    Default new installation admin account doesn't work

    Admin Account 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 '' at line 1

    select a.admin_id, a.admin_firstname, a.admin_lastname, a.admin_username, a.admin_email_address, a.admin_created, a.admin_modified, a.admin_logdate, a.admin_lognum, g.admin_groups_name from admin a, admin_groups g where a.admin_id= 1 and g.admin_groups_id=

    I get this message when I try to edit my admin account. when i try to use easy populate it says that I do not have administrative rights. I had problems on installation. When I installed I could not log in with my admin account. I used the work around by creating a password through phpadmin, but now my admin account doesn't work.

    Also I wanted to know if oscmax has done work to secure against script injection hacks. I'm sure you guys have, but how robust is it? Are script injectors part of the reason there is no search tool on this site?
    thanks
    Last edited by djelf7; 04-02-2010 at 06:22 AM.

  2. #2
    Lurker
    Join Date
    Apr 2010
    Posts
    2
    Rep Power
    0


    Default Re: new installation admin account doesn't work

    1. EXTRA INFO REGARDING THIS INSTALL!


      The next page has more options. This is step 2 of the installation. Enter the correct web server information.
    2. If you want to enable SSL, check the checkbox, and confirm that all info is correct. MY NOTE I never got an option to enable SSL
    3. If you are on shared hosting, make sure the "persistent connections" box is unchecked. MY NOTE I never got an option to check or uncheck persistent connections
    4. Choose to store sessions as files or in the database and click continue. MY NOTE I never got this option. After I entered the web server info it just headed straight to the conclusion with catalog and admin tool buttons!!!
    5. You have reached the conclusion of the install script. Before you continue, click each button, "Catalog" and "Administration Tool" to test the install. MY NOTE I clicked on the buttons but they did not take me to the site rather I was taken to www.mydomain.com/catalog//://
      and www.mydomain.com/catalog//://admin respectively, so I keyed in the correct destination in the url bar and I was taken to the store and the admin tool, but lo and behold the username and password below did not work.
    6. Login to the admin panel with the default credentials: email : admin@localhost.com pw: admin This login didn't work, so I used the work around going to phpadmin and copying and pasting an already created user. Leading to the problem which I talk about in the orginal post.

Similar Threads

  1. Admin Panel links do not work
    By gelliinc in forum osCmax v2 Installation issues
    Replies: 2
    Last Post: 05-06-2009, 10:14 AM
  2. Admin password doesn't work
    By jmelson in forum osCmax v2 Installation issues
    Replies: 1
    Last Post: 01-08-2009, 08:02 AM
  3. Admin Login After Installation ???
    By ScaleCreep in forum osCmax v2 Installation issues
    Replies: 2
    Last Post: 04-04-2007, 10:38 PM
  4. Why don't popups work when products are added through Admin?
    By Shadeau in forum osCMax v1.7 Installation
    Replies: 1
    Last Post: 05-28-2005, 12:54 PM
  5. Admin tool will not work?
    By mclaudnic in forum osCommerce 2.2 Installation Help
    Replies: 3
    Last Post: 01-21-2005, 04:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •