[Contribution] Links Manager for osC v1.00

[rabbitseffort]

ellen, be sure you have the file it is telling you it cant find: includes/functions/links.php

[Jack_mcs]

Hi,

I ran into a couple of problems installing 1.14.

First, when I ran the links_setup.php, I got the following error:

 

Fatal error: Cannot redeclare tep_show_category() (previously declared in /home/theli11/public_html/shop/includes/header.php:226) in /home/theli11/public_html/shop/includes/boxes/categories.php on line 13

This is most likely caused by the template you are using. Open the includes/header.php file and change all occurrences of tep_show_category to something else, like tep_show_category_template. It should not give that error then.

 

Jack

[ellemence]

ellen, be sure you have the file it is telling you it cant find: includes/functions/links.php

 

 

Thanks for catching that... I missed that file. Embarrassment lead me to check all my files, and I am pretty sure I am okay now. But when I try to go to links.php, I get this error:

 

Fatal error: Cannot redeclare tep_show_category() (previously declared in /home/theli11/public_html/shop/includes/header.php:226) in /home/theli11/public_html/shop/includes/boxes/categories.php on line 13

 

This error is even more confusing to me. P.S. I am using a template from TemplateMonster, so I am linking like this: <a href=<?=tep_href_link('links.php')?>>

<img src=images/b10.gif width=152 heigth=25 border=0></a>

[ellemence]

Thanks for catching that... I missed that file. Embarrassment lead me to check all my files, and I am pretty sure I am okay now. But when I try to go to links.php, I get this error:

 

Fatal error: Cannot redeclare tep_show_category() (previously declared in /home/theli11/public_html/shop/includes/header.php:226) in /home/theli11/public_html/shop/includes/boxes/categories.php on line 13

 

This error is even more confusing to me. P.S. I am using a template from TemplateMonster, so I am linking like this: <a href=<?=tep_href_link('links.php')?>>

<img src=images/b10.gif width=152 heigth=25 border=0></a>

 

 

Oh, never mind...another contributor also helped by suggesting I rename the tep_show_category to tep_show_category_template. This worked perfectly. Unfortunately, now I can't find the other post to thank the other contributor.

 

I hope I'll get good at this so that I can pass along the great assistance...

[iZilla_Pod]

I just installed Links Manager V. 1.14 on my site. However, when I click on the "Links" link in the information box, a page with this error appears:

 

1146 - Table 'izilla_osc1.link_categories_description' doesn't exist

select link_categories_name from link_categories_description where link_categories_id = '0'

[TEP STOP]

 

Also, when I attempt to open "Links Manager" in the left column of the Admin screen, this error is displayed:

 

1146 - Table 'izilla_osc1.links_status' doesn't exist

select links_status_id, links_status_name from links_status where language_id = '1'

[TEP STOP]

 

By the way, I didn't do the cron jobs thing that was in the readme file because it said it was optional. Can someone please let me know how to fix this problem?

 

Thanks!

[rabbitseffort]

looks like the sql wasnt ran or ran improperly, it is stating you dont have that table--the cron job isnt necessary so that isnt it--it is your database

[iZilla_Pod]

looks like the sql wasnt ran or ran improperly, it is stating you dont have that table--the cron job isnt necessary so that isnt it--it is your database

 

Wow, I completely forgot to run the sql. That fixed it. Thanks for the help!

[DeathAdder]

Notification of a small modification to links_featured.php

 

My web host is using MySql v4.0.25 - The 'ON DUPLICATE KEY UPDATE' Sql syntax is not available in versions of MySql prior to 4.1.0. This version should work with all MySql versions 4.0.25 and higher...

 

2 Changes:

 

Modifications to the SQL query to support older versions of MySql (Versions prior to 4.1.0).

 

Added to the Featured Links drop down, the links Experation date (simple display) next to the name of the featured link.

 

This zip only contains an instructional text file with the required changes. Only one file is changed for this catalogadmininks_featured.php I included this file as well.

 

NOT A COMPLETE PACKAGE

 

http://www.oscommerce.com/community/contributions,1256

 

- DeathAdder

[Jack_mcs]

Please, please , please - Don't uplaod partial packages. This casues so many problems down the road. If you are going to make such changes, regardless of how small, download the last version, make the change and upload it again.

 

Jack

[Guest]

Jack,

 

Sorry bout contacting you directly. I keep forgetting that there is more than one page to a forum. Anyways, I was the guy who mailed you on the error that I was getting from the Links manager V1.14. It gave me this error-

 

 

1146 - Table 'metalart_osstore.TABLE_LINKS_STATUS' doesn't exist

 

select links_status_id, links_status_name from TABLE_LINKS_STATUS where language_id = '1'

 

[TEP STOP]

 

 

I looked at the database directly and it looks like it is there. I am no guru, but its says that the "table_links_status" doesn't exist yet I went in to myphp and looked at it. It's there. So I am kinda scratchin my head on this one. I will continue to look thru the forum for answers, until I hear from you. I did notice that a post said that it is possable that the "links_setup.php" did not run correctly. In that case, should I just drop all the "links" tables and run it again? Or is there a simpler answer? Thanx for any help.

 

Craig.

[Guest]

Jack,

 

Craig here. Just got it working. Not sure what happend or what I did wrong, but when I purged the main database of the "Links" tables and all variables, I checked the code, and the only thing I did wrong was in the addition of the BOX_INFORMATION definitions. I had originaly added them at the end. When I went thru a second time, I moved it to the end of the BOX_ definitions. I also ran the links_db_update.php file. It works fine now. Still scratchin my head, but no matter now. Thanx.

 

Craig.

[motoroma]

I followed all steps, but when I'm clicking over link doesn't show anything. Load header, index, but anothing else.

I read in forums that other persons made the same questions, but I can't found any answer.

 

Please, can anybody help me?

 

my site is http://www.shales.com.ar

 

Do you need more information for yours answers?

 

Thanks!!!

Diego

[Jack_mcs]

Try reloading the links.php file from the contribution. If that doesn't work, try making a copy of the privacy.php file, naming it links.php and uploading it to your site. Does the privacy page display when you go to the links page? If not, there is something wrong with shop. If it does, then there is something wrong in the links manager installation.

 

Jack

[motoroma]

Try reloading the links.php file from the contribution. If that doesn't work, try making a copy of the privacy.php file, naming it links.php and uploading it to your site. Does the privacy page display when you go to the links page? If not, there is something wrong with shop. If it does, then there is something wrong in the links manager installation.

 

Jack

 

Jack,I tried that and I think that the problem is in installation, I rechecked all steps and those are alright. Can be the version of mysql?

 

I believe that one thing is wrong. In admin when I open the "Link Manager" alright is ok, but show the labels like this

 

TABLE_HEADING_TITLE

Asc Desc TABLE_HEADING_URL

Asc Desc TABLE_HEADING_CLICKS

Asc Desc TABLE_HEADING_STATUS

Asc Desc TABLE_HEADING_ACTION

 

Can that be the mistake?

 

thanks very much!

[Jack_mcs]

In the least, that indicates missing definitions in your files. You should fix the obvious problems first. Maybe that will solve the rest.

 

Jack

[Guest]

Links Manager for osC(MS2) v1.13

 

 

Dear profesional

 

i installed the above contribution,

There is some site which want exchange link with me but they do not have link manging program

 

1- How can they enter my data info in thier site ??

2- they r some site offer their data in html code or banner and just to be copied in the other site and a check is made if reallz the code exist or not, is this possible in this contribution

 

 

Please advice

 

regards

amin

[matrix2223]

Hi Jack,

 

I went to add a featured link within the admin, set the date, then clicked on update. I then got this error;

 

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 'ON DUPLICATE KEY UPDATE date_added = now()' at line 1

 

insert into links_featured (links_id, date_added, expires_date) values ('1', now(), '20060930') ON DUPLICATE KEY UPDATE date_added = now()

 

[TEP STOP]

 

Any ideas,

 

Thanks,

 

Eric

[zaxxon]

i posted this question before and nevre had any response to it, maybe it was missed...

the contribution seem to work ok, but still have the warnings alerts, i wonder if any one could have a look a it ??

i installed this contribution and then installed again just to be sure cuz i am getting errors

when in the admin side. this eror from catalog/admin/links.php?links_status_list&search=

was after i added one link which is marked pending these error lines come out when i look at either all or pending links)

 

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in *****\www\catalog\admin\links.php on line 733

Warning: reset() [function.reset]: Passed variable is not an array or object in *****\www\catalog\admin\includes\classes\object_info.php on line 17

Warning: Variable passed to each() is not an array or object in *****\www\catalog\admin\includes\classes\object_info.php on line 18

 

 

after this i thought maybe i am getting this error cuz i submitted a link before i added categories. so i went to phpmyadmin and dropped the links tables.

ran links_setup again and went to the admin to create categories

when i click on the 'new category' button these are the errors that come up (above the header and the page does seem to load fine other wise - though i am not sure)

 

Warning: array_merge() [function.array-merge]: Argument #1 is not an array in *****\www\catalog\admin\link_categories.php on line 111

Warning: reset() [function.reset]: Passed variable is not an array or object in *******\www\catalog\admin\includes\classes\object_info.php on line 17

Warning: Variable passed to each() is not an array or object in *******\www\catalog\admin\includes\classes\object_info.php on line 18

i looked through the code over and over again , and made sure i installed it exactly as described. and it exactly as written. i went on and kept pressing almost ech and every option in links manager to see if any of the functionality is not there, but it seems all is working and even though i get these 3 warnings, when i do add categories it seems to be working fine - but i really dont know cuz i never saw it with out the warnings wink.gif

 

any one have any idea whats gone wrong ?

[bianca]

hi

i installed the application on osc MS2

my friend put my site link in his site as test, then he tried to submit his link

but i got this error :

 

Our link cannot be found on http://www.his website.com

 

we revice together the entry data,

 

- what is the problem

- is it possible for my friend to copy html code contian my info and paste this code in his site?

 

thxxxxx

biki

[sgostelow]

That should work but you will lose many of the new options. If you want to try, find this code in the links.php file (the new one) at line 389:

		case 'LINK_LIST_COUNT':
	  $listing_sql .= "l.links_clicked " . ($sort_order == 'd' ? 'desc' : '') . ", ld.links_title";
	  break;
  }
}

and add this after it:

echo $listing_sql;

That will display some text on your links page. Copy and paste that here and restore the file to the way you want it.

 

Jack

 

We're running CRE Loaded 6.2 Standard and are seeing the problem where the links do not show up when you click on the link category. The category listings gives a link count that is correct, and the links appear correctly in the Admin->Links Manager->Links page. The links page displays the default text "There are no links to list in this category."

 

I've ensured that the link is approved and the language settings are correctly set to English in all relevant admin screens.

 

Below is an SQL dump from the shop demonstrating this problem as requested on post #422 (quoted above):

 

select l.links_image_url, ld.links_title, ld.links_description, l.links_url, l.links_clicked, l.links_id, ld.language_id from links_description ld, links l, links_to_link_categories l2lc where l.links_status = '2' and l.links_id = l2lc.links_id and ld.links_id = l2lc.links_id and l2lc.link_categories_id = '1' and ( ld.language_id = '1' xor ld.language_id = '99') order by ld.links_title

 

You can see it for yourself on our website (due to go live in the next month or so) - see myBoomBox iPod accessories

 

It seems the issue is with the language SQL WHERE clause as the other clauses look OK... any help with this appreciated. Thanks

[sgostelow]

I forgot to mention that I've installed Links Manager v1.14 on CRE Loaded 6.2.

 

Also it's probably better if you look at this link instead myBoomBox web links page as you can see the category counters and then when you click on the category (e.g. iPod Forums & Discussion) it comes back with an empty list.

 

Shaun

[Jack_mcs]

Hi Jack,

 

I went to add a featured link within the admin, set the date, then clicked on update. I then got this error;

 

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 'ON DUPLICATE KEY UPDATE date_added = now()' at line 1

 

insert into links_featured (links_id, date_added, expires_date) values ('1', now(), '20060930') ON DUPLICATE KEY UPDATE date_added = now()

 

[TEP STOP]

 

Any ideas,

 

Thanks,

 

Eric

The fix is on this page.

 

Jack

[sgostelow]

Interestingly, despite the fact that my links within categories do not display I've just added a featured link and that displays with no problem...

[aapinen]

i posted this question before and nevre had any response to it, maybe it was missed...

the contribution seem to work ok, but still have the warnings alerts, i wonder if any one could have a look a it ??

 

I've same problem. If you find a solution please post.

[aapinen]

 

I have this kind of problem. The headers of the links are from wrong part of stylesheet.css.

 

Those headers style is from .productListing-heading instead of .linkListing-heading.

 

How can I customize those headers to fit that table? I dont want to change the .productListing-heading style becouse thats in use in my shopping cart.

 

How could I eg. change that table height in the first line so that those text would fit it?

Edited August 27, 2006 by aapinen