getting this error

5 replies [Last post]

Sat, 12/22/2007 - 12:07

spike

Offline

Joined: 12/21/2007

Juice: 15

user warning: Unknown column 'fp.fpid' in 'on clause' query: SELECT fp.*, user.purchase_date FROM uc_file_products AS fp LEFT JOIN uc_file_product_users AS user ON fp.fpid = user.fpid WHERE user.uid = 1 ORDER BY fp.filename in /xxx/xxxx/xxxx/includes/database.mysql.inc on line 172.

this is what I see after coming back from PP and go to the myfiles link.
everything up to this point is working great. I did some research in the forums but didn't find a direct connection to this error.
thanks

Sat, 12/22/2007 - 20:25

#1 View page

torgosPizza

Offline

Joined: 08/14/2007

Juice: 4110

Re: getting this error

Did you install the File Product module? (uc_file)

If you did it looks like the uc_file table needs to be created. Perhaps uninstalling and reinstalling uc_file would help, if you've already installed it once.

--
Help directly fund development: Donate via PayPal!

Sat, 12/22/2007 - 20:38

#2 View page

spike

Offline

Joined: 12/21/2007

Juice: 15

well I think I did hehe, as I read more and more I think maybe I have gotten off the correct track as to what should or needs to be installed. I looked over a couple of your posts but being this is all new to me and the fact that I am at the age where the brain don't work good "LOL" I could have missed something. now if I understand the install correct under /modules/ubercart I need to make a new dir called extra is this correct so far? than I place the unziped file contents in the extra dir. I just checked and the zip file I have in fact is uc_file_product-1.7.4 and from a post that you made I remember you stating to make sure that was the most current.
Sorry this is starting to read like a best seller so I need to stop here and let you respond.
spike
ps

thanks for the VERY nice reply and if we don't link back up I hope you have a GREAT Holiday and and very good 2008.
one last question why are you so happy in the picture? LOL

Sat, 12/22/2007 - 21:44

#3 View page

spike

Offline

Joined: 12/21/2007

Juice: 15

new twist now

well I as per your advice did a reinstall and now all my payments from PP are coming back as Pending? I guess I just don't understand the flow here and why do we have to review 11 to 15 screens for setup? I can't help but think their is a much better way or at least one that don't require 20 screens of setup. Think I will have a look at Ecommerce perhaps that will do the same with less issues.

Mon, 12/24/2007 - 10:23

#4 View page

Shawn Conn

Offline

Joined: 08/07/2007

Juice: 916

Re: new twist now

Just to clarify Spike, do you have the uc_file and uc_file_product module enabled? uc_file_product was a module for digital products prior to alpha 8. It has since been depreciated in favor the built-in ubercart module uc_file. You only need uc_file enabled. If you have both modules enabled, you're sure to run into problems (as I think is the case for you).

-Shawn Conn: If the Name Don't Rhyme It Ain't Mine

Tue, 12/25/2007 - 17:12

#5 View page

torgosPizza

Offline

Joined: 08/14/2007

Juice: 4110

Re: Re: new twist now

Argh, yes, I meant "File Downloads" - sorry for the confusion. That's the uc_file module found in core, not the Contrib.

To answer your question I'm happy in that pic because I was at a great metal show and I got to meet the guys from the band afterwards. Cool dudes!

--
Help directly fund development: Donate via PayPal!

Ubercart

Navigation

User login