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

Started by tcarden on 14 Jan 2013, 10:21 PM · Views: 682

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

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

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