when I click "install" for 2checkout, I get error message

[maria82g]

when i try to install 2checkout payment module
I get a blank page saying "WARNING: An Error occurred, please refresh the page and try again."
i tried uploading fresh copy 5 times, cleared browser cache, same probs
Zen Cart v1.5.1/v1.5.0
help please!

[frank18]

when i try to install 2checkout payment module
I get a blank page saying "WARNING: An Error occurred, please refresh the page and try again."
i tried uploading fresh copy 5 times, cleared browser cache, same probs
Zen Cart v1.5.1/v1.5.0
help please!

Did you check your /logs folder? You may find a clue there.

[maria82g]

this is the log


"[21-Mar-2014 20:49:37 UTC] PHP Fatal error: 1050:Table '2checkout' already exists :: CREATE TABLE 2checkout (
`2co_id` int(11) NOT NULL auto_increment,
`start_time` datetime NOT NULL default '0000-00-00 00:00:00',
`finish_time` datetime NOT NULL default '0000-00-00 00:00:00',
`status` varchar(50) collate latin1_general_ci NOT NULL default '',
`amount` float NOT NULL default '0',
`2co_order_id` int(11) NOT NULL default '0',
`session_id` varchar(50) collate latin1_general_ci NOT NULL default '',
PRIMARY KEY (`2co_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci; in /hermes/bosoraweb188/b1526/ipg.mgdezignscom/printables/includes/classes/db/mysql/query_factory.php on line 120
"

[maria82g]

ok got it! deleted the table, was able to install! working now!!
Note: always check error log!
Thanks!!!!!!!!!!!1

[frank18]

ok got it! deleted the table, was able to install! working now!!
Note: always check error log!
Thanks!!!!!!!!!!!1

Yep, the error log is the best thing in ZC since sliced bread - invaluable tool.

[maria82g]

sorry to bug you again but now I am not having any error code, in fact after successful purchase (i did 3 test purchase) i see payment in my paypal, i get emails from my zencart and 2co but the orders do not appear in my admin?

[deri3]

this is the log


"[21-Mar-2014 20:49:37 UTC] PHP Fatal error: 1050:Table '2checkout' already exists :: CREATE TABLE 2checkout (
`2co_id` int(11) NOT NULL auto_increment,
`start_time` datetime NOT NULL default '0000-00-00 00:00:00',
`finish_time` datetime NOT NULL default '0000-00-00 00:00:00',
`status` varchar(50) collate latin1_general_ci NOT NULL default '',
`amount` float NOT NULL default '0',
`2co_order_id` int(11) NOT NULL default '0',
`session_id` varchar(50) collate latin1_general_ci NOT NULL default '',
PRIMARY KEY (`2co_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci; in /hermes/bosoraweb188/b1526/ipg.mgdezignscom/printables/includes/classes/db/mysql/query_factory.php on line 120
"

Please provide me with details on how you fixed this issue, I'm having the same problem with installing another payment gateway called 'simple pay'. I do not know what table to delete and where to delete it from. Please help, I'm not very good with PHP and coding in general.

[DrByte]

Please provide me with details on how you fixed this issue, I'm having the same problem with installing another payment gateway called 'simple pay'. I do not know what table to delete and where to delete it from. Please help, I'm not very good with PHP and coding in general.

It's VERY DANGEROUS for me to tell you this, because this will DELETE any data already in the table, which means it could delete important history if you've been using the module previously. So, YOU HAVE BEEN WARNED.

If the error says "Fatal error: 1050:Table '2checkout' already exists " then the tablename is "2checkout", so you would go into phpMyAdmin, find the table named "2checkout" and check the box next to it, and choose "drop" from the menu. Or you could click the "SQL" tab and type "DROP TABLE 2checkout;" and click Go. The table will be instantly gone, WITH NO WAY TO GET ITS DATA BACK.
Then you can proceed with installing the module again.

[mc12345678]

Why not in the install "script" just skip that line/section instead of potentially deleting the entire table?

I don't know if the command to create the table is in a file or pasted into the install sql patches.

Worst case, if going to go into phpmyadmin and look around, then could see if the table is setup to be equivalent or better than what is necessary.

[RodG]

It's VERY DANGEROUS for me to tell you this, because this will DELETE any data already in the table, which means it could delete important history if you've been using the module previously. So, YOU HAVE BEEN WARNED.

If the error says "Fatal error: 1050:Table '2checkout' already exists " then the tablename is "2checkout", so you would go into phpMyAdmin, find the table named "2checkout" and check the box next to it, and choose "drop" from the menu. Or you could click the "SQL" tab and type "DROP TABLE 2checkout;" and click Go. The table will be instantly gone, WITH NO WAY TO GET ITS DATA BACK.
Then you can proceed with installing the module again.

FWIW, if/when I'm ever in this situation I'll *never* delete the table. I simply rename it. This way, after the install script has done its job without error it is usually a matter of copying the data from the renamed table to the newly created table (assuming that there is data that needs to be recovered).

This method also avoids the need for MC12345678's suggestion to edit any scripts to 'skip' the line that is trying to insert the duplicate table... AND it allows comparison between the old and new table structures for any differences.
Just my 2cents worth.

Cheers
RodG