Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

[Contribution] Links Manager for osC v1.00


VJ

Recommended Posts

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

"I must admit that I personally measure success in terms of the contributions an individual makes to her or his fellow human beings."

---Margaret Mead---

 

"The answer is never the answer. What's really interesting is the mystery. If you seek the mystery instead of the answer, you'll always be seeking. I've never seen anybody really find the answer -- they think they have, so they stop thinking. But the job is to seek mystery, evoke mystery, plant a garden in which strange plants grow and mysteries bloom. The need for mystery is greater than the need for an answer.

--Ken Kesey"

Link to comment
Share on other sites

  • Replies 1.1k
  • Created
  • Last Reply

Top Posters In This Topic

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

Support Links:

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

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

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>

Link to comment
Share on other sites

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...

Link to comment
Share on other sites

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!

Link to comment
Share on other sites

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

"I must admit that I personally measure success in terms of the contributions an individual makes to her or his fellow human beings."

---Margaret Mead---

 

"The answer is never the answer. What's really interesting is the mystery. If you seek the mystery instead of the answer, you'll always be seeking. I've never seen anybody really find the answer -- they think they have, so they stop thinking. But the job is to seek mystery, evoke mystery, plant a garden in which strange plants grow and mysteries bloom. The need for mystery is greater than the need for an answer.

--Ken Kesey"

Link to comment
Share on other sites

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!

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Support Links:

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

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

  • 2 weeks later...

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

Diego

Link to comment
Share on other sites

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

Support Links:

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

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

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!

Diego

Link to comment
Share on other sites

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

 

Jack

Support Links:

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

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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 ?

currently using OSC2.2MS2 051113 with the following contributions:

 

AJAX Attributemanager 2.1 - All_products 4.4 - Banner manager 1.5b - banner hack picture in manager * description in product listing hack ms2 v2.4 * drop shadow boxes v.1.1 * Easy populater 2.76d-ms2 by surfalot * FCKEditor * header tag controller v2.5.9 * jcssmenu * LoginBox 5.6 * option type feature v1.71 * OSC-Cach-v1.1 * popup_imagecleaned_stilized_2 * Remove from cart button hack * scrolling bestsellers * Article manager1.4 * Links Manager v1.14. * proffessional invoice&packingslip 6.1 * Ultimate SEO URLs

Personaly i think all these features NEED to be in the main core as they are quite basic features that are missing. but then again what do i know?

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Support Links:

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

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

linkitrj4.jpg

 

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 by aapinen
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...