[OzzModz] Contact Us Form Log

[OzzModz] Contact Us Form Log [Paid] 2.1.0 Beta 4

No permission to buy ($10.00)
Overview Updates (5) History Discussion
Ozzy47

Ozzy47

Well-known member
ozzy47 submitted a new resource:

[OzzModz] Contact Us Form Log - Log all contact us form submissions

Always wanted to check contact emails without leaving your forum? Then the Ozzmodz Contacts Log is for you.

This is a relatively simple addon that will log all contact-form submissions to the database. Those with permission will be able to view the log, on a simple table. It's a convenient way to quickly view the submissions received from the contact us form, rather than logging into email.

There is only one setting for this addon, it controls the amount of results to show in the log...
Click to expand...

Read more about this resource...
 
@ozzy47 I have few question before buy it:

1. Sometimes the users send email through contact us page but we don't receive it due to email configuration issue, so this addon will help us to know all the mesaages sent through contact us page even if we didn't receive it in our email, right?

2. The list will be available in admincp or the forum?

3. I want to give the permission to specific user only to view the list not to all usergroup, is this possible?

4. I suggest to add a feature to send alert/notification to authorised user if anybody sent new message through contact us page, what do you think?
 
Last edited:
1) Technically yes, it should.

2) The log is viewable in the front end.

3) Yes, via user permissions.

4) Perhaps in a future update.
 
Last edited:
ozzy47 said:
1) Technically yes, it should.

2) The log is viewable in the front end.

3) Yes, via user permissions.

4) Perhaps in a future update.
Click to expand...

Thanks, we will buy it now :)
However, I wish if you can consider our suggestion "alerts" in the next release
 
Hi @ozzy47

I installed it and now I am not able to send a message through contact us page. I am getting this error:

Code: 
XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'handled' in 'field list' src/XF/Db/AbstractStatement.php:217
Generated by: 26 Oct 2019 at 10:07 AM
Stack trace
INSERT  INTO `xf_ozzmodz_logcontactus_log` (`user_agent`, `received`, `ipaddress`, `username`, `email`, `subject`, `message`, `log_id`, `handled`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL statement...', 1054, '42S22')
#1 src/XF/Db/Mysqli/Statement.php(39): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1054, '42S22')
#2 src/XF/Db/Mysqli/Statement.php(54): XF\Db\Mysqli\Statement->prepare()
#3 src/XF/Db/AbstractAdapter.php(94): XF\Db\Mysqli\Statement->execute()
#4 src/XF/Db/AbstractAdapter.php(218): XF\Db\AbstractAdapter->query('INSERT  INTO `x...', Array)
#5 src/XF/Mvc/Entity/Entity.php(1452): XF\Db\AbstractAdapter->insert('xf_ozzmodz_logc...', Array, false)
#6 src/XF/Mvc/Entity/Entity.php(1184): XF\Mvc\Entity\Entity->_saveToSource()
#7 src/addons/OzzModz/ContactusLog/XF/Pub/Controller/Misc.php(83): XF\Mvc\Entity\Entity->save()
#8 src/XF/Mvc/Dispatcher.php(321): OzzModz\ContactusLog\XF\Pub\Controller\Misc->actionContact(Object(XF\Mvc\ParameterBag))
#9 src/XF/Mvc/Dispatcher.php(244): XF\Mvc\Dispatcher->dispatchClass('XF:Misc', 'Contact', Object(XF\Mvc\RouteMatch), Object(OzzModz\ContactusLog\XF\Pub\Controller\Misc), NULL)
#10 src/XF/Mvc/Dispatcher.php(100): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(OzzModz\ContactusLog\XF\Pub\Controller\Misc), NULL)
#11 src/XF/Mvc/Dispatcher.php(50): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#12 src/XF/App.php(2178): XF\Mvc\Dispatcher->run()
#13 src/XF.php(390): XF\App->run()
#14 index.php(20): XF::runApp('XF\\Pub\\App')
#15 {main}
Request state
array(4) {
  ["url"] => string(19) "/forum/misc/contact"
  ["referrer"] => string(41) "/forum/misc/contact"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(7) {
    ["subject"] => string(10) "Test title"
    ["message"] => string(13) "Test message "
    ["_xfRedirect"] => string(45) "/forum/contactusloglog/"
    ["_xfToken"] => string(8) "********"
    ["_xfRequestUri"] => string(19) "/forum/misc/contact"
    ["_xfWithData"] => string(1) "1"
    ["_xfResponseType"] => string(4) "json"
  }
}
 
Sadiq6210 said:
Hi @ozzy47

I installed it and now I am not able to send a message through contact us page. I am getting this error:

Code: 
XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'handled' in 'field list' src/XF/Db/AbstractStatement.php:217
Generated by: 26 Oct 2019 at 10:07 AM
Stack trace
INSERT  INTO `xf_ozzmodz_logcontactus_log` (`user_agent`, `received`, `ipaddress`, `username`, `email`, `subject`, `message`, `log_id`, `handled`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL statement...', 1054, '42S22')
#1 src/XF/Db/Mysqli/Statement.php(39): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1054, '42S22')
#2 src/XF/Db/Mysqli/Statement.php(54): XF\Db\Mysqli\Statement->prepare()
#3 src/XF/Db/AbstractAdapter.php(94): XF\Db\Mysqli\Statement->execute()
#4 src/XF/Db/AbstractAdapter.php(218): XF\Db\AbstractAdapter->query('INSERT  INTO `x...', Array)
#5 src/XF/Mvc/Entity/Entity.php(1452): XF\Db\AbstractAdapter->insert('xf_ozzmodz_logc...', Array, false)
#6 src/XF/Mvc/Entity/Entity.php(1184): XF\Mvc\Entity\Entity->_saveToSource()
#7 src/addons/OzzModz/ContactusLog/XF/Pub/Controller/Misc.php(83): XF\Mvc\Entity\Entity->save()
#8 src/XF/Mvc/Dispatcher.php(321): OzzModz\ContactusLog\XF\Pub\Controller\Misc->actionContact(Object(XF\Mvc\ParameterBag))
#9 src/XF/Mvc/Dispatcher.php(244): XF\Mvc\Dispatcher->dispatchClass('XF:Misc', 'Contact', Object(XF\Mvc\RouteMatch), Object(OzzModz\ContactusLog\XF\Pub\Controller\Misc), NULL)
#10 src/XF/Mvc/Dispatcher.php(100): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(OzzModz\ContactusLog\XF\Pub\Controller\Misc), NULL)
#11 src/XF/Mvc/Dispatcher.php(50): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#12 src/XF/App.php(2178): XF\Mvc\Dispatcher->run()
#13 src/XF.php(390): XF\App->run()
#14 index.php(20): XF::runApp('XF\\Pub\\App')
#15 {main}
Request state
array(4) {
  ["url"] => string(19) "/forum/misc/contact"
  ["referrer"] => string(41) "/forum/misc/contact"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(7) {
    ["subject"] => string(10) "Test title"
    ["message"] => string(13) "Test message "
    ["_xfRedirect"] => string(45) "/forum/contactusloglog/"
    ["_xfToken"] => string(8) "********"
    ["_xfRequestUri"] => string(19) "/forum/misc/contact"
    ["_xfWithData"] => string(1) "1"
    ["_xfResponseType"] => string(4) "json"
  }
}
Click to expand...

I am sorry about that. Please redownload the files and upload them to the server. There was some development code still left in one of the files.
 
Due to the tragedy everyone in the world is facing, this product is reduced by 20%. The price is updated and there is no need for a coupon.
 
@Ozzy47

I received several errors as below, is this related to the addon?

  • XF\Db\Exception: MySQL query error [1406]: Data too long for column 'ipaddress' at row 1
  • src/XF/Db/AbstractStatement.php:230
  • Generated by: Jeny
  • 17 Apr 2022 at 2:05 AM

Stack trace​

INSERT INTO xf_ozzmodz_logcontactus_log (user_agent, received, ipaddress, username, email, subject, message, log_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
------------

#0 src/XF/Db/Mysqli/Statement.php(198): XF\Db\AbstractStatement->getException('MySQL query err...', 1406, '22001')
#1 src/XF/Db/Mysqli/Statement.php(79): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1406, '22001')
#2 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(220): XF\Db\AbstractAdapter->query('INSERT INTO `x...', Array)
#4 src/XF/Mvc/Entity/Entity.php(1514): XF\Db\AbstractAdapter->insert('xf_ozzmodz_logc...', Array, false)
#5 src/XF/Mvc/Entity/Entity.php(1246): XF\Mvc\Entity\Entity->_saveToSource()
#6 src/addons/OzzModz/ContactusLog/XF/Pub/Controller/Misc.php(83): XF\Mvc\Entity\Entity->save()
#7 src/XF/Mvc/Dispatcher.php(352): OzzModz\ContactusLog\XF\Pub\Controller\Misc->actionContact(Object(XF\Mvc\ParameterBag))
#8 src/XF/Mvc/Dispatcher.php(259): XF\Mvc\Dispatcher->dispatchClass('XF:Misc', 'Contact', Object(XF\Mvc\RouteMatch), Object(OzzModz\ContactusLog\XF\Pub\Controller\Misc), NULL)
#9 src/XF/Mvc/Dispatcher.php(115): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(OzzModz\ContactusLog\XF\Pub\Controller\Misc), NULL)
#10 src/XF/Mvc/Dispatcher.php(57): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#11 src/XF/App.php(2352): XF\Mvc\Dispatcher->run()
#12 src/XF.php(524): XF\App->run()
#13 index.php(20): XF::runApp('XF\\Pub\\App')
#14 {main}

Request state​

array(4) {
["url"] => string(19) "/forum/misc/contact"
["referrer"] => string(41) "/forum/misc/contact"
["_GET"] => array(0) {
}
["_POST"] => array(7) {
["_xfToken"] => string(8) "********"
["subject"] => string(17) "حدف عضوية"
["message"] => string(132) "السلام عليكم
["_xfRedirect"] => string(41) "/forum/misc/contact"
["_xfRequestUri"] => string(19) "/forum/misc/contact"
["_xfWithData"] => string(1) "1"
["_xfResponseType"] => string(4) "json"
}
}
Click to expand...
 
@Ozzy47, I am still receiving this errors:

Currently I disabled the addon, please advise

  • XF\Db\Exception: MySQL query error [1406]: Data too long for column 'ipaddress' at row 1
  • src/XF/Db/AbstractStatement.php:230
  • 13 Feb 2023 at 12:23 PM

Stack trace​

INSERT INTO xf_ozzmodz_logcontactus_log (user_agent, received, ipaddress, username, email, subject, message, log_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
------------

#0 src/XF/Db/Mysqli/Statement.php(198): XF\Db\AbstractStatement->getException('MySQL query err...', 1406, '22001')
#1 src/XF/Db/Mysqli/Statement.php(79): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1406, '22001')
#2 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(220): XF\Db\AbstractAdapter->query('INSERT INTO `x...', Array)
#4 src/XF/Mvc/Entity/Entity.php(1514): XF\Db\AbstractAdapter->insert('xf_ozzmodz_logc...', Array, false)
#5 src/XF/Mvc/Entity/Entity.php(1246): XF\Mvc\Entity\Entity->_saveToSource()
#6 src/addons/OzzModz/ContactusLog/XF/Pub/Controller/Misc.php(83): XF\Mvc\Entity\Entity->save()
#7 src/XF/Mvc/Dispatcher.php(352): OzzModz\ContactusLog\XF\Pub\Controller\Misc->actionContact(Object(XF\Mvc\ParameterBag))
#8 src/XF/Mvc/Dispatcher.php(259): XF\Mvc\Dispatcher->dispatchClass('XF:Misc', 'Contact', Object(XF\Mvc\RouteMatch), Object(OzzModz\ContactusLog\XF\Pub\Controller\Misc), NULL)
#9 src/XF/Mvc/Dispatcher.php(115): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(OzzModz\ContactusLog\XF\Pub\Controller\Misc), NULL)
#10 src/XF/Mvc/Dispatcher.php(57): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#11 src/XF/App.php(2352): XF\Mvc\Dispatcher->run()
#12 src/XF.php(524): XF\App->run()
#13 index.php(20): XF::runApp('XF\\Pub\\App')
#14 {main}

Request state​

array(4) {
["url"] => string(19) "/forum/misc/contact"
["referrer"] => string(41) "https://www.domain.com/forum/misc/contact"
["_GET"] => array(0) {
}
["_POST"] => array(7) {
["_xfToken"] => string(8) "********"
["subject"] => string(5) "test2"
["message"] => string(3) "222"
["_xfRedirect"] => string(45) "https://www.domain.com/forum/contactusloglog/"
["_xfRequestUri"] => string(19) "/forum/misc/contact"
["_xfWithData"] => string(1) "1"
["_xfResponseType"] => string(4) "json"
}
}
Click to expand...
 
danger GIF
Warning Sign GIF


Now That Ive got your attention:
This is a beta release, take a full backup before installing on a production site. Optimally try it out on a test site that is a replication of your live site before installing on the live site. It has had limited testing.[/B]

Ozzy47 updated [OzzModz] Contact Us Form Log with a new update entry:

[OzzModz] Contact Us Form Log for XenForo for XenForo 2.2+ Update 2.1.0 Beta 3

WARNING, WARNING, WARNING!!!!!!!!!!!

danger GIF
Warning Sign GIF


Now That Ive got your attention:
This is a beta release, take a full backup before installing on a production site. Optimally try it out on a test site that is a replication of your live site before installing on the live site...
Click to expand...

Read the rest of this update entry...
 
Thanks @Ozzy47 for the update.

Since it is in development, maybe it is the right time to suggest :)
I would like to suggest the below:
1. Sending alert/notification to the authorized users if anybody sent new message through contact us page.
2. Adding a button near the message to quote the message and reply through PM (conversation) if the user is registered in the forum.

Thanks again
 
Ozzy47 said:
danger GIF
Warning Sign GIF


Now That Ive got your attention:
This is a beta release, take a full backup before installing on a production site. Optimally try it out on a test site that is a replication of your live site before installing on the live site. It has had limited testing.[/B]

Ozzy47 updated [OzzModz] Contact Us Form Log with a new update entry:

[OzzModz] Contact Us Form Log for XenForo for XenForo 2.2+ Update 2.1.0 Beta 3



Read the rest of this update entry...
Click to expand...

@Ozzy47

Finally, I decided to take the risk and upgrade the addon in the live forum.
The upgrade process failed and I got the below error:

1708508620659.webp

[COLOR=hsl(var(--xf-editorFocusColor))]1708508693415.webp[/COLOR]

If I click (Upgrade), I got the below error:

1708508666619.webp

Currently there is no option to uninstall it!
 
You must log in or register to reply here.

Similar threads

Ozzy47
[OzzModz] Contact Us Form Redirect to Conversation
Replies
0
Views
438
Ozzy47
Ozzy47
S
Add-on Contact us form questions & routing
Replies
4
Views
442
stromb0li
S
Ozzy47
[OzzModz] Contact Form Explanation Fields
Replies
0
Views
423
Ozzy47
Ozzy47
troops
  • Question Question
XF 2.2 Contact us form emails not being received
Replies
4
Views
1K
Rhody
Rhody
smozgur
Contact Us form - SPAM management
Replies
2
Views
1K
Kirby
K
Back
Top Bottom