Author Topic: Cannot install PayPal patch  (Read 6092 times)

Lockheed

  • Beginner
  • *
  • Posts: 27
Cannot install PayPal patch
« on: March 19, 2010, 13:26:16 pm »
I am following this guide: http://www.b-planet.com/VirtueMart/paypal-patch.html
but get stuck at "Create the database Table using the create_temporary_order_table.sql script included in the downloaded zip file."

My virtuemart with its Joomla installation is located in the /shop/ subfolder of my website based on another joomla instance installed in the root folder.

I uploaded and unpacked the scrip in the /shop/ folder but from there, I can go nowhere.
I login to PHPmyAdmin and in the SQL tab I am trying to run
Code: [Select]
mysql <\shop\create_temporary_order_table.sqlor
Code: [Select]
mysql create_temporary_order_table.sqlor many other combinations, but every time I am getting
Code: [Select]
#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 'mysql <\shop\create_temporary_order_table.sql' at line 1
Can somebody help me with this, please?

stinga

  • Contributing Developer
  • Full Member
  • *
  • Posts: 872
    • Squangle ltd
Re: Cannot install PayPal patch
« Reply #1 on: March 19, 2010, 13:56:23 pm »
What is the mysql statement that is causing the problem?
Stinga.
614869 products in 747 categories with 15749 products in 1 category.
                                             Document Complete   Fully Loaded
                Load Time First Byte Start Render   Time      Requests      Time      Requests
First View     2.470s     0.635s     1.276s          2.470s       31            2.470s      31
Repeat View  1.064s     0.561s     1.100s          1.064s       4             1.221s       4

Lockheed

  • Beginner
  • *
  • Posts: 27
Re: Cannot install PayPal patch
« Reply #2 on: March 19, 2010, 13:57:55 pm »
What is the mysql statement that is causing the problem?
I am not sure what do you mean. I gave all the details I can think of in my initial post.

Lockheed

  • Beginner
  • *
  • Posts: 27
Re: Cannot install PayPal patch
« Reply #3 on: March 20, 2010, 14:13:12 pm »
Anyone?

stinga

  • Contributing Developer
  • Full Member
  • *
  • Posts: 872
    • Squangle ltd
Re: Cannot install PayPal patch
« Reply #4 on: March 20, 2010, 15:44:12 pm »
G'day,

No you haven't.

You have given us the name of the script that is executed.
mysql will show you the statement that is failing.
Some of the line in error will be on the end of the error msg, you posted, which has been cut off.
Stinga.
614869 products in 747 categories with 15749 products in 1 category.
                                             Document Complete   Fully Loaded
                Load Time First Byte Start Render   Time      Requests      Time      Requests
First View     2.470s     0.635s     1.276s          2.470s       31            2.470s      31
Repeat View  1.064s     0.561s     1.100s          1.064s       4             1.221s       4

Lockheed

  • Beginner
  • *
  • Posts: 27
Re: Cannot install PayPal patch
« Reply #5 on: March 20, 2010, 16:49:43 pm »
Well, I do not think the problem is with the script but the way I am trying to execute it. I have no idea how to do it and I mostly guessed, probably wrongly.

Therefore, I think the solution is proper command I need to input into SQL tab of phpMyadmin, but I have no idea how it should look, given virtuemart installation of joomla is in a subdirectory.

stinga

  • Contributing Developer
  • Full Member
  • *
  • Posts: 872
    • Squangle ltd
Re: Cannot install PayPal patch
« Reply #6 on: March 20, 2010, 17:28:39 pm »
Ah!,

I think I know what the problem is... you need to tell mysql what database to use.
What is you database called? Then you need.

mysql db_name <create_temporary_order_table.sql

You are telling mysql that the name of the database to connect to is create_temporary_order_table.sql

Or you can connect to your DB with
mysql
mysql> use DB_NAME
mysql> \. create_temporary_order_table.sql
mysql> exit
Stinga.
614869 products in 747 categories with 15749 products in 1 category.
                                             Document Complete   Fully Loaded
                Load Time First Byte Start Render   Time      Requests      Time      Requests
First View     2.470s     0.635s     1.276s          2.470s       31            2.470s      31
Repeat View  1.064s     0.561s     1.100s          1.064s       4             1.221s       4

Lockheed

  • Beginner
  • *
  • Posts: 27
Re: Cannot install PayPal patch
« Reply #7 on: March 20, 2010, 19:10:34 pm »
Thank you. This is the output of this command:

#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 'mysql zzz033_shop <create_temporary_order_table.sql' at line 1
mysql zzz033_shop < create_temporary_order_table.sql

stinga

  • Contributing Developer
  • Full Member
  • *
  • Posts: 872
    • Squangle ltd
Re: Cannot install PayPal patch
« Reply #8 on: March 20, 2010, 19:43:48 pm »
G'day,

Are you on a linux host? How are you connecting to mysql?

On a linux host, you would enter mysql, you might need a username and password.
It looks like you are already in mysql.
Stinga.
614869 products in 747 categories with 15749 products in 1 category.
                                             Document Complete   Fully Loaded
                Load Time First Byte Start Render   Time      Requests      Time      Requests
First View     2.470s     0.635s     1.276s          2.470s       31            2.470s      31
Repeat View  1.064s     0.561s     1.100s          1.064s       4             1.221s       4

Lockheed

  • Beginner
  • *
  • Posts: 27
Re: Cannot install PayPal patch
« Reply #9 on: March 20, 2010, 21:34:16 pm »
I am using phpMyAdmin from cpanel, tab named SQL.

stinga

  • Contributing Developer
  • Full Member
  • *
  • Posts: 872
    • Squangle ltd
Re: Cannot install PayPal patch
« Reply #10 on: March 21, 2010, 10:47:35 am »
G'day,

Oh! I am not so hot on cpanel, I am more a 'get your hands dirty at the OS' type of hacker :-)

If you are using cpanel you won't be able to use the script, that was designed to be run from a command prompt.
Open the .sql file you have in your favorite editor an cat-n-paste the commands out of it and paste them into phpadmin. That should work.
Stinga.
614869 products in 747 categories with 15749 products in 1 category.
                                             Document Complete   Fully Loaded
                Load Time First Byte Start Render   Time      Requests      Time      Requests
First View     2.470s     0.635s     1.276s          2.470s       31            2.470s      31
Repeat View  1.064s     0.561s     1.100s          1.064s       4             1.221s       4