DevFuse Products (View All Products)
Issue information
-
#000212
-
0 - None Assigned
-
Fixed
-
1.2.1
-
1.2.1
Issue Confirmations
-
Yes (0)No (0)
When notification method is set to PM alert, all moderation actions that should trigger a notification fails.
Invision Board 3.0.5
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§ion=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?
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?
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
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












