[OzzModz] Contact Us Form Log

[OzzModz] Contact Us Form Log [Paid] 2.0.0

No permission to buy ($10.00)

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...

Read more about this resource...
 

Sadiq6210

Well-known member
@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:

Ozzy47

Well-known member
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:

Sadiq6210

Well-known member
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.

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

Sadiq6210

Well-known member
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"
  }
}
 

Ozzy47

Well-known member
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"
  }
}

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.
 

Ozzy47

Well-known member
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.
 

Sadiq6210

Well-known member
@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"
}
}
 
Top