Jack_mcs Posted August 18, 2007 Author Share Posted August 18, 2007 Every update has worked with existing links so there is no reason why you cannot do that. If it were my shop, after making a backup, I would install all of the files as if in a new install, overwriting your existing files. Then run the links_db_update.php file. That will update your Links settings without doing any damage. The last step would be to figure out what is missing with the tables associated with the links. The easiest way would be to export the data (not the structure) for all of your link manager tables, then delete them all of those tables, run the new sql, then upload the data sql file you created. I'm pretty sure all of that will work. Otherwise, you will need to go through the updates one at a time. Jack Quote 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 More sharing options...
c_engine Posted August 20, 2007 Share Posted August 20, 2007 How do i connect this ver son of Link Manager to SEO URL. Many Thanks Quote Link to comment Share on other sites More sharing options...
webvision Posted August 20, 2007 Share Posted August 20, 2007 Can someone please guide me in the right direction? I'm trying to display more then 1 featured link in /includes/boxes/links.php When i add one more line like the following code. it just displays the same link twice: $info_box_contents[] = array('align' => 'center', 'text' => '<a href="' . $link['links_url'] . '" target="_' . $openMode . '">' . $link['links_title'] . '</a><br>' . '<a href="' . $link['links_url'] . '" target="_' . $openMode . '">' . $link['links_title'] . '</a><br>'); I want it to display 10 different featured or regular links.. whichever is easier to do. Thank you Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted August 20, 2007 Author Share Posted August 20, 2007 How do i connect this ver son of Link Manager to SEO URL. Many Thanks You need to make a change to the Ulimate SEO file. There was a version of that in the contribution section but it was removed for some reason. There is a thread here somewhere with the code you need. You should use google to seach for it: site:www.oscommerce.com/forums Ultimate SEO Links Manager Jack Quote 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 More sharing options...
Jack_mcs Posted August 20, 2007 Author Share Posted August 20, 2007 Can someone please guide me in the right direction? I'm trying to display more then 1 featured link in /includes/boxes/links.php When i add one more line like the following code. it just displays the same link twice: $info_box_contents[] = array('align' => 'center', 'text' => '<a href="' . $link['links_url'] . '" target="_' . $openMode . '">' . $link['links_title'] . '</a><br>' . '<a href="' . $link['links_url'] . '" target="_' . $openMode . '">' . $link['links_title'] . '</a><br>'); I want it to display 10 different featured or regular links.. whichever is easier to do. Thank you The code in the box only selects one link at a time. You will need to change this statement$link = tep_db_fetch_array($link_featured_query); to while($link = tep_db_fetch_array($link_featured_query)) and then enclose the code below it in {}. The result code should look something like while($link = tep_db_fetch_array($link_featured_query)) { $info_box_contents = array(); $info_box_contents[] = array('align' => 'center', 'text' => '<a href="' . $link['links_url'] . '" target="_' . $openMode . '"><img src="' . $link['links_image_url'] . '"</a><br>' . $link['links_title']); } Jack Quote 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 More sharing options...
webvision Posted August 20, 2007 Share Posted August 20, 2007 thank you for that. It worked for other people that want to do this, here's the whole code for /includes/boxes/links.php <!-- links.php //--> <tr> <td> <?php $info_box_contents = array(); $info_box_contents[] = array('text' => BOX_HEADING_LINKS); new infoBoxHeading($info_box_contents, false, false, tep_href_link(FILENAME_LINKS)); while($link = tep_db_fetch_array($link_featured_query)) { $info_box_contents = array(); $info_box_contents[] = array('align' => 'center', 'text' => '<a href="' . $link['links_url'] . '" target="_' . $openMode . '">' . $link['links_title'] . '</a><br>'); new infoBox($info_box_contents); } ?> </td> </tr> <!-- links.php_eof //--> Quote Link to comment Share on other sites More sharing options...
blafrog Posted August 23, 2007 Share Posted August 23, 2007 How to remove or not display ?parentid=0 in the url? eg. http://mysite.com/xxxxx-links-1.html?parentid=0 thanks for any help. Quote Link to comment Share on other sites More sharing options...
Curly Posted August 29, 2007 Share Posted August 29, 2007 I just installed this contribution, and I can add categories and links in the admin part, but the links are not showing up on my site. I looked through the forum and did the following things: - Language of the links is set to all - I have added dutch to the languages in links.php (language id 5) - I changed LINKS_DISPLAY_SPANISH to LINKS_DISPLAY_DUTCH and set it to true in the admin configuration - Both English and Dutch languages are set to true But regardless of these things I gtried, the links are still not showing up. The link count si also still showing 0. Any thoughts abotu what could be the problem? Do I need to change anything else to be able to use and extra language. Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted August 29, 2007 Author Share Posted August 29, 2007 If you have english installed, do the links show up for it? Jack Quote 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 More sharing options...
Curly Posted August 30, 2007 Share Posted August 30, 2007 No, the links don't even show up when I change the language to English. When I do a search for links I can get my links to show, but when I click them I get redirected to the category page, stating that there are no links. Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted August 30, 2007 Author Share Posted August 30, 2007 I can't think of what might cause that. All I can suggest is to go over your link settings. Also, if possible, install the contribution into a clean shop. If it still fails, then you are either making a mistake in the installation or something on your server is causing a problem (which I doubt). Jack Quote 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 More sharing options...
lblanks240 Posted September 9, 2007 Share Posted September 9, 2007 i have a problem i just installed the latest version 1.7 with the update to oscommerce version rc1 using php5 it was a clean install on the link index page http://angelstoyshop.com/osCommerce/links.php i get teh error 1064 - You have an error in your SQL syntax near '( links_description ld, links_to_link_categories l2c, link_categories lc ) on (l' at line 1 select l.links_status from links l LEFT JOIN ( links_description ld, links_to_link_categories l2c, link_categories lc ) on (l.links_status = 2 and ld.language_id = '1' and l2c.links_id = l.links_id and lc.parent_id = '0') [TEP STOP] and on the admin index page http://angelstoyshop.com/..../admin/links.php i get 1064 - You have an error in your SQL syntax near '( links_description ld ) on ( l.links_id = ld.links_id ) ' at line 1 select count(*) as total from links l left join ( links_description ld ) on ( l.links_id = ld.links_id ) [TEP STOP] in the \includes\classes\split_page_results.php the code has been changed to this $this->sql_query .= " limit " . max($offset, 0) . ", " . $this->number_of_rows_per_page; what could be causing the proble and how do i solve it thanks lenard Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted September 9, 2007 Author Share Posted September 9, 2007 What version of mysql are you using? Jack Quote 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 More sharing options...
lblanks240 Posted September 9, 2007 Share Posted September 9, 2007 What version of mysql are you using? Jack mysql version 5 thanks lenard Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted September 9, 2007 Author Share Posted September 9, 2007 mysql version 5thanks lenard I just tried it on a server running mysql 5.2 and it runs as expected. The error appears to be mysql related but maybe it is just an installation problem? Jack Quote 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 More sharing options...
Curly Posted September 17, 2007 Share Posted September 17, 2007 I could get my links to show in a fresh install. But I did notice a difference. I can set the status of the links now, where in my shop, this is not possible. There are only blank lines instead of the different statusses. I think this might have something to do with my problem. Any idea what could be causing this? Quote Link to comment Share on other sites More sharing options...
Curly Posted September 17, 2007 Share Posted September 17, 2007 Found it after a a little longer search. Seems that I had to insert the status codes in the database for my language id. Quote Link to comment Share on other sites More sharing options...
viperek Posted September 22, 2007 Share Posted September 22, 2007 Access Denied No Right Permission Access Please contact your Web Administrator to request more access or if you found any problem. When im tring to go to Links Manager II any ideas?? Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted September 23, 2007 Author Share Posted September 23, 2007 Sounds like you have the admin access contribution installed and you haven't enabled the Links Manager files. Jack Quote 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 More sharing options...
viperek Posted September 23, 2007 Share Posted September 23, 2007 Sounds like you have the admin access contribution installed and you haven't enabled the Links Manager files. Jack yup i have done that it works now :D but do i have to create categories by my self or is it possible to feed it of my database ? Thanks Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted September 23, 2007 Author Share Posted September 23, 2007 To create a category, you click on the Link Categories section in admin and click on Add Category. Jack Quote 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 More sharing options...
babba Posted September 29, 2007 Share Posted September 29, 2007 Hello Community, yesterday I also installed this great contribution - but had to spend all night and plenty hours today to find the problem with the Categories. Finally - after turning off the SEO safe URL Option - I've got my test setup running and I like it very much. However one problem left: When having the Reciprocal Link Option on, my system is not able to recognize to check the phrase at the full link I have entered - but hitting "Visit Reciprocal Link" shows my partner link entries. Since I like this feature I would like to use it - but the failing Link check is prohibiting the partner link request. Has anyone else observed such and is there a hint how to fix this? Thanks for productive feedbacks and greetings from Germany babba Quote Link to comment Share on other sites More sharing options...
dmatwood Posted October 2, 2007 Share Posted October 2, 2007 I installed this contrib. 1.17V and when I go into the admin, enter the link info and then click on check link it gives me this message: Error Reading URL Is there something I missed. I checked the installation again and it seems to be fine. I just dont know if I missed something. Thanks For any help this looks like a great contribution David Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted October 2, 2007 Author Share Posted October 2, 2007 I installed this contrib. 1.17V and when I go into the admin, enter the link info and then click on check link it gives me this message: Error Reading URL Is there something I missed. I checked the installation again and it seems to be fine. I just dont know if I missed something. Thanks For any help this looks like a great contribution David I think a few people have had this problem but I can't get it to fail except when the link is invalid or not working. Have you tried to visit it manually? Jack Quote 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 More sharing options...
dmatwood Posted October 3, 2007 Share Posted October 3, 2007 I think a few people have had this problem but I can't get it to fail except when the link is invalid or not working. Have you tried to visit it manually? Jack I'm not sure how to visit it manually. I have never done that. Would you advise uninstalling it and trying an earlier version? thanks David Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.