DirectOne / Secure Pay module - 1146 error

[lrrsa]

I have tried to install the ?DirectOne / Secure Pay? module (of 6 April 2006) but receive the following error message:

? 1146 ? Table ?lrrsa.orders? doesn?t exist

SELECT^ FROM orders LIMIT 1

[TEP STOP] ?

 

I have Googled this error message and got this response ? with my comments inside the square brackets:

 

?If you get the following error; ? then you have added a mod that requires a database update and have not either;

 

1. Ran a db update script (if one is supplied with the mod)

[none was supplied, and I don't think one was needed]

2. Not updated the database with the SQL instructions from the install text file

[none were provided and I don't think any were needed]

3. Installed the mod with EasyMod, EM does not execute SQL queries (at the time of posting this). [i do not know what EasyMod is, to install the module I clicked the ?INSTALL? button in osCommerce, as I would to install any other payment module]?

 

Does anyone have any clues as to what might be wrong?

 

Any help or clues would be gratefully appreciated.

[SimonPockley]

I have tried to install the ?DirectOne / Secure Pay? module (of 6 April 2006) but receive the following error message:

? 1146 ? Table ?lrrsa.orders? doesn?t exist

SELECT^ FROM orders LIMIT 1

[TEP STOP] ?

 

I have Googled this error message and got this response ? with my comments inside the square brackets:

 

?If you get the following error; ? then you have added a mod that requires a database update and have not either;

 

1. Ran a db update script (if one is supplied with the mod)

[none was supplied, and I don't think one was needed]

2. Not updated the database with the SQL instructions from the install text file

[none were provided and I don't think any were needed]

3. Installed the mod with EasyMod, EM does not execute SQL queries (at the time of posting this). [i do not know what EasyMod is, to install the module I clicked the ?INSTALL? button in osCommerce, as I would to install any other payment module]?

 

Does anyone have any clues as to what might be wrong?

 

Any help or clues would be gratefully appreciated.

[SimonPockley]

I don't have an answer for your problem but maybe you can help me install directone.

 

Using FileZilla I've uploaded the single directone.php file to 2 locations:

 

1. /includes/languages/english/modules/payment/

2. /includes/modules/payment/

 

When I relaod and open the paymet modules section of osCommerce

 

/modules.php?set=payment&selected_box=modules

 

I can't see directone (I can see other options)

 

Do you know how I can actually install directone?

[Guest]

the error means the orders table is not present. It tries to access it during install. Check with phpmyadmin if the orders table exists.

[lrrsa]

I don't have an answer for your problem but maybe you can help me install directone.

 

Using FileZilla I've uploaded the single directone.php file to 2 locations:

 

1. /includes/languages/english/modules/payment/

2. /includes/modules/payment/

 

When I relaod and open the paymet modules section of osCommerce

 

/modules.php?set=payment&selected_box=modules

 

I can't see directone (I can see other options)

 

Do you know how I can actually install directone?

[lrrsa]

Hello Simon,

 

But there are two files called "directone.php", one - in the languages sub-directory is of 1 kb in size; the other is of 13 kb in size. My guess is that you have put the 1 kb file in two locations, instead of putting the 13 kb file in the payment modules directory.

 

Regards,

 

Frank