Link Manager 3.0 Support Thread

[countrycharm]

I've never got it to go that high! 8710 is alot of config groups!
is this a new install or upgrade of Links Manager? should be new if table are installing.

Have you done other links manager installs? THe group setting is limited to finding only 301 of them!

if you don't have any links to save, try doing the uninstall and then reinstall... I'll need more info so I can recreate the error... normaly the refreash page comes from a database error or a sql format error. which running the sql by it self would fail too. The first call is to check the configuration group for link manager, but it limmits from 0-300... intresting... think I forgot to delete the 301 part of it, so it should find them, but not delete them.... I'd be intrested in the number of Links Manager groups you have... using phpmyadmin do a quary for Links Manager and see how many show up...

I've done the install on a clean ZC 1.5.2, old massed up ZC 1.5.1 and a live ZC 1.5.1 limmited testing...
With my old live site I had to clean the database by hand due to junk keeping it out of sysnic. running the uninstaller would fix the tables by deleting them and then running the installer would replace them...

I'd be interested in the number of Links Manager groups you have... using phpmyadmin do a quary for Links Manager and see how many show up...

Just 1 shows up..... I'll have to put this on the back burner until things are fixed in the installer.

[DivaVocals]

Just 1 shows up..... I'll have to put this on the back burner until things are fixed in the installer.

Except that's just it.. can't "fix" unless the issue can be recreated..

[countrycharm]

Except that's just it.. can't "fix" unless the issue can be recreated..

I can understand that Diva. I like using the old installers better. I could at list see what was installed and what wasn't so I could play around with the installer code and fix it. I really don't know much about these self auto installer...... :-)

[DivaVocals]

I can understand that Diva. I like using the old installers better. I could at list see what was installed and what wasn't so I could play around with the installer code and fix it. I really don't know much about these self auto installer...... :-)

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

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