Zen Cart Logo
Forums / All Other Contributions/Addons / Got an error w/ install.sql and now not sure what to do next..?

Got an error w/ install.sql and now not sure what to do next..?

Views: 599

Results 1 to 4 of 4
14 Jan 2013, 10:21 PM
#1
tcarden avatar

tcarden

Zen Follower

Join Date:
Oct 2012
Posts:
282
Plugin Contributions:
0

Got an error w/ install.sql and now not sure what to do next..?

Hey everyone, thanks for all the help so far, really appreciate it.

Im trying to install Fast & Easy checkout plugin by Numinix.
I pasted the entire contents of install.sql into the 'Install SQL Patches'.

i think this line (sorry i should have saved);

INSERT IGNORE INTO admin_pages (page_key,language_key,main_page,page_params,menu_key,display_on_menu,sort_order) VALUES .....

i got an error - 'admin_pages' doesnt exist.

trying to decide what to do next?

  1. run the uninstall.php
  2. reset the DB to how it was before, i have a backup somewhere
  3. continue the installation
15 Jan 2013, 12:24 AM
#2
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: Got an error w/ install.sql and now not sure what to do next..?

admin_pages is the name of the database table without any prefix. If your store is using a prefix, then you'll need to manually add the prefix if you're using phpMyAdmin to run the SQL query.

15 Jan 2013, 3:37 PM
#3
tcarden avatar

tcarden

Zen Follower

Join Date:
Oct 2012
Posts:
282
Plugin Contributions:
0

Re: Got an error w/ install.sql and now not sure what to do next..?

Dr. Bytes, thanks for answering my post,
that occurred to me and i did look for that but it's not there. on my test site the table names have a prefix of zen_

but there is no zen_admin_pages, there is zen_admin but that stores admin user info.

also checked for zen_pages but that doesn't exist either,...uggg.

15 Jan 2013, 3:40 PM
#4
tcarden avatar

tcarden

Zen Follower

Join Date:
Oct 2012
Posts:
282
Plugin Contributions:
0

Re: Got an error w/ install.sql and now not sure what to do next..?

i just looked on the 'real' site i'm doing this for and i do see that table, so i'm not sure why the test doesn't have it, weird, i'm pretty they are the same version of ZC