Link Manager 3.0 Support Thread

Sorry I spent so much time getting back on the image upload... found while sortting out a new install that I had changed mine so much that it didn't match the download version anylonger. Had to weed out what should be a simple switch out for you... Back up and test to make sure I didn't miss something...

The page is rearanged a bit so I could get the form to take enctype="multipart/form-data" and work right.

Attachment #14171

I did a install on a clean ZC1.5.2 test site.
This version of XAMPP includes:
- Apache 2.4.4
- MySQL 5.6.12
- PHP 5.5.0

Linkmanager really needs to be reworked for easer install and link click recording.

davewest:

Sorry I spent so much time getting back on the image upload... found while sortting out a new install that I had changed mine so much that it didn't match the download version anylonger. Had to weed out what should be a simple switch out for you... Back up and test to make sure I didn't miss something...

The page is rearanged a bit so I could get the form to take enctype="multipart/form-data" and work right.

Attachment #14171

I did a install on a clean ZC1.5.2 test site.
This version of XAMPP includes:
- Apache 2.4.4
- MySQL 5.6.12
- PHP 5.5.0

Linkmanager really needs to be reworked for easer install and link click recording.
So submit your!!! :laugh:

IJS!!

DivaVocals:

So submit your!!! :laugh:

IJS!!

Yap.. toying with click counts.. then I'll have to go for it.:D

davewest:

Yap.. toying with click counts.. then I'll have to go for it.:D

taps foot and waits patiently
:P

OK... sent up an updated mod... didn't have an old 1.3.x ZC anywhere to test, so not sure it works below 1.5.1 and PHP 5.4....

trying something new, a sql installer. work good on my test and active sites...

New to this version;

An admin installer page!

New to the code is the ability to block URL's from submitting. Status 'Blocked' will check URL against existing databased URL's when submitted. Blocked URL's will not be displayed and treated the same as Pending. I have plans on making the block smarter, but right now it's just a dumb exist match test. Will be changing to a domain match when I get time.

New sidebox. this one displays only the link image at 150px x 30px of all links to total number set in the configure section. With an added space
for you to insert paid links or ads so on.

Updated;

*fixed Admin link page image upload
*fixed click counts
*fixed click counter with on/off switch
*fixed changed use from mysql_ to ZC $db_ should be PHP 5.4 to 5.5 ready (tested on PHP 5.5.3 and 5.4.26 with ZC 1.5.1 and 1.5.2)

:shocking:

Whoo hoo!!!

davewest:

OK... sent up an updated mod... didn't have an old 1.3.x ZC anywhere to test, so not sure it works below 1.5.1 and PHP 5.4....

trying something new, a sql installer. work good on my test and active sites...

---

New to this version;

An admin installer page!

New to the code is the ability to block URL's from submitting. Status 'Blocked' will check URL against existing databased URL's when submitted. Blocked URL's will not be displayed and treated the same as Pending. I have plans on making the block smarter, but right now it's just a dumb exist match test. Will be changing to a domain match when I get time.

New sidebox. this one displays only the link image at 150px x 30px of all links to total number set in the configure section. With an added space
for you to insert paid links or ads so on.

---

Updated;

*fixed Admin link page image upload
*fixed click counts
*fixed click counter with on/off switch
*fixed changed use from mysql_ to ZC $db_ should be PHP 5.4 to 5.5 ready (tested on PHP 5.5.3 and 5.4.26 with ZC 1.5.1 and 1.5.2)

:shocking:

Where can I download your updated version until zen cart approves it.... :)

countrycharm:

Where can I download your updated version until zen cart approves it.... :)

What... give away the location to where I hide!:unsure:

OK... my blog link is in the link sidebox of my tag line site! And Link Manager is working live on the same if you want to drop a link.... and so folks don't get confused... I use a different way of displaying forms and responceses, not part of the download.

davewest:

What... give away the location to where I hide!:unsure:

OK... my blog link is in the link sidebox of my tag line site! And Link Manager is working live on the same if you want to drop a link.... and so folks don't get confused... I use a different way of displaying forms and responceses, not part of the download.

Brain freeze so you telling me to drop a line to from your website...... :)

countrycharm:

Brain freeze so you telling me to drop a line to from your website...... :)

OK... thinking I'm not making to much sense... been looking at to many lines today.. wish this county didn't have so many roads... now if I can get the speed limits right so my code can run the analyses... nothing like maps to drive you nuts!

so... in my sig is the link to my store with has the link to my blog which has the download.... or just add /fsbublog to the end of the link...

Does someone have and installer other than the auto installer. I get errors running the auto installer. When I go to the admin and enter https://www.yourstore.com/your_admin/install_link_manager.php and click on install It doesn't install. Here's what it shows:

Links Manager v3.6.0 for ZenCart Installing...
WARNING: An Error occurred, please refresh the page and try again.

When I refresh the page it installs up to this point:

Links Manager v3.6.0 for ZenCart Installing...
Configuration Group Links Manager already exists SKIPPED
Links Manager Configuration_Group ID = 8710
Admin pages created for ZC 1.5.x
Table zen_links installed!
Table zen_links_description installed!
Table zen_links_status installed!
Table zen_links_to_link_categories installed!
Table zen_link_categories installed!
table link_categories_description is already installed.
WARNING: An Error occurred, please refresh the page and try again.

It shows under the configuration menu and under admin/extras but when you click on links on link categories it shows and error:
WARNING: An Error occurred, please refresh the page and try again.

I'm running
zen cart 1.5.1

Server Host: p3plcpnl0047.prod.phx3.secureserver.net (184.168.200.208)
|

Server OS: Linux 2.6.32-458.18.1.lve1.2.39.el6.x86_64 |

Server Date: 06/29/2014 14:02:36 |

Server Up Time: 11:02:36 up 77 days, 7:38, 0 users, load average: 5.71, 7.08, 7.89 |

PHP Version: 5.4.26 (Zend: 2.4.0) PHP Memory Limit: 328M |

PHP File Uploads: On Max Size: 2M |

Database Data Size: 14,621 kB

[TABLE="width: 90%"]

Database: MySQL 5.5.32-cll-lve |

Database Date: 06/29/2014 11:02:35 |

HTTP Server: Apache mod_fcgid/2.3.10-dev |

PHP Safe Mode: Off |

POST Max Size: 8M

[/TD]
[/TR]
[/TABLE]

Any ideas why this is happening. Thanks in advance.

countrycharm:

Any ideas why this is happening. Thanks in advance.
Not unless you post the errors that are in your error log.. this will help FIX (versus SKIP) the auto-installer..

Links Manager Configuration_Group ID = 8710
Links Manager v3.6.0 for ZenCart Installing...
WARNING: An Error occurred, please refresh the page and try again.

When I refresh the page it installs up to this point:

Links Manager v3.6.0 for ZenCart Installing...
Configuration Group Links Manager already exists SKIPPED
Links Manager Configuration_Group ID = 8710
Admin pages created for ZC 1.5.x
Table zen_links installed!
Table zen_links_description installed!
Table zen_links_status installed!
Table zen_links_to_link_categories installed!
Table zen_link_categories installed!
table link_categories_description is already installed.
WARNING: An Error occurred, please refresh the page and try again.

It shows under the configuration menu and under admin/extras but when you click on links on link categories it shows and error:

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

DivaVocals:

Not unless you post the errors that are in your error log.. this will help FIX (versus SKIP) the auto-installer..

This is the first error when trying to install from the auto installer.

[29-Jun-2014 18:40:43 America/New_York] PHP Fatal error: 1146:Table 'zen151.configuration_group' doesn't exist :: SELECT 'configuration_group_id' FROM configuration_group WHERE configuration_group_title = 'Links Manager' in /home/xxxxxxxxxx/public_html/includes/classes/db/mysql/query_factory.php on line 120

This is the error when I refresh the page but it installs with a error.

[29-Jun-2014 18:44:54 America/New_York] PHP Fatal error: 1062:Duplicate entry '3-1' for key 'PRIMARY' :: INSERT INTO zen_links_status VALUES (3, 1, 'Blocked') in /home/xxxxxxx/public_html/includes/classes/db/mysql/query_factory.php on line 120

Installed this when I refeshed the page...
Links Manager v3.6.0 for ZenCart Installing...
Configuration Group Links Manager already exists SKIPPED
Links Manager Configuration_Group ID = 8710
Admin pages created for ZC 1.5.x
Table zen_links installed!
Table zen_links_description installed!
Table zen_links_status installed!
Table zen_links_to_link_categories installed!
Table zen_link_categories installed!
table link_categories_description is already installed.
WARNING: An Error occurred, please refresh the page and try again.

This is the error I get when I go to admin/extras/links

[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

This is the error I get when I go to admin/extras/links Categories..

[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

Here are the admin link manager configurations image... OH One more thing, when side box is enabled I get an error too.

davewest:

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

Yes I know. When Cowoa was first installed a good while back it installed a high! config groups number 8687 so it went from there.
This is a brand new install.

Have you done other links manager installs? THe group setting is limited to finding only 301 of them!
Not on zen cart 1.5.1 only on 1.3.9h

if you don't have any links to save, try doing the uninstall and then reinstall.
The uninstall does not work. I have to drop my database and use the backup I made.

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 will have to try to install it again today and let you know

davewest:

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.

countrycharm:

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

DivaVocals:

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

countrycharm:

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

DivaVocals:

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