Installed manually and applied the fix and all working like a dream. I don't intend upgrading to vB3 for a long time yet [why fix it if it aint broke?] so this does a great job for me - thanks!

www.dragonninja.co.uk/links.php

Great to hear FleaBag, you mind if we use your site for an example on the first post?

Keptic: I installed the upgrade manually and everything is working on my site also. Feel free to use my site:

http://www.glassmavenhaven.com/forum/links.php?s=

News
We will be completly going through the code and fixing bugs. This should be a stable release in matter of few days. We will also be releasing v3 in a matter of weeks. We will be sending out a final testing for all beta testers.

So expect v3 soon. We are also reworking the code for v3, to make it function better, and the admin and options are being COMPLETLY rewritten.

Regards,

I am the original coder of vB Links Directory 2.0. I coded this awhile back while starting coding, let me assure everyone that we are much more intelligent with our coding. Keptic has not gotten a chance to do alot of coding, but in v3, he will be recoding many of the parts, he codes smart, and his main worry is functionality, and integration. Mine will be features.

We have a great product lined up for you guys. Free of charge.

I hope everyone will stick with us to see one of the more bigger, and well-featured hacks :)

I'd be honoured mate! And if you ever need a beta tester, I'm always willing. ;)

Odd.. Has anyone tried the 250 upgrade script/install script that Dark_Wizard attached from this post?:
https://vborg.vbsupport.ru/showthrea...707#post419707

The upgrade goes through without a problem, but you get database errors when you try to access the scipt in the admin CP (yes I also submitted the vb options as asked in the instructions).

I then ran an uninstall and a install from scratch (and of course submitted the vb options again!), and I still got the problem going on. Files are hacked properly, anyone else getting this issue?

Can you be more specific? What are the exact error messages? Do a view source on the error page and paste it into a post here so I can fix it...

Database error in vBulletin Control Panel 2.3.0:

Invalid SQL:
SELECT *
FROM gportal_weblinkscat
ORDER BY catid

mysql error: Unknown column 'catid' in 'order clause'

mysql error number: 1054

---------------------------------------------------------------

Database error in vBulletin Control Panel 2.3.0:

Invalid query id specified
mysql error:

mysql error number: 0

I have it uninstalled at the moment, but here were the SQL errors. Any ideas? :D

Hmmm...surprised no one else found this error. Try this weblinksadmin.php file....

Updated the install/upgrade download file as well....

Still the same problem unfortunately. :( I submitted the 'validate' thing in options, and all files are hacked perfectly. I can click on "Add Category" without error, and submit a category with no error. I cannot click on 'links' to add a link though without that error above. When I also click on "view all links" it brings up the error again. Fix make work! :D

Here's those errors:

When clicking on "Add new Link -> Links"

Database error in vBulletin Control Panel 2.3.0:

Invalid SQL:
SELECT *
FROM gportal_weblinkscat
WHERE webcatid = '1'
ORDER BY linkid

mysql error: Unknown column 'linkid' in 'order clause'

mysql error number: 1054

------------------------

When clicking on "View ALL Links"

Database error in vBulletin Control Panel 2.3.0:

Invalid query id specified
mysql error:

mysql error number: 0

-Jason

Hmmm...these are the files from Keptic so something isn't right...I will look into it and get back to you...

Thanks so much. :)

His original 2.0 series installed fine for me and worked. I'm doing a completely fresh install each time with your files, figured that would help in the troubleshooting...

Try this file...

Version 3.0 is running on my site now http://www.dpclan.com/forums/links.php

v3 Looks real nice, I can't wait... :)

As for the previous issue, still problems:

Clicking on "View/Edit":

Database error in vBulletin Control Panel 2.3.0:

Invalid SQL:
SELECT *
FROM gportal_weblinkscat
ORDER BY catid

mysql error: Unknown column 'catid' in 'order clause'

mysql error number: 1054

----------------------------------------------

Clicking on "Add new Link"

Database error in vBulletin Control Panel 2.3.0:

Invalid SQL:
SELECT *
FROM gportal_weblinkscat
ORDER BY catid

mysql error: Unknown column 'catid' in 'order clause'

mysql error number: 1054

----------------------------------------------------

Clicking on "View ALL Links":

Database error in vBulletin Control Panel 2.3.0:

Invalid query id specified
mysql error:

mysql error number: 0

Hmm. :)

-Jason

These are the same files that Keptic posted...if I wasn't so busy with 3.0 I would rewrite 2.0's admin piece...

Strange indeed... When I install 2.x it works fine, it was always 2.5 that I just couldn't get to work.. Must be something we're missing.. I could just be jinxed. :P

I just installed 2.5 and get the same errors you have listed:

Database error in vBulletin Control Panel 2.3.0:

Invalid SQL:
SELECT *
FROM gportal_weblinkscat
WHERE webcatid = '1'
ORDER BY linkid

mysql error: Unknown column 'linkid' in 'order clause'

mysql error number: 1054

Date: Wednesday 30th of July 2003 12:31:40 AM
Script: http://thedecostop.com/forums/forums...elinks&catid=1
Referer: http://www.thedecostop.com/forums/ad...nksadmin.php?&

I'm working on an update for Keptic and it will be done today...

Awesome! Thanks so much for working with us DW!

Just an FYI.

Arunan has contacted me to say that he no longer has a vb license and is asking me to takeover and complete the vB Links Directory 3.0 hack. I have been working on this as well as my vbWar hack and will get a beta out soon.

The first round of beta testers will need to be people who can offer to test this as a full install and not an upgrade as I need time to write that part of the script. I will also continue to work with 2.0 to get it stable before the final release of 3.0.

Arunan sends his regards and apologies.....

Hey thanks for keeping us posted. :) Send my regards on as well.

Okay no problem, I'm willing to test anything you need me for in the 2.x series as well as 3.0 if you don't have a mound of beta testers by now lol.. Just let me know!

Good luck!

I would be more than willing to beta test anything you guys come up with too.
Just give a holler :)

I can test it as a full install if you want Dark_Wizard :)

I can test a clean install too.. but on vacation utill Aug14th

Just to let you know...the 3.0 beta is about 1-2 weeks away. I'll keep you posted.

Sounds great, hopefully the 2.5 fixes will be a tad earlier. ;)

Yes they will...

:banana:

Thanks alot for your hard work.

thanks for continuing the project, if it's anything like your other scripts, this will totally rock :)

I want to use this hack and I have it installed, but I am thinking of uninstalling it. If I use it, is there a way to allow my users to be notified of the newest links in the directory through the new threads or something?

Right now I have a CoolLinks forum and just have links posted in there. It seems to work OK, because it's a forum it puts the new links into the newest threads and also at the top of the page where I have an iframe showing the latest posts on my forumz. Can this hack do anything like this or do something so that links aren't just lost within the directory without anybody even knowing they've been added?

If you can help me with this problem, that would be great.

Thanks for any help you can provide.

There is a '10 latest hacks' list which I'm sure you can rework to show up on your index or wherever. It's just the results of a query you perform on the database. Put it in a nice layout and you should be set...

I like the idea but I cannot get it ready for version 3.0, I will look into it though for a future release, 3.1 maybe?

when i click a link it takes you to the redirect page and just keeps on refreshing?

sabre, check in your admin panel if it actually has an URL to refresh to. If there's no URL it will indeed just refresh

is there a fix for the errors above for 2.5

this error:

Database error in vBulletin Control Panel 2.3.0:

Invalid SQL:
SELECT *
FROM gportal_weblinkscat
WHERE webcatid = '1'
ORDER BY linkid

mysql error: Unknown column 'linkid' in 'order clause'

mysql error number: 1054

------------------------

When clicking on "View ALL Links"

Database error in vBulletin Control Panel 2.3.0:

Invalid query id specified
mysql error:

mysql error number: 0

by the way... I'll do a complete install to beta test 3.0... I have well over 120 links I would add right away.

How odd, I am getting the same message:

When trying to view links in a category:

and when trying to view all links:

I need to update some links, any ideas?

I'll be fixing 2.5 this week as I'm still in the middle of about 3 other hacks... :(