5 replies to this topic

[joro2oo1]

CODE

mySQL query error: INSERT INTO ibf_mail_queue (mail_to,mail_date,mail_subject,mail_content) VALUES('TEST@TEST.COM',1234567890,'Forum Subscription New Topic Notification','TEST,

TEST публикува нова тема озаглавена "DELETE" във "TEST FORUM".

----------------------------------------------------------------------
DELETE

----------------------------------------------------------------------

The topic can be found here:
='http://test.com/forum/index.php?showtopic=1' target='_blank'>http://test.com/forum/index.php?showtopic=1

Please note that if you wish to get email notification of any replies to this topic, you will have to click on the
"Track this Topic" link shown on the topic page, or by visiting the link below:
='http://test.com/forum/index.php?showtopic=1' target='_blank'>http://test.com/forum/index.php?showtopic=1


Unsubscribing:
--------------

You can unsubscribe at any time by logging into your control panel and clicking on the "View Subscriptions" link.
If you are not subscribed to any forums and wish to stop receiving notification, uncheck the setting
"Send me any updates sent by the board administrator" found in \\'My Controls\\' under \\'Email Settings\\'.
Regards,

='http://test.com/forum/index.php')' target='_blank'>http://test.com/forum/index.php')

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 'My Controls\\' under \\'Email Settings\\'.
Regards,

TEST FORUM' at line 1
mySQL error code:
Date: Monday 19th of September 2005 07:13:43 PM

and the problem is in this line:

CODE

INSERT INTO ibf_mail_queue (mail_to,mail_date,mail_subject,mail_content) VALUES('TEST@TEST.COM',1234567890,'Forum Subscription New Topic Notification','TEST,

It's missing a comma (')

In which file can I fix that?  

Thanks in advance!

[Michael]

I think the problem is in your sources/post.php file.  Are you sure you have this updated to use the file that comes with 2.0.4 for this file?

[joro2oo1]

I think the problem is in your sources/post.php file.  Are you sure you have this updated to use the file that comes with 2.0.4 for this file?

I think so.

But in sources/post.php I can't find any error. The post.php is the original file without any modifactions.

[Michael]

I think this is the file that is calling on that function that causes your error.  The error is actually right here:

CODE

found in \\'My Controls\\' under \\'Email Settings\\'.

Honestly I've never taken the time to understand what exactly is required as far as what is required for these slashes, but something here is messing this up.

Search this post.php file for these lines:

CODE

                $DB->do_insert( 'mail_queue', array( 'mail_to' => $r['email'], 'mail_date' => time(), 'mail_subject' => $ibforums->lang['tt_subject'], 'mail_content' => $std->txt_safeslashes($this->email->message) ) );

And:

CODE

                $DB->do_insert( 'mail_queue', array( 'mail_to' => $r['email'], 'mail_date' => time(), 'mail_subject' => $ibforums->lang['ft_subject'], 'mail_content' => $std->txt_safeslashes($this->email->message) ) );

Make sure those lines look just like that.

[joro2oo1]

Thank you so much!!!

It was missing part of the code

CODE

$std->txt_safeslashes($this->email->message) ) );

Once again - thank you!

[Michael]

The issue this topic was opened for has now been resolved.  If you need further assistance, please open a new topic.  If this topic was closed prematurely, please contact me so I can re-open it.

Topic Closed