Log in

View Full Version : v3 Articles 1.0.1 - [vB 3.0.1]


Pages : 1 [2] 3 4 5

KevinLe
07-09-2004, 01:05 AM
Yes, and the attachment thumbnails work in the forums, but not for the articles.
Yeah, I have same problem with the thumbnail in article.

Kohhal
07-09-2004, 08:57 AM
I'm getting one uncached template, forumhome_subforumseparator_post, on most pages within the V3 Articles. How can I fix this?
Once you create your first category or article then that won't be a problem. That template is only used if one of the above is empty from what I remember...

the Sandman
07-09-2004, 11:08 AM
Once you create your first category or article then that won't be a problem. That template is only used if one of the above is empty from what I remember...It appears you are correct MasterG. Thanks!

Cold Steel
07-11-2004, 12:40 AM
<font color="yellow">* Cold Steel installs.
</font>

Nice hack.

Henry-RS
07-11-2004, 04:21 AM
Yeah, I have same problem with the thumbnail in article.

Ditto.

Kwak
07-11-2004, 05:40 AM
For those with version 3.0.3 and started from scratch (not upgrade), did the hack work for you?

Henry-RS
07-12-2004, 04:36 AM
Thumbnails don't work. Everything else was fine.

John
07-12-2004, 09:26 AM
Thumbnails don't work. Everything else was fine.

GD not installed?

Henry-RS
07-12-2004, 04:48 PM
Thumbnails work fine on my forum. The article thumbnails are not working.

alapo
07-12-2004, 07:30 PM
3.0.3 changed how thumbnailing works I think.

JustAskJulie
07-12-2004, 09:51 PM
If I turn off moderation per category, does it revert back to usergroup permissions?
IE. If I turn off moderation for the category but for my forums I have it set to moderate all posts from unregistered users, will it still moderate posts from unregistered users?

dndog
07-14-2004, 04:19 PM
I think I might have found a bug...whenever I write an article and use the word "on", it replaces it with "o*n". Am I the only one with this?

I am using vBulletin 3.0.1

ixian
07-14-2004, 04:25 PM
I think I might have found a bug...whenever I write an article and use the word "on", it replaces it with "o*n". Am I the only one with this?

I am using vBulletin 3.0.1


Yes. Doesn't happen to me, and "on" is so common in the English language that I guarantee someone would have reported it before now.

WreckRman2
07-14-2004, 04:25 PM
I tried to create a 2nd maini category and it didn't show it on the article page correctly. Not sure if this has been adressed yet or not.

Henry-RS
07-14-2004, 07:11 PM
Is this hack still being supported?

Daniel.C
07-14-2004, 07:14 PM
i keep getting this error with mine:
I run the install script and i keep getting this error:

Database error in vBulletin 3.0.3:
Invalid SQL:
INSERT INTO vb3_datastore VALUES('arcadesettings', 845)

mysql error: Duplicate entry 'arcadesettings' for key 1
mysql error number: 1062
Date: Wednesday 14th of July 2004 02:24:05 PM
Script: http://www.infinitiveintentions.com...tall_arcade.php
Referer:
Username: Sparky


What should i do to get rid of this error ? Is there anyway to empty the database of the arcade stuff.

kira
07-15-2004, 07:17 AM
This is a wonderful and useful hack. I'm having the same thumbnail issues as Henry RS on my 3.03 test forum (I'd show you but, well, it's my test forum!). GD 2+ is enabled, thumbnails are working on the rest of the forums. It's just the article thumbs that are showing up a broken image. Does anyone know what might be wrong?

(I should mention that the first test article I created before turning on the thumbnails on my forum is showing the correct "placeholder" image, i.e. the "file.gif" I uploaded as part of this hack.)

Other than this glitch, I love this addition to my forums, and can't wait to move my articles over to the new system. Many thanks, John!

JustAskJulie
07-15-2004, 03:13 PM
I've noticed another glitch.

If you are moderating articles/ comments and you delete one instead of validating it, when you look at the info on the articles page... it doesn't update there.

IE. On the category page it shows the last update as being one that I deleted. And on the article list page where it shows the comments, it shows two comments on one article where there is only one (there were two initially in moderation and I deleted one of them).

Mickie D
07-15-2004, 08:06 PM
how do i move a article placed in the wrong room by a member ?

also my thimbnails are not working also but by the looks of it, it will be done in an update so no rush.

but would like to know how to move an article into another room ?

bgtking
07-15-2004, 11:36 PM
Is there a way to make it so articles in a subcategory appear in the latest article column of the parent? Like how if in your forums a post is made in a subforum, it shows up as new in the first forum.

Littlebit
07-16-2004, 12:14 PM
I installed on 3.0.3 and have the same thumbnails issue...I also do have GD installed and enabled in vB and the server. I have a feeling you already know what the problem is, but wanted to mention for you.
Thank you for this hack John! I'm now able to tranfer all my html articles to the database.
If it's okay to put in a request, I'd like to be able to choose if the date, time and written by is shown or not with an option in admincp. Or even better if we can edit those in admincp.

Kwak
07-16-2004, 03:54 PM
I had the article working on 3.0.1.
I upgraded to 3.0.3 and the article script did not work because I had uploaded the new files (from 3.0.3.)

I redid the hack, modified files and uploaded for 3.0.3.
The article still not show up. I did the install again and the Full Installation does not work because the tables exists. I did the Install Templates Only and I found out the articles showed up.

BUT..when I click on a category, I get
Unable to add cookies, header already sent.
File: /home/ikwak/public_html/calpolyonline/forums/includes/functions.php
Line: 1730

Where do you suppose the problem lies in?

Kwak
07-16-2004, 03:57 PM
Also, how do you remove the Article script complete as I want to redo the hack??

It uninstalls but there tells me

"The database changes made to this vBulletin installation have been undone.
However, tables containing content and category information still remain. For security reasons, these tables must be deleted manually."

the Sandman
07-16-2004, 04:22 PM
I had the article working on 3.0.1.
I upgraded to 3.0.3 and the article script did not work because I had uploaded the new files (from 3.0.3.)

I redid the hack, modified files and uploaded for 3.0.3.
The article still not show up. I did the install again and the Full Installation does not work because the tables exists. I did the Install Templates Only and I found out the articles showed up.

BUT..when I click on a category, I get
Unable to add cookies, header already sent.
File: /home/ikwak/public_html/calpolyonline/forums/includes/functions.php
Line: 1730

Where do you suppose the problem lies in?Make sure there are no blank lines ("white space") below the final ?> tag.

Kwak
07-16-2004, 04:26 PM
Make sure there are no blank lines ("white space") below the final ?> tag.
For which file/template?

the Sandman
07-16-2004, 04:54 PM
For which file/template?Look in the error message ;)

Unable to add cookies, header already sent.
File: /home/ikwak/public_html/calpolyonline/forums/includes/functions.php
Line: 1730

Kwak
07-16-2004, 04:59 PM
Look in the error message ;)

Unable to add cookies, header already sent.
File: /home/ikwak/public_html/calpolyonline/forums/includes/functions.php
Line: 1730
I don't believe I have touched/hacked the functions.php file during or after the modifications. Should I really touch it (might get an error on the board)?

MissKalunji
07-16-2004, 09:25 PM
Is there any addon to show the articles on a none vb page???

Mike Gaidin
07-17-2004, 04:48 AM
For some reason on my article.php page it shows up as being in Debug Mode, but the rest of the pages on my site are not. Anyone see this before?

Blam Forumz
07-17-2004, 10:43 AM
John i love your hacks, :) Thanks, this'll help me alot :)

JustAskJulie
07-17-2004, 08:16 PM
Is there any addon to show the articles on a none vb page???

If you are using VBIndex there is a module to include your featured article.

Cold Steel
07-18-2004, 09:17 AM
Able to edit/delete articles from within the ACP or move it to another category.
This would be great.

H2k
07-18-2004, 04:53 PM
When i install this Great Mod it work with me Fine Just wheni try to go view the article i get this error

Warning: Division by zero in /forums/article.php on line 260



There seems to have been a slight problem with the Demo Forum database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

Database error in vBulletin 3.0.3:

Invalid SQL:
SELECT * FROM articlepost
WHERE type=2 AND articleid=1
ORDER BY postdateline ASC
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 4

mysql error number: 1064

Date: Sunday 18th of July 2004 10:44:46 AM
Script: http://localhost/forums/article.php?a=1
Referer: http://localhost/forums/article.php
Username: Admin
IP Address: 172.0.0.1


any fix please for this ..

thankyou

Logikos
07-18-2004, 05:20 PM
worked great on vB 3.0.3 :)

H2k
07-18-2004, 05:35 PM
Can u tell me how u let it work .. ?

KTBleeding
07-18-2004, 09:10 PM
I just upgraded to 3.0.3 and article.php keeps giving me a blank white page.

ShutDown23
07-18-2004, 09:18 PM
try re-installing the templates KT

KTBleeding
07-18-2004, 09:24 PM
try re-installing the templates KT
Blah, I feel like such a fool.

Thanks!

Snyper
07-18-2004, 11:39 PM
Thanks again for this great hack.

I have a Little Prob with a Attachments (?jpg &gif)
See a Screennshot ( Displayed a Red Cross and no Images)

Can everybody help ????

( GD2 is installed and enabled )

Big ThX :nervous: :nervous: :nervous: :nervous: :nervous:

Mike Gaidin
07-19-2004, 12:47 AM
EDIT: Nevermind, I fixed my problem.

nickels376
07-19-2004, 04:14 PM
I've got a real quick question, posting HTML into the Articles system is causing a spacing issue where the HTML is listed almost a page down and the rest of the space is blank - You have to scroll down to get to the actual article and the tables are all spaced out whacky.

Is there something I'm doing wrong?

-Dom

LoOnEyToOnZ
07-23-2004, 12:07 AM
Conclusion - Does v3articles work on 3.0.3 ?

MissKalunji
07-23-2004, 12:22 AM
Conclusion - Does v3articles work on 3.0.3 ?



Yes perfectly :D

bgtking
07-23-2004, 12:45 PM
Not perfectly... attachment thumbnails do not work right.

Littlebit
07-23-2004, 01:13 PM
not perfectly for me ... the images and thumbs are not functioning with 3.0.3

mixylplik3
07-23-2004, 02:15 PM
*clicks uninstall

j_86
07-23-2004, 04:35 PM
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

TTG
07-23-2004, 06:47 PM
Thankfully installed on my test forum before installing on main ..
Too many missing icons in too many different areas and uploaded images don't show .. GD is enabled and Rebuild Attachment Thumbnails done .. think I'll come back to this thread in a few weeks when all the bugs have been ironed out .. :)

Littlebit
07-23-2004, 07:09 PM
I think the changes vB made to fix that SQL error while building attachment thumbnails may be why the images are wacky now with this hack... I'm sure John's all on fixing it for next release.

MissKalunji
07-23-2004, 07:10 PM
not perfectly for me ... the images and thumbs are not functioning with 3.0.3

The Thumbnail use to work now it doesnt work :disappointed: if i click on the image it shows up but when im just looking at the article...it doesnt show up :-(

How to fix it?

for some reason im having the same problem with the Member Profile Picture hack :disappointed:

j_86
07-24-2004, 10:18 AM
When I hit *rebuild thumbnails*, it messed it up even further.

* j_86 hits uninstall, but so much wanted something like this :(

Brinkley
07-24-2004, 01:34 PM
I have vB 3.0.2 and Thumbnails & Graphics do not go.

See my old Thread ... :disappointed:

Help John !!!!!!

Big ThX :nervous: :nervous: :nervous:

Mickie D
07-25-2004, 11:16 AM
how do we move a article that was posted in the wrong section ?

thanks very much for any help

PS the gifs(thumbs) are not working for me in 303 but not a huge problem ;)

just cant move the wrongly submited articles

alzibub
07-25-2004, 06:16 PM
Hi,

I have installed this on VB3.0.3 - and am having issues - sorry !!
It is a clean install of this hack...

When I navigate to the article.php - and then click on either 'Main Catagory' or 'Main Sub-Catagory' - I get an SQL error as follows...

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

Also - I can't see any buttons for adding a new Article - I figure they are on the next page but cant get that far because of this error...

I have removed and re-added using the install file - but still the same :(

Sorry - any assistance greatly appreciated
Cheer

Tigga
07-26-2004, 12:44 AM
Nice work John, I'm using it on my personal site. :)
One thing I noticed though... I don't believe I'm the one that created your templates. ;)

Koutaru
07-26-2004, 02:40 AM
I've noticed a really small thing, when you comment, the "" and & shows a HTML standard code. ?_? Anyway to fix?

spence2
07-26-2004, 03:07 AM
Is there any chance that this wonderful hack will be updated to work with vB3.03?

TTG
07-26-2004, 10:43 AM
Clicked install .. great hack .. will prove very useful .. added today and now playing around with it and had no problems.

Installation instructions easy to follow.

Edited / added a couple of changed graphics to fit my theme and all now working well.

http://www.thetechguys.co.uk/forum/article.php?

Datenpapst
07-26-2004, 01:21 PM
your a great man John ;)


Really good hack. Installed it in my board.

spence2
07-26-2004, 02:27 PM
If you successfully install this hack, could you please mention in your "thank you" to John which version of vB you are using?

'Just trying to confirm that it works without further modifications on vB3.03 ... thanks for the info!

Fargo
07-26-2004, 05:32 PM
*installs

Worked great, John!

Still one minor issue though. I can post small articles and I can include more content to existing articles, however if I post one LARGE article, nothing will be added (nothing includes, title as well as content).

Now, ive read through all posts in this thread, and im making a guess that the following post indicates the problem I am having:

https://vborg.vbsupport.ru/showpost.php?p=524214&postcount=195

If this is by design, what would I need to do to alter this so I can post large(r) amounts of text at one time? If this is a bug, is there any immediate plans to fix it?

Thanks again for a great mod!

MissKalunji
07-26-2004, 05:37 PM
Still looking for a hack :disappointed: dat display sthe latest Article on a none vb pages n e one?

alzibub
07-26-2004, 06:13 PM
Hi,

I have installed this on VB3.0.3 - and am having issues - sorry !!
It is a clean install of this hack...

When I navigate to the article.php - and then click on either 'Main Catagory' or 'Main Sub-Catagory' - I get an SQL error as follows...

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

Also - I can't see any buttons for adding a new Article - I figure they are on the next page but cant get that far because of this error...

I have removed and re-added using the install file - but still the same :(

Sorry - any assistance greatly appreciated
Cheer

Not sure what happened - but my other admin was able to view the Articles, post articles the whole 9 yards - I then re-checked and now I can see it all - no probs...

Got no idea what changed - so can't elaborate...

In response to spence2 - I have VB3.0.3 - I have rolled it through all upgrades since RC2 of VB3 - and yeah it now works.... although no idea what caused the initial SQL errors I was getting..

Cheers for a cool hack :D

Mephisteus
07-26-2004, 07:07 PM
very handy, very handy indeed.

trekwarfare
07-27-2004, 03:36 PM
I'm thinking of using a section of this for my members player sheets. Is there anyway to prevent extra spaces in posts from being removed?? Our character sheets have tabbed columns, and when posted, those are removed (the extra spacing that is).

Just wondering if there is an easy way to go about this??

Thanks for the wonderful hack!!!!!

pjdaley
07-27-2004, 03:48 PM
Still looking for a hack :disappointed: dat display sthe latest Article on a none vb pages n e one?


same here

MissKalunji
07-27-2004, 08:49 PM
same here

Welcome To the club


Did anyone find a way to fix the thumbnail issue in vb 3.3??

TheLegendofLink
07-29-2004, 08:02 PM
Hey would it be possible to make this an add-on for any of the Portal systems on vB.org? I think this would be perfect for a Review section for my Zelda site I am in the process of making. Thanks to anyone who replys.

- TheLegendofLink.com

Edit: Nvm I found a place on the Add-on section of the vB3 hacks, and it should do what I want. Great hack I will install this later.

- TheLegendofLink.com

Mickie D
07-29-2004, 08:28 PM
it would be nice to just be able to move the articles if they are posted in the wrong section :(

and will this be updated for 3.0.3 ?

if not i will uninstall ... no i am not having a pop this is a wonderful hack but images are kinda important so it was just a question if it will be please :)

Regards

j_86
07-29-2004, 09:19 PM
So much for "The Author(s) agreed to give support for this modification!" :(

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;

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
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...

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
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
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
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:

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
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
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!

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:

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/article.php?do=editcomment&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.php?p=520774&postcount=114

JustAskJulie
08-12-2004, 06:19 PM
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
how search the artides?
Insert this HTML anywhere in a template within the default forums directory

<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
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...

bing11
08-15-2004, 03:52 PM
Insert this HTML anywhere in a template within the default forums directory

<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.
thank you
It looks nice

Pitman
08-15-2004, 10:11 PM
thank you
It looks nice
The search function doesn't use page navigation, it shows all of the search results on one page. I think that may be the reason it wasn't added in the intial release, I'm sure it will be fixed in the next version :)

rs-host.net
08-16-2004, 02:58 PM
Installed , and working good.

soccerclue
08-16-2004, 09:00 PM
Hi, I found out that when you post an article the number of posts of the user is counted. However, when I tried to delete the articles, the number of posts of the user cannot be adjusted. Does anyone know how to fix this? Hope someone can fix this for me. Thanks. Other than that, this is a really nice hack.

mariannet
08-17-2004, 07:32 PM
I actually had the exact same error during testing, and then found that I had to save vBulletin Options to fix the problem.

But of course that can't be it, because you followed the instructions - right?

Hoho.. thanks!
Glad I found it on page 3!

mariannet
08-17-2004, 08:06 PM
Anyone got the "link instead of thumbnail" working?
No news on moving articles?

Shame, I love it and my kids will love it, but the thumbnail thing is the only thing holding us back :(

xug
08-18-2004, 02:38 PM
very nice :)

monstergamer what do you use for your review/cheat section ?
Looks so good on your website


Mone'


I have extended that hack to the fullest!!!

Have a sneak peak, will be released after my vB3 (XUG V4) goes Live! (Hopefully within a week or two and only when there is a demand for)

https://vborg.vbsupport.ru/

j_86
08-18-2004, 03:40 PM
OH MY GOD I want!!

MissKalunji
08-18-2004, 06:01 PM
I have extended that hack to the fullest!!!

Have a sneak peak, will be released after my vB3 (XUG V4) goes Live! (Hopefully within a week or two and only when there is a demand for)

http://www.rhyze.net/tease4.jpg


What did you do to make the thumbnail work??
are you using vb 3.03??

John
08-18-2004, 07:35 PM
I have extended that hack to the fullest!!!

Have a sneak peak, will be released after my vB3 (XUG V4) goes Live! (Hopefully within a week or two and only when there is a demand for)

Bad timing, there's going to be an update to this next week.

xug
08-18-2004, 07:45 PM
Bad timing, there's going to be an update to this next week.

Why Bad Timing?

Not for me at least, because it is exactly what I want and need and it runs so smooth and I use this as for reviews and previews made by me and my team, the members must be satisfied with vBArticles that I turned around for the member review section :D

Sanity
08-18-2004, 07:46 PM
Bad timing, there's going to be an update to this next week.

Any new features John?

Some bugs (dont know if they have been posted before):

- Preview works, but the $message in the editor is empty and so the editied posting after sending
- Last user who made a comment isnt linked to his profile (linkvalue is empty
- Questionmarks wont be parsed (it shows the HTML-Code instead)

xug
08-18-2004, 07:47 PM
What did you do to make the thumbnail work??
are you using vb 3.03??

The Thumbnails are Photopost Powered, when you click on the thumnail you will go to that image in that games category within photopost.

MissKalunji
08-18-2004, 07:51 PM
Bad timing, there's going to be an update to this next week.


Hurray i cant wait!!!!!!!!!!!!

j_86
08-18-2004, 07:59 PM
John I love you!!

PLEASE fix attatchments! Please fix table prefix erros! Please let us change rating! Please update post counts! Please delete attatchements when you delete an article!

And, if you have time, store attatchments to files?

arpy
08-18-2004, 09:04 PM
You can find a fix for the thumbs problem here:
https://vborg.vbsupport.ru/showthread.php?t=68495

I opened a new thread because this is really to large ;)

arpy

MissKalunji
08-18-2004, 09:10 PM
You can find a fix for the thumbs problem here:
https://vborg.vbsupport.ru/showthread.php?t=68495

I opened a new thread because this is really to large ;)

arpy



IT WORKS!!!!!!!!!!!!!!!!!!!!!!!!!! HIGH FIVE :nervous:

Thx thx


still looking for a hack that displays the latest article on a none vb page :ermm:

xug
08-18-2004, 10:59 PM
And the image size permission!!!

John
08-19-2004, 06:11 PM
Any new features John?

Some bugs (dont know if they have been posted before):

- Preview works, but the $message in the editor is empty and so the editied posting after sending
- Last user who made a comment isnt linked to his profile (linkvalue is empty
- Questionmarks wont be parsed (it shows the HTML-Code instead)

For certain reasons, v3 Articles was coded as a standalone system which was then combined with vBulletin. Because it was a whole new system, there were a few bugs which needed to be worked out.

The new version is very different to the old. It's completely integrated with vBulletin, in the sense that it's entirely based on the thread/post system. Because of this, the biggest benefit is that you get the stability of vB3 - everything works in much the same way as the rest of the forum, so you get all the additional features threads have. (Such as polls, for example.)

The difference is that threads are called articles, and posts are called comments. And of course, the layout is geared towards article presentation, as well as all the old v3 Article features.

Ted S
08-19-2004, 06:31 PM
John,
I assume you are mostly trying to stabalize the system to make it work better but I don't suppose that in this version or a later one you could make it possible to allow articles to be moved under a new user account? A lot of our articles come from people who aren't on our forum or don't want the article to show under their actual username so I generally post them and then have to move them into a new user account but I don't think vbarticles allowed for that in the past.

Thanks again for the amazing hack, I spent all weekened fine tunning an external script that I wrote in the past and now I see its probably all a waste :)

JustAskJulie
08-20-2004, 12:36 AM
Fixes:
Show correct profile info when username is clicked.
If articles are allowed from unregistered users but moderation is turned on the system currently lets unregistered users view the unmoderated articles submitted by unregistered users.

My suggestions:

Allow articles to moved from one category to another
Show date article is submitted

tteal
08-20-2004, 12:47 AM
For certain reasons, v3 Articles was coded as a standalone system which was then combined with vBulletin. Because it was a whole new system, there were a few bugs which needed to be worked out.

The new version is very different to the old. It's completely integrated with vBulletin, in the sense that it's entirely based on the thread/post system. Because of this, the biggest benefit is that you get the stability of vB3 - everything works in much the same way as the rest of the forum, so you get all the additional features threads have. (Such as polls, for example.)

The difference is that threads are called articles, and posts are called comments. And of course, the layout is geared towards article presentation, as well as all the old v3 Article features.

Does this mean that it will soon work with VB 3.0.3? Just wondering. I tried installing and like most folks, it didn't work so I had no choice but to abort due to SQL errors.

Razgo
08-21-2004, 06:22 AM
i would also like to see it take on the settings my attachments have in the forums. currently i have attachments set to upload 3 at a time. but this is not carried over in the article hack.

thanks.

John
08-21-2004, 12:08 PM
Does anyone actually use captions? I'm thinking about whether to keep them or not.

MissKalunji
08-21-2004, 12:09 PM
Does anyone actually use captions? I'm thinking about whether to keep them or not.


I do but i dont think its really necessary :rolleyes:

j_86
08-21-2004, 01:51 PM
John; the ability to either use Database attatchments or the file system, and the automatic deletion of related attatchments when an article is deleted.

Nam
08-21-2004, 10:52 PM
THANKS FOR THE AWESOME HACK....!!!!! YOU ARE DA BEST!!!!

INSTALLED

Lionel
08-23-2004, 03:38 AM
has anyone got a fix for updating moderation in article front page display?

opus
08-24-2004, 04:20 PM
is it possible to make the articles look less like threads?

GMeadows
08-24-2004, 05:04 PM
Any tips on how to center the introduction text?

Gary

spence2
08-25-2004, 10:12 AM
Thank you for upgrading this great hack, John!

cclaerhout
08-25-2004, 12:44 PM
Thank you for upgrading this great hack, John!
Thanks for this great hack. Another advice, it would be great if the search fonction could work also with V3 Articles. And please, keep de captions, it can be very usefull.

MissKalunji
08-25-2004, 12:48 PM
Hey did he posted the update of the hack?

Caiman
08-25-2004, 01:25 PM
Installed with ease, everything works great, awesome hack

*Install

Symbian.info
08-25-2004, 03:23 PM
Wait with the install until the new version is there (have VB 3.03) That will come this week you said early on?? But so far looks great!

spence2
08-25-2004, 05:31 PM
Hey did he posted the update of the hack?

Not yet.

MissKalunji
08-25-2004, 05:52 PM
Not yet.



oki thx

tteal
08-25-2004, 09:11 PM
Will an update be posted soon for 3.0.3? any idea?

spence2
08-27-2004, 09:46 AM
. . . there's going to be an update to this next week.

That was posted on the 18th and today is the 27th; so, hopefully, that means any day now.

John
08-27-2004, 09:56 AM
That was posted on the 18th and today is the 27th; so, hopefully, that means any day now.

It's done, I just haven't packaged it up yet.

spence2
08-27-2004, 10:09 AM
Sweetness!

cclaerhout
08-27-2004, 11:52 AM
I'm happy, even if it means i'll have to translate it again in french ;-)

www.tfw2005.com
08-27-2004, 03:56 PM
Can I have the Articles sort alphabeticaly instead of as summitted. Looking through the code, but wanted to get a post started here.

Thanks for this hack, I know I as well as others really needed it.

In case anyone else is searching this thread for this, I found it.

In your includes/functions_articles.php file


Find this:

$articles = $DB_site->query("SELECT * FROM " . TABLE_PREFIX . "article
WHERE categoryid=$cid $moderationSQL ORDER BY dateline DESC LIMIT $start, $finish");

Replace with this:

$articles = $DB_site->query("SELECT * FROM " . TABLE_PREFIX . "article
WHERE categoryid=$cid $moderationSQL ORDER BY title ASC LIMIT $start, $finish");


ASC is forwards, DESC is backwards. Datline is by post date, title is by alphabetically. I suppose you can also sort by other variables by replacing the word "title" in there, but thats up to you to figure out.

Later!

Mickie D
08-27-2004, 07:54 PM
cant wait for the new update :)

well done all involved

Fargo
08-28-2004, 10:04 AM
John, is there any possibility to give us a spoiler of what to expect with the new version (that is, if you don't forsee releasing it in the next day or so).

Not sure if you were including new features or just making bug fixes...

I would REALLY like to see an article description field included if possible. This would be shown under the title in the articles list, and would allow users to get a better idea of what the article is about before navigating to it. :)

trackpads
08-28-2004, 12:33 PM
John, is there any possibility to give us a spoiler of what to expect with the new version (that is, if you don't forsee releasing it in the next day or so).

Not sure if you were including new features or just making bug fixes...

I would REALLY like to see an article description field included if possible. This would be shown under the title in the articles list, and would allow users to get a better idea of what the article is about before navigating to it. :)
John,

Please dont forget about the counting articles in sub-sub-forums!

thanks for all your work!

-Jason

Host Directory
08-30-2004, 12:26 AM
I guess i will wait for the update before installing this hack.

Does anyone know what the deal is with uninstalling the hack ( if ever i wanted to )?

I notice it keeps with an install script... so does it also come with an unistall script or is this not needed?

Ted S
08-30-2004, 01:10 AM
The install script has a remove feature which works out very nicely.

Host Directory
08-30-2004, 01:12 AM
Cool.. i will be waiting for the update since its almost ready and then i will install this one.

zetetic
08-30-2004, 01:54 AM
Tiny Bug:

On Article index page, username under "Last comment by" doesn't link to user profile as it should.

Solution:

Edit template: article_lastcommentby

Find:

<phrase 1="member.php?$session[sessionurl]username=$article[lastposter]" 2="$category[lastposter]">$vbphrase[by_x]</phrase>

Replace with:

<phrase 1="member.php?$session[sessionurl]username=$category[lastposter]" 2="$category[lastposter]">$vbphrase[by_x]</phrase>

TCB
08-30-2004, 10:31 AM
Looking forward to install this one on 3.0.3 :D

Any news on when the update might be released?

Ghostsuit
08-30-2004, 04:45 PM
I was about to install this as well. Guess I'll wait on the new version. Any idea when it will be packaged John?

integra99
08-30-2004, 04:59 PM
It's done, I just haven't packaged it up yet.
Package it up!

deaconxgp
08-30-2004, 05:29 PM
is there any reason why when i add images to the article they all show as red X's...?? i can click them and view them just fine but at the end of the article when you view the media thumbnails...they're nothing but red X's

also, how do i get an image next to the featured article?

j_86
08-30-2004, 05:45 PM
Why not read through the thread ;)

MissKalunji
08-30-2004, 05:47 PM
Package it up!


package is up???

deaconxgp
08-30-2004, 06:33 PM
Why not read through the thread ;)

i did read through it, and i tried the other thread with the thumbnail fix but it still didn't work.

any ideas?

TCB
08-31-2004, 06:51 AM
package is up???

Yeah, John mentioned almost a week ago that the update was ready and that he only needed to package the files. So Integra99 refers to John's statement and 'asked' (in a pushing way ;)) 'please package up'...

Can't wait John :p

Nam
08-31-2004, 01:56 PM
If you are using VbIndex is there a module to include your featured article??? PLEASE PLEASE HELP....THANKS SO MUCH!!!!

spence2
09-01-2004, 12:27 PM
Originally Posted by spence2
That was posted on the 18th and today is the 27th; so, hopefully, that means any day now.
It's done, I just haven't packaged it up yet.

Please pack 'er up for all us 3.03 souls groveling at your feet. :squareeyed:

trackpads
09-02-2004, 06:31 AM
Is it possible to run two article systems on the same board?

AlfonsoC
09-02-2004, 02:01 PM
Hi....

Need a complete description of tables used by v3 articles 1.0.1... seems that something went wrong in the installation and some tables weren't created okay. So I cannot uninstall or install another time.

So, anyone can put the layout of the tables associated with v3 articles, please.

Host Directory
09-02-2004, 05:34 PM
I couldn't wait for the new version - so i installed and everything works fine. Great hack but can anyone tell me what code i might need to change to do the following?

I would like to be able to place announcements in the articles section so that i request my users to write the articles and offer them link backs, ect.

I would also like to sticky some articles ( like sticky thread ) that are popular.

Anyone know how to do that? I think it would make this hack complete.

MissKalunji
09-03-2004, 02:45 PM
anyone would be able to write a script for me? to show up the article in a non vb page

if yes please e-mail me : jamaican_dymes69@hotmail.com
Or send me a pm

I willing to pay!! i need it :nervous:


Thank u ppl

Host Directory
09-03-2004, 02:54 PM
Yeah i wanted to be able to add it to a non vbpage also. They could put a option for admins to send the article to a non vbpage but it would have to be able to write the article into a menu system on another page. So it created a new link on a non vbpage - leading to the article on a non vb page.

I guess that would take a bit of coding.

AlfonsoC
09-03-2004, 07:03 PM
After various days of battling with this hack. After trying to search more information about the table schema used by it, after sending several e-mails to the creator, after posting a request for information here (read my previous post to this) and today asking another time support for the creator (and willing to pay for this).

Got extremely p*ssed with this rogue hack and decided to get rid of it COMPLETELY of my system until a future version who solves the fails and cleans everything and deficiencies.

To get rid of v3 from your database you need to follow this simple steps:

0. MAKE A BACKUP OF YOUR DB! It's vital to recover it if anything goes wrong. This steps are done by me, but everything can fail and send your Forums DB to h*ll... Give yourself a second chance to get completely cleaned.

1. I assume that you tried to uninstall it via the install.php script provided by the programmer of the hack. If not, do it and follow next steps to get a completely clean system another time.

2. Connect to your database (check with your provider if your database is on a remote server), this is my case, so you need to issue from a shell of your account this command: mysql -h databasehost -D databasename -p -u yourusername

3. Issue this command on the mysql client: drop table articles ; repeat this command (drop table) with the next tables: articleattachment, articlecategory, articlepost, articlerating. This deletes phisically those tables from your database, note that at the end of each drop table <table name> you need to end that line with ; and double check the table name...

4. Next command is very delicate, so check ten times if needed before hitting enter, because will do surgery with a table who is vital for your forums and only you want to remove a column on a table, not restoring the database and start another time from step 2. :rolleyes:
On the mysql client you need to issue this command to remove the column added by the installer: alter table usergroup drop column articlepermissions ; (Note the ; at the end of the sentence).
Depending of the table size (small.... very small unless you run thousands of different groups) mysql client can wait for some time to return the control.

5. You've done it!. Probably you will have some more little bits from v3 articles on you DB (watch on phrase manager & template manager). But at least you've cleaned manually your DB (who the install script doesn't do giving the excuse of 'keeping' the content... wth! I want to get rid of everything!) and if you from time to time find anything you can safely remove it with complete peace of mind (will do, at least for this version).

6. Follow the install directions another time, but deleting what you added in the past (do some backups of the files before applying surgery - copy them to filename.php.original for example).

7. Remove the files you added.

8. Last but not least, click Uninstall on this thread if you previously clicked Install.

Edit:

If you followed those steps in the order I've told you, seems to be 99% uninstalled, just found little bits hanging on the DB. So... since Uninstall doesnt work as intended, you need to thank the autor to do manually. Additions to the uninstall procedure.

Fire a shell session and connect to your mysql database (just follow another time step 2 on the procedure).

Do a simple query like this: select * from settinggroup where grouptitle="v3_articles" ;

MySQL will surely return you a row as a result. In this case, fire this command: DELETE FROM `settinggroup` WHERE `grouptitle` = 'v3_articles' LIMIT 1 ;

Revised all my tables and didn't found more things related to v3 articles on my system, so if you want/need it... following those simple steps will give you a 99.99999999(pure period)% system.

Host Directory
09-03-2004, 07:17 PM
Sorry it didnt work out for you AlfonsoC. I installed this hack on my board and had no problems with it.

Its working fine for me.

TCB
09-04-2004, 06:32 AM
Sorry it didnt work out for you AlfonsoC. I installed this hack on my board and had no problems with it.

Its working fine for me.

What vb version are you running? 3.0.1 ?

Host Directory
09-04-2004, 02:31 PM
TCB i am running vb3.0.

Zachariah
09-05-2004, 01:25 PM
Hi....

Need a complete description of tables used by v3 articles 1.0.1... seems that something went wrong in the installation and some tables weren't created okay. So I cannot uninstall or install another time.

So, anyone can put the layout of the tables associated with v3 articles, please.

Take apart the install files or XML imported files in the hack.

Host Directory
09-05-2004, 11:57 PM
Does anyone know what i might do to make the article system do this.

I want to be able to add html on the main article template so that i can put a graphic saying ( Write articles for us ) and maybe a html text description next to it saying something like - Volunteer article writers needed.

The graphic would point to - http://www.yourdomain.com/forums/profile.php?do=editusergroups , so they could opt to join.

Obviously this html ( graphic and description ) would only show to members who did not have permission to write articles - otherwise the add an article graphic would show instead.

Should be easy to do this but i am not a coder.

Anyone have any suggestions?

spence2
09-06-2004, 02:27 AM
... there's going to be an update to this next week.

That was posted on the 18th and today is the 27th; so, hopefully, that means any day now.
It's done, I just haven't packaged it up yet.

Does anyone have an idea what is delaying this release?

JustAskJulie
09-06-2004, 03:39 AM
If you are using VbIndex is there a module to include your featured article??? PLEASE PLEASE HELP....THANKS SO MUCH!!!!

I believe there is one on the VbIndex site.

SamirDarji
09-07-2004, 11:50 PM
Hey Julie, looks like I see you everywhere ;)

Goodspeed
09-08-2004, 09:01 PM
Great hack!

I've a question: Is it possible to move articles between categories?

cclaerhout
09-09-2004, 07:12 AM
Great hack!

I've a question: Is it possible to move articles between categories?

No. May be in the next version that everybody's waiting for.

blueuniverse
09-09-2004, 04:39 PM
Yeah, I'm pretty sure that should be in the next version, as he mentioned it would be a lot more like the default posting, thread system.

Any update on the release?

Ghostsuit
09-09-2004, 04:56 PM
Last I spoke to him (day or two ago) he still hadn't packaged it. Probably just busy.

SamirDarji
09-09-2004, 06:05 PM
Anybody have an exact list of the issues that the new package will address?

JamesFrost
09-10-2004, 12:09 PM
John,

another great hack. Is there any plan to allow users to give reputation to articles that they like?

James Frost

Ghostsuit
09-10-2004, 12:17 PM
Never know could be in the new version thats soon to be released, just have to wait and see :)

cosmin
09-10-2004, 02:32 PM
--

post reference 1: https://vborg.vbsupport.ru/showpost.php?p=536854&postcount=304

post reference 2: https://vborg.vbsupport.ru/showpost.php?p=537188&postcount=313

--

i am having this same problem. i went through the install.php file and everythign was fine til i clicked on the default 'Main Sub-Category' link from /forumroot/article.php .... then it took me to the error message:Database error in vBulletin 3.0.3:

Invalid SQL: SELECT * FROM article
WHERE categoryid=2 AND (articleuserid=31 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
...i uninstalled v3articles, and manually deleted all additions to the DB, and REINSTALLED, yet still the same issue :(

... any help?

blueuniverse
09-10-2004, 04:35 PM
It would probs be best to wait for the new version.

Ghostsuit
09-10-2004, 04:47 PM
It would probs be best to wait for the new version.

Thats what I'm doing...though it's so tempting :D

cosmin
09-10-2004, 04:57 PM
--
i see.

i noticed at their website the new v3Articles forums... but it didnt give me access. wasnt sure if it is a paid hack. anyway. this thread is subscribed, will check back soon! :D

thanks for your input.

Ted S
09-10-2004, 09:49 PM
I've spoken with John and while I am confident that vba will be a GREAT hack don't expect a ton of feature additions (although I'd be there are a few). Just plan for a solid, well working hack which is exactly what most of us need. Bells and whissles come down the road and for a free system I'm already amazed...

Neutral Singh
09-11-2004, 08:16 AM
Thanks for this great mod... installation was with out even a single hitch but then I am having following problem in vBulletin 3.0.3 while runing article.php. Is this hack compatible with this version. ? Thanks in advance.

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

yowen
09-11-2004, 10:51 AM
I have tried to create a word count for my articles, a word count that would show up under the rating, but I cant get it to work. Do any of you guys know of a way to get this done? I tried the search but couldnt find a way.

SamirDarji
09-11-2004, 04:07 PM
--

post reference 1: https://vborg.vbsupport.ru/showpost.php?p=536854&postcount=304

post reference 2: https://vborg.vbsupport.ru/showpost.php?p=537188&postcount=313

--

i am having this same problem. i went through the install.php file and everythign was fine til i clicked on the default 'Main Sub-Category' link from /forumroot/article.php .... then it took me to the error message:Database error in vBulletin 3.0.3:

Invalid SQL: SELECT * FROM article
WHERE categoryid=2 AND (articleuserid=31 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
...i uninstalled v3articles, and manually deleted all additions to the DB, and REINSTALLED, yet still the same issue :(

... any help?

Strange. I'm running it on 3.0.3 and the installer worked fine. What version of MySQL are you running?

Mickie D
09-11-2004, 04:58 PM
i cant seem to find the 3.0.3 version has it been released yet ?

and is there a fix to the no image's if the new vb articles ahs not been released yet ?

Regards
Mick

lovevn
09-11-2004, 05:46 PM
Thanks a lot for releasing this John..

as for why this is better than a forum, it`s a more structured layout... for searching, archiving purposes..

Wel, I have realized one thing. That is we can not use search funtion of the forum to search in the article. Does any one know the way to sovle this problem?

SamirDarji
09-11-2004, 06:35 PM
I'm thinking that if there is a way to get the articles indexed similarly to threads and the search routine re-written to include article indexes, it might work. I'm thinking of a solution to the same lack-of-a-search problem for the calendar. But there is no quick solution to this issue and is one drawback to having this hack vs using a forum for article posts (which would be searchable).

nelto
09-12-2004, 04:12 AM
Working on 3.0.3.
Me clicks install

Btw is this possible to integrate with VBA?
Like showing on the main page just like the thread system it has?
If so can some one please tell me how?

cosmin
09-13-2004, 01:55 PM
Strange. I'm running it on 3.0.3 and the installer worked fine. What version of MySQL are you running?--
currently the server is running: MYSQL Version 4.0.20-standard-log

..could that be the issue? seems like most people can install and it works fine... mine i installed and all works except for viewing the articles when i click on the SUB-CATEGORY :(

SamirDarji
09-13-2004, 03:29 PM
--
currently the server is running: MYSQL Version 4.0.20-standard-log

..could that be the issue? seems like most people can install and it works fine... mine i installed and all works except for viewing the articles when i click on the SUB-CATEGORY :(

That's probably not it since I'm running 3.23.54-max-debug. But I have run into a problem with seeing my main forums with no one logged in on certain computers. It's weird.

My test setup runs off an external usb drive, so I can take it anywhere with me and work. Well, on my home 98se system as a server, the forums don't show up to someone not logged in, and they should. But on a win2k or xp system they show up fine. And it's the same stuff running off the same drive. I'm dumbfounded and pretty mad at the same time.

cosmin
09-13-2004, 05:40 PM
--
thanks for your input and help SamirDarji,

our site is hosted on a server that runs LINUX. anyone else have any ideas why this error occurs?

has anyone else installed it on a LINUX server and had this mySQL issue?

SamirDarji
09-13-2004, 11:45 PM
Since it was pointing to a problem with line 2 of articles.php, did you look at line 2 and see what might be going on?

rex_b
09-13-2004, 11:57 PM
how can we add the stars to like the showthread lookalike part.

cosmin
09-14-2004, 01:44 AM
--
for everyones FYI... i did this from the INSTALL notes ... and it now works.2. Log into the Admin Control Panel.
Expand "vBulletin Options", and click on the "vBulletin Options" link.
Scroll to the bottom, click v3 Articles - click "Edit Settings".
Click on "Save".

Expand "Usergroups" on the left. Click "Usergroup Manager".
Edit the settings for any usergroup, and click "Update".

SamirDarji
09-14-2004, 02:09 AM
I'm glad you found the problem. I'm surprised you could even see the main category. Did you do this when you initially installed or just now?

I intially had problems seeing my forums until I did that too, but I still have that goofy problem where I can't see them when running on the 98se server. I've even tried doing the save settings again with no luck.

Symbian.info
09-15-2004, 03:03 PM
i cant seem to find the 3.0.3 version has it been released yet?
and is there a fix to the no image's if the new vb articles ahs not been released yet ?


Nope, i am also still waiting (long time :cheeky:) I hope that John find some time to release it...

spence2
09-15-2004, 04:07 PM
August:

... there's going to be an update to this next week.


That was posted on the 18th and today is the 27th; so, hopefully, that means any day now.


It's done, I just haven't packaged it up yet.

September:

Does anyone have an idea what is delaying this release?

September 15th <2004> ... were you possibly just having a little "fun" with us, John?

TheMusicMan
09-16-2004, 01:37 PM
I have an issue with <img> tags not parsing the html on the featured article page.

I have just started using the v3Articles on my www site, and currently have only a few articles on there. I have an article I want to feature that has an image in the first few lines. When I select 'Feature this article' - the display on the featuerd article page does not parse the <img> html code correctly, and the URL for the image shows up instead of the image itself.

I understand that this might have been a design decision to keep the featured article page small, neat and tidy - and a sensible decision too. However, is there a way to overide this setting and allow the <img> code to be parsed thus showing the image not the anchor...?

Here's the link > http://www.themouthpiece.com/vb/article.php

Thanks

Milorad
09-16-2004, 06:53 PM
I would like to display the author's profile picture instead of their avatar.

how would I go about that?

The Geek
09-16-2004, 06:59 PM
I would like to display the author's profile picture instead of their avatar.

how would I go about that?
Hope no one thinks im rocking the boat...

But I was interested in this mod until it struck me that you should be able to do virtually everything this mod does with a handful of template modifications couldnt you? You could simply insist on a particular forum using a particular style (one modified to this layout).
That way you could also get the search facility (the key reason I didnt install right away).

Like I said, correct me if I am wrong. I would be very interested in something like this... but it doesnt make sense for it to not come up in a search.

Thanks ;)

TheMusicMan
09-16-2004, 10:32 PM
Can someone please advise me how to enable SuperModerator Moderation of submitted articles. I am trying to find out how the submission engine works when I choose Moderate Articles.
At the moment, the only usergroup who can actually see submitted articles is Admin and I cannot find a setting anywhere that allows me to have the usergroup SuperModerators as Moderators of submitted articles.

Can anyone offer some advice here please.

And... is there soon to be a support forum for v3Articles at the authors site?

Host Directory
09-17-2004, 04:11 PM
Can someone please advise me how to enable SuperModerator Moderation of submitted articles. I am trying to find out how the submission engine works when I choose Moderate Articles.
At the moment, the only usergroup who can actually see submitted articles is Admin and I cannot find a setting anywhere that allows me to have the usergroup SuperModerators as Moderators of submitted articles.

Can anyone offer some advice here please.

And... is there soon to be a support forum for v3Articles at the authors site?
You just goto your usergroups and your find the usergroup for super moderators.. click on go and then scroll down. Your see a list of options for articles, enable the features you want that usergroup to use.

TheMusicMan
09-17-2004, 04:23 PM
...but I don't see any options for actually giving permission for that usergroup to actually Moderate the Articles... there's no option for that there!!!

See screenshot!

Any advice?

Host Directory
09-17-2004, 04:26 PM
Yes there is, its under general permissions and above forum viewing permissions.

If you can see those permissions and not article permissions you have done something wrong when installing the hack.

TheMusicMan
09-17-2004, 04:27 PM
Yes, I agree there is a section for Articles, but no entry for 'Moderate Articles' in that section... see previous screenshot uploaded after you posted!

Host Directory
09-17-2004, 04:36 PM
But you have edit own and other articles - which is the same thing.

m0h2
09-17-2004, 04:36 PM
Yes, there is no option for moderating the articles.

TheMusicMan
09-17-2004, 04:38 PM
But you have edit own and other articles - which is the same thing.

Thanks for replying quickly here by the way... much appreciated

But my Super Moderators don't see the articles that have been added to the moderation queue... just admins...?? so they don't see any articles to edit!!!

Yes, there is no option for moderating the articles.

Surely this isn't correct?

If it is, how do you use the article system when you have loads of articles being submitted and the Moderators can't moderate??

VB-Fanatiker
09-17-2004, 10:19 PM
Hi,

this hack dont work with vB 3.0.0, right? Always error at line 2 in articles.php. :disappointed: But I need this hack, it's a great one! Anybody ideas? :rolleyes: At Johns side suport=0 ... :ermm:
thx

VB-F

Rich
09-18-2004, 03:45 PM
Hello,
I have just taken the time to read the entire thread. I can't say that i applaud the author of this hack for his "support" on this hack.
I am running 3.0.3. I too was having the same problem with the thumbs as everyone else was. John should have answered that question seeing as it effected everyone that ran 3.0.3. That made it a serious bug.
This hack is great. I think the concept behind it was great as well. However, the support that the author agreed to is poor. I won't be clicking install until something better comes along and doesn't carry any bugs.
I would like to thank arpy for repairing the thumbnail problem with 3.0.3. It worked great.

***** A fairly quick way to remove a featured post is to create a "test" post. Make that the featured post, and then delete it. Once it is deleted, the featured post box will no longer be visible.*****

MissKalunji
09-18-2004, 04:53 PM
anyone still not intrested on a hack that displays the article on a none vb page?? :confused:

spence2
09-18-2004, 04:54 PM
Hello,
I have just taken the time to read the entire thread. I can't say that i applaud the author of this hack for his "support" on this hack.
I am running 3.0.3. I too was having the same problem with the thumbs as everyone else was. John should have answered that question seeing as it effected everyone that ran 3.0.3. That made it a serious bug.
This hack is great. I think the concept behind it was great as well. However, the support that the author agreed to is poor. I won't be clicking install until something better comes along and doesn't carry any bugs.
I would like to thank arpy for repairing the thumbnail problem with 3.0.3. It worked great.

***** A fairly quick way to remove a featured post is to create a "test" post. Make that the featured post, and then delete it. Once it is deleted, the featured post box will no longer be visible.*****

I think your criticism is fair ... but, perhaps the most annoying thing is that John did take the time to post that he had updated the hack ... stated he would post his update here ... and then did not follow through.

SamirDarji
09-18-2004, 10:26 PM
I would like to thank arpy for repairing the thumbnail problem with 3.0.3. It worked great.

Where is this? I read through everything, but never found it. :(

welo
09-18-2004, 10:52 PM
Here (https://vborg.vbsupport.ru/showthread.php?p=544396&#post544396), right? (which then leads you here (https://vborg.vbsupport.ru/showthread.php?t=68495))

gfxhavenowner
09-19-2004, 10:38 PM
Not sure if this has been answered yet, but will Google spider the articles?

xug
09-20-2004, 12:27 AM
I think your criticism is fair ... but, perhaps the most annoying thing is that John did take the time to post that he had updated the hack ... stated he would post his update here ... and then did not follow through.

John rather trashes other peoples work, even when it's their first attempt.

Way to go John.

hockyfan
09-21-2004, 09:21 PM
Is there any way to take current threads and make them into articles?

h

MissKalunji
09-21-2004, 09:28 PM
Lawrd

:( i've been waiting for ever for this hack guess ill go back to cute news plus i didnt find ne one to write the script for me

* MissKalunji clicks uninstall *

Thx ya'll for your help :nervous:

VB-Fanatiker
09-21-2004, 10:58 PM
Somebody with vB.3.0.0 and this hack works? I think no...

cclaerhout
09-22-2004, 05:14 PM
Once upon a time there was a great hack,
Which we used to pray for having it.
Remember how we waited it for weeks,
And dreamed of all the great things we could do.
Refrain:
Those were the days my friend,
We'd thought they'd never end,
We'd cry and hope for-ever and a day,
We'd live the life he choose,
We'd fight and always lose,
For we were young and sure to have to wait.
Lalala lah lala, lalala lah lala
Those were the days, oh yes, those were the days.


----
sorry i'm becoming mad :-D
----

j_86
09-22-2004, 05:23 PM
:( Our entire organisation was put on hold for the release.

alzibub
09-22-2004, 07:35 PM
:( Our entire organisation was put on hold for the release.
You guys are a joke !

At what point did you pay for this software - pay for the support you expect ?
I am thinking never !

People like you all moaning on puts coders like John off coding stuff - because he doesn't need the grief from ingrates...

Three options

1, Uninstall
2, Create one yourself that is better then offer it for free, support the whole lot then judge
3, Keep your mouths shut and be thankful for people less selfish than yourself !

You pay for it - you can complain - till then suck it up and move on..

Sorry that was off topic - but it really grates on me seeing people like that

welo
09-22-2004, 07:50 PM
I was just about to say pretty much the same thing (maybe a little bit more eloquently, but still pretty much the same thing). I'd like to see this thing come along a bit quicker too, but damn.

spence2
09-22-2004, 08:25 PM
You guys are a joke !

At what point did you pay for this software - pay for the support you expect ?
I am thinking never !

People like you all moaning on puts coders like John off coding stuff - because he doesn't need the grief from ingrates...

Three options

1, Uninstall
2, Create one yourself that is better then offer it for free, support the whole lot then judge
3, Keep your mouths shut and be thankful for people less selfish than yourself !

You pay for it - you can complain - till then suck it up and move on..

Sorry that was off topic - but it really grates on me seeing people like that

When someone states: "I Agree to Support This Hack"
When someone states: "I have created an update & will post it."

Then, I'm sorry, but there is a credibility gap when they do not!

Why is it "demanding" to expect someone to keep their word? If there is a delay or a change of plans, couldn't John simply post that new information?

Three More Options:
1. Mind your own business.
2. Repeat step 1.
3. Repeat step 2.

MissKalunji
09-22-2004, 08:31 PM
When someone states: "I Agree to Support This Hack"
When someone states: "I have created an update & will post it."

Then, I'm sorry, but there is a credibility gap when they do not!

Why is it "demanding" to expect someone to keep their word? If there is a delay or a change of plans, couldn't John simply post that new information?

Three More Options:
1. Mind your own business.
2. Repeat step 1.
3. Repeat step 2.


lolllllllll jeez ppl take it easy not worth it to argue and curse each other :nervous:

John
09-22-2004, 08:40 PM
I have to say, some of the abusive emails I've been getting really make me sick of some of the people in this community.

Please appreciate that as a freelancer I have to work to make a living, and at the moment I don't have *any* spare time - period. My financial situation is dire to say the least, and as such supporting free hacks on vB.org is the last of my priorities.

The main reason for the delay is because the new system uses a different database structure to the old, which means I'll have write an import script - because anything less than that and I'll have a bunch of ingrates emailing me with complaints. Furthermore, I'm sure there are going to be a lot of people who actually prefer the old system to the new one - visually, it's completely different. When I can afford to, I'll get the update packaged up and the import script written.

John
09-22-2004, 08:42 PM
When someone states: "I Agree to Support This Hack"
When someone states: "I have created an update & will post it."

Then, I'm sorry, but there is a credibility gap when they do not!

Wow, I guess I really owe you. There, I've changed the status of the hack to suit.

Lionel
09-22-2004, 08:54 PM
You did not have to reply to that John. I am sure there are plenty of us that are grateful for what is still a great hack. For my part, I will say thank you again.

trackpads
09-22-2004, 08:56 PM
You did not have to reply to that John. I am sure there are plenty of us that are grateful for what is still a great hack. For my part, I will say thank you again.

Ditto

Ghostsuit
09-22-2004, 09:02 PM
I have to say, some of the abusive emails I've been getting really make me sick of some of the people in this community. I have to say it annoys me too the way people get irate about things like this. Still I can understand to a degree the frustration, however it should never come to abusive emails. I know ever time I PM'd you I got an answer which was polite and clear.

The main reason for the delay is because the new system uses a different database structure to the old, which means I'll have write an import script - because anything less than that and I'll have a bunch of ingrates emailing me with complaints. Furthermore, I'm sure there are going to be a lot of people who actually prefer the old system to the new one - visually, it's completely different. When I can afford to, I'll get the update packaged up and the import script written.Cheers for the honesty, least we have an idea it's going to be a while before it probably get's done.

Now here's a tip for everyone thats used this or is using the v3arcade...why not go donate a coin or two if you can spare it (if you havn't already) to help John out after all the arcade hacks damn fine and worth a few quid as a donation never mind this hack.

John
09-22-2004, 09:03 PM
I know, thanks - but there are some people who are just beyond belief, where if it's a matter of trying to work to pay the bills or to do free support, they seem to think I should do the latter.

Anyway, not to go on about it - I'm sure many of you are going to be surprised when you see what's coming next. (All my free time has gone into it - that's why it's been so difficult to get anything else done, apart from the fact that I don't have much spare time in the first place.)

John
09-22-2004, 09:07 PM
Now here's a tip for everyone thats used this or is using the v3arcade...why not go donate a coin or two if you can spare it (if you havn't already) to help John out after all the arcade hacks damn fine and worth a few quid as a donation never mind this hack.

Donations are the only reason I can afford to keep the v3 site running - thanks to everyone who's given something towards it. But don't think because I'm harping on about finance that I'm after donations, they're very much appreciated - but I don't expect anything back.

Ghostsuit
09-22-2004, 09:09 PM
You might not expect them but you do deserve a few :)

hockyfan
09-22-2004, 09:21 PM
Not to repeat myself, but with all of the complaints I think my question on the previous page was overlooked, and I wanted to know if there was an answer to it. I had askedIs there any way to take current threads and make them into articles?
If anyone can let me know I'd really appreciate it, thanks. :)


h

John
09-22-2004, 09:25 PM
Not to repeat myself, but with all of the complaints I think my question on the previous page was overlooked, and I wanted to know if there was an answer to it. I had asked
If anyone can let me know I'd really appreciate it, thanks. :)


h

Old system: It's a lot of hard work.
New system: Yes.