vb.org Archive
Page 9 of 28 « First 78 9 101119 Last »
Show 40 post(s) from this thread on one page

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.


All times are GMT. The time now is 09:33 AM.
Page 9 of 28 « First 78 9 101119 Last »
Show 40 post(s) from this thread on one page

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.01255 seconds
  • Memory Usage 1,758KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code_printable
  • (2)bbcode_html_printable
  • (10)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete