Link Manager 3.0 Support Thread

[countrycharm]

Not that different except the SQL is executed from a PHP file.. If you understand SQL and a little bit of PHP, they are not that difficult to understand/troubleshoot/fix..

My point was that if you throw in the towel the problem will not be addressed.. needs to be something that can be replicated or you need to provide error messages/logs so that the issue can be addressed.. throwing in the towel on the troubleshooting process means that the issue will not be addressed for a while.. It's easier to fix the issue if you can report on what you're seeing when the other person is not able to replicate your issue..

I think I already supplied the error logs file messages and the process I took that created the errors. I haven't thrown in the towel but I have other projects to take care of before I can get back to this and fix the installer issues.. That what I was trying to say. Yes I do understand SQL and some PHP but I really haven't took the time to look at the install_links_manager.php file but I will.
The site database does use the zen_ prefix. That might be why it throws these 2 errors when clicking on admin/extra/Links and Links categories don't know yet..

[29-Jun-2014 18:51:54 America/New_York] PHP Fatal error: 1146:Table 'zen151.zen_link_categories_description' doesn't exist :: select lcd.link_categories_name as links_category from zen_links_to_link_categories l2lc left join zen_link_categories_description lcd on lcd.link_categories_id = l2lc.link_categories_id where l2lc.links_id = '1' and lcd.language_id = '1' in /home/xxxxxxxx/public_html/includes/classes/db/mysql/query_factory.php on line 120

[29-Jun-2014 18:50:45 America/New_York] PHP Fatal error: 1146:Table 'zen151.zen_link_categories_description' doesn't exist :: select count(*) as total from zen_link_categories lc left join zen_link_categories_description lcd on lc.link_categories_id = lcd.link_categories_id where lcd.language_id = '1' in /home/xxxxxxxx/public_html/includes/classes/db/mysql/query_factory.php on line 120

[countrycharm]

OK so I had a little more time to check this out. Never could get this to install from a clean install. It had errors as describe above.
I did get it installed but had to download links manager version 1.3.9.
I uploaded all files from links manager 3.6.0, and used the install_links_manager.sql script from links manager version 1.3.9.
After that I run the install_links_manager.php script and it updated the database perfect without any errors. Everything works perfectly.
I'm kinda stump why.

[davewest]

OK... been out working... just finshed checking this out.

The installer is an attemp at catching possible errors and fixing them. however, ZC catches errors itself and puts out the message to refresh the page which compounds the errors! I do have a error in the code that plays funny, sometimes it works, sometime not... so to fix it I changed it too read..

/**************** update status if needed *****************/

     // $check_status = ;
      $check_result = $db->Execute("SELECT links_status_name FROM ".$db_prefix.$table_name3." WHERE links_status_name = 'Blocked'");
      if ($check_result->fields['links_status_name'] == '')  { //fixed 6/29/2014 
      
           $db->Execute("INSERT INTO ".$db_prefix.$table_name3." VALUES (3, 1, 'Blocked')");   //links_status
           
       echo 'Table ' . $table_name3 .' updated with Blocked!<br />';
    }

The first time the waring came up I couldn't get it to reproduce even messing up my database so I put in another catch to stop the install if the database shows to many links manager groups...
so.. updated the installer and created a sql page.. tested them both and they work for me.

I updated the full package on my site, will send an update here when I see what else needs fixing or I get some more of what I want done.

[davewest]

Hi Is this true. Google Officially Says "No" to Reciprocal Linking? If this is so what good is this module....:)

I don't play will with others... if Google wants to force rules on us again... there are other search engines out that do like link backs... If I remember right, reciprocal ranking was an issues ages back and shouldn't be your only reason for links.

As a shopper, if you don't have what I'm looking for, but have a link to a site that does, I'm more then likely coming back to you because you didn't spam me with useless junk ads.

That's why I do links, not what Google wants or think, but for what the customer may like or need.

[countrycharm]

I don't play will with others... if Google wants to force rules on us again... there are other search engines out that do like link backs... If I remember right, reciprocal ranking was an issues ages back and shouldn't be your only reason for links.

As a shopper, if you don't have what I'm looking for, but have a link to a site that does, I'm more then likely coming back to you because you didn't spam me with useless junk ads.

That's why I do links, not what Google wants or think, but for what the customer may like or need.

I asked Diva and she basically said the same thing so we decided against link reciprocal and will only approve links that has useful link information that will help a customer find what they need.

In general links that will be of interest to customers related to what is being sold..

Thanks to both of you. You are a great help to the zen cart community.

[DivaVocals]

I asked Diva and she basically said the same thing so we decided against link reciprocal and will only approve links that has useful link information that will help a customer find what they need.


Thanks to both of you. You are a great help to the zen cart community.

and honestly the reciprical linking Google is targeting is that stupid kind of linking where you have links to your favorite aunt's pet grooming site on your scuba gear shop because you're trying to "help your aunt out".. or worse a bunch of silly links to sites that have NOTHING to do with the primary business of the site in exchange for them adding you to their own equally dumba$$ed links page.. crap SEO strategy..

[nlinksolution]

I just installed this module on v155

And it generates following error.
PHP Fatal error: Call to undefined method linkListingBox::tableBox() in ///// link_listing.php on line 20

Any idea how to fix?