vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   Links and Files Database (https://vborg.vbsupport.ru/showthread.php?t=60403)

CERTguide 04-05-2004 06:38 PM

Quote:

Originally Posted by AndrewD
I don't know ;)

I tried adding these links to my test database and they work just fine for me. The links checking process simply tries to open a connection to the specified file. Maybe you had a very busy server?


I tried several times with no luck. I wish my server was that busy.

AlexanderT 04-05-2004 06:52 PM

Quote:

Originally Posted by AndrewD
Thanks - I'll think about this idea. But is bandwidth to your site more expensive than my time as a programmer? (smiling)

:nervous:

AndrewD 04-05-2004 07:00 PM

Quote:

Originally Posted by CERTguide
I tried several times with no luck. I wish my server was that busy.

I think the code would benefit from a bit better error reporting when these problems arise. I'll have a look at it next time I have some free time (probably the weekend). Otherwise we're grappling in the dark.

What I did to get the link working was simply open your link in a new window then cut and paste from the address line into the links database. Sure you've not missed out a character somewhere?

CERTguide 04-05-2004 07:05 PM

I copied the link into the database and copied it back out after it said it was not available. Always works in a browser, never in the database.

Konk 04-05-2004 07:50 PM

A fantastic hack, I'm in the process of installing it. Thanks!

I hope that you find interest/time to continue with the:
- Integrate this with the VB attachment system to allow users to upload files
- Integrate this with the VB moderation system

I imagine it's complicated but I'm sure many would be very appreciative!

Animension 04-06-2004 12:09 AM

Hello, I recently installed this hack (along with the integration with vBAdvanced hack).

My problem is that I cannot add links. I can add categories, but when I attempt to add links it sits there and loads nothing. I've tried several different web pages but it still just sits there.

Any help is appreciated.

EDIT: I played around and found that it was the URL check that was messing it up. However now, I get this SQL database error:

Code:

Database error in vBulletin 3.0.0 Release Candidate 4:

Invalid SQL: 
                INSERT INTO local_linkslink (linkname, linkurl, linkdesc, linkhits, linkforum, linkcheck, linkstatus, linkdate, linkusername, linkuserid)
                VALUES (
                'www',
                'http://www.google.com',
                'thedhrhetrgtgfehe',
                0,
                '11',
                1081171544,
                ,
                1081171544,
                'Ultima Ichijouji',
                1
                )
       
mysql error: You have an error in your SQL syntax near '
                1081171544,
                'Ultima Ichijouji',
        ' at line 10

mysql error number: 1064

Date: Monday 05th of April 2004 06:25:44 AM
Script: http://www.animension.net/adrf/local_links.php
Referer: http://www.animension.net/adrf/local...ddlink&catid=1
Username: Ultima Ichijouji


AndrewD 04-06-2004 04:21 AM

Quote:

Originally Posted by Animension
EDIT: I played around and found that it was the URL check that was messing it up. However now, I get this SQL database error:

Code:

Database error in vBulletin 3.0.0 Release Candidate 4:

Invalid SQL: 
                INSERT INTO local_linkslink (linkname, linkurl, linkdesc, linkhits, linkforum, linkcheck, linkstatus, linkdate, linkusername, linkuserid)
                VALUES (
                'www',
                'http://www.google.com',
                'thedhrhetrgtgfehe',
                0,
                '11',
                1081171544,
                ,
                1081171544,
                'Ultima Ichijouji',
                1
                )
       
mysql error: You have an error in your SQL syntax near '
                1081171544,
                'Ultima Ichijouji',
        ' at line 10


The SQL error is happening where the value (statuscheck) returned by check_url is inserted into the database. You said that you'd played around with check_url - perhaps you've deleted the return code by mistake?

AndrewD 04-06-2004 04:22 AM

Quote:

Originally Posted by CERTguide
I copied the link into the database and copied it back out after it said it was not available. Always works in a browser, never in the database.

OK - this weekend ...

hitmanuk2k 04-06-2004 03:54 PM

just installed.... but when i go to local_links.php?links (where i am told i can add categories...) there are no options at all for anything....

AndrewD 04-06-2004 04:12 PM

Quote:

Originally Posted by hitmanuk2k
just installed.... but when i go to local_links.php?links (where i am told i can add categories...) there are no options at all for anything....

Do you not see another tool bar across the screen? It should say Links, Search and Administer links v1.01. Click on Links and you'll get a pull down menu with the Create Category option

If not, we need to look deeper.


All times are GMT. The time now is 06:08 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01922 seconds
  • Memory Usage 1,750KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code_printable
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete