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)
-   -   v3 Articles 1.0.1 - [vB 3.0.1] (https://vborg.vbsupport.ru/showthread.php?t=65934)

tteal 08-11-2004 09:41 PM

I'm getting that same error now after upgrading to VBulletin 3.0.3 ... this was working fine in 3.0.1

Any help would be great!

Thanks!

Quote:

Originally Posted by weirdpixels
Just installed on vb 3.03 but i am getting the following mysql error:

Database error in vBulletin 3.0.3:

Invalid SQL: SELECT * FROM article
WHERE categoryid=2 AND (articleuserid=1 OR open IN (0,1)) ORDER BY dateline DESC LIMIT 0,
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2

mysql error number: 1064

Date: Wednesday 04th of August 2004 01:24:03 PM
Script: http://www.weirdpixels.co.uk/forum/article.php?c=2
Referer: http://www.weirdpixels.co.uk/forum/article.php

This happens when i click on a Category or sub Category
any ideas of what could be causing this?


bing11 08-12-2004 04:22 AM

how search the artides?

Razgo 08-12-2004 07:41 AM

i also have a can't edit problem:

Code:

Database error in vBulletin 3.0.3:

Invalid SQL: SELECT articlepost.*, article.categoryid FROM vb3_articlepost
                                                                          INNER JOIN vb3_article AS article ON (article.articleid = articlepost.articleid)
                                                                          WHERE articlepost.postid=2
mysql error: Unknown table 'articlepost'

mysql error number: 1051

Date: Thursday 12th of August 2004 02:44:33 AM
Script: http://www.sensory-fusion.com/forum/...itcomment&id=2
Referer: http://www.sensory-fusion.com/forum/article.php?a=1
Username: Razgo
IP Address: 210.49.43.36


Razgo 08-12-2004 08:00 AM

ok i found my answer in a SQL error in the script? back in post 114 and this worked for me.

just have to figure out why thumbnails don't show as an image. thumbnails on the forum work fine.

https://vborg.vbsupport.ru/showpost....&postcount=114

JustAskJulie 08-12-2004 06:19 PM

Quote:

Originally Posted by bing11
how search the artides?

I've been wondering that too.

Is this hack still being supported?

j_86 08-12-2004 06:32 PM

It isnt being supported.. the author also ignores me on MSN.

Pitman 08-12-2004 08:34 PM

Quote:

Originally Posted by bing11
how search the artides?

Insert this HTML anywhere in a template within the default forums directory

Code:

        <b>Search Articles:</b><br>
        <form action="article.php" method="get">
                <input type="hidden" name="do" value="search" />
                <input type="text" class="bginput" name="keyword" size="20" />$gobutton
        </form>

To use it outside of the forums directory, hard code the bold text above.

TTG 08-12-2004 09:30 PM

How do you delete an individual article ?

JustAskJulie 08-13-2004 05:47 PM

I've just run into another problem. WHen you click the username of the person who posted the article. Instead of being taken to THEIR profile, I'm being taken to my own.

zetetic 08-13-2004 05:53 PM

Quote:

Originally Posted by JustAskJulie
I've just run into another problem. WHen you click the username of the person who posted the article. Instead of being taken to THEIR profile, I'm being taken to my own.

Seems to be an issue on your end, JaJ. That doesn't happen on my site...


All times are GMT. The time now is 05:31 PM.

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.01740 seconds
  • Memory Usage 1,745KB
  • 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
  • (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