Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

1054 - Unknown column 'lf.links_all_pages' in 'where clause'


baddis

Recommended Posts

I install link manager II V 1.18 but I get the following error please help I have no clue what's wrong

 

 

1054 - Unknown column 'lf.links_all_pages' in 'where clause'

 

select l.links_id, l.links_url, l.links_image_url, ld.links_title, ld.links_description, lf.expires_date from links l, links_description ld, links_featured lf where l.links_id = ld.links_id AND ld.links_id = lf.links_id AND lf.links_all_pages = '1' and (ld.language_id = '1' or ld.language_id = 99) AND lf.expires_date >= now() order by RAND()

 

 

http://cellularisit.com/newstore/links.php

Edited by baddis
Link to comment
Share on other sites

It most likely means you didn't run the database setup file.

 

Jack

 

 

I ran database setup but now I get this error

 

 

Fatal error: Cannot redeclare do_magic_quotes_gpc() (previously declared in /home/cellular/public_html/newstore/includes/functions/compatibility.php:18) in /home/cellular/public_html/newstore/includes/functions/compatibility.php on line 18

Link to comment
Share on other sites

  • 6 months later...
I install link manager II V 1.18 but I get the following error please help I have no clue what's wrong

 

 

1054 - Unknown column 'lf.links_all_pages' in 'where clause'

 

select l.links_id, l.links_url, l.links_image_url, ld.links_title, ld.links_description, lf.expires_date from links l, links_description ld, links_featured lf where l.links_id = ld.links_id AND ld.links_id = lf.links_id AND lf.links_all_pages = '1' and (ld.language_id = '1' or ld.language_id = 99) AND lf.expires_date >= now() order by RAND()

 

 

http://cellularisit.com/newstore/links.php

I have the same error after installing version 1.19 of 24-11-08. And I did run de links_setup.php succesful. I'm on mysql 5 en php 5, I think it has something to do with that. But the tric I normally do is not working this time. I tried version 1.20, thought it would change something, but it is not.

Link to comment
Share on other sites

In the database I have not links_all_pages under any of the link tables.

I saw in admin/links_featured.php :

 

$linkShow_query = tep_db_query("SELECT lf.links_all_pages FROM " . TABLE_LINKS_FEATURED . " lf, " . TABLE_LINKS_DESCRIPTION . " ld where lf.links_id = ld.links_id");

 

But I have links_all_pages not in my TABLE_LINKS_FEATURED nor in my TABLE_LINKS_DESCRIPTION

Link to comment
Share on other sites

The fixed has been posted in the support thread. Please always post contribution specific questions in the support thread for that contribution.

 

Jack

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

All of My Addons

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...