| View previous topic :: View next topic |
| Author |
Message |
aubade63
Joined: 01 Feb 2008
Posts: 8
|
 Posted: Fri Feb 01, 2008 3:18 pm
Post subject: A probleme with paypal .. |
|
|
I have a probleme with the payment by paypal.
Paypal say to me that it is good but user is time left.
This is my C:\Program Files\FirstSpot\log\txn.txt
Friday 01st of February 2008 03:57:11 PM - invoice number not found
payment_date = 06:57:01 Feb 01, 2008 PST
txn_type = web_accept
last_name = ROY
residence_country = FR
item_name = Plan pas cher
payment_gross =
mc_currency = EUR
business = anne.lebel@gl-events.com
payment_type = instant
verify_sign = A7SOPN055SzlgQzwYDr7U1N5RC1rAWV5sGFKsfbJ2bKt8Fv-hMJU7o9-
payer_status = unverified
tax = 0.00
payer_email = eric.roy@gl-events.com
txn_id = 4XG902910G835593V
quantity = 1
receiver_email = anne.lebel@gl-events.com
first_name = Eric
payer_id = 96AYH63Y4HZNJ
receiver_id = PVMG6W9C9P3FU
item_number =
payment_status = Completed
payment_fee =
mc_fee = 0.28
shipping = 0.00
mc_gross = 1.00
custom = -1|rt|Plan pas cher !
charset = windows-1252
notify_version = 2.4
Be able to use me? Please |
|
| Back to top |
|
 |
alan
Forum facilitator
Joined: 26 Sep 2003
Posts: 4435
|
|
| Back to top |
|
|
dominic
Forum facilitator
Joined: 23 Oct 2007
Posts: 103
|
Posted: Mon Feb 04, 2008 4:53 am
Post subject: |
|
|
| Moreover, we suspect the problem relates to your database. Do you use FirstSpot's default one or build up another yourself? Can you check if the corresponding transaction record is shown under the Credit Cards tab in Configuration Manager? |
|
| Back to top |
|
|
aubade63
Joined: 01 Feb 2008
Posts: 8
|
Posted: Tue Feb 05, 2008 9:00 am
Post subject: |
|
|
When i see "Credits Cards"/"Show logs", there is nothing !
Would like to see itself a file particularly? |
|
| Back to top |
|
|
dominic
Forum facilitator
Joined: 23 Oct 2007
Posts: 103
|
Posted: Tue Feb 05, 2008 9:32 am
Post subject: |
|
|
Which version of FirstSpot are you using?
Do you use the default database or build up another yourself?
Please export the table ppal in Users tab and check if there's entry shown in FirstSpot\ccdata.csv. |
|
| Back to top |
|
|
aubade63
Joined: 01 Feb 2008
Posts: 8
|
Posted: Tue Feb 05, 2008 9:55 am
Post subject: |
|
|
Which version of FirstSpot are you using?
This is FirstSpot v5.0.0 Advanced Edition
Do you use the default database or build up another yourself?
I think i use the default database
Please export the table ppal in Users tab and check if there's entry shown in FirstSpot\ccdata.csv.
My Creditcardlog is :
DATE,USER,STATUS,PLAN,AMT,QTY,ITEM NAME,METHOD
Jan-01 01:00,,,,,,, |
|
| Back to top |
|
|
dominic
Forum facilitator
Joined: 23 Oct 2007
Posts: 103
|
Posted: Tue Feb 05, 2008 11:19 am
Post subject: |
|
|
This issue will happen when importing a .csv file which was exported from a blank database table.
Please perform the following steps to clear the table PPAL manually and test again:
1) Shut down FirstSpot
2) Copy the files ppal.dbf and ppal.mdx from the original installation zip file
3) Paste the two files in FirstSpot\datasource |
|
| Back to top |
|
|
aubade63
Joined: 01 Feb 2008
Posts: 8
|
Posted: Tue Feb 05, 2008 2:22 pm
Post subject: |
|
|
This is the same but i can read this message when i redirect to paypal :
Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][Pilote ODBC dBase] Type de données incompatible dans l'expression du critère., SQL state 22005 in SQLExecDirect in C:\Program Files\FirstSpot\cfgmgr\db_access.php on line 42
Warning: odbc_exec(): 6 is not a valid ODBC-Link resource in C:\Program Files\FirstSpot\cfgmgr\db_access.php on line 42
Warning: odbc_close(): 6 is not a valid ODBC-Link resource in C:\Program Files\FirstSpot\cfgmgr\db_access.php on line 56
Warning: odbc_exec(): 6 is not a valid ODBC-Link resource in C:\Program Files\FirstSpot\cfgmgr\db_access.php on line 42
Warning: odbc_fetch_row(): supplied argument is not a valid ODBC result resource in C:\Program Files\FirstSpot\local\transaction.php on line 325 |
|
| Back to top |
|
|
dominic
Forum facilitator
Joined: 23 Oct 2007
Posts: 103
|
Posted: Wed Feb 06, 2008 4:41 am
Post subject: |
|
|
From the error messages, it seems that there's problem with the ODBC connection parameter when FirstSpot inserts record into the table PPAL. However, we are unable to reproduce this error in our lab.
You may try the following ways to see if the same error occurs:
1) Reboot the machine after the database files update and perform Paypal test
2) Re-install FirstSpot and perform Paypal test without importing any .csv files
At the same time, could you also provide the following information for us to simulate your case?
1) Windows type together with SP version
2) Microsoft dBase Driver (*.dbf) version and date (can be found in Control Panel->Administrative Tools->Data Sources (ODBC)->Drivers) |
|
| Back to top |
|
|
dominic
Forum facilitator
Joined: 23 Oct 2007
Posts: 103
|
Posted: Wed Feb 06, 2008 6:08 am
Post subject: |
|
|
We've just produced similar errors and suspect the reason for your case is similar to this one:
http://www.patronsoft.com/forum/viewtopic.php?t=2077
So, before trying to reinstall FirstSpot, please follow the above link to update the three PHP files. Then, restart FirstSpot and perform PayPal test again. |
|
| Back to top |
|
|
aubade63
Joined: 01 Feb 2008
Posts: 8
|
|
| Back to top |
|
|
dominic
Forum facilitator
Joined: 23 Oct 2007
Posts: 103
|
Posted: Wed Feb 06, 2008 2:33 pm
Post subject: |
|
|
| Could you further describe what's meant by "nothing"? |
|
| Back to top |
|
|
|
Search
Profile
Log in
Register
