Jump to content


Issue information

  • #019998

  • Fixed

  • 2.0.4

  • 2.2.1

  • 0 - None Assigned


Issue Confirmations

  • Yes (0)No (0)
Photo

Profile tab sql error

Posted by (CSN) Tails on 08 December 2009 - 08:20 PM

Hi!

IPB v3.0.5 + Blog v2.0.4 + Gallery v3.0.4

I get this when I click the "Blog" tab in my profile or any user profile:

Error Number: 1064
 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 ') and member_id=1 ORDER BY blog_id' at line 1
 IP Address: 89.208.228.226
 Page: /index.php?&app=members&section=load&module=ajax&member_id=1&tab=blog&md5check=22ffc8a27c35b5ace8344fb066bc6aa2
 Debug: array (
  1 => 
  array (
	'file' => '/home/***/public_html/ips_kernel/classDb.php',
	'line' => 1019,
	'function' => 'query',
	'class' => 'db_driver_mysql',
  ),
  3 => 
  array (
	'file' => '/home/***/public_html/admin/applications_addon/ips/blog/sources/parsing.php',
	'line' => 165,
	'function' => '_loadLastRead',
	'class' => 'blogParsing',
  ),
  4 => 
  array (
	'file' => '/home/***/public_html/admin/applications/members/sources/tabs/blog.php',
	'line' => 42,
	'function' => '__construct',
	'class' => 'blogParsing',
  ),
  5 => 
  array (
	'file' => '/home/***/public_html/admin/applications/members/modules_public/ajax/load.php',
	'line' => 105,
	'function' => 'return_html_block',
	'class' => 'profile_blog',
  ),
  6 => 
  array (
	'file' => '/home/***/public_html/admin/sources/base/ipsController.php',
	'line' => 412,
	'function' => 'doExecute',
	'class' => 'public_members_ajax_load',
  ),
  7 => 
  array (
	'file' => '/home/***/public_html/admin/sources/base/ipsController.php',
	'line' => 91,
	'function' => 'execute',
	'class' => 'ipsAjaxCommand',
  ),
)
 mySQL query error: SELECT blog_id, member_id, last_read, unread_count, last_count, entries_read FROM ibf_blog_read WHERE blog_id in(0,) and member_id=1 ORDER BY blog_id

Updating status to: Fixed
Updating version to: 2.0.4
Issue fixed in: 2.1.0 Beta 1

Moot now that the next version will be out soon.


Will this affect anyone presently using IP.Blog 2.0.4 with IP.Board 3.0.5?

..Al


I doubt it, as I don't get that error after a clean upgrade to IP.Board 3.0.5.


If you are affected, please read this topic for a fix: http://community.inv...1-305-blog-20x/






0 user(s) are reading this issue

0 members, 0 guests, 0 anonymous users