Jump to content

  • twitter
  • youtube
  • googleplus
  • facebook
  • rss
  • newsletter


Issue information

  • #000212

  • 0 - None Assigned

  • Fixed

  • 1.2.1

  • 1.2.1


Issue Confirmations

  • Yes (0)No (0)
Photo

SQL Error

Posted by marcoos on 02 March 2010 - 06:57 AM

When notification method is set to PM alert, all moderation actions that should trigger a notification fails.
Invision Board 3.0.5

 mySQL query error: SELECT * FROM ibf_ignored_users WHERE ignore_messages=1 AND ignore_owner_id IN (  ) AND ignore_ignore_id=3418
===================================================
 Date: Tue, 02 Mar 2010 12:53:25 +0000
 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 ignore_ignore_id=3418' at line 1
 IP Address: 85.221.213.215
 Page: /index.php?app=forums&module=moderate&section=moderate&f=4&t=320284&st=0&auth_key=****************************&do=01
 Debug: array (
  1 =>
  array (
	'file' => '/home/www-root/**********/ips_kernel/classDb.php',
	'line' => 1019,
	'function' => 'query',
	'class' => 'db_driver_mysql',
  ),
  3 =>
  array (
	'file' => '/home/www-root/**********/admin/applications/members/sources/classes/messaging/messengerFunctions.php',
	'line' => 1694,
	'function' => 'blockedByUser',
	'class' => 'messengerFunctions',
  ),
  4 =>
  array (
	'file' => '/home/www-root/**********/admin/sources/classes/maa/moderatorActionAlert.php',
	'line' => 240,
	'function' => 'sendNewPersonalTopic',
	'class' => 'messengerFunctions',
  ),
  5 =>
  array (
	'file' => '/home/www-root/**********/admin/applications/forums/modules_public/moderate/moderate.php',
	'line' => 2348,
	'function' => 'setupAlert',
	'class' => 'moderatorActionAlert',
  ),
  6 =>
  array (
	'file' => '/home/www-root/**********/admin/applications/forums/modules_public/moderate/moderate.php',
	'line' => 163,
	'function' => '_openTopic',
	'class' => 'public_forums_moderate_moderate',
  ),
  7 =>
  array (
	'file' => '/home/www-root/**********/admin/sources/base/ipsController.php',
	'line' => 291,
	'function' => 'doExecute',
	'class' => 'public_forums_moderate_moderate',
  ),
)
 mySQL query error: SELECT * FROM ibf_ignored_users WHERE ignore_messages=1 AND ignore_owner_id IN (  ) AND ignore_ignore_id=3418

Updating status to: Confirmed

Make sure you have a valid member id filled in the Moderator Action Alert settings. If your still getting an error, can you open a ticket with your ftp/admin cp login details so I can take a look at this?


Michael, on 03 March 2010 - 11:57 AM, said:

Updating status to: Confirmed

Make sure you have a valid member id filled in the Moderator Action Alert settings. If your still getting an error, can you open a ticket with your ftp/admin cp login details so I can take a look at this?

"Send to who?" and "PM Author ID"  were set to -1.

For security reasons I'm unable to provide FTP access to our server, nor to board's control panel, but if you need some files to further analyze the problem I can send them as well as SQL Dump of any table that might be helpful.


Ok, will make it harder to troubleshoot but I understand. Can you fill in both the "Send to who?" and "PM Author ID" settings to a valid member id, then do a test with a moderator action. Let me know if the database error still happens. I get sms/email alerts from the customer centre, so I suggest you open a ticket with what happens so we can resolve this faster.


Updating severity to: 0 - None Assigned
Updating status to: Fixed
Updating version to: 1.2.1
Issue fixed in: 1.2.1






0 user(s) are reading this issue

0 members, 0 guests, 0 anonymous users