vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   vB Links Directory 2.0 *NEW VERSION* (https://vborg.vbsupport.ru/showthread.php?t=44551)

Dark_Wizard 07-21-2003 02:25 PM

Quote:

Today at 10:49 AM DiscussAnything said this in Post #610
I've done all 3 of your fixes, but with the same results. The admin panel is also giving dbase errors left and right.

for View all links:

PHP Code:

Invalid query id  specified
mysql error


mysql error number

For edit link in admin panel:

PHP Code:

Invalid SQL
SELECT 
FROM gportal_weblinkscat 
WHERE webcatid 
'2' 
ORDER BY linkid 

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

mysql error number1054 

and for add new link, after selecting the category:

PHP Code:

Invalid SQL
SELECT 
FROM gportal_weblinkscat 
WHERE webcatid 
'2' 
ORDER BY linkid 

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

mysql error number1054 

If i'm the only one dealing with this, I can redo the hack, but if its something in the hack, I'll help to try hunting it down. So just let me know. Is anyone else getting strange behavior after the update?


Reapply the hack as my fixes worked for others...

DrkFusion 07-21-2003 03:13 PM

Sorry...as I said before I do not have a place to test all these fixes do to server upgrades, I will look at it as soon as I find someone to give me ftp access and admin cp access.

DiscussAnything 07-21-2003 04:05 PM

Shame I'm not at home right now (travelling this week) otherwise I'll let you play around as much as you want on my local installation. I'm not too comfortable with testing things on a live database though..

If you give me pointers where to look I can look into it myself. Right now it all looks fine though, and yet it doesnt work, for me. I'll redo the hack from scratch though and apply DW's fixes. I'll let you know..

Thanks

jacobi 07-21-2003 04:11 PM

I noticed, that for some odd reason (I'm only a novice at PHP), when you copy and paste the PHP code off these posts, it doesn't quite transfer correctly. So, the workaround I figured out is to click "quote," whereby it will take the code and quote it for a new reply post, and then copy that text (minus the bbCode, of course). Does that make sense?

cindyd 07-21-2003 05:46 PM

How odd AJ, I haven't had that problem. I C&P into my HTML editor and it is fine.

DiscussAnything 07-21-2003 05:49 PM

just a note, i just redid the hack + update + fixes from scratch and I still have the same problems.... weird

TheJANG 07-21-2003 05:56 PM

Quote:

Today at 06:41 AM DiscussAnything said this in Post #608
after the update the link and description are not inserted into the database, when I add a new link. Everything looks alright though, and I didnt change any of the code/templates :confused:

I'm experiencing this same problem. I started with the build attached to the original post, then applied the 250 upgrade and did the Dark_Wizard edits (at least one of which was already in the latest 250 build). I'm running vB 2.2.8.

Adding links from the admin_cp works fine. Adding from links.php does not pass in the URL or description.

Also, not that this is anything big, but the misspelling "catagory" is used many places in the admin pages.

Dark_Wizard 07-21-2003 06:35 PM

I'm going to rewrite the admin piece for Keptic....give me a little time to complete it.

cindyd 07-21-2003 06:37 PM

Quote:

[i]Adding from links.php does not pass in the URL or description.
The links you added aren't waiting for validation by any chance?

Dark_Wizard 07-21-2003 06:42 PM

Quote:

Today at 02:56 PM TheJANG said this in Post #617
Adding links from the admin_cp works fine. Adding from links.php does not pass in the URL or description.

in links.php

find:
PHP Code:

$DB_site->query("
    INSERT INTO gportal_weblinkslink
    (catagoryid, linkname, linkurl, linkdesc, valid)
    VALUES 
    ('
$catid', '".addslashes(htmlspecialchars($linkname))."', '".addslashes($linkurl)."', '".addslashes(htmlspecialchars($$linkdesc))."', $vd)
"
); 

change to this:
PHP Code:

$DB_site->query("
    INSERT INTO gportal_weblinkslink
    (catagoryid, linkname, linkurl, linkdesc, valid)
    VALUES 
    ('
$catid', '".addslashes(htmlspecialchars($linkname))."', '".addslashes($linkurl)."', '".addslashes(htmlspecialchars($linkdesc))."', '$vd')
"
); 

There was an extra $ in $linkdesc


All times are GMT. The time now is 04:37 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.01787 seconds
  • Memory Usage 1,755KB
  • 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
  • (5)bbcode_php_printable
  • (4)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