Printable View
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.Quote:
Originally Posted by 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
"
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 :smile: - invaluable tool.Quote:
Originally Posted by 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?
It may be a PayPal setup issue. Did PayPal payments appear in your admin before installing this "payment" option?
also not getting redirected, getting error here at process2_checkout.php
main_page=checkout_payment&error_message=MODULE_PAYMENT_2CHECKOUT_TEXT_ERROR_HAS H_MESSAGE
yes, if I use only paypal as payment method , they do appear, but if payment si made via 2co, there is error, no redirect no checkout success confirmation nor the orders in my admin
everything was working fine till recently I had to change servers, and zencart got messed up, I had to reinstall everything,
now just successfully re installed 2co but getting this error, i can see that I have made payment in my paypal, but the orders do not appear in my admin, also i do not get redirected, yet the payment is made.
Check your 2co module for file merging errors - use WinMerge or even better Beyond Compare.Quote:
Originally Posted by maria82g
Pls note - I do not answer openly accessible questions by PM.
I know!I just PMed to notify that I asked the question in this thread, I never asked you any question via PM :) I just said I have another issue and I have posted in this thread :) i thought since you were online, I could get this resolved quickly :)Quote:
Originally Posted by frank18
I giveup! :*( I can't do it :(:no:
I downloaded better compare, compared all the 4 files, everything is same!
any other ideas? :(
The text IN_ALL_UPPER_CASE is indicative that the module hasn't been fully/correctly installed.Quote:
Originally Posted by maria82g
Common causes are the files have been uploaded to the admin folder rather than the main folder (or vice verci), or the files have been placed in a folder literally called "CUSTOM" rather than the foldername of the template being used.
There are other possible causes too, but those are the most common.
Cheers
RodG
I figured out that when I use the option of "give my links" in 2co for redirect, the checkout is successful, works fine, takes me to confirmation and thank you page perfectly, order gets listed in admin section, cart gets updated..
I uploaded zip folder in my zencart folder, and extracted, it appears all files moved to where they were supposed to , I have checked them so many times that I have memorized the tree of all 3 folders and one file went in the main zencart folder "process2_checkout.php" I am clearly missing something and for the life of me I cannot figure out what! meanwhile I will have to do with this option, I guess , at least it is working, thank you everyone for your support! zen community rocks! many thanks to Frank esp :)
So is it "fully" functional or are you still having to do something special/unique to use just a part of it's original intent? Ie, problem solved, or just getting by with something?Quote:
Originally Posted by maria82g
just getting by with something, the problem not yet solved, :( I have tried everything , I would love a redirect but if this option works well
then I am ok with it :)
Quote:
Originally Posted by maria82g
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.Quote:
Originally Posted by deri3
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.
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.
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).Quote:
Originally Posted by DrByte
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