vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Major Additions - Discuss!! A Yahoo Answers Clone (https://vborg.vbsupport.ru/showthread.php?t=281692)

Christos Teriakis 04-19-2012 01:51 PM

Quote:

Originally Posted by David_R (Post 2321534)
Database error in vBulletin 4.1.11:

Invalid SQL:
SELECT * FROM user WHERE userid= LIMIT 1;

Is missing the userid. Where exactly did you met this? Does this question have post from a registered user?

Chris

Christos Teriakis 04-19-2012 01:52 PM

Quote:

Originally Posted by hakkuo23 (Post 2321545)
Database error in vBulletin 4.1.12:

Invalid SQL:
SELECT * FROM vb_user WHERE userid= LIMIT 1;

Is missing the userid. Where exactly did you met this? Does this question have post from a registered user?

Chris

Christos Teriakis 04-19-2012 01:55 PM

Quote:

Originally Posted by BadgerDog (Post 2321567)
Also ... :)

Seem to have a cosmetic issue with Facebook buttons appearing in the middle of other fields, over writing stuff that's there? :confused:

We don't use Facebook and all the vBulletin options for it are turned OFF ...

Thanks

Regards,
Doug

Another one user has the same problem (around in the 2nd page here). Don't know why it appears there. Maybe a custom style issue. In anycase I'll try to find another solution for sharing option. I dont like it too, not because is not working for me, but because it leaves a wide space from the right side. But this is the official FB plugin.

Chris

Christos Teriakis 04-19-2012 01:56 PM

Quote:

Originally Posted by SilverBoy (Post 2321557)
nice work as always Chris :)

I just wonder if the questions and replies added to the post count of the user? I think we need if it is not added to show it in user profile and user posts too :).

Thank you. As I said in my main post, this is still a basic version. If I see that there is interest from users, I'll start adding things.

Chris

Da-Vinci 04-19-2012 02:09 PM

Quote:

Originally Posted by ChrisTERiS (Post 2321515)
You welcome. As I said in a previous post, my design knowledge is minimal. It's not bad to say it. Coding is different that design. So this post is going to DaVinchi too. If you have a final css version that works, I can add it to the distribution file, to avoid all these changes after a new release.

Thank you both of you.

Chris

Best thing I can think of is to try and use existing stylevars in the CSS file, for instance, EG:

On the default skin, the stylevar {vb:stylevar forumhead_border} matches the colour #5A7F97 but only has a border of 1px.

So in the discuss.css the original category menu decleration looks like this.

HTML Code:

div.categoriesmenu {
    display:block;
    width: auto;
    position:relative;
    background: #C9D6DE;
    border: 2px solid #5A7F97;
    padding: 10px;
}

A possible replacement could be,

HTML Code:

div.categoriesmenu {
    display:block;
    width: auto;
    position:relative;
    background: {vb:stylevar forumhead_background};
    border: {vb:stylevar forumhead_border};
    padding: 10px;
}

The theory is that a Style designer shouldn't make any clashes with colours within the theme and the stylevars will be inherited through all styles.

The problem is finding the correct stylevars. I haven't found a stylevaro that matches the colour #C9D6DE, so without doubt some of the colours would need to be changed.

You may also need to make a new CSS template rather than a file, to use the stylevars, it's been so long since I done any styling I can't remember, I would need to experiment to be sure.

hakkuo23 04-19-2012 02:20 PM

Quote:

Originally Posted by ChrisTERiS (Post 2321579)
Is missing the userid. Where exactly did you met this? Does this question have post from a registered user?

Chris

This happens when I try to reply to a question. I am a registered user.
Here is the full error:
Database error in vBulletin 4.1.12:

Invalid SQL:

Code:

Warning: mysqli_query() [function.mysqli-query]: (42000/1064): 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 'LIMIT 1' at line 1 in [path]/includes/class_core.php on line 1391

SELECT * FROM vb_user WHERE userid= LIMIT 1;

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 'LIMIT 1' at line 1
Error Number  : 1064
Request Date  : Thursday, April 19th 2012 @ 11:19:05 AM
Error Date    : Thursday, April 19th 2012 @ 11:19:05 AM
Script        : http://xenogamers.org/discuss.php?do=savereply
Referrer      : http://xenogamers.org/discuss.php?do=viewquestion&questionid=5
IP Address    : 24.97.196.3
Username      : silence
Classname    : vB_Database_MySQLi
MySQL Version : 5.1.61-cll


Christos Teriakis 04-19-2012 06:17 PM

Quote:

Originally Posted by hakkuo23 (Post 2321590)
This happens when I try to reply to a question. I am a registered user.
Here is the full error:
Warning: mysqli_query()

hmmm.. are you using mysqli? Let me check it, but I think that you must change to mysql in config file

Chris

BadgerDog 04-19-2012 06:35 PM

Quote:

Originally Posted by ChrisTERiS (Post 2321673)
hmmm.. are you using mysqli? Let me check it, but I think that you must change to mysql in config file

Chris

As noted in my post above, I consistently get exactly the same error while replying to a post... ;)

Quote:

Used XXX's to preserve some privacy ...

Database error in vBulletin 4.1.3:

Invalid SQL:
SELECT * FROM user WHERE userid= LIMIT 1;

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 'LIMIT 1' at line 1
Error Number : 1064
Request Date : Thursday, April 19th 2012 @ 09:22:54 AM
Error Date : Thursday, April 19th 2012 @ 09:22:54 AM
Script : http://www.xxxx.com/discuss.php?do=savereply
Referrer : http://www.xxxx.com/discuss.php?do=v...n&questionid=2
IP Address : 99.99.99.99
Username : Tester
Classname : vB_Database
MySQL Version : 5.0.95
UserID of original post starter was 2 and UserID of reply poster is also 2 ...

Regards,
Doug

BadgerDog 04-19-2012 06:35 PM

Quote:

Originally Posted by ChrisTERiS (Post 2321580)
Another one user has the same problem (around in the 2nd page here). Don't know why it appears there. Maybe a custom style issue. In anycase I'll try to find another solution for sharing option. I dont like it too, not because is not working for me, but because it leaves a wide space from the right side. But this is the official FB plugin.

Chris

Thank you very much... appreciate it ... :)

Regards,
Doug

Krusty1231 04-20-2012 02:17 AM

Code:

Invalid SQL:
SELECT * FROM _vbuser WHERE userid= LIMIT 1;

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 'LIMIT 1' at line 1
Error Number  : 1064
Request Date  : Thursday, April 19th 2012 @ 08:13:09 PM
Error Date    : Thursday, April 19th 2012 @ 08:13:10 PM
Script        : http://www.XXX.com/XXXX/discuss.php?do=savereply
Referrer      : http://www.XXX.com/XXXX/discuss.php?do=viewquestion&questionid=1
IP Address    : XXX.83.16.XX
Username      : Jerry
Classname    : vB_Database
MySQL Version : 5.0.92-log

Same issue.

David_R 04-20-2012 04:53 AM

Quote:

Originally Posted by ChrisTERiS (Post 2321578)
Is missing the userid. Where exactly did you met this? Does this question have post from a registered user?

Chris

Yes, I am getting the error message from registered user, while submitting the question or answer. Give us the complete right to use this product, Moderators and Admin cannot delete a users answer and question @ all.

Christos Teriakis 04-20-2012 05:23 AM

Version 1.2.0 has the following changes:
  1. Not showing avatar in Latest/Popular questions ... Fixed...
  2. MySQL error trying to send PM after a new reply ... Fixed...
  3. discuss.css file moved to templating system as discuss.css template. From now on any changes must be done on that template and not on the file.
To upgrade to 1.2.0
  1. Upload the files:
    1. discuss.php
    2. discuss_modcp.php
    3. discuss_usercp.php
  2. Import product-discuss.xml. Don't forget to check "Overwrite".
Chris

ahobilam 04-20-2012 06:52 AM

Dear Sir,
I really like this mod,
hence I installed it and nominated for MOTM
but today when I try to reply a question I go the following error.
Can you look in to this asasp?
Database error in vBulletin 4.1.11:

Invalid SQL:
SELECT * FROM brahmins_user WHERE userid= LIMIT 1;

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 'LIMIT 1' at line 1
Error Number : 1064
Request Date : Friday, April 20th 2012 @ 07:47:52 AM
Error Date : Friday, April 20th 2012 @ 07:47:52 AM
Script : http://www.brahminsnet.com/forums/di...p?do=savereply
Referrer : http://www.brahminsnet.com/forums/di...n&questionid=3
IP Address : 122.174.35.179
Username : bmbcAdmin
Classname : vB_Database
MySQL Version : 5.1.58-1ubuntu1

The resulting url is:
http://www.brahminsnet.com/forums/di...p?do=savereply

Christos Teriakis 04-20-2012 07:38 AM

Quote:

Originally Posted by ahobilam (Post 2321816)
Invalid SQL:
SELECT * FROM brahmins_user WHERE userid= LIMIT 1;

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 'LIMIT 1' at line 1

Please download and upgrade to 1.2.0. Has fixed. The bug was after saving the reply when the system was trying to send a PM to question's owner.

Chris

ProFifaLeagues 04-20-2012 08:30 AM

How Do you mark a Question as Resolved??

ahobilam 04-20-2012 08:34 AM

Sri:
Dear Author,
today after getting the update
I hope the above database problem is solved.
It should be checked with more answers later.
thanks,
nvs

ahobilam 04-20-2012 08:38 AM

Dear Author,
is it possible to add other social book mark buttons also as we have in our postbit?
thanks
nvs

BadgerDog 04-20-2012 09:47 AM

Quote:

Originally Posted by ChrisTERiS (Post 2321804)
Version 1.2.0 has the following changes:
  1. Not showing avatar in Latest/Popular questions ... Fixed...
  2. MySQL error trying to send PM after a new reply ... Fixed...
  3. discuss.css file moved to templating system as discuss.css template. From now on any changes must be done on that template and not on the file.
To upgrade to 1.2.0
  1. Upload the files:
    1. discuss.php
    2. discuss_modcp.php
    3. discuss_usercp.php
  2. Import product-discuss.xml. Don't forget to check "Overwrite".
Chris

Thank you very much for the update Chris .. :)

I can confirm this update solved our SQL error reply issue and I received a PM as well ...

Do you do contract work? In other words, referring to my previous post, can you be hired to better match the product's color use to our site? See pic from previous post.

Regards,
Doug

BadgerDog 04-20-2012 10:53 AM

Quote:

Originally Posted by BadgerDog (Post 2321567)
Also ... :)

Seem to have a cosmetic issue with Facebook buttons appearing in the middle of other fields, over writing stuff that's there? :confused:

We don't use Facebook and all the vBulletin options for it are turned OFF ...

Thanks

Regards,
Doug

Chris.... :)

Note: problem of Facebook buttons in cosmetically messing up display disappeared under 1.20. They now appear in a separate area just below "views" and "replies" banners. I'm not sure why they are appearing at all, since we have Facebook options turned OFF in vBulletin. :confused:

Is there some way of turning these buttons off so they don't display? :)

Regards,
Doug

Christos Teriakis 04-20-2012 10:53 AM

Quote:

Originally Posted by BadgerDog (Post 2321842)
Thank you very much for the update Chris .. :)

I can confirm this update solved our SQL error reply issue and I received a PM as well ...

Do you do contract work? In other words, referring to my previous post, can you be hired to better match the product's color use to our site? See pic from previous post.

Regards,
Doug

Hello Doug,

Thank you for you offer, but I can guarantee you that hiring me for design work, should be a 100% waste of your money. Sorry but my design level is just acceptable. Nothing more. If I knew how to do a better color combination or design, be sure that I should have included it for free. I believe that you must look for a designer by profession.

Chris

BadgerDog 04-20-2012 11:02 AM

Quote:

Originally Posted by ChrisTERiS (Post 2321804)
Version 1.2.0 has the following changes:
  1. discuss.css file moved to templating system as discuss.css template. From now on any changes must be done on that template and not on the file.

Da-Vinci... :)

How does this change affect your post here:

https://vborg.vbsupport.ru/showpost....8&postcount=52

Thanks ....

Regards,
Doug

Christos Teriakis 04-20-2012 11:04 AM

Quote:

Originally Posted by rammieone (Post 2321828)
How Do you mark a Question as Resolved??

In question view page, in the section of Answers. Any answer (NOT BELONGING TO AUTHOR), has a button "Best Answer". Click it and that's all. If you want to cancel it, then you need to go to "My Questions", find the question in the list, and select "Re-Open". This will cancel your previous selection.

Chris

Preech 04-20-2012 11:18 AM

So we have to register to view the live demo.

Christos Teriakis 04-20-2012 01:35 PM

Quote:

Originally Posted by Preech (Post 2321869)
So we have to register to view the live demo.

No.. There are 3 demo accounts to check it. See my main post.

Chris

ProFifaLeagues 04-20-2012 01:53 PM

Quote:

Originally Posted by ChrisTERiS (Post 2321864)
In question view page, in the section of Answers. Any answer (NOT BELONGING TO AUTHOR), has a button "Best Answer". Click it and that's all. If you want to cancel it, then you need to go to "My Questions", find the question in the list, and select "Re-Open". This will cancel your previous selection.

Chris


Thanks Chris Superb Work on this mod

BadgerDog 04-20-2012 04:44 PM

Should there be a TAB for "Solved" besides the ones for "Just Asked" and "Most Replied"?

Thanks .. :)

Regards,
Doug

Christos Teriakis 04-20-2012 05:29 PM

Quote:

Originally Posted by BadgerDog (Post 2321956)
Should there be a TAB for "Solved" besides the ones for "Just Asked" and "Most Replied"?

Thanks .. :)

Regards,
Doug

Step by step :) I just released it for vB3. A good way to remember the old good days:erm:

Chris

BadgerDog 04-20-2012 06:27 PM

Quote:

Originally Posted by ChrisTERiS (Post 2321965)
Step by step :) I just released it for vB3. A good way to remember the old good days:erm:

Chris


Thank you .. :D

I'll watch for it here ..

Regards,
Doug

vetty 04-20-2012 11:24 PM

Problem 1: With Sub-Categories !

First, I would like to mention, this is an excellent mod. I like it.

Now to the problem. When there are sub-categories inside the main-category;

Ex.
1st Main Category
>> 10 Sub Categories

On /discuss.php ->
5 Sub-Categories are are shown below the Main Category, rest are shown as (.......)
That's good as all the sub's wont be cluttering.

https://vborg.vbsupport.ru/external/2012/04/22.png

When I click the Main Category, It redirects to the 5th Sub-Category.
When I click any other Sub-Categories, It redirects to the Home page (CMS).

Note: Using VBSEO. In the previous posts I read ChrisTERiS mentioning about vbseo (license).

Problem 2: Sidebar !

Pl refer the screenshot - Top Margin, Center, Right Padding ..

https://vborg.vbsupport.ru/external/2012/04/23.png

Found Solution for Problem 2: (for my theme)

Remove:

Code:

#sidebar_container {
    float: right;
    margin-bottom: 3em;
    padding: 17px 0;
    width: 270px;
}

#sidebar_container > ul {
    background: url("images/gradients/top-highlight.png") repeat-x scroll left top #F1F1F1;
    border: 1px solid #C1C1C1;
    border-radius: 5px 5px 5px 5px;
    box-shadow: 0 0 0 #C8C8C8;
    float: left;
    width: 99%;
}

#sidebar_container .underblock {
width: 250px;
}

Add:

Code:

#sidebar_container .blockbody {
padding: 10px;
width: 228px;
}

https://vborg.vbsupport.ru/external/2012/04/24.png

Christos Teriakis 04-21-2012 05:03 AM

Quote:

Originally Posted by vetty (Post 2322043)
Problem 1: With Sub-Categories !

First, I would like to mention, this is an excellent mod. I like it.

Now to the problem. When there are sub-categories inside the main-category;

Ex.
1st Main Category
>> 10 Sub Categories

On /discuss.php ->
5 Sub-Categories are are shown below the Main Category, rest are shown as (.......)
That's good as all the sub's wont be cluttering.

To be honest, is the first time that I didn't checked the categories/subcategories functionallity as the code is the same in all my mods and works for years. I'll do a check and I'll come back with a fix if I find something wrong there.

Chris

GhostHunter2010 04-21-2012 06:50 AM

why should ya install this when you have google :)

basilrath 04-21-2012 08:44 AM

Quote:

why should ya install this when you have google
Looks a damn good mod in my opinion and the "in house" Q&A is a more friendly "relative" way to integrate members within the site.

Kudos to Chris

BadgerDog 04-21-2012 09:46 AM

Quote:

Originally Posted by David_R (Post 2322141)
Chris,

We have kicked out your Modification from our site, You don't even how to delete and edit articles, I am going to pay for a new mod and install it in on my website. Same modification without any copyright voliation. Useless modification made by a dumb fellow.

Regards

Don't make excuses... be honest and simply own up to what you did and continue to do with other authors' work ... ;)

It's pretty obvious from looking at your site, that you plagiarize everyone's work for free, including even removing vBulletin's copyright. :rolleyes:

I stand to be corrected, but I believe that violates your license agreement with vBulletin, so maybe someone should pass that information onto them? :D

Although, given your location, no copyright protection would ever be enforced anyway, so I'm not sure it's worth the effort except for the public embarrassment factor, which doesn't seem to bother you anyway. :p

Regards,
Doug

Taurus1 04-21-2012 10:06 AM

It really completely disturbs my peace when I see people with so little respect for others work! David R....what you do on your site is really a disgrace. But OK, fortunately good always prevails over bad. So, in future, when things don't go to well, you might think of this thread.

BirdOPrey5 04-21-2012 11:39 AM

Personal disputes removed from this thread. Please keep it on topic and if you have a personal issue with someone PM them with your concerns. Personal insults do not belong on vBulletin.org no matter the reason.

Christos Teriakis 04-21-2012 02:17 PM

Quote:

Originally Posted by BirdOPrey5 (Post 2322201)
Personal disputes removed from this thread. Please keep it on topic and if you have a personal issue with someone PM them with your concerns. Personal insults do not belong on vBulletin.org no matter the reason.

Personal disputes? It's not. It's a legal dispute. As I know, the copyright laws are same worldwide. He did something out of law, and he admit that he did it!! How I can keep myself calm? Have you count how many times I gave support to this member? Do you like to check how he was bombing me with continues post in forums and PMs? And after all, he shows his appreciation by removing my copyright link. In a site full of banners my 2 small phrases were making his site appearing ugly??

And what about my report? Does this member continue "walking" on this site? I need to know the moderator's decision for my report. I think that I've the right to know it.

Thank you
Chris

BirdOPrey5 04-21-2012 04:23 PM

The personal insults were too much. Legal or personal, it does not matter, that is not what this site is about.

You said you reported it to your local police then follow up with them. Personally I hope you can find sort of resolution that you would be happy with, but in any case we do not allow the attacking of another member whether you feel it is justified or not- sorry.

I have no access to PMs nor did I count anything because whether you helped him once or 100 times does not make the act of removing a copyright notice any better or worse.

IF the violation was still occurring I would suggest you contact his web host and file a DMCA complaint, but it is my understanding he has removed the mod so there is nothing I can think of left to do.

Also vBulletin license details are not public but we do offer a branding-free license so sites without vBulletin branding MAY be completely legit.

Christos Teriakis 04-21-2012 04:44 PM

Quote:

Originally Posted by BirdOPrey5 (Post 2322288)
You said you reported it to your local police then follow up with them. Personally I hope you can find sort of resolution that you would be happy with, but in any case we do not allow the attacking of another member whether you feel it is justified or not- sorry.

Yes I did reported him to the police station, but this is something totally different, and it takes time. When I was reported him here I was expecting that should be an action from your side. He admit that he removed my copyright, something that is phohibited as I'm saying in my main post. He didn't said "No, You're wrong". He said "Yes I removed it". In this case you look like that you don't care for my rights. So, if the community doese cares for me, I'll not care for the community too.

Thank you
Christos Teriakis

BirdOPrey5 04-21-2012 04:58 PM

Christos,

I don't know what action would make you happy but he removed the mod. Even if someone was found to be using vBulletin without their branding they don't immediately revoke their license and report them to the police- they simply send an email reminding them of their license agreement and if they agree to restore the copyright or remove vBulletin then the case is considered resolved.

Best I can tell you called him out and he removed the mod. Even if he didn't vBulletin.org does NOT take sides in disputes. That would lead us down a very dangerous path. We are all volunteers here and we have neither the time nor desire to act as judge and jury between member disputes.

Christos Teriakis 04-21-2012 05:11 PM

Quote:

Originally Posted by BirdOPrey5 (Post 2322297)
Christos,

I don't know what action would make you happy ....

Simple one. Ban him even for 1 day, just to make clear to him that by getting something for free, does not means that he is free to do anything he likes (eg removing the copyright).

If you can see my issue (even for a moment) as developer that you're and not as moderator, then you can understand how I'm feeling now.

Thank you and lets end it here.

Chris


All times are GMT. The time now is 06:43 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.01766 seconds
  • Memory Usage 1,878KB
  • 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
  • (2)bbcode_html_printable
  • (27)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (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