Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

pronane

Archived
  • Posts

    39
  • Joined

  • Last visited

Profile Information

  • Real Name
    PAul

pronane's Achievements

  1. bump pe de bump. still having the same problems above if anyone can help!!
  2. i have/had this problem, where it wouldnt show up paypal but would show up the others. I have done a dodgy hack which now makes it look like the credit card/paypal is being returned even though it isnt, i have manually added it in, because i know thats the only payment method I am using.
  3. when i return from paypal the cart contents are not clearing, the transaction goes through fine and i get the rexeipt email and the transaction goes through. But the contents of the cart are still full. how do i clear them? also the email address populated on the paypal page for the user that is buying the product is the email of the recipient of the payment i.e. me, the store owner. is it possible to get the email address of the user buying the products populated? thanks for any help!! :)
  4. Vger thanks once more for the reply. i have found the problem though, the company hosting the site, had created another db called test and had created a username and password for it, that was fine for me working untill i installed the paypal ipn on the old DB i.e. toolsdirect not test. Once i changed the DB name and password in the config file it pointed at toolsdirect through, and the host has now deleted the DB called test.
  5. define('DB_SERVER_PASSWORD', ''); define('DB_DATABASE', 'osCommerce'); define('USE_PCONNECT', 'false'); define('STORE_SESSIONS', ''); By the way if i change the catalog/includes/local/configure.php to match the above, it brings me to the oscommerce install page. However the file under admin/includes/local/configure.php also includes: define('DB_SERVER', 'mysql.host.ie'); define('DB_SERVER_USERNAME', '*****'); define('DB_SERVER_PASSWORD', '****'); define('DB_DATABASE', 'trojan_test'); define('CONFIGURE_STATUS_COMPLETED', 1); define('USE_PCONNECT', 'false'); define('STORE_SESSIONS', 'mysql'); and if i change trojan_test to trojan_toolsdirect, I get the same error 1046. the database is definately called trojan_toolsdirect though. This is what i cant figure out. Unless my hosting company has created a trojan_test by accident and not told me/i cant see it from phpmyadmin?!?! And because i did all the updates i did for the paypal IPN v3.0 upgrade were done to trojan_toolsdirect. Could that be the problem?!?!
  6. I have been away on holidays so Iam only getting to do this now. Under the file /includes/local/configure.php I have the following: define('DB_SERVER', 'mysql.host.ie'); define('DB_SERVER_USERNAME', '*****'); define('DB_SERVER_PASSWORD', '****'); define('DB_DATABASE', 'trojan_test'); define('CONFIGURE_STATUS_COMPLETED', 1); define('USE_PCONNECT', 'false'); define('STORE_SESSIONS', 'mysql'); If i change trojan_test to trojan_toolsdirect ( which is the DB name ) , I get the following error when I initally try to log on to the catalog: 1046 - No database selected select configuration_key as cfgKey, configuration_value as cfgValue from configuration why is this happening? Because it shouldnt be working for trojan_test as there is no DB called trojan_test! I assume its on this line in the application_top.php page: // set the application parameters $configuration_query = tep_db_query('select configuration_key as cfgKey, configuration_value as cfgValue from ' . TABLE_CONFIGURATION); while ($configuration = tep_db_fetch_array($configuration_query)) { define($configuration['cfgKey'], $configuration['cfgValue']); } any help would be greatly appreciated, by the way i can log onto the admin console and here are the settings for that: define('DB_SERVER', ''); define('DB_SERVER_USERNAME', 'mysql'); define('DB_SERVER_PASSWORD', '');
  7. sorry excuse my ignorance, what do you mean includes/local? catalog/includes/local. I dont beleive that there is a local folder there, but are you saying that in these folders, there are local configuration files for certain pages?!?! Btw after you click the "confirm order" button, what page actually is called, is it checkout_process.php? Because if it is, there is no "insert into" sql statement in that php file.
  8. how come its only one page that is looking in the wrong database though? Does every page have a unique configuration setup?
  9. which configure files should i check? ya i know its not its just i dont know whereits getting trojan_test from, which files should i look up? Thanks for the help!!
  10. ya , i know that its looking in trojan_test, the thing is the database is called trojan_toolsdirect. I dont konw where its getting trojan_test from. I was installing the paypal IPN v3.0 add-on to oscommerce.
  11. I am getting the following order at checkout_process.php insert into orders_session_info (sendto, billto, firstname, lastname, payment, payment_title, payment_amount, payment_currency, payment_currency_val, language, language_id, currency, currency_value, content_type, txn_signature, orders_id) values ('3', '3', 'Paul', 'Ronane', 'paypal', 'PayPal', '64.99', 'EUR', '1.00000000', 'english', '1', 'USD', '1.00000000', 'physical', 'e45f64ade41f8f2ca3bd1d09cd86ab85', '2') the thing is the username isnt trojan_test, its sometihing else, does anyone know wht i need to do to get this working? any help would be much appreciated!! Thanks!
  12. I have spoken with my host about getting DBA access to my database, he says I have all privileges i.e. that I now have DBA access to my database, however when i try to run paypal.sql on my databse I get the following error on the first line: #1142 - ALTER command denied to user 'tooll223'@'zinc.xxxxxx' for table 'orders' the first line of paypal.sql is: ALTER TABLE orders ADD payment_id INT( 11 ) DEFAULT '0' NOT NULL; I also tried it with my databasename like such ALTER TABLE Mydatabase.orders ADD payment_id INT( 11 ) DEFAULT '0' NOT NULL; but i still get the same problem, my hosting company have told me they have given me the DBA priviliges so I just cant figure it out. anyone any ideas?
  13. how did you get the payment optoin to appear? i am having the same problem though i am trying to use it with paypal
  14. pronane

    Paypal not Appearing!!

    i have the exact same problem, it doesnt appear but sometimes by luck you can press continue on the payment options button
  15. i have the exact same problem but its just with paypal and i cant figure itout.
×
×
  • Create New...