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)

zetetic 07-30-2004 12:45 AM

There seems to be a 5000 character limit on articles. Does anyone know if this is adjustable?

flstreetscene 07-30-2004 05:26 AM

I get this error during installation;

Code:

Database error in vBulletin 3.0.3:

Invalid SQL: INSERT INTO phrase (phraseid, languageid, varname, text, phrasetypeid) VALUES (NULL, '0', 'setting_commentsperpage_title', 'Comments Per Page', '5000')
mysql error: Duplicate entry 'setting_commentsperpage_title-0-5000' for key 2

mysql error number: 1062

What exactly do I need to delete / drop from my database for a clean installation?

hitmanuk2k 07-30-2004 09:43 AM

i have had a go at doing this myself but couldnt find what i had to remove in article.php. basically if you go to http://forum.pesinsight.com/article.php?a=1.... i want to get rid of the catagory background image (in the row with the article title)... because as you can see it messes it up. but i dont want to have to change my forum style because its fine elsewhere. so if i just wanted to remove it from the articles? how would i? i managed to get rid of the avatar myself but couldnt do the bg.

hitmanuk2k 07-30-2004 09:57 AM

Quote:

Originally Posted by pjdaley
same here

i also would like a hack to show the latest articles on non-vb page, maybe the last 10 (like you can do with the latest threads hack on non-vb page). i would be willing to pay a small amount if someone could do this.

.:.NetStartz.:. 07-30-2004 07:16 PM

Same problem here...

Quote:

Originally Posted by JimpsEd
Database error in vBulletin 3.0.3:

Invalid SQL: SELECT * FROM vb3_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: Friday 23rd of July 2004 06:34:37 PM
Script: http://forum.ugamer.net/article.php?c=2
Referer: http://forum.ugamer.net/article.php
Username: Sardukar
IP Address: 81.6.241.167


:( new install


Brinkley 07-31-2004 12:30 AM

Hello,

I´m waiting for a Bugfixed Version for vB 3.0.3 , Hack removed

To many Probs :disappointed: :disappointed: :disappointed:

Greets

Henry-RS 08-01-2004 04:45 AM

Quote:

Originally Posted by Brinkley
Hello,

I?m waiting for a Bugfixed Version for vB 3.0.3 , Hack removed

To many Probs :disappointed: :disappointed: :disappointed:

Greets


Ditto.

Lonny 08-01-2004 03:53 PM

when I go to forum/article.php

I get a blank page :(

why is that?

Lonny 08-01-2004 03:53 PM

oh yea I'm running 3.0.0

any chances that the problem is there? what should I do now?

MindTrix 08-01-2004 03:55 PM

make sure the templates have been added to each style

JustAskJulie 08-01-2004 07:00 PM

Can anyone tell me what I would need to change to show the date the article was submitted on the article list?

Morrus 08-01-2004 11:25 PM

Quote:

Originally Posted by Mickie D
it would be nice to just be able to move the articles if they are posted in the wrong section :(

I've managed to do this by directly editing the database, but it's a pain - you have to edit the article table (change the category number), and also the category table (change things like last article, last comment, number of articles, etc.)

I agree, it would be great to be able to move the articles through the system itself.

laeth 08-03-2004 05:08 PM

Any chance of an update to vb3?

Like the hack, but so many bugs :(

PET 08-03-2004 10:27 PM

i don't have time to...read all the topic, but i have a quick question.

How can i move an article ?

Morrus 08-04-2004 12:32 AM

Quote:

Originally Posted by PET
i don't have time to...read all the topic, but i have a quick question.

How can i move an article ?

Sure, reading the entire topic is a bit much - but raising your gaze a couple of inches to the post above the one before yours isn't. ;)

weirdpixels 08-04-2004 10:29 AM

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?

weirdpixels 08-04-2004 12:53 PM

everything is ok now, managed to figure out what was cauing the mysql error
Great hack, *clicks install

acrimony 08-05-2004 02:59 PM

I am also waiting for the 3.0.3 SQL DB fix :)

acrimony 08-05-2004 04:19 PM

I figured it out, I had to go to vB3 Articles menu in the main vbulletin settings and hit save :p

gyutae 08-05-2004 09:02 PM

How would I go about making more than 1 situation of a articles board. For example, I want an articles board and a reviews board that are separate.. any ideas?

gyutae 08-06-2004 12:08 AM

To clarify on my previous post, I want to make two different instances of this same hack. One for articles, the other for reviews, and possibly more in the future for other sections of my site. My question is this: How would I go about running two instances of this hack on my site with one vbulletin? I have tried changin all the "article" variable names to "review" but still ran into some trouble with duplicate database entries. I'm planning on creating different tables for the differetn instances. So which variables names need to be changed so that database entries and settings will not conflict? Please help John. Thanks.

stryka 08-06-2004 02:52 PM

Is it possible to hide the ARTICLES from the main forum....

I would like to create a entertainment section and query these articles based on the article type...

any suggestions.... is it possible?

vau7 08-06-2004 10:55 PM

Great Hack, thank you!

One Question:
Is there a way to import Threads from a whole section into an articlecategory?
Its surley hard to modify...

cinq 08-07-2004 01:06 AM

Can the system take more than 4 image attachments per article ?
If so, can anyone provide a screenie how they will be displayed ?

Much appreciated, thanks :D

tides 08-08-2004 12:20 AM

Can not edit comment... :disappointed:
Code:

Database error in vBulletin 3.0.1:

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

mysql error number: 1051

Date: Saturday 07th of August 2004 08:20:21 PM
Script: http://ffxi.alxndr.net/article.php?do=editcomment&id=3
Referer: http://ffxi.alxndr.net/article.php?goto=lastcomment&v=1&a=2#comment4
Username: Jessica
IP Address: 68.94.70.75


Chrissicom 08-09-2004 12:23 PM

I have just installed this hack as it is perfect for my articles & interviews database for my Sandra Bullock community. Although I have a little problem with the attachments. I can view an attached image, but the thumbnail does not display. I have PHP 4.3.7 as ISAPI on Win 2003 Std installed and GD2 enabled in vB options and the thumbs of vB threads work, the thumb of vB articles don't work :( what could be the problem here? (have vB 3.0.3)

tides 08-10-2004 09:52 AM

How can I let other administrators (not super administrators) to access the control panel?
I need someone to mondorate the catgolary for me. Thanks.

bgtking 08-10-2004 03:46 PM

Quote:

Originally Posted by Chrissicom
I have just installed this hack as it is perfect for my articles & interviews database for my Sandra Bullock community. Although I have a little problem with the attachments. I can view an attached image, but the thumbnail does not display. I have PHP 4.3.7 as ISAPI on Win 2003 Std installed and GD2 enabled in vB options and the thumbs of vB threads work, the thumb of vB articles don't work :( what could be the problem here? (have vB 3.0.3)

No, the attachments thumnails do not work with 3.0.3. The problem was brought up weeks ago, but still nothing has been fixed.

Mickie D 08-10-2004 09:53 PM

i think it might be better to hard code an image for the thumbs (until its fixed) that way you will get an image and name and they can click the image to see it ?

i will look at the hack see what i can do :)

Martaigne 08-10-2004 11:43 PM

Quote:

Originally Posted by Mickie D
i think it might be better to hard code an image for the thumbs (until its fixed) that way you will get an image and name and they can click the image to see it ?

i will look at the hack see what i can do :)

I was considering just finding the template for displaying the thumbnails and having it produce a just a text link instead. Please let us know if you find anything!

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 11:45 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.02283 seconds
  • Memory Usage 1,834KB
  • 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
  • (4)bbcode_code_printable
  • (11)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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