Zen Cart Logo
Forums / Installing on a Linux/Unix Server / Admin Login error:1146 Table 'vmgad_store.linkpoint_api' doesn't exist

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

Views: 1,278

Results 1 to 8 of 8
9 Dec 2010, 5:00 PM
#1
martinsure avatar

martinsure

New Zenner

Join Date:
May 2005
Posts:
8
Plugin Contributions:
0

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??

9 Dec 2010, 6:21 PM
#2
vger avatar

vger

Past Contributor

Join Date:
Nov 2004
Location:
Norfolk, United Kingdom
Posts:
3,189
Plugin Contributions:
0

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

9 Dec 2010, 10:42 PM
#3
martinsure avatar

martinsure

New Zenner

Join Date:
May 2005
Posts:
8
Plugin Contributions:
0

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

Nope is not there.

Do you know how it looks? :)

9 Dec 2010, 11:23 PM
#4
vger avatar

vger

Past Contributor

Join Date:
Nov 2004
Location:
Norfolk, United Kingdom
Posts:
3,189
Plugin Contributions:
0

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

9 Dec 2010, 11:55 PM
#5
martinsure avatar

martinsure

New Zenner

Join Date:
May 2005
Posts:
8
Plugin Contributions:
0

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

10 Dec 2010, 12:20 AM
#6
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

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:

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)     )
10 Dec 2010, 12:55 PM
#7
vger avatar

vger

Past Contributor

Join Date:
Nov 2004
Location:
Norfolk, United Kingdom
Posts:
3,189
Plugin Contributions:
0

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

10 Dec 2010, 2:56 PM
#8
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

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 ...