Tips Blog

Welcome to our technical tips blog – solutions and answers for numerous Joomla, Wordpress, Magento, Linux, MySQL and other problems.
 

Magento Fatal error: Class not found in Mage.php errors

Was trying to install the MeanBee Royal Mail Domestic and International Shipping Extension via Magento Connect. It installed fine, but  when going to System -> Delivery Methods – I got the error : Fatal error: Class ‘Meanbee_Royalmail_Helper_Data’ not found in

read more

Extract iphone sms, notes and contacts from backup to Excel or CSV – SQLiteStudio

To extract SMS messages from an iPhone backup. Backup iPhone using iTunes Install SQLiteStudio (free) from sourceforge. Open SQLiteStudio In MacOS open folder /Users/USERNAME/Library/Application Support/MobileSync/Backup/RANDOM_NAME in Windows 10 open folder C:\Users\USERNAME\AppData\Roaming\Apple Computer\MobileSync\Backup\RANDOM_NAME the file you want is called “3d0d7e5fb2ce288813306e4d4636395e047a3d28”. Copy

read more

PHP MYSQL code for SELECT, UPDATE, LOADRESULT and LOADOBJECT examples

PHP mysql_connect for UPDATE example mysql_select_db(“database”, $con); $result = mysql_query(“ALTER TABLE jos_acajoom_subscribers ADD interested_in varchar(200); “); if (!$result) { die(‘Invalid query: ‘ . mysql_error()); } mysql_close($con) Joomla MYSQL loadResult example global $database;  $sql = ‘SELECT title FROM #__categories’; $database->setQuery( $sql

read more

Illegal characters in MYSQLdump solution:

Illegal characters in MYSQLdump solution: use php or command line to export mysql database as latin1 : <?php exec(“mysqldump –default-character-set=latin1 -uUSERNAME -pPASSWORD DATABASE > DATABASE.sql”); ?> open in editor and Find/Replace latin1 to utf8 then import using web interface or

read more