Linkpoint CC Review Problem

[VS4Hire]

I'm getting the following error:

1054 Unknown column 'lp.customer_id' in 'where clause'
in:
[select count(*) as total from customers c, linkpoint_api lp where lp.customer_id = c.customers_id ]

I've checked my zen database and don't see any tables relating to LP or Linkpoint, yet payments are being processed perfectly...

Thanks!
Michelle

[DrByte]

Which version of Zen Cart ?
Which versions have you upgraded from?
How long have you had the Linkpoint module installed? ie: which version of Zen Cart?
If you write down all your linkpoint module settings, then remove the module, and re-install it, and fill in all your settings again ... does that make the error go away ?

(There are some table-field fixes in the "install" process, which may resolve the matter you're reporting).

[VS4Hire]

Which version of Zen Cart?
1.3.7

Which versions have you upgraded from?
I believe it was previously 1.3.5

How long have you had the Linkpoint module installed? ie: which version of Zen Cart?
From the beginning (again, I believe 1.3.5)

If you write down all your linkpoint module settings, then remove the module, and re-install it, and fill in all your settings again ... does that make the error go away?
I will try that now and let you know.

Michelle

[VS4Hire]

Just deleted the module and re-installed it - no changes.

I know I'm missing the lp.XXX tables - just not sure why or how to add them...

Is there a manual install of the linkpoint module that I can grab the SQL file from?

Thanks!
Michelle

[DrByte]

Is there a manual install of the linkpoint module that I can grab the SQL file from?

The SQL portion is built-in to the "Install" process of the module.

[VS4Hire]

I guess what I meant was - is there somewhere else (besides my installation files) where I can go to download a new copy of the module?

Reason I ask this is because the cc_review file in question seems to be the only file that has lp.* in it - also can't find it in a SQL file.

Thanks!
Michelle