Deprecated: Joomla\Input\Input implements the Serializable interface, which is deprecated. Implement __serialize() and __unserialize() instead (or in addition, if support for old PHP versions is necessary) in /homepages/13/d380392445/htdocs/Jlive/libraries/vendor/joomla/input/src/Input.php on line 41

Deprecated: Return type of Joomla\Input\Input::count() should either be compatible with Countable::count(): int, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /homepages/13/d380392445/htdocs/Jlive/libraries/vendor/joomla/input/src/Input.php on line 170
Geoffrey Chapman - Macrotone Blogs - Page 20

Macrotone Blogs

Macrotone blogs upon Joomla, our products and other matters.

An IT professional with a wide experience of IT systems, specialising in Database Management and Security.

PHP calling MySQL functions and procedures

Following on from a recent post on creating MySQL functions and procedures from PHP, the next logical step is to make use of the functions and procedures.

To call a MySQL procedure using the Joomla database classes you make use of a CALL statement.

  $query = 'CALL #__dbprocedure (' . $userId . ',"' . $date . '","' . $ndate . '","' . $datap . '",' . $npwds . ')';
  $db->setQuery($query);
  $retn= $db->query();   // Returns false if query fails to execute

 

Continue reading

Using PHP to create MySQL database procedures

There was a requirement to create MySQL database procedures and functions for a future feature of the Password Control plugin component.   Much time and effort was put into finding a solution that would work.  Extensive searching of the available documentation and internet resources didn't really help hence this blog.

Extensive attempts using the SQL update files and the manifest file failed to produce a result.  In the end a solution was found using the manifest installation script file and writting PHP code.

Continue reading

Oracle based packages available

The Oracle database packages, Unwrap v1.0, Holidays v1.3, Stats v1.4, Audit v1.6 and Data Masking v1.0  are available for registered users in the Download area.

Oracle Express 11g and Goldengate to SQL server

I see that Oracle has release Oracle Express 11g for windows 32 bit and Linux 64bit system.   You can get it from the link below.

http://www.oracle.com/technetwork/database/express-edition/downloads/index.html

I also saw this interesting article about using Oracle Goldengate to connect to Microsoft SQL Server.  I find this of interest due to previous experience using the 'Transaparent Gateway' to get information from SQL Server to Oracle for a client.  I enclose the link for those of you that may want to have a look. 

http://www.oracle.com/technetwork/articles/datawarehouse/oracle-sqlserver-goldengate-460262.html

Fake Name Generator

Found this web site that enables one to completely generate a fake identify, complete with valid email address etc.  Interesting although I haven't tried it.   Could be useful for those sites that want more than an email address.

Fake Name Generator

5 More Free Tools For Windows 7 You Have To Try

Peter Bruzzese said in his blog: "Every couple of months, it's both entertaining and useful to revisit the tools and toys available to make our desktop experience smoother, more flexible, and, yes, more fun. A while back, I identified eight free Windows 7 tools you have to try and later revealed some truly awesome tools for Windows 7 power users. I have five more "gotta try" Windows tools for you to consider." Check them out here:
More Free Tools

Setting up QNAP web server

Use the following QNAP Web sever and this article is also useful More setup

Speeding up Firefox 5

Found this which may be useful.  If you are not sure then don`t bother, but everything here can be set back to normal if needed. Just make a note somewhere of the default settings as well as the changes you have made.

Continue reading

Fixing dying iTunes server

Useful article to aid fixing the iTunes server on the QNAP.

Upgrade Windows 7 with Upgrade Media

Came upon this useful web link.  Upgrade Windows 7

Go To Top

Joomla! Debug Console

Session

Profile Information

Memory Usage

Database Queries