vb.org Archive - Integration with vBulletin - BlackBerry Native vBulletin App

Page 10 of 42

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)

- - Integration with vBulletin - BlackBerry Native vBulletin App (https://vborg.vbsupport.ru/showthread.php?t=227794)

DSanchez

11-15-2009 12:46 AM

Bug report:

1. http://www.blokessportbike.com/
2. Curve 8330
3. 4.5.0.131
4. Sprint

I get this error when trying to view any forum: org.xml.sax.SAXParseException: Undefined entity reference 'nbsp'.

Thanks!

DSanchez

11-15-2009 01:27 AM

Ah ha! I found the problem. TABLE_PREFIX was missing from get_threads.php. I modified it like so:

Code:

$dataQuery = "SELECT t.*, p.pagetext FROM " . TABLE_PREFIX . "thread t LEFT JOIN "

        . TABLE_PREFIX . "post p ON ( p.postid = t.lastpostid ) WHERE t.forumid = "

        . $fid . " AND t.open = 1 AND t.visible = 1 ORDER BY t.lastpost DESC LIMIT "

        . $offset . "," . $rows;

And also in get_posts.php:

Code:

dataQuery = "SELECT * FROM " . TABLE_PREFIX . "post WHERE ThreadID = " . $threadid . " AND visible = 1 ORDER BY Dateline DESC LIMIT " . $offset . "," . $rows;

Quantnet

11-15-2009 01:52 AM

only if your forum table use a prefix. Most standard vb installations don't but it's good that the author should take this into account.

Eric Anderson

11-15-2009 02:05 AM

Ok so if I use Prefix in my forum then I need to adjust something...????

Eric Anderson

11-15-2009 02:55 AM

Quote:

Originally Posted by DSanchez (Post 1914394)

Ah ha! I found the problem. TABLE_PREFIX was missing from get_threads.php. I modified it like so:

Code:

$dataQuery = "SELECT t.*, p.pagetext FROM " . TABLE_PREFIX . "thread t LEFT JOIN "

        . TABLE_PREFIX . "post p ON ( p.postid = t.lastpostid ) WHERE t.forumid = "

        . $fid . " AND t.open = 1 AND t.visible = 1 ORDER BY t.lastpost DESC LIMIT "

        . $offset . "," . $rows;

And also in get_posts.php:

Code:

dataQuery = "SELECT * FROM " . TABLE_PREFIX . "post WHERE ThreadID = " . $threadid . " AND visible = 1 ORDER BY Dateline DESC LIMIT " . $offset . "," . $rows;

SWEET ALL PROBLEMS SOLVED!!! I had an issue with it showing OCt 2005 only posts and figured I had to get rid of the norm all fixed now thanks!!

xug	11-15-2009 10:36 AM

Ok, I changed this above code in my files and got a step closer.

Now i will see the threads, but when I click on a thread title I get the following.

Thread title
With a 'More' link directly below it
plus error code

org.xml.sax.SAXParseException: Expecting end of file

gbechtel

11-16-2009 01:21 AM

I can get all the forums, the new posts, and I logged on with Username and p/w. But when I click on a new thread it says: org.xml.sax.SAXParseEXCEPTION: Undefined entity reference 'nbsp'.

I am also getting Database error in vBulletin 3.8.4:

Code:

Invalid SQL:

SELECT * FROM post WHERE ThreadID = 83188 AND visible = 1 ORDER BY Dateline DESC LIMIT 40,10;

MySQL Error   : Table 'masscops_vbforum.post' doesn't exist

Error Number  : 1146

Request Date  : Sunday, November 15th 2009 @ 08:52:45 PM

Error Date    : Sunday, November 15th 2009 @ 08:52:45 PM

Script        : http://www.masscops.com/forums/mobif...3188&r=10&o=40

Referrer      :

Another database error:

Code:

Database error in vBulletin 3.8.4:

Invalid SQL:

SELECT t.*, p.pagetext FROM thread t LEFT JOIN post p ON ( p.postid = t.lastpostid ) WHERE t.forumid = 50 AND t.open = 1 AND t.visible = 1 ORDER BY t.lastpost DESC LIMIT 0,10;

MySQL Error   : Table 'masscops_vbforum.thread' doesn't exist

Error Number  : 1146

Request Date  : Sunday, November 15th 2009 @ 08:50:00 PM

Error Date    : Sunday, November 15th 2009 @ 08:50:00 PM

Script        : http://www.masscops.com/forums/mobif...&f=50&r=10&o=0

Installed on http://www.masscops.com/forums/

Eric Anderson

11-16-2009 01:45 AM

Had the same error because I am using a table prefix for my forums. If you are using table prefix then the fix above Click Here should help you it fixed my exact problem.

Just a thought
Eric

gbechtel

11-16-2009 02:21 AM

Quote:

Originally Posted by Eric Anderson (Post 1914994)

Had the same error because I am using a table prefix for my forums. If you are using table prefix then the fix above Click Here should help you it fixed my exact problem.

Just a thought
Eric

Thanks Eric, that seem to get rid of the db errors

vbreal

11-16-2009 03:34 AM

Quote:

Originally Posted by DSanchez (Post 1914394)

Ah ha! I found the problem. TABLE_PREFIX was missing from get_threads.php. I modified it like so:

Code:

$dataQuery = "SELECT t.*, p.pagetext FROM " . TABLE_PREFIX . "thread t LEFT JOIN "

        . TABLE_PREFIX . "post p ON ( p.postid = t.lastpostid ) WHERE t.forumid = "

        . $fid . " AND t.open = 1 AND t.visible = 1 ORDER BY t.lastpost DESC LIMIT "

        . $offset . "," . $rows;

And also in get_posts.php:

Code:

dataQuery = "SELECT * FROM " . TABLE_PREFIX . "post WHERE ThreadID = " . $threadid . " AND visible = 1 ORDER BY Dateline DESC LIMIT " . $offset . "," . $rows;

thanks for the fix!!!

All times are GMT. The time now is 08:34 PM.

Page 10 of 42

« First

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01424 seconds Memory Usage 1,751KB 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 (8)bbcode_code_printable (3)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
Messages: