Results 1 to 8 of 8
  1. #1
    Join Date
    May 2005
    Posts
    8
    Plugin Contributions
    0

    Default Admin Login error:1146 Table 'vmgad_store.linkpoint_api' doesn't exist

    Hello

    Zen Cart: 1.3.9h
    is a new installation with the test information.

    The site itself is working but trying to enter Admin Area receive an error: "1146 Table 'vmgad_store.linkpoint_api' doesn't exist"

    Never show the screen to ask for a passw.

    Any ideas??

  2. #2
    Join Date
    Nov 2004
    Location
    Norfolk, United Kingdom
    Posts
    3,036
    Plugin Contributions
    2

    Default Re: Admin Login error:1146 Table 'vmgad_store.linkpoint_api' doesn't exist

    Access your db via phpMyAdmin and check to see if the table is there.

    Vger

  3. #3
    Join Date
    May 2005
    Posts
    8
    Plugin Contributions
    0

    Default Re: Admin Login error:1146 Table 'vmgad_store.linkpoint_api' doesn't exist

    Nope is not there.

    Do you know how it looks? :)

  4. #4
    Join Date
    Nov 2004
    Location
    Norfolk, United Kingdom
    Posts
    3,036
    Plugin Contributions
    2

    Default Re: Admin Login error:1146 Table 'vmgad_store.linkpoint_api' doesn't exist

    No, that table is created when LinkPoint is activated in your Zen Cart admin panel.

    Vger

  5. #5
    Join Date
    May 2005
    Posts
    8
    Plugin Contributions
    0

    Default Re: Admin Login error:1146 Table 'vmgad_store.linkpoint_api' doesn't exist

    That's the strange part because I when I go to admin it goes directly to that problem. Never ask me for the user or passw.

    Probably need to reinstall.

    Thanks

  6. #6
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Admin Login error:1146 Table 'vmgad_store.linkpoint_api' doesn't exist

    I cannot see what is triggering the error, off the top of my head ...

    I have tried installing FirstDate/LinkPoint/YourPay and deleting the database table linkpoint_api but cannot produce an error that prevents me from getting to the Admin ...

    You can create the table fresh ... but it might be a good idea to try to see what is causing the error ...

    Is there more to the error message than you have posted?

    Do you see any debug logs in the /cache directory?



    To try to work around the problem ... after you have really tried to figure out what is happening that you cannot even get into the Admin ... backup your database ... then run the following SQL in your phpMyAdmin SQL area:
    Code:
    CREATE TABLE linkpoint_api (
                      id int(11) unsigned NOT NULL auto_increment,
                      customer_id varchar(11) NOT NULL default '',
                      lp_trans_num varchar(64) NOT NULL default '',
                      order_id int(11) NOT NULL default '0',
                      avs_response varchar(4) NOT NULL default '',
                      r_error varchar(250) NOT NULL default '',
                      approval_code varchar(254) NOT NULL default '',
                      transaction_result varchar(25) NOT NULL default '',
                      message text NOT NULL,
                      transaction_response_time varchar(25) NOT NULL default '',
                      transaction_time varchar(50) NOT NULL default '',
                      transaction_reference_number varchar(64) NOT NULL default '',
                      fraud_score int(11) NOT NULL default '0',
                      cc_number varchar(20) NOT NULL default '',
                      cc_expire varchar(12) NOT NULL default '',
                      ordertype varchar(8) NOT NULL default '',
                      cust_info text,
                      chargetotal decimal(15,4) NOT NULL default '0.0000',
                      date_added datetime NOT NULL default '0001-01-01 00:00:00',
                      PRIMARY KEY  (id),
                      KEY idx_customer_id_zen (customer_id)     )
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  7. #7
    Join Date
    Nov 2004
    Location
    Norfolk, United Kingdom
    Posts
    3,036
    Plugin Contributions
    2

    Default Re: Admin Login error:1146 Table 'vmgad_store.linkpoint_api' doesn't exist

    It's just a suspicion but I think that resolving that one problem will result in another one showing up.

    Vger

  8. #8
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Admin Login error:1146 Table 'vmgad_store.linkpoint_api' doesn't exist

    I have to agree with Vger, as I said finding the cause of the problem is the best solution ...

    One thing you should consider, as this is a new install with the demo data, you might try removing everything from the server, getting a clean download of the current version of Zen Cart from our Home page and empty your database that you used for Zen Cart and start fresh ...
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

 

 

Similar Threads

  1. v139h SQL Error 1146 Table TABLE_CUSTOMERS_ADMIN_NOTES doesn't exist
    By utefan in forum General Questions
    Replies: 4
    Last Post: 3 Mar 2016, 07:45 PM
  2. v139d Error message -- #1146 - Table 'classyca_poscheap.admin' doesn't exist
    By wwwursa in forum Customization from the Admin
    Replies: 1
    Last Post: 8 Sep 2013, 06:12 PM
  3. v151 upgrading error 1146 table doesn't exist
    By scottrdj in forum Upgrading to 1.5.x
    Replies: 4
    Last Post: 31 Dec 2012, 03:05 PM
  4. MYSQL error #1146 table doesn't exist - help!
    By TheKenster in forum Installing on a Linux/Unix Server
    Replies: 1
    Last Post: 20 Jan 2012, 01:48 PM
  5. 1146 Table error zenconfiguration doesn't exist
    By gayelston in forum Installing on a Linux/Unix Server
    Replies: 6
    Last Post: 1 Dec 2007, 10:26 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
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR