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

[baddis]

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 May 11, 2008 by baddis

[Jack_mcs]

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

 

Jack

[baddis]

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

[Jack_mcs]

That's not a Links Manager problem. Do a search from google returns these results.

 

Jack

[Clau123]

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.

[Clau123]

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

[Jack_mcs]

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

 

Jack