OSCOMMERCE SUPPORT CALL 702-453-3332

 

Help - Search - Members - Calendar
Full Version: insert moneybookers_SQL" file into database
osCommerce Community Support Forums > osCommerce Online Merchant v2.x > Contributions / Add-Ons > Payment Modules > Other
uphere
I am a 2 day veteran of osCommerce it installed without the slightest problem. I do have a slight problem with the moneybookers osCommerce Payment Module v1.2

Step 9:



Backup your database then, insert the included "moneybookers_SQL" file into your database.

I do not have a lot of experience with MYSQL I not sure how to do this

Can someone please help?

Thanks
uphere
QUOTE (uphere @ Aug 2 2007, 08:33 PM) *
I am a 2 day veteran of osCommerce it installed without the slightest problem. I do have a slight problem with the moneybookers osCommerce Payment Module v1.2

Step 9:
Backup your database then, insert the included "moneybookers_SQL" file into your database.

I do not have a lot of experience with MYSQL I not sure how to do this

Can someone please help?

Thanks

I figured out how to do it using phpMyAdmin. Click on the database then sql and drag the code or upload it.

Now I have an 1064 error: crying.gif
CODE
Error

SQL-query :

CREATE TABLE moneybookers(
mb_moneybookers_id int( 11 ) NOT NULL AUTO_INCREMENT ,
mb_orders_id int( 11 ) default NULL ,
mb_customers_id int( 11 ) default NULL ,
mb_date_ordered varchar( 255 ) default NULL ,
mb_pay_to_email varchar( 255 ) default NULL ,
mb_pay_from_email varchar( 255 ) default NULL ,
mb_merchant_id varchar( 255 ) default NULL ,
mb_tranaction_id varchar( 40 ) default NULL ,
mb_mbtranaction_id varchar( 255 ) default NULL ,
mb_mbamount varchar( 255 ) default NULL ,
mb_mbcurrency varchar( 255 ) default NULL ,
mb_status varchar( 255 ) default NULL ,
mb_md5sig varchar( 255 ) default NULL ,
mb_oscmd5 varchar( 40 ) default NULL ,
mb_amount varchar( 255 ) default NULL ,
mb_currency varchar( 255 ) default NULL ,
mb_curlerror varchar( 255 ) default NULL ,
PRIMARY KEY ( mb_moneybookers_id )
)ENGINE = MYISAM DEFAULT CHARSET = latin1

MySQL said:
#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 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 20


My host uses MYSQL 4.0.17 and php 4.3.9

there seems to be issues with the last line
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2008 Invision Power Services, Inc.