vb.org Archive
Page 139 of 205 « First 3989129137138 139 140141149189 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Major Additions - GRPS: Groups Commune 2.0.x (https://vborg.vbsupport.ru/showthread.php?t=127303)

Merriweather 03-05-2007 07:14 PM
On the posting issue, some users are still getting this database error:

Invalid SQL:

SELECT COUNT(*) AS replies
FROM grps_thread
WHERE threadid =;

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 3 Error Number : 1064
Date : Monday, March 5th 2007 @ 01:04:01 PM
Script : http://www.<edit>.com/groups/newreply.php
Referrer : http://www.<edit>.com/groups/newreply.php?do=newreply&t=36
IP Address : <edit>
Username : <edit>
Classname : vb_database

I will do the other tests for you this evening, I have to go for a while.

Merriweather 03-06-2007 03:40 AM
Quote:
Originally Posted by sabret00the (Post 1196491)
can you upload these two to the groups folder please.

and then run:
www.yoursite.com/groups/test_groups.php?g=XX
http://www.yoursite.com/groups/test_....php?g=XX&t=YY

please substitute XX and YY for numbers in which icons display or in your case don't, in the normal groups.php and viewthread.php
test_groups.php just gave this:

Code:
=>
test_viewthread.php gave this:

Code:
=>=>=>=>=>=>=>=>=>=>=>=>=>=>

Merriweather 03-06-2007 03:45 AM
Another issue users are having is that it's putting HTML in the text entry box if a user previews their post. Seeing as we don't allow HTML in posts on the fourm, it's casuing a problem with formatting.

Merriweather 03-06-2007 03:49 AM
This whole random inability to post is really troublesome on my forums. It's the same DB error over and over:

Quote:
Database error in vBulletin 3.6.5:

Invalid SQL:

SELECT COUNT(*) AS replies
FROM grps_thread
WHERE threadid =;

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 3
Error Number : 1064
Date : Monday, March 5th 2007 @ 09:47:35 PM
Script : http://www.<edit>.com/groups/newreply.php
Referrer : http://www.<edit>.com/groups/newreply.php?do=newreply&t=98
IP Address : <edit>
Username : <edit>
Classname : vb_database
We can't find any rhyme or reason for it, but some of my groups, you can only start threads and can't reply to them at all!!!

sabret00the 03-06-2007 07:22 AM
Quote:
Originally Posted by Merriweather (Post 1196838)
Another issue users are having is that it's putting HTML in the text entry box if a user previews their post. Seeing as we don't allow HTML in posts on the fourm, it's casuing a problem with formatting.
can i get a screenshot of this one please?

as for the database error, i'm on it

sabret00the 03-06-2007 07:34 AM
Quote:
Originally Posted by Merriweather (Post 1196840)
This whole random inability to post is really troublesome on my forums. It's the same DB error over and over:



We can't find any rhyme or reason for it, but some of my groups, you can only start threads and can't reply to them at all!!!
can you run this query please and give me the results [sql] SELECT COUNT(*) AS replies
FROM grps_thread
WHERE threadid = 98[/sql]

sabret00the 03-06-2007 07:34 AM
Quote:
Originally Posted by Merriweather (Post 1196838)
Another issue users are having is that it's putting HTML in the text entry box if a user previews their post. Seeing as we don't allow HTML in posts on the fourm, it's casuing a problem with formatting.
can i get a screenshot of that because i'm unable to replicate that.

sabret00the 03-06-2007 07:35 AM
Quote:
Originally Posted by Merriweather (Post 1196837)
test_groups.php just gave this:

Code:
=>
test_viewthread.php gave this:

Code:
=>=>=>=>=>=>=>=>=>=>=>=>=>=>
And there was DEFINITELY use of posticons on both pages correct?

sabret00the 03-06-2007 07:47 AM
Quote:
Originally Posted by Merriweather (Post 1196837)
test_groups.php just gave this:

Code:
=>
test_viewthread.php gave this:

Code:
=>=>=>=>=>=>=>=>=>=>=>=>=>=>
can you please run this query with the same values for which you used XX and YY on the test_viewthread.php please

[sql] SELECT grps_post.postid, grps_post.groupid, grps_post.username AS postusername, grps_post.ipaddress AS ip, grps_post.title AS posttitle, grps_post.dateline, grps_post.pagetext, grps_post.iconid, i.title AS icontitle, i.iconpath, grps_post.visible, grps_post.allowsmilie, grps_post.showsignature, grps_post.edit_username, grps_post.edit_userid, grps_post.edit_reason, grps_post.edit_dateline, grps_post.delete_username, grps_post.delete_userid, grps_post.delete_reason, grps.leaderid, u.*, uf.*, utf.*, a.avatarid, a.avatarpath, NOT ISNULL(ca.userid) AS hascustomavatar, ca.dateline AS avatardateline, ca.width AS avwidth, ca.height AS avheight
FROM grps_post
LEFT JOIN grps ON (grps.groupid = grps_post.groupid)
LEFT JOIN user u ON (u.userid = grps_post.userid)
LEFT JOIN userfield uf ON (uf.userid = u.userid)
LEFT JOIN usertextfield utf ON (utf.userid = u.userid)
LEFT JOIN icon i ON (i.iconid = grps_post.iconid) > 0
LEFT JOIN avatar a ON (a.avatarid = u.avatarid)
LEFT JOIN customavatar ca ON (ca.userid = u.userid)
WHERE grps_post.groupid = XX and grps_post.threadid = YY
ORDER BY grps_post.dateline ASC
[/sql]

and please just look for the iconpath column and let me know if it's empty on all counts.

hold on, i think i've figured it out. are you using a default icon on your forums?

Merriweather 03-06-2007 02:31 PM
Quote:
Originally Posted by sabret00the (Post 1196939)
can you run this query please and give me the results [sql] SELECT COUNT(*) AS replies
FROM grps_thread
WHERE threadid = 98[/sql]
Results: 1


All times are GMT. The time now is 06:41 AM.
Page 139 of 205 « First 3989129137138 139 140141149189 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.02218 seconds
  • Memory Usage 1,756KB
  • 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
  • (6)bbcode_code_printable
  • (8)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (5)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