Forums / Managing Customers and Orders / I am getting a error on my main_page=checkout_process please help

I am getting a error on my main_page=checkout_process please help

Views: 2,658

Results 1 to 15 of 15
3 Jan 2013, 7:17 AM
#1
brevardcountypcr avatar

brevardcountypcr

New Zenner

Join Date:
Nov 2011
Posts:
67
Plugin Contributions:
0

I am getting a error on my main_page=checkout_process please help

I am getting a error on my main_page=checkout_process please help WARNING: An Error occurred, please refresh the page and try again.

3 Jan 2013, 8:40 AM
#3
design75 avatar

design75

Totally Zenned

Join Date:
Dec 2009
Location:
Amersfoort, The Netherlands
Posts:
2,862
Plugin Contributions:
5

Re: I am getting a error on my main_page=checkout_process please help

check your cache / log folder for errorlogs, and also fill in the posting tips above. without those it is impossible to help

3 Jan 2013, 8:42 AM
#4
brevardcountypcr avatar

brevardcountypcr

New Zenner

Join Date:
Nov 2011
Posts:
67
Plugin Contributions:
0

Re: I am getting a error on my main_page=checkout_process please help

Design75:

check your cache / log folder for errorlogs, and also fill in the posting tips above. without those it is impossible to help

where would I find that in my admin account ??

3 Jan 2013, 8:52 AM
#5
design75 avatar

design75

Totally Zenned

Join Date:
Dec 2009
Location:
Amersfoort, The Netherlands
Posts:
2,862
Plugin Contributions:
5

Re: I am getting a error on my main_page=checkout_process please help

you don't.
The folders for the error logs can be found in your file structure, accessed through ftp, or cpanel.

The posting tips are right above the window for coposing a new message

3 Jan 2013, 9:07 AM
#6
brevardcountypcr avatar

brevardcountypcr

New Zenner

Join Date:
Nov 2011
Posts:
67
Plugin Contributions:
0

Re: I am getting a error on my main_page=checkout_process please help

Design75:

you don't.
The folders for the error logs can be found in your file structure, accessed through ftp, or cpanel.

The posting tips are right above the window for coposing a new message
[03-Jan-2013 00:04:12] PHP Warning: implode() [<a href='function.implode'>function.implode</a>]: Invalid arguments passed in /home/brevard1/public_html/store/includes/modules/payment/usaepay_api.php on line 244
[03-Jan-2013 00:04:12] PHP Fatal error: 1146:Table 'brevard1_zencart1.usaepay_api' doesn't exist :: insert into usaepay_api (id, customer_id, order_id, result_code, auth_code,
ref_num, batch, avs_result, cvv2_result, error,
error_code, curl_error, acs_url, pareq, reason)
values ('', '2',
'1', 'A',
'02396Z', '398311257', '1',
'Address: Match & 5 Digit Zip: Match', 'Match', 'Approved',
'00000', '', '',
'', 'Approved') in /home/brevard1/public_html/store/includes/classes/db/mysql/query_factory.php on line 101
03-Jan-2013 00:04:18] PHP Warning: implode() [<a href='function.implode'>function.implode</a>]: Invalid arguments passed in /home/brevard1/public_html/store/includes/modules/payment/usaepay_api.php on line 244
[03-Jan-2013 00:04:18] PHP Fatal error: 1146:Table 'brevard1_zencart1.usaepay_api' doesn't exist :: insert into usaepay_api (id, customer_id, order_id, result_code, auth_code,
ref_num, batch, avs_result, cvv2_result, error,
error_code, curl_error, acs_url, pareq, reason)
values ('', '2',
'1', 'A',
'02575Z', '398311265', '1',
'Address: Match & 5 Digit Zip: Match', 'Match', 'Approved',
'00000', '', '',
'', 'Approved') in /home/brevard1/public_html/store/includes/classes/db/mysql/query_factory.php on line 101
[03-Jan-2013 00:05:32] PHP Warning: implode() [<a href='function.implode'>function.implode</a>]: Invalid arguments passed in /home/brevard1/public_html/store/includes/modules/payment/usaepay_api.php on line 244
[03-Jan-2013 00:05:32] PHP Fatal error: 1146:Table 'brevard1_zencart1.usaepay_api' doesn't exist :: insert into usaepay_api (id, customer_id, order_id, result_code, auth_code,
ref_num, batch, avs_result, cvv2_result, error,
error_code, curl_error, acs_url, pareq, reason)
values ('', '2',
'1', 'A',
'05990Z', '398311449', '1',
'Address: Match & 5 Digit Zip: Match', 'Match', 'Approved',
'00000', '', '',
'', 'Approved') in /home/brevard1/public_html/store/includes/classes/db/mysql/query_factory.php on line 101
[03-Jan-2013 00:05:32] PHP Warning: implode() [<a href='function.implode'>function.implode</a>]: Invalid arguments passed in /home/brevard1/public_html/store/includes/modules/payment/usaepay_api.php on line 244
[03-Jan-2013 00:05:32] PHP Fatal error: 1146:Table 'brevard1_zencart1.usaepay_api' doesn't exist :: insert into usaepay_api (id, customer_id, order_id, result_code, auth_code,
ref_num, batch, avs_result, cvv2_result, error,
error_code, curl_error, acs_url, pareq, reason)
values ('', '2',
'1', 'A',
'05990Z', '398311449', '1',
'Address: Match & 5 Digit Zip: Match', 'Match', 'Approved',
'00000', '', '',
'', 'Approved') in /home/brevard1/public_html/store/includes/classes/db/mysql/query_factory.php on line 101
checkout_process.php is there but I am getting that warning. I look at this in my admin folder.

3 Jan 2013, 9:24 AM
#7
design75 avatar

design75

Totally Zenned

Join Date:
Dec 2009
Location:
Amersfoort, The Netherlands
Posts:
2,862
Plugin Contributions:
5

Re: I am getting a error on my main_page=checkout_process please help

looks like you have a you have a payment module called usaepay , that is giving the error. Check if you installed all the files, and to the right places.
Was there an sql file you needed to run? beacaus the table "usaepay_api" does not exist.

3 Jan 2013, 9:38 AM
#8
brevardcountypcr avatar

brevardcountypcr

New Zenner

Join Date:
Nov 2011
Posts:
67
Plugin Contributions:
0

Re: I am getting a error on my main_page=checkout_process please help

Design75:

looks like you have a you have a payment module called usaepay , that is giving the error. Check if you installed all the files, and to the right places.
Was there an sql file you needed to run? beacaus the table "usaepay_api" does not exist.
I did it give me errors every time i try to run the sql file for it when I try to import it to my php admin . I put the files in the regular store folder. but the checkout_process is not going through.

3 Jan 2013, 9:42 AM
#9
design75 avatar

design75

Totally Zenned

Join Date:
Dec 2009
Location:
Amersfoort, The Netherlands
Posts:
2,862
Plugin Contributions:
5

Re: I am getting a error on my main_page=checkout_process please help

So the sql never installed?? if true this explains why the module is not working

what was the exact error message on the sql?

3 Jan 2013, 9:49 AM
#10
brevardcountypcr avatar

brevardcountypcr

New Zenner

Join Date:
Nov 2011
Posts:
67
Plugin Contributions:
0

Re: I am getting a error on my main_page=checkout_process please help

Design75:

So the sql never installed?? if true this explains why the module is not working

what was the exact error message on the sql?
ok I go to my zencart database in my php admin. then I go to import.
then it says #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM AUTO_INCREMENT=1' at line 18
CREATE TABLE usaepay_api (
id int( 11 ) unsigned NOT NULL AUTO_INCREMENT ,
customer_id int( 11 ) NOT NULL default '0',
order_id int( 11 ) NOT NULL default '0',
result_code varchar( 50 ) NOT NULL default '0',
auth_code varchar( 50 ) default NULL ,
ref_num varchar( 100 ) default NULL ,
batch varchar( 50 ) NOT NULL default '0',
avs_result varchar( 50 ) NOT NULL default '0',
cvv2_result varchar( 50 ) NOT NULL default '0',
error varchar( 50 ) NOT NULL default '0',
error_code varchar( 50 ) NOT NULL default '0',
curl_error varchar( 50 ) NOT NULL default '0',
acs_url varchar( 50 ) NOT NULL default '0',
pareq varchar( 50 ) NOT NULL default '0',
reason varchar( 50 ) NOT NULL default '0',
UNIQUE KEY id ( id )
) TYPE = MYISAM AUTO_INCREMENT =1;

now what it not working.
I get the same error as my customer does when doing the checkout process after put in the credit card number

3 Jan 2013, 9:58 AM
#11
design75 avatar

design75

Totally Zenned

Join Date:
Dec 2009
Location:
Amersfoort, The Netherlands
Posts:
2,862
Plugin Contributions:
5

Re: I am getting a error on my main_page=checkout_process please help

open the sql file in something like notepad or notepad++

on the last line, change TYPE = MYISAM to ENGINE = MYISAM

save the file, and try again to install.

3 Jan 2013, 10:09 AM
#12
brevardcountypcr avatar

brevardcountypcr

New Zenner

Join Date:
Nov 2011
Posts:
67
Plugin Contributions:
0

Re: I am getting a error on my main_page=checkout_process please help

Design75:

open the sql file in something like notepad or notepad++

on the last line, change TYPE = MYISAM to ENGINE = MYISAM

save the file, and try again to install.

I am still getting the error

3 Jan 2013, 10:17 AM
#13
design75 avatar

design75

Totally Zenned

Join Date:
Dec 2009
Location:
Amersfoort, The Netherlands
Posts:
2,862
Plugin Contributions:
5

Re: I am getting a error on my main_page=checkout_process please help

the sql error? in that case i do not know right now what goes wrong, because if I run your sql with the change all is well

3 Jan 2013, 10:32 AM
#14
brevardcountypcr avatar

brevardcountypcr

New Zenner

Join Date:
Nov 2011
Posts:
67
Plugin Contributions:
0

Re: I am getting a error on my main_page=checkout_process please help

Design75:

the sql error? in that case i do not know right now what goes wrong, because if I run your sql with the change all is well

I download it from the usaepay site . you think it corrupted

3 Jan 2013, 10:42 AM
#15
brevardcountypcr avatar

brevardcountypcr

New Zenner

Join Date:
Nov 2011
Posts:
67
Plugin Contributions:
0

Re: I am getting a error on my main_page=checkout_process please help

or you think I should get the latest zen cart